SAP table BSAK (Generated Table for View)

SAP table BSAK has 11 primary key fields being MANDT,BUKRS,LIFNR,UMSKS,UMSKZ,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 LFB1 BUKRS
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
UMSKZ Special G/L Indicator CHAR 1 0 UMSKZ
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
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
WAERS Currency Key CUKY 5 0 WAERS
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BLART Document Type CHAR 2 0 BLART
MONAT Fiscal period NUMC 2 0 MONAT
BSCHL Posting Key CHAR 2 0 BSCHL
ZUMSK Target Special G/L Indicator CHAR 1 0 DZUMSK
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
GSBER Business Area CHAR 4 0 GSBER
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
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
LWSTS Tax amount in Reporting Currency CURR 23 2 LWSTS
BDIFF Valuation Difference CURR 23 2 BDIFF
BDIF2 Valuation Difference for the Second Local Currency CURR 23 2 BDIF2
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 AUFNR
ANLN1 Main Asset Number CHAR 12 0 IFIMASTFIXASSET ANLN1
ANLN2 Asset Subnumber CHAR 4 0 IFIXASSET ANLN2
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
SAKNR G/L Account Number CHAR 10 0 SAKNR
HKONT General Ledger Account CHAR 10 0 HKONT
FKONT Financial Budget Item NUMC 3 0 FIPLS
FILKD Account Number of the Branch CHAR 10 0 FILKD
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 23 2 SKFBT
SKNTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
WSKTO Cash Discount Amount in Document Currency CURR 23 2 WSKTO
ZLSCH Payment Method CHAR 1 0 DZLSCH
ZLSPR Payment Block Key CHAR 1 0 DZLSPR
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
HBKID Short Key for a House Bank CHAR 5 0 HBKID
BVTYP Partner bank type CHAR 4 0 BVTYP
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
SAMNR Invoice List Number NUMC 8 0 SAMNR
ZOLLT Customs Tariff Number CHAR 8 0 DZOLLT
ZOLLD Customs Date DATS 8 0 DZOLLD
LZBKZ State Central Bank Indicator CHAR 3 0 LZBKZ
LANDL Supplying Country/Region CHAR 3 0 LANDL
DIEKZ Service Indicator (Foreign Payment) CHAR 1 0 DIEKZ
MANSP Dunning Block CHAR 1 0 MANSP
MSCHL Dunning Key CHAR 1 0 MSCHL
MADAT Date of Last Dunning Notice DATS 8 0 MADAT
MANST Dunning Level NUMC 1 0 MAHNS_D
MABER Dunning Area CHAR 2 0 MABER
XNETB Indicator: Document posted net ? CHAR 1 0 XNETB
XANET Indicator: Down Payment in Net Procedure? CHAR 1 0 XANET
XCPDD Indicator: Address and Bank Data Set Individually CHAR 1 0 XCPDD
XESRD Indicator: Is Any ISR Data Set in the Document? CHAR 1 0 XESRD
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
MWSK1 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM1 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY1 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
DMBT1 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT1 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR1 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK2 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM2 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY2 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
DMBT2 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT2 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR2 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
MWSK3 Tax Code for Distribution CHAR 2 0 MWSKX
TXDAT_FROM3 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TAX_COUNTRY3 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
DMBT3 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT3 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
HIST_TAX_FACTOR3 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
HIST_TAX_FACTOR Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
QSSKZ Withholding Tax Code CHAR 2 0 QSSKZ
QSSHB Withholding Tax Base Amount CURR 23 2 QSSHB
QBSHB Withholding Tax Amount (in Document Currency) CURR 23 2 QBSHB
BSTAT Document Status CHAR 1 0 BSTAT_D
ANFBN Document Number of the Bill of Exchange Payment Request CHAR 10 0 ANFBN
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document NUMC 4 0 ANFBJ
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted CHAR 4 0 ANFBU
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
REBZT Follow-On Document Type CHAR 1 0 REBZT
STCEG VAT Registration Number CHAR 20 0 STCEG
EGBLD Country/Region of Destination for Delivery of Goods CHAR 3 0 EGBLD
EGLLD Supplying Country/Region for Delivery of Goods CHAR 3 0 EGLLD
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
QSFBT Withholding Tax-Exempt Amount (in Document Currency) CURR 23 2 QSFBT
XINVE Indicator: Capital Goods Affected? CHAR 1 0 XINVE
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
FIPOS Commitment Item CHAR 14 0 FIPOS
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
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
DMB21 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB22 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB23 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB31 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB32 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB33 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
MWST2 Tax Amount in Second Local Currency CURR 23 2 MWST2
MWST3 Tax Amount in Third Local Currency CURR 23 2 MWST3
SKNT2 Cash Discount Amount in Second Local Currency CURR 23 2 SKNT2
SKNT3 Cash Discount Amount in Third Local Currency CURR 23 2 SKNT3
BDIF3 Valuation Difference for the Third Local Currency CURR 23 2 BDIF3
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
RSTGR Reason Code for Payments CHAR 3 0 RSTGR
UZAWE Payment method supplement CHAR 2 0 T042F UZAWE
KOSTL Cost Center CHAR 10 0 KOSTL
LNRAN Sequence Number of Asset Line Items in Fiscal Year NUMC 5 0 ANEK LNRAN
XSTOV Indicator: Document Is Flagged for Reversal CHAR 1 0 XSTOV
KZBTR Original Reduction Amount in Local Currency CURR 23 2 KZBTR_FI
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
XARCH Indicator: Document Already Archived? CHAR 1 0 XARCH
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 TCURC PSWSL
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
EMPFB Payee/Payer CHAR 10 0 EMPFB
PRCTR Profit Center CHAR 10 0 PRCTR
XREF3 Reference key for line item CHAR 20 0 XREF3
DTWS1 Instruction Key 1 NUMC 2 0 DTAT16
DTWS2 Instruction Key 2 NUMC 2 0 DTAT17
DTWS3 Instruction key 3 NUMC 2 0 DTAT18
DTWS4 Instruction key 4 NUMC 2 0 DTAT19
XPYPR Indicator: Items from Payment Program Blocked CHAR 1 0 XPYPR
KIDNO Payment Reference CHAR 30 0 KIDNO
PYCUR Currency for Automatic Payment CUKY 5 0 PYCUR
PYAMT Amount in Payment Currency CURR 23 2 PYAMT
BUPLA Business Place CHAR 4 0 BUPLA
SECCO Section Code CHAR 4 0 SECCO
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
PENLC1 Penalty Charge Amount in First Local Currency CURR 23 2 PENALTY1
PENLC2 Penalty Charge Amount in Second Local Currency CURR 23 2 PENALTY2
PENLC3 Penalty Charge Amount in Third Local Currency CURR 23 2 PENALTY3
PENFC Penalty Charge Amount in Document Currency CURR 23 2 PENALTY
PENDAYS Number of Days for Penalty Charge Calculation INT4 10 0 PDAYS
PENRC Reason for Late Payment CHAR 2 0 PENRC
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 SBEWART
KBLNR Document Number for Earmarked Funds CHAR 10 0 KBLNR_FI
KBLPOS Earmarked Funds: Document Item NUMC 3 0 KBLPOS
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
GMVKZ Item is in Execution CHAR 1 0 FM_GMVKZ
Item not transferred to execution
I Item for information transferred to execution
X Item must be executed
SRTYPE Type of Additional Receivable CHAR 2 0 FM_SRTYPE
1 Dunning Charge
2 Dunning Interest
3 Deferral Interest
4 General Execution Costs
LOTKZ Lot Number for Requests CHAR 10 0 PSO_LOTKZ
ZINKZ Exempted from Interest Calculation CHAR 2 0 DZINKZ
FKBER Functional Area CHAR 16 0 FKBER
INTRENO Internal Real Estate Master Data Code CHAR 13 0 VVINTRENO
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
HKTID ID for Account Details CHAR 5 0 HKTID
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_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
PAYT_RSN Payment Reason CHAR 4 0 FARP_PAYT_RSN
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
KONTT Account Assignment Category for Industry Solution CHAR 2 0 KONTT_FI
KONTL Acct assignment string for industry-specific acct assignmnts CHAR 50 0 KONTL_FI
UEBGDAT Transfer Date of an Item to Legal Dunning Proceeding DATS 8 0 UEBGDATUM
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
EGRUP Equity group CHAR 3 0 T8JF JV_EGROUP
BTYPE Billing Indicator CHAR 2 0 T8JA JV_BILIND
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
PERNR Personnel Number NUMC 8 0 PERNR_D
VORGN Transaction Type for General Ledger CHAR 4 0 VORGN
AWTYP Reference procedure CHAR 5 0 AWTYP
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

BSAK foreign key relationships

Table Field Check Table Check Field
0 BSAK ANLN1 IFIMASTFIXASSET Generated Table for View MANDT
0 BSAK ANLN1 IFIMASTFIXASSET Generated Table for View COMPANYCODE
0 BSAK ANLN1 IFIMASTFIXASSET Generated Table for View MASTERFIXEDASSET
1 BSAK ANLN2 IFIXASSET Generated Table for View MANDT
1 BSAK ANLN2 IFIXASSET Generated Table for View COMPANYCODE
1 BSAK ANLN2 IFIXASSET Generated Table for View MASTERFIXEDASSET
1 BSAK ANLN2 IFIXASSET Generated Table for View FIXEDASSET
0 BSAK BTYPE T8JA Payroll Type MANDT
0 BSAK BTYPE T8JA Payroll Type BILIND
1 BSAK BUKRS LFB1 Vendor Master (Company Code) MANDT
1 BSAK BUKRS LFB1 Vendor Master (Company Code) LIFNR
1 BSAK BUKRS LFB1 Vendor Master (Company Code) BUKRS
0 BSAK EGRUP T8JF Investment Group MANDT
0 BSAK EGRUP T8JF Investment Group BUKRS
0 BSAK EGRUP T8JF Investment Group VNAME
0 BSAK EGRUP T8JF Investment Group EGRUP
1 BSAK LIFNR LFA1 Supplier Master (General Section) MANDT
1 BSAK LIFNR LFA1 Supplier Master (General Section) LIFNR
0 BSAK LNRAN ANEK Document Header Asset Posting MANDT
0 BSAK LNRAN ANEK Document Header Asset Posting BUKRS
0 BSAK LNRAN ANEK Document Header Asset Posting ANLN1
0 BSAK LNRAN ANEK Document Header Asset Posting ANLN2
0 BSAK LNRAN ANEK Document Header Asset Posting GJAHR
0 BSAK LNRAN ANEK Document Header Asset Posting LNRAN
1 BSAK PSWSL TCURC Currency Codes MANDT
1 BSAK PSWSL TCURC Currency Codes WAERS
0 BSAK UZAWE T042F Payment method supplements MANDT
0 BSAK UZAWE T042F Payment method supplements UZAWE
1 BSAK VNAME T8JV Joint Venture MANDT
1 BSAK VNAME T8JV Joint Venture BUKRS
1 BSAK VNAME T8JV Joint Venture VNAME