1. Home
  2. Resources
  3. SAP Tables
  4. BSAS - Accounting: Secondary Index for G/L Accounts (Cleared Items)

SAP Table BSAS

Accounting: Secondary Index for G/L Accounts (Cleared Items)

BSAS (Accounting: Secondary Index for G/L Accounts (Cleared Items)) 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 BSAS to other SAP tables.

BSAS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS CHAR 4 0
HKONT General Ledger Account HKONT CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
ZUONR Assignment Number DZUONR CHAR 18 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
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
WAERS Currency Key WAERS CUKY 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART CHAR 2 0
MONAT Fiscal Period MONAT NUMC 2 0
BSCHL Posting Key BSCHL CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
GSBER Business Area GSBER CHAR 4 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
FKONT Financial Budget Item FIPLS NUMC 3 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
SGTXT Item Text SGTXT CHAR 50 0
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
AUFNR Order Number AUFNR_NEU CHAR 12 0
WERKS Plant WERKS_D CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
XOPVW Indicator: Open item management? XOPVW CHAR 1 0
X Yes
NULL No
VALUT Value date VALUT DATS 8 0
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
BDIFF Valuation Difference BDIFF CURR 13 2
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR 13 2
VBUND Company ID of trading partner RASSC CHAR 6 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
WVERW Bill of exchange usage type WVERW CHAR 1 0
D Discounting
F Forfeiting
I Collection
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
MWST2 Tax Amount in Second Local Currency MWST2 CURR 13 2
MWST3 Tax Amount in Third Local Currency MWST3 CURR 13 2
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR 13 2
RDIF3 Exchange Rate Difference Realized for Third Local Currency RDIF3 CURR 13 2
XRAGL Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
PRCTR Profit Center PRCTR CHAR 10 0
XSTOV Indicator: Document is flagged for reversal XSTOV CHAR 1 0
X Yes
NULL No
XARCH Indicator: Document already archived ? XARCH CHAR 1 0
X Yes
NULL No
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
RFZEI Payment Card Item RFZEI_CC NUMC 3 0
CCBTC Payment cards: Settlement run CCBTC CHAR 10 0
XREF3 Reference key for line item XREF3 CHAR 20 0
BUPLA Business Place BUPLA CHAR 4 0
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR 13 2
PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2 CURR 13 2
PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3 CURR 13 2
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
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 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
BUZID Identification of the Line Item BUZID CHAR 1 0
AUGGJ Fiscal Year of Clearing Document AUGGJ NUMC 4 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
PGEBER Partner Fund FM_PFUND CHAR 10 0
PGRANT_NBR Partner Grant GM_GRANT_PARTNER CHAR 20 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PBUDGET_PD FM: Partner Budget Period FM_PBUDGET_PERIOD CHAR 10 0
FIPEX Commitment item - Do not use field - see note 447805 FM_FIPEX_DONT_USE CHAR 24 0
PRODPER JVA_PROD_MONTH ACCP 6 0
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OINEGPSTG Negative posting line (exchange fees) OIA_NGPSTL CHAR 1 0
X Yes
NULL No
PROPMANO Mandate, Mandate-Opening Contract REHORECNNRM CHAR 13 0

BSAS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSAS PROJK BSAS MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
BSAS PROJK BSAS PROJK PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR