SAP table BSIS (Generated Table for View)

SAP table BSIS has 9 primary key fields being MANDT,BUKRS,HKONT,AUGDT,AUGBL,ZUONR,GJAHR,BELNR,BUZEI.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
HKONT General Ledger Account CHAR 10 0 HKONT
AUGDT Clearing Date DATS 8 0 AUGDT
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
ZUONR Assignment number CHAR 18 0 DZUONR
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
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
WAERS Currency Key CUKY 5 0 TCURC WAERS
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BLART Document Type CHAR 2 0 T003 BLART
MONAT Fiscal period NUMC 2 0 MONAT
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
GSBER Business Area CHAR 4 0 TGSB GSBER
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
FKONT Financial Budget Item NUMC 3 0 FIPLS
DMBTR Amount in local currency CURR 23 2 DMBTR
WRBTR Amount in document currency CURR 23 2 WRBTR
FCSL Amount in Functional Currency CURR 23 2 FINS_VFCCUR12
RFCCUR Functional Currency CUKY 5 0 FINS_CURRFC
MWSTS Tax Amount in Local Currency CURR 23 2 MWSTS
WMWST Tax Amount in Document Currency CURR 23 2 WMWST
SGTXT Item Text CHAR 50 0 SGTXT
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
AUFNR Order Number CHAR 12 0 AUFK AUFNR_NEU
WERKS Plant CHAR 4 0 T001W WERKS_D
KOSTL Cost Center CHAR 10 0 KOSTL
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
VALUT Value date DATS 8 0 VALUT
BSTAT Document Status CHAR 1 0 BSTAT_D
BDIFF Valuation Difference CURR 23 2 BDIFF
BDIF2 Valuation Difference for the Second Local Currency CURR 23 2 BDIF2
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 TCURC PSWSL
WVERW Bill of Exchange Usage Type CHAR 1 0 WVERW
D Discounting
F Forfeiting
I Collection
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
MWST2 Tax Amount in Second Local Currency CURR 23 2 MWST2
MWST3 Tax Amount in Third Local Currency CURR 23 2 MWST3
BDIF3 Valuation Difference for the Third Local Currency CURR 23 2 BDIF3
RDIF3 Exchange Rate Difference Realized for Third Local Currency CURR 23 2 RDIF3
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
PRCTR Profit Center CHAR 10 0 PRCTR
XSTOV Indicator: Document Is Flagged for Reversal CHAR 1 0 XSTOV
XARCH Indicator: Document Already Archived? CHAR 1 0 XARCH
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
XREF3 Reference key for line item CHAR 20 0 XREF3
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23 2 PPDIFF
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts) CURR 23 2 PPDIF2
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts) CURR 23 2 PPDIF3
BEWAR Transaction type CHAR 3 0 T856 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
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
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
BUZID Identification of the Line Item CHAR 1 0 BUZID
AUGGJ Fiscal Year of Clearing Document NUMC 4 0 AUGGJ
UZAWE Payment method supplement CHAR 2 0 UZAWE
SEGMENT Segment for Segmental Reporting CHAR 10 0 FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FB_PSEGMENT
PGEBER Partner Fund CHAR 10 0 FM_PFUND
PGRANT_NBR Partner Grant CHAR 20 0 GM_GRANT_PARTNER
MEASURE Funded Program CHAR 24 0 FM_MEASURE
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
PBUDGET_PD FM: Partner Budget Period CHAR 10 0 FM_PBUDGET_PERIOD
BDGT_ACCOUNT Budget Account CHAR 10 0 PSM_BDGT_ACCOUNT
RE_ACCOUNT Cash Ledger: Expense or Revenue Account CHAR 10 0 FAGL_RE_ACCOUNT
FIPEX CHAR 1 0
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
KIDNO Payment Reference CHAR 30 0 KIDNO
PRODPER Production Month ACCP 6 0 JVA_PROD_MONTH
QSSKZ Withholding Tax Code CHAR 2 0 QSSKZ
PROPMANO Mandate, Mandate-Opening Contract CHAR 13 0 REHORECNNRM
GKONT Offsetting Account Number CHAR 10 0 GKONT
GKART Offsetting Account Type CHAR 1 0 GKOAR
GHKON G/L Acct of Offsetting Acct in General Ledger Accounting CHAR 10 0 GHKONT
LOGSYSTEM_SENDER Logical System of the Sender CHAR 10 0 LOGSYSTEM_SENDER
BUKRS_SENDER Company Code in Sender System CHAR 4 0 BUKRS_SENDER
BELNR_SENDER Document Number of an Accounting Document in Sender System CHAR 10 0 BELNR_SENDER
GJAHR_SENDER Fiscal Year of an Accounting Document in the Sender System NUMC 4 0 GJAHR_SENDER
BUZEI_SENDER Item Number Within Accounting Document in Sender System NUMC 3 0 BUZEI_SENDER
HBKID Short Key for a House Bank CHAR 5 0 HBKID
HKTID ID for Account Details CHAR 5 0 HKTID
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP

BSIS foreign key relationships

Table Field Check Table Check Field
0 BSIS AUFNR AUFK Order master data AUFNR
1 BSIS BEWAR T856 Transaction Types MANDT
1 BSIS BEWAR T856 Transaction Types TRTYP
0 BSIS BLART T003 Document Types MANDT
1 BSIS BSCHL TBSL Posting Key MANDT
1 BSIS BSCHL TBSL Posting Key BSCHL
0 BSIS BUPLA J_1BBRANCH Business Place MANDT
0 BSIS BUPLA J_1BBRANCH Business Place BUKRS
0 BSIS BUPLA J_1BBRANCH Business Place BRANCH
0 BSIS BUPLA J_1BBRANCH Business Place BUPLA_TYPE
1 BSIS GSBER TGSB Business Areas MANDT
1 BSIS GSBER TGSB Business Areas GSBER
0 BSIS MWSKZ T007A Tax Keys KALSM
0 BSIS MWSKZ T007A Tax Keys MWSKZ
1 BSIS PROJK PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 BSIS PROJK PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 BSIS PSWSL TCURC Currency Codes MANDT
0 BSIS PSWSL TCURC Currency Codes WAERS
1 BSIS VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 BSIS VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 BSIS WAERS TCURC Currency Codes MANDT
0 BSIS WAERS TCURC Currency Codes WAERS
1 BSIS WERKS T001W Plants/Branches MANDT
1 BSIS WERKS T001W Plants/Branches WERKS