fi diff table imp field(ubi)
DESCRIPTION
FI important table and FieldTRANSCRIPT
![Page 1: Fi Diff Table Imp Field(Ubi)](https://reader036.vdocuments.us/reader036/viewer/2022073120/563db828550346aa9a9111bb/html5/thumbnails/1.jpg)
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)](https://reader036.vdocuments.us/reader036/viewer/2022073120/563db828550346aa9a9111bb/html5/thumbnails/2.jpg)
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)](https://reader036.vdocuments.us/reader036/viewer/2022073120/563db828550346aa9a9111bb/html5/thumbnails/3.jpg)
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)](https://reader036.vdocuments.us/reader036/viewer/2022073120/563db828550346aa9a9111bb/html5/thumbnails/4.jpg)
Field Name DescriptionMANDT Client KEY Field
TABLE : BSAS[Secondary Index for G/L Accounts] (Cleared Items)