SAP table FAGL_S_OPEN_ITEMS (Fields from Open Item Tables BSIS, BSIK, and BSID)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
GJAHR Fiscal Year NUMC 4 0 GJAHR
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
AWTYP Reference procedure CHAR 5 0 AWTYP
GLVOR Business Transaction CHAR 4 0 GLVOR
AWSYS Logical System CHAR 10 0 LOGSYSTEM
HKONT General Ledger Account CHAR 10 0 HKONT
MEINS Base Unit of Measure UNIT 3 0 MEINS
MENGE Quantity QUAN 13 3 MENGE_D
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
GSBER Business Area CHAR 4 0 GSBER
AUFNR Order Number CHAR 12 0 AUFNR_NEU
WERKS Plant CHAR 4 0 WERKS_D
KOSTL Cost Center CHAR 10 0 KOSTL
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
PRCTR Profit Center CHAR 10 0 PRCTR
BEWAR Transaction type CHAR 3 0 RMVCT
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
FKBER Functional Area CHAR 16 0 FKBER
FIPOS Commitment Item CHAR 14 0 FIPOS
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
PPRCT Partner Profit Center CHAR 10 0 PPRCTR
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
BSCHL Posting Key CHAR 2 0 BSCHL
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
BUZID Identification of the Line Item CHAR 1 0 BUZID
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
WAERS Currency Key CUKY 5 0 WAERS
WRBTR Amount in document currency CURR 23 2 WRBTR
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 PSWSL
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
DMBTR Amount in local currency CURR 23 2 DMBTR
DMBE2 Amount in Second Local Currency or Global Currency CURR 23 2 DMBE2
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency CURR 23 2 DMBE3
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
VBELN Billing Document CHAR 10 0 VBELN_VF
REBZT Follow-On Document Type CHAR 1 0 REBZT
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY