0FIS_TRIAL_BAL_DS

Data Source for Trial Balance | #TRAN | Extraction method: F1 | No Delta | Component: Financial Accounting: General Ledger
Column Name Description
Column Name Description
💲 Local Currency (RHCUR):
PREV_BAL Balance previous periods
PERIOD_BAL Balance of a period
CMP_PREV_BAL Comparison balance previous periods
CMP_PERIOD_BAL Comparison balance of a period
PREV_BAL_DIFF Difference
PERIOD_BAL_DIFF Difference
HSL Value in Local Currency
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of the original transaction currency (RWCUR):
WSL Value in Original Transaction Currency (Document Currency)
💲 Controlling area currency (RKCUR):
KSL Value in Group Currency
💲 Currency Key of Third Currency (ROCUR):
OSL Value in Another Currency
Column Name Description
📏 Base Unit of Measure (RUNIT):
MSL Quantity
Column Name Description
BUDAT Posting Date in the Document
BLDAT Document Date in Document
AUGDT Clearing Date
BZDAT Asset Value Date
Column Name Description
DRCRK Debit/Credit Indicator Show values
KOART Account type Show values
GKOAR Offsetting Account Type Show values
Column Name Description Domain name
MANDT Client MANDT
RBUKRS Company Code BUKRS
RLDNR Ledger in General Ledger Accounting RLDNR
RYEAR General Ledger Fiscal Year GJAHR
KTOPL Chart of Accounts KTOPL
RACCT Account Number SAKNR
RCNTR Cost Center KOSTL
PRCTR Profit Center PRCTR
RFAREA Functional Area FKBER
RBUSA Business Area GSBER
KOKRS Controlling Area CACCD
SEGMENT Segment for Segmental Reporting FB_SEGMENT
POPER Posting period POPER
GJAHR Fiscal Year GJAHR
LIFNR Account Number of Supplier LIFNR
KUNNR Customer Number KUNNR
PREV_BAL_PERCENT Percentage FISD_PERCENT_DOM
PERIOD_BAL_PERCENT Percentage FISD_PERCENT_DOM
CMP_RYEAR Fiscal year GJAHR
REP_POPER Posting period POPER
REP_RYEAR General Ledger Fiscal Year GJAHR
BELNR Document Number of an Accounting Document BELNR
DOCLN Six-Character Posting Item for Ledger DOCLN6
RMVCT Transaction type RMVCT
AWTYP Reference procedure AWTYP
AWSYS Logical system of source document LOGSYS
AWREF Reference document number AWREF
SCNTR Sender cost center KOSTL
PPRCTR Partner Profit Center PRCTR
SFAREA Partner Functional Area FKBER
SBUSA Trading partner's business area GSBER
RASSC Company ID of Trading Partner RCOMP
PSEGMENT Partner Segment for Segmental Reporting FB_SEGMENT
PERIV Fiscal Year Variant PERIV
BLART Document Type BLART
BUZEI Number of Line Item Within Accounting Document BUZEI
ZUONR Assignment number ZUONR
BSCHL Posting Key BSCHL
KTOSL Transaction Key CHAR3
SLALITTYPE Subledger-Specific Line Item Type SLALITTYPE
USNAM User Name XUBNAME
LOKKT Alternative Account Number in Company Code SAKNR
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
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
SGTXT Item Text TEXT50
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
MATNR Material Number MATNR
WERKS Plant WERKS
UMSKZ Special G/L Indicator UMSKZ
MWSKZ Tax on sales/purchases code MWSKZ
HBKID Short Key for a House Bank HBKID
HKTID ID for Account Details HKTID
AUGBL Document Number of the Clearing Document BELNR
AUGGJ Fiscal Year of Clearing Document GJAHR
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
ANBWA Asset Transaction Type BWASL
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR
BWTAR Valuation Type BWTAR
BWKEY Valuation area BWKEY
GKONT Offsetting Account Number GKONT
PERNR Personnel Number PERNR
PBUKRS Company Code of Partner BUKRS
UKOSTL Origin cost center KOSTL
ULSTAR Origin activity LSTAR
LSTAR Activity Type LSTAR
AUFNR Order Number AUFNR
VKORG Sales Organization VKORG
VTWEG Distribution Channel VTWEG
SPART Division SPART
REP_PERIOD_TXT Text element for period range CHAR7
REP_PERIOD_YEAR Reporting periods with year CHAR12
PREV_PERIOD_TXT Text element for previous period CHAR7
PREV_PERIOD_YEAR Previous period with year CHAR12
REP_POPER_TO Posting period POPER