0FIS_LITB_DS_EV

Data Source for Line Item Browser Grid for Entry View | #TRAN | Extraction method: F1 | No Delta | Component: Financial Accounting: General Ledger
Tables used: CSKS, CEPC, KNA1, LFB1, KNB1 ... +12 more
Column Name Description
MANDT Client
BUKRS Company Code
GSBER Business Area
KOSTL Cost Center
SAKNR G/L Account Number
KUNNR Customer Number
LIFNR Account Number of Supplier
PRCTR Profit Center
SEGMENT Segment for Segmental Reporting
KSTAR Cost Element
KOKRS Controlling Area
KTOPL Chart of Accounts
RLDNR Ledger in General Ledger Accounting
Column Name Description
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT_SHL Signed Amount for Updating in General Ledger (Long)
💲 Currency Key (T014_WAERS):
ABSBT_SHL Credit Management: Signed Hedged Amount
💲 Currency for Automatic Payment (PYCUR):
PYAMT_SHL Signed Amount in Payment Currency
💲 Local Currency (HWAER):
DMBTR_SHL Signed Amount in Local Currency (Long)
SKNTO_SHL Signed Cash Discount Amount in Local Currency
BDIFF_SHL Valuation Difference with +/- Sign
💲 Currency Key of Second Local Currency (HWAE2):
DMBE2_SHL Signed Amount in Second Local Currency (Long)
BDIF2_SHL Signed Valuation Difference for the Second Local Currency
💲 Currency Key of Third Local Currency (HWAE3):
DMBE3_SHL Signed Amount in Third Local Currency (Long)
BDIF3_SHL Signed Valuation Difference for the Third Local Currency
💲 Currency Key (WAERS):
WRBTR_SHL Signed Amount in Document Currency (Long)
QSSHB_SHL Signed Withholding Tax Base Amount
SKFBT_SHL Amount Eligible for Cash Discount in Doc. Crcy with +/- Sign
WSKTO_SHL Signed Cash Discount Amount in Document Currency
QBSHB_SHL Signed Withholding Tax Amount (in Document Currency)
QSFBT_SHL Signed Withholding Tax-Exempt Amount (in Document Currency)
💲 Currency Key (OWAER):
WOGBTR Total Value in Object Currency (Long)
💲 Controlling area currency (KWAER):
WKGBTR Total Value in Controlling Area Currency (Long)
WKFBTR Fixed Value in Controlling Area Currency (Long)
PAGBTR Total Price Variance in CO Area Currency (Long)
PAFBTR Fixed Price Variance in CO Area Currency (Long)
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
📏 Unit of Measure (MEINH):
MEGBTR Total Quantity
MEFBTR Fixed Quantity
📏 Posted Unit of Measure (MEINB):
MBGBTR Total quantity entered
MBFBTR Fixed quantity entered
Column Name Description
AUGDT Clearing Date
VALUT Value date
ZFBDT Baseline Date for Due Date Calculation
MADAT Date of Last Dunning Notice
DABRZ Reference date for settlement
BLDAT Document Date in Document
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
AEDAT Date of the Last Document Change by Transaction
WWERT Translation date
VATDATE Tax Reporting Date
ZALDT Probable Payment Date (Cash Discount 1 Due)
FAEDT Due Date of Payment
ALLGSTID Open Items at Key Date
Column Name Description
KOART Account type Show values
MWART Tax Type Show values
XKRES Indicator: Can Line Items Be Displayed by Account? Show values
XOPVW Managed on an Open Item Basis Show values
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? Show values
ZBFIX Fixed Payment Terms Show values
WVERW Bill of Exchange Usage Type Show values
VERTT Contract Type Show values
XRAGL Indicator: Clearing Was Reversed Show values
XNEGP Indicator: Negative Posting Show values
XPYPR Indicator: Items from Payment Program Blocked Show values
XUMSW Indicator: Sales-Related Item ? Show values
SHKZG Debit/Credit Indicator Show values
BSTAT Document Status Show values
WRTTP Value Type Show values
BEKNZ Debit/credit indicator Show values
MVFLG Quantity Complete/Incomplete Show values
RBEST Category of Reference Purchase Order Show values
ERLKZ Completion Indicator for Line Item Show values
BELTP Debit Type Show values
SCOPE Object Class Show values
PSCOPE Partner object class Show values
AUTYP Order category Show values
PAUTYP Partner Order Category Show values
LEDNR Ledger for Controlling Objects Show values
Column Name Description Domain name
BELNR Document Number of an Accounting Document BELNR
GJAHR Fiscal Year GJAHR
BUZEI Number of Line Item Within Accounting Document BUZEI
BUZID Identification of the Line Item CHAR1
AUGBL Document Number of the Clearing Document BELNR
BSCHL Posting Key BSCHL
UMSKZ Special G/L Indicator UMSKZ
UMSKS Special G/L Transaction Type UMSKS
PARGB Trading partner's business area GSBER
MWSKZ Tax on sales/purchases code MWSKZ
ZUONR Assignment number ZUONR
SGTXT Item Text TEXT50
VBUND Company ID of Trading Partner RCOMP
BEWAR Transaction type RMVCT
AUFNR Order Number AUFNR
VBELN Billing Document VBELN
VBEL2 Sales Document VBELN
POSN2 Sales Document Item POSNR
ETEN2 Schedule Line Number ETENR
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
HKONT General Ledger Account SAKNR
FILKD Account Number of the Branch MAXKK
ZTERM Terms of payment key ZTERM
ZBD1T Cash discount days 1 ZBDXT
ZBD2T Cash discount days 2 ZBDXT
ZBD3T Net Payment Terms Period ZBDXT
ZBD1P Cash discount percentage 1 PRZ23
ZBD2P Cash Discount Percentage 2 PRZ23
ZLSCH Payment Method ZLSCH
ZLSPR Payment Block Key ZAHLS
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
REBZZ Line Item in the Relevant Invoice BUZEI
REBZT Follow-On Document Type REBZT
SAMNR Invoice List Number SAMNR
MSCHL Dunning Key MSCHL
MANSP Dunning Block MANSP
MANST Dunning Level MAHNS
MABER Dunning Area MABER
WERKS Plant WERKS
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
RSTGR Reason Code for Payments RSTGR
VERTN Contract Number RANL
VBEWA Flow Type SBEWART
IMKEY Internal Key for Real Estate Object IMKEY
UZAWE Payment method supplement UZAWE
GEBER Fund BP_GEBER
PPRCT Partner Profit Center PRCTR
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
FKBER Functional Area FKBER
RFZEI Payment Card Item NUM03
CCBTC Payment cards: Settlement run CCBTC
KKBER Credit control area KKBER
XREF3 Reference key for line item CHAR20
DTWS1 Instruction Key 1 DTWSX
DTWS2 Instruction Key 2 DTWSX
DTWS3 Instruction key 3 DTWSX
DTWS4 Instruction key 4 DTWSX
KIDNO Payment Reference CHAR30
AGZEI Clearing Item AGZEI
BUPLA Business Place J_1BBRANCH
SECCO Section Code SECCO
CESSION_KZ Accounts Receivable Pledging Indicator CESSION_KZ
GRANT_NBR Grant GM_GRANT_NBR
FKBER_LONG Functional Area FKBER
AUGGJ Fiscal Year of Clearing Document GJAHR
PSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
PFKBER Partner Functional Area FKBER
EGRUP Equity group JV_EGROUP
VNAME Joint venture JV_NAME
RECID Recovery Indicator JV_RECIND
KTOSL Transaction Key CHAR3
HZUON Assignment Number for Special G/L Accounts ZUONR
BWTAR Valuation Type BWTAR
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
AWSYS Logical system of source document LOGSYS
POSNR Accounting Document Line Item Number POSNR_ACC
BLART Document Type BLART
MONAT Fiscal period MONAT
USNAM User Name XUBNAME
XBLNR Reference Document Number XBLNR1
STBLG Reverse Document Number BELNR
STJAH Fiscal Year of Reversal Document GJAHR
KURSF Exchange rate KURSF
GLVOR Business Transaction CHAR4
FIKRS Financial Management Area FIKRS
LDGRP Ledger Group FAGL_LDGRP
GRPID Batch Input Session Name CHAR12
DBBLG Recurring Entry Document Number BELNR
BVORG Number of Cross-Company Code Posting Transaction BVORG
TCODE Transaction Code TCODE
XREF1_HD Reference Key 1 Internal for Document Header CHAR20
XREF2_HD Reference Key 2 Internal for Document Header CHAR20
XBLNR_ALT Alternative Reference Number XBLNR_ALT
BKTXT Document Header Text TEXT25
CO_BELNR Document Number CO_BELNR
CO_BUZEI Posting Row BUZEI
CO_SGTXT Segment text TEXT50
OBJNR Object number J_OBJNR
VERSN Version COVERSI
HRKFT CO key subnumber CO_SUBKEY
VRGNG CO Business Transaction J_VORGANG
PAROB Partner Object J_OBJNR
PAROB1 Partner object (always filled) J_OBJNR
USPOB Source Object (Cost Center/Activity Type) J_OBJNR
MATNR Material Number MATNR
PERNR Personnel Number PERNR
OBJNR_N1 Auxiliary account assignment 1 J_OBJNR
OBJNR_N2 Auxiliary account assignment 2 J_OBJNR
OBJNR_N3 Auxiliary account assignment 3 J_OBJNR
LOGSYSO Logical System of Object LOGSYS
PKSTAR Cost element of partner KSTAR
PBUKRS Company Code of Partner BUKRS
LOGSYSP Logical system of partner object LOGSYS
OBJNR_HK Object Number of Origin Object J_OBJNR
QMNUM Notification Number QMNUM
PGEBER Partner Fund BP_GEBER
PGRANT_NBR Partner Grant GM_GRANT_NBR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period FM_BUDGET_PERIOD
ACCAS Account Assignment ACCAS
ACCASTY Object Type J_OBART
LSTAR Activity Type LSTAR
PSPNR Work Breakdown Structure Element (WBS Element) PS_POSID
PSPID Project definition PS_PSPID
PACCAS Partner Account Assignment ACCAS
PACCASTY Partner Object Type J_OBART
PKOSTL Partner Cost Center KOSTL
PAUFNR Partner order number AUFNR
PPSPNR Partner Work Breakdown Structure Element PS_POSID
PPSPID Partner Project PS_PSPID
PCE4KEY Partner Assignment Object Key for CO-PA Data Basis (CE4xxxx) RKEOBJNR
CE4KEY Assignment Object Key for CO-PA Data Basis (CE4xxxx) RKEOBJNR
ERKRS Operating concern ERKRS
PLSTAR Partner activity LSTAR
PVBELN Number of Partner Sales Order VBELN
PVBPOSNR Partner Sales Order Item POSNR
KNDNR Customer KUNNR
ARTNR Product number MATNR
KAUFN Sales Order Number VBELN
VKORG Sales Organization VKORG
SPART Division SPART
VTWEG Distribution Channel VTWEG
BZIRK Sales District BZIRK
KDGRP Customer Group KDGRP
MATKL Material Group MATKL
VKGRP Sales group VKGRP
KMVTNR Sales employee PERNR
KMVKBU Sales office VKBUR
BRSCH Industry key BRSCH
KSTRG Cost Object KSTRG
KDPOS Item number in Sales Order NUM06
FKART Billing Type FKART
PERIO Number of periods per seasonal cycle PERAN
FISCPER Fiscal Year/Period FCIW_FISCPER
S_CATEGORY Plan Category FCOM_CATEGORY