0FI_GL_CN_44

DataSource for Journal Ledger Report | #TRAN | Extraction method: F1 | No Delta | Component: Financial Accounting: General Ledger
Tables used: BSEG, FUDT_VDOCBSEG, BKPF, FUDT_VDOCBKPF, GLFUNCT ... +33 more
Column Name Description
BELNR Document Number of an Accounting Document
BSCHL Posting Key
BUKRS Company Code
BUZEI Number of Line Item Within Accounting Document
GJAHR Fiscal Year
GSBER Business Area
KOART Account type Show values
UMSKZ Special G/L Indicator
HKONT General Ledger Account
KKBER Credit control area
KUNNR Customer Number
LIFNR Account Number of Supplier
RLDNR Ledger
RYEAR General Ledger Fiscal Year
SAKNR G/L Account Number
MANDT Client
RRCTY Record Type Show values
RVERS Version
KTOPL Chart of Accounts
Column Name Description
💲 Local Currency (HWAER):
BWWRT Valuated Amount in Local Currency
DMSHB Amount in Local Currency with +/- Signs
SKNTO Cash Discount Amount in Local Currency
ZINSZ Interest Calculation Numerator (Days in Arrears * Amount)
BDIFF Valuation Difference
DMBTR Amount in Local Currency
DMHAB Credit Amount in Local Currency
DMSOL Debit Amount in Local Currency
BWSHB Valuated Amount in Local Currency with Sign
💲 Currency Key of Second Local Currency (HWAE2):
BWWR2 Amount Valuated in Local Currency 2
DMBE2 Amount in Second Local Currency
BDIF2 Valuation Difference for the Second Local Currency
DMHA2 Credit Amount in Second Local Currency
DMSO2 Debit Amount in Second Local Currency
DMSH2 Amount in Second Local Currency with +/- Sign
BWSH2 Valuated Amount in Second Local Currency with Sign
💲 Currency Key of Third Local Currency (HWAE3):
BWWR3 Amount Valuated in Local Currency 3
DMBE3 Amount in Third Local Currency
BDIF3 Valuation Difference for the Third Local Currency
DMHA3 Credit Amount in Third Local Currency
DMSO3 Debit Amount in Third Local Currency
DMSH3 Amount in Third Local Currency with +/- Sign
BWSH3 Valuated Amount in Third Local Currency with Sign
💲 Document Currency (Key) (WAERS):
QBSHB Withholding Tax Amount in Document Currency
QSFBT Withholding Tax Exempt Amount in Document Currency
QSSHB Withholding Tax Base Amount in Document Currency
SKFBT Amount Eligible for Cash Discount in Document Currency
WSKTO Cash Discount Amount in Document Currency
WRSHB Amount in Document Currency (Foreign Currency)
ASKTO Current Cash Discount Amount in Document Currency
WRBTR Amount in Document Currency
WRHAB Credit Amount in Document Currency
WRSOL Debit Amount in Document Currency
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT Amount for General Ledger Update (Absolute)
💲 Currency of Credit Control Area (KKBWR):
ABSBT Credit Management: Hedged Amount (Absolute)
💲 Currency for Automatic Payment (PYCUR):
PYAMT Amount in Automatic Payment Currency (Absolute)
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
Column Name Description
AUGDT Clearing Date
BLDAT Document Date in Document
BUDAT Posting Date in the Document
FAEDT Net Due Date
MADAT Date of Last Dunning Notice
VALUT Value date
ZALDT Probable Payment Date (Cash Discount 1 Due)
ZFBDT Baseline Date for Due Date Calculation
DABRZ Reference date for settlement
CPUDT Day On Which Accounting Document Was Entered
ALLGSTID Open Items at Key Date
Column Name Description
BSTAT Document Status Show values
KOART Account type Show values
SHKZG Debit/Credit Indicator Show values
STAKZ Indicator: Statistical Document? Show values
VERTT Contract Type Show values
WVERW Bill of Exchange Usage Type Show values
XSTRP Indicator: Disputed Item? Show values
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? Show values
XARCH Indicator: Document Already Archived? Show values
XNEGP Indicator: Negative Posting Show values
ZBFIX Fixed Payment Terms Show values
XPYPR Indicator: Items from Payment Program Blocked Show values
XAUGP Indicator: Item Has Been Cleared? Show values
XRAGL Indicator: Clearing Was Reversed Show values
XOPVW Indicator: Open Item Management? Show values
XLGCLR Open Item Management by Ledger Group Show values
XREORG Doc. Contains Open Item that Was Transferred During Reorg. Show values
MWART Tax Type Show values
UPMOD BW Delta Process: Record Mode Show values
RRCTY Record Type Show values
CURT2 Currency Type of Second Local Currency Show values
CURT3 Currency Type of Third Local Currency Show values
AUGST Clearing Status of Line Item Show values
BSTAT_S Document Status Show values
HIDE_EMPTY Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
INC_TMPDOC Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
SIM_STATUS Status of Posting Document Show values
Column Name Description Domain name
ANLN1 Main Asset Number ANLN1
ANLN2 New asset subnumber, 4 characters ANLN2_4
AUFNR Order Number AUFNR
AUGBL Document Number of the Clearing Document BELNR
BLART Document Type BLART
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
ETEN2 Schedule Line Number ETENR
FILKD Account Number of the Branch MAXKK
JAMON Fiscal Year/Posting Period from Posting Date JAMON_XPO
KONTO Account Number KTONR
KOSTL Cost Center KOSTL
MABER Dunning Area MABER
MANSP Dunning Block MANSP
MANST Dunning Level MAHNS
MONAT Fiscal period MONAT
MSCHL Dunning Key MSCHL
MWSKZ Tax on sales/purchases code MWSKZ
POSN2 Sales Document Item POSNR
PRCTR Profit Center PRCTR
REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
SAMNR Invoice List Number SAMNR
SGTXT Item Text TEXT50
UMSKS Special G/L Transaction Type UMSKS
UZAWE Payment method supplement UZAWE
VBEL2 Sales Document VBELN
VBELN Billing Document VBELN
VBEWA Flow Type SBEWART
VBUND Company ID of Trading Partner RCOMP
VERTN Contract Number RANL
VERZ1 Days in Arrears for Cash Discount Terms 1 WRTV3
VERZN Days in Arrears by Net Due Date WRTV3
WERKS Plant WERKS
XBLNR Reference Document Number XBLNR1
ZBD1P Cash discount percentage 1 PRZ23
ZBD1T Cash discount days 1 ZBDXT
ZBD2P Cash Discount Percentage 2 PRZ23
ZBD2T Cash discount days 2 ZBDXT
ZBD3T Net Payment Terms Period ZBDXT
ZLSCH Payment Method ZLSCH
ZLSPR Payment Block Key ZAHLS
ZTERM Terms of payment key ZTERM
ZUONR Assignment number ZUONR
XREF1 Business Partner Reference Key CHAR12
XREF2 Business Partner Reference Key CHAR12
RSTGR Reason Code for Payments RSTGR
KURSE Effective Exchange Rate in the Line Item KURSF
REBZT Follow-On Document Type REBZT
RFZEI Payment Card Item NUM03
CCBTC Payment cards: Settlement run CCBTC
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
PROJK Individual Structural Element (WBS Element) in Ext. Format CHAR24
KIDNO Payment Reference CHAR30
BUPLA Business Place J_1BBRANCH
SECCO Section Code SECCO
GKART Offsetting Account Type GKART
GKONT Offsetting Account Number GKONT
PYORD Payment Order PYORD
CESSION_KZ Accounts Receivable Pledging Indicator CESSION_KZ
BUZID Identification of the Line Item CHAR1
AUGGJ Fiscal Year of Clearing Document GJAHR
AGZEI Clearing Item AGZEI
LONGNUM Smart Number /SAPPSPRO/LONGNUM
AWSYS Logical System LOGSYS
AWTYP Reference procedure AWTYP
BEWAR Transaction type RMVCT
DOCNR Document Number of a General Ledger Document BELNR
DOCLN Six-Character Posting Item for Ledger DOCLN6
FKBER Functional Area FKBER_SHORT
FKBER_LONG Functional Area FKBER
GLVOR Business Transaction CHAR4
IMKEY Internal Key for Real Estate Object IMKEY
KOKRS Controlling Area CACCD
KSTAR Cost Element KSTAR
PARGB Trading partner's business area GSBER
PERIO Period/Year JAHRPER
PFKBER Partner Functional Area FKBER
PKOSTL Partner cost center KOSTL
POPER Posting period POPER
PPRCT Partner Profit Center PRCTR
PSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
SEGMENT Segment for Segmental Reporting FB_SEGMENT
LDGRP Ledger Group FAGL_LDGRP
AWKEY Reference Key AWKEY
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
FISCVAR Fiscal year variant RSFISCVAR
FISCPER Fiscal year / period RSFISCPER
RFISCVAR Fiscal year variant RSFISCVAR
RFISCPER Fiscal year / period RSFISCPER
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
PCGRP Profit Center Group GRPNAME
USNAM User Name XUBNAME
STBLG Reverse Document Number BELNR
STJAH Fiscal Year of Reversal Document GJAHR
BKTXT Document Header Text TEXT25
KOTXT Account Name TEXT50
XBLNR_ALT Alternative Reference Number XBLNR_ALT
ACC_LEVEL G/L Account Number REP_ACC_LEVEL
PERIOD Period REP_PERIOD_TEXT
ACCOUNT G/L Account REP_ACCOUNT_TEXT
DIRECTION Direction REP_INDICATOR_TEXT