1. Home
  2. Resources
  3. SAP Tables
  4. FAGL_S_OPEN_ITEMS - Fields from Open Item Tables BSIS, BSIK, and BSID

SAP Table FAGL_S_OPEN_ITEMS

Fields from Open Item Tables BSIS, BSIK, and BSID

FAGL_S_OPEN_ITEMS (Fields from Open Item Tables BSIS, BSIK, and BSID) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FAGL_S_OPEN_ITEMS to other SAP tables.

FAGL_S_OPEN_ITEMS table fields

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

FAGL_S_OPEN_ITEMS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FAGL_S_OPEN_ITEMS ZZREGION SYST MANDT ZREG User Defined Regions MANDT
FAGL_S_OPEN_ITEMS ZZREGION FAGL_S_OPEN_ITEMS ZZREGION ZREG User Defined Regions ZZREGION
FAGL_S_OPEN_ITEMS ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
FAGL_S_OPEN_ITEMS ZZSPREG FAGL_S_OPEN_ITEMS ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
FAGL_S_OPEN_ITEMS ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
FAGL_S_OPEN_ITEMS ZZSTATE * T005S Taxes: Region (Province) Key LAND1
FAGL_S_OPEN_ITEMS ZZSTATE FAGL_S_OPEN_ITEMS ZZSTATE T005S Taxes: Region (Province) Key BLAND
FAGL_S_OPEN_ITEMS ZZUSERFLD1 FAGL_S_OPEN_ITEMS ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
FAGL_S_OPEN_ITEMS ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT