fi diff table imp field(ubi)

8
TABLE : BKPF (Accounting do Field Name Description MANDT Client BUKRS Company Code BELNR Accounting Document Number GJAHR Fiscal Year BLART Document Type BLDAT BUDAT MONAT Fiscal Period (posting period) CPUDT Entre date CPUTM Time of Entry UPDDT Date of Last Document Update GLVOR Business Transaction AWTYP Reference Transaction AWKEY Reference Key Document Date in the Document Posting Date in the Document

Upload: soumabha-chatterjee

Post on 04-Dec-2015

216 views

Category:

Documents


2 download

DESCRIPTION

FI important table and Field

TRANSCRIPT

Page 1: Fi Diff Table Imp Field(Ubi)

TABLE : BKPF (Accounting document Header)Field Name Description

MANDT ClientBUKRS Company Code KEY FieldBELNR Accounting Document Number KEY FieldGJAHR Fiscal Year KEY FieldBLART Document Type

BLDATBUDATMONAT Fiscal Period (posting period)CPUDT Entre dateCPUTM Time of EntryUPDDT Date of Last Document UpdateGLVOR Business TransactionAWTYP Reference TransactionAWKEY Reference Key

AA = Asset Posting,WA =Goods Issue,SB=G/L ACCOUNT POSTING

Document Date in the DocumentPosting Date in the Document

Combination of doc no,comp code and fiscal yr etc (auto by sys)

Page 2: Fi Diff Table Imp Field(Ubi)

TABLE : BSEG (Accounting Document Segment)Field Name Description

MANDT ClientBUKRS Company Code KEY FieldBELNR Accounting Document Number KEY FieldGJAHR Fiscal Year KEY FieldBUZEI Number of Line Item

BUZID ID of the Line ItemAUGDT Clearing DateAUGCP Clearing Entry DateAUGBL Clearing DocumentBSCHL Posting Key 89 =M ,91 = S always sameKOART Account Type

SHKZG Debit/Credit Indicator H = Credit and S = DebitDMBTR Amount in Local CurrencyWRBTR Amount in Document CurrencyPSWBT General Ledger AmountPSWSL General Ledger Currency INR etc.KTOSL Transaction Key GBB/etcZUONR Assignment Number Combination of comp cd,doc no etcVORGN Transaction Type for General LedgerHKONT General Ledger AccountKUNNR Customer Number 1 (customer)LIFNRVBELN Billing DocumentVBEL2 Sales Document

A =Asset, M= Material, S=General G/L account, T = Tax etc

A =Asset, M= Material, S=General G/L account, D = Customers, K=Vendors

Account Number of Vendor or Creditor

Page 3: Fi Diff Table Imp Field(Ubi)

TABLE : BSIS (Secondary Index for G/L Accounts)Field Name DescriptionMANDT Client KEY FieldBUKRS Company Code KEY FieldHKONT General Ledger Account KEY FieldAUGDT Clearing Date KEY FieldAUGBL Document Number of the Clearing Document KEY FieldZUONR Assignment Number KEY FieldGJAHR Fiscal Year KEY FieldBELNR KEY FieldBUZEI KEY Field

BUDATBLDATWAERS Currency KeyXBLNR Reference Document NumberBLART Document Type

MONAT Fiscal PeriodBSCHL Posting Key

SHKZG Debit/Credit IndicatorGSBER Business AreaMWSKZ Sales Tax CodeDMBTR Amount in Local CurrencyWRBTR Amount in Document CurrencyMWSTS Tax Amount in Local CurrencyWMWST Tax Amount in Document CurrencyWERKS PlantPRCTR Profit CenterPSWBT

Accounting Document NumberNumber of Line Item Within Accounting Document (Number of Line Item)

Posting Date in the DocumentDocument Date in Document

AA = Asset Posting,WA =Goods Issue,SB=G/L ACCOUNT POSTING

50=Credit Entry,40 =debit entry, 70= Debit asset,75 =credit asset etc

H= CREDIT,S=DEBIT.

Amount for Updating in General Ledger

Page 4: Fi Diff Table Imp Field(Ubi)

Field Name DescriptionMANDT Client KEY Field

TABLE : BSAS[Secondary Index for G/L Accounts] (Cleared Items)