Follow us on LinkedIn for your next SAP project

SAP Table BSAK

Accounting: Secondary Index for Vendors (Cleared Items)

BSAK (Accounting: Secondary Index for Vendors (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 BSAK to other SAP tables.

BSAK table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT
CLNT
3 0
BUKRS
Company Code
BUKRS LFB1
CHAR
4 0
LIFNR
Account Number of Vendor or Creditor
LIFNR LFA1
CHAR
10 0
UMSKS
Special G/L Transaction Type
UMSKS
CHAR
1 0
UMSKZ
Special G/L Indicator
UMSKZ
CHAR
1 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
CPUDT
Day On Which Accounting Document Was Entered
CPUDT
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
ZUMSK
Target Special G/L Indicator
DZUMSK
CHAR
1 0
SHKZG
Debit/Credit Indicator
SHKZG
CHAR
1 0
GSBER
Business Area
GSBER
CHAR
4 0
MWSKZ
Tax on sales/purchases code
MWSKZ
CHAR
2 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
BDIFF
Valuation Difference
BDIFF
CURR
13 2
BDIF2
Valuation Difference for the Second Local Currency
BDIF2
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
CHAR
12 0
ANLN1
Main Asset Number
ANLN1
CHAR
12 0
ANLN2
Asset Subnumber
ANLN2
CHAR
4 0
EBELN
Purchasing Document Number
EBELN
CHAR
10 0
EBELP
Item Number of Purchasing Document
EBELP
NUMC
5 0
SAKNR
G/L Account Number
SAKNR
CHAR
10 0
HKONT
General Ledger Account
HKONT
CHAR
10 0
FKONT
Financial Budget Item
FIPLS
NUMC
3 0
FILKD
Account Number of the Branch
FILKD
CHAR
10 0
ZFBDT
Baseline Date for Due Date Calculation
DZFBDT
DATS
8 0
ZTERM
Terms of Payment Key
DZTERM
CHAR
4 0
ZBD1T
Cash discount days 1
DZBD1T
DEC
3 0
ZBD2T
Cash discount days 2
DZBD2T
DEC
3 0
ZBD3T
Net Payment Terms Period
DZBD3T
DEC
3 0
ZBD1P
Cash Discount Percentage 1
DZBD1P
DEC
5 3
ZBD2P
Cash Discount Percentage 2
DZBD2P
DEC
5 3
SKFBT
Amount Eligible for Cash Discount in Document Currency
SKFBT
CURR
13 2
SKNTO
Cash discount amount in local currency
SKNTO
CURR
13 2
WSKTO
Cash discount amount in document currency
WSKTO
CURR
13 2
ZLSCH
Payment Method
DZLSCH
CHAR
1 0
ZLSPR
Payment Block Key
DZLSPR
CHAR
1 0
ZBFIX
Fixed Payment Terms
DZBFIX
CHAR
1 0
HBKID
Short Key for a House Bank
HBKID
CHAR
5 0
BVTYP
Partner Bank Type
BVTYP
CHAR
4 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
SAMNR
Invoice List Number
SAMNR
NUMC
8 0
ZOLLT
Customs Tariff Number
DZOLLT
CHAR
8 0
ZOLLD
Customs Date
DZOLLD
DATS
8 0
LZBKZ
State Central Bank Indicator
LZBKZ
CHAR
3 0
LANDL
Supplying Country
LANDL
CHAR
3 0
DIEKZ
Service Indicator (Foreign Payment)
DIEKZ
CHAR
1 0
MANSP
Dunning block
MANSP
CHAR
1 0
MSCHL
Dunning key
MSCHL
CHAR
1 0
MADAT
Last dunned on
MADAT
DATS
8 0
MANST
Dunning level
MAHNS_D
NUMC
1 0
MABER
Dunning Area
MABER
CHAR
2 0
XNETB
Indicator: Document posted net ?
XNETB
CHAR
1 0
XANET
Indicator: Down payment in net procedure ?
XANET
CHAR
1 0
XCPDD
Indicator: Address and bank data set individually
XCPDD
CHAR
1 0
XESRD
Indicator: Is any ISR data set in the document ?
XESRD
CHAR
1 0
XZAHL
Indicator: Is the posting key used in a payment transaction?
XZAHL
CHAR
1 0
MWSK1
Tax Code for Distribution
MWSKX
CHAR
2 0
DMBT1
Amount in Local Currency for Tax Distribution
DMBTX
CURR
13 2
WRBT1
Amount in foreign currency for tax breakdown
WRBTX
CURR
13 2
MWSK2
Tax Code for Distribution
MWSKX
CHAR
2 0
DMBT2
Amount in Local Currency for Tax Distribution
DMBTX
CURR
13 2
WRBT2
Amount in foreign currency for tax breakdown
WRBTX
CURR
13 2
MWSK3
Tax Code for Distribution
MWSKX
CHAR
2 0
DMBT3
Amount in Local Currency for Tax Distribution
DMBTX
CURR
13 2
WRBT3
Amount in foreign currency for tax breakdown
WRBTX
CURR
13 2
QSSKZ
Withholding Tax Code
QSSKZ
CHAR
2 0
QSSHB
Withholding Tax Base Amount
QSSHB
CURR
13 2
QBSHB
Withholding Tax Amount (in Document Currency)
QBSHB
CURR
13 2
BSTAT
Document Status
BSTAT_D
CHAR
1 0
ANFBN
Document Number of the Bill of Exchange Payment Request
ANFBN
CHAR
10 0
ANFBJ
Fiscal Year of the Bill of Exchange Payment Request Document
ANFBJ
NUMC
4 0
ANFBU
Company Code in Which Bill of Exch.Payment Request Is Posted
ANFBU
CHAR
4 0
VBUND
Company ID of trading partner
RASSC
CHAR
6 0
REBZT
Follow-On Document Type
REBZT
CHAR
1 0
STCEG
VAT Registration Number
STCEG
CHAR
20 0
EGBLD
Country of Destination for Delivery of Goods
EGBLD
CHAR
3 0
EGLLD
Supplying Country for Delivery of Goods
EGLLD
CHAR
3 0
QSZNR
Certificate Number of the Withholding Tax Exemption
QSZNR
CHAR
10 0
QSFBT
Withholding Tax-Exempt Amount (in Document Currency)
QSFBT
CURR
13 2
XINVE
Indicator: Capital Goods Affected?
XINVE
CHAR
1 0
PROJK
Work Breakdown Structure Element (WBS Element)
PS_PSP_PNR
NUMC
8 0
FIPOS
Commitment Item
FIPOS
CHAR
14 0
NPLNR
Network Number for Account Assignment
NPLNR
CHAR
12 0
AUFPL
Routing number of operations in the order
CO_AUFPL
NUMC
10 0
APLZL
Internal counter
CIM_COUNT
NUMC
8 0
XEGDR
Indicator: Triangular deal within the EU ?
XEGDR
CHAR
1 0
DMBE2
Amount in Second Local Currency
DMBE2
CURR
13 2
DMBE3
Amount in Third Local Currency
DMBE3
CURR
13 2
DMB21
Amount in Second Local Currency for Tax Breakdown
DMB2X
CURR
13 2
DMB22
Amount in Second Local Currency for Tax Breakdown
DMB2X
CURR
13 2
DMB23
Amount in Second Local Currency for Tax Breakdown
DMB2X
CURR
13 2
DMB31
Amount in Third Local Currency for Tax Breakdown
DMB3X
CURR
13 2
DMB32
Amount in Third Local Currency for Tax Breakdown
DMB3X
CURR
13 2
DMB33
Amount in Third Local Currency for Tax Breakdown
DMB3X
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
SKNT2
Cash Discount Amount in Second Local Currency
SKNT2
CURR
13 2
SKNT3
Cash Discount Amount in Third Local Currency
SKNT3
CURR
13 2
BDIF3
Valuation Difference for the Third Local Currency
BDIF3
CURR
13 2
XRAGL
Indicator: Clearing was Reversed
XRAGL
CHAR
1 0
RSTGR
Reason Code for Payments
RSTGR
CHAR
3 0
UZAWE
Payment Method Supplement
UZAWE T042F
CHAR
2 0
KOSTL
Cost Center
KOSTL
CHAR
10 0
LNRAN
Sequence number of asset line items in fiscal year
LNRAN ANEK
NUMC
5 0
XSTOV
Indicator: Document is flagged for reversal
XSTOV
CHAR
1 0
KZBTR
Original Reduction Amount in Local Currency
KZBTR_FI
CURR
13 2
XREF1
Business partner reference key
XREF1
CHAR
12 0
XREF2
Business partner reference key
XREF2
CHAR
12 0
XARCH
Indicator: Document already archived ?
XARCH
CHAR
1 0
PSWSL
Update Currency for General Ledger Transaction Figures
PSWSL TCURC
CUKY
5 0
PSWBT
Amount for Updating in General Ledger
PSWBT
CURR
13 2
IMKEY
Internal Key for Real Estate Object
IMKEY
CHAR
8 0
ZEKKN
Sequential Number of Account Assignment
DZEKKN
NUMC
2 0
FISTL
Funds Center
FISTL
CHAR
16 0
GEBER
Fund
BP_GEBER
CHAR
10 0
DABRZ
Reference Date for Settlement
DABRBEZ
DATS
8 0
XNEGP
Indicator: Negative posting
XNEGP
CHAR
1 0
EMPFB
Payee/Payer
EMPFB
CHAR
10 0
PRCTR
Profit Center
PRCTR
CHAR
10 0
XREF3
Reference key for line item
XREF3
CHAR
20 0
DTWS1
Instruction key 1
DTAT16
NUMC
2 0
DTWS2
Instruction key 2
DTAT17
NUMC
2 0
DTWS3
Instruction key 3
DTAT18
NUMC
2 0
DTWS4
Instruction key 4
DTAT19
NUMC
2 0
XPYPR
Indicator: Items from Payment Program Blocked
XPYPR
CHAR
1 0
KIDNO
Payment Reference
KIDNO
CHAR
30 0
PYCUR
Currency for Automatic Payment
PYCUR
CUKY
5 0
PYAMT
Amount in Payment Currency
PYAMT
CURR
13 2
BUPLA
Business Place
BUPLA
CHAR
4 0
SECCO
Section Code
SECCO
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
PENLC1
Penalty charge amount in first local currency
PENALTY1
CURR
13 2
PENLC2
Penalty charge amount in second local currency
PENALTY2
CURR
13 2
PENLC3
Penalty Charge Amount in Third Local Currency
PENALTY3
CURR
13 2
PENFC
Penalty charge amount in document currency
PENALTY
CURR
13 2
PENDAYS
Number of days for penalty charge calculation
PDAYS
INT4
10 0
PENRC
Reason for late payment
PENRC
CHAR
2 0
VERTT
Contract Type
RANTYP
CHAR
1 0
VERTN
Contract Number
RANL
CHAR
13 0
VBEWA
Flow Type
SBEWART
CHAR
4 0
KBLNR
Document Number for Earmarked Funds
KBLNR_FI
CHAR
10 0
KBLPOS
Earmarked Funds: Document Item
KBLPOS
NUMC
3 0
GRANT_NBR
Grant
GM_GRANT_NBR
CHAR
20 0
GMVKZ
Item is in Execution
FM_GMVKZ
CHAR
1 0
SRTYPE
Type of Additional Receivable
FM_SRTYPE
CHAR
2 0
LOTKZ
Lot Number for Requests
PSO_LOTKZ
CHAR
10 0
ZINKZ
Exempted from interest calculation
DZINKZ
CHAR
2 0
FKBER
Functional Area
FKBER
CHAR
16 0
INTRENO
Internal Real Estate Master Data Code
VVINTRENO
CHAR
13 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
HKTID
ID for account details
HKTID
CHAR
5 0
BUDGET_PD
FM: Budget Period
FM_BUDGET_PERIOD
CHAR
10 0
KONTT
Account Assignment Category for Industry Solution
KONTT_FI
CHAR
2 0
KONTL
Acct assignment string for industry-specific acct assignmnts
KONTL_FI
CHAR
50 0
UEBGDAT
Transfer date of an item to legal dunning proceeding
UEBGDAT
DATS
8 0
VNAME
Joint Venture
JV_NAME T8JV
CHAR
6 0
EGRUP
Equity group
JV_EGROUP T8JF
CHAR
3 0
BTYPE
Payroll Type
JV_BILIND T8JA
CHAR
2 0
OIEXGNUM
Exchange agreement number
OIA_EXGNUM
CHAR
10 0
OINETCYC
Netting cycle (FI blocking indicator)
OIA_NETCYC
CHAR
1 0
OIEXGTYP
Exchange type
OIA_EXGTYP
CHAR
4 0
PROPMANO
Mandate, Mandate-Opening Contract
REHORECNNRM
CHAR
13 0

BSAK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSAK BTYPE BSAK MANDT T8JA
Payroll Type
MANDT
BSAK BTYPE BSAK BTYPE T8JA
Payroll Type
BILIND
BSAK BUKRS BSAK MANDT LFB1
Vendor Master (Company Code)
MANDT
BSAK BUKRS BSAK LIFNR LFB1
Vendor Master (Company Code)
LIFNR
BSAK BUKRS BSAK BUKRS LFB1
Vendor Master (Company Code)
BUKRS
BSAK EGRUP BSAK BUKRS T8JF
Investment Group
BUKRS
BSAK EGRUP BSAK VNAME T8JF
Investment Group
VNAME
BSAK EGRUP BSAK EGRUP T8JF
Investment Group
EGRUP
BSAK EGRUP BSAK MANDT T8JF
Investment Group
MANDT
BSAK LIFNR BSAK MANDT LFA1
Vendor Master (General Section)
MANDT
BSAK LIFNR BSAK LIFNR LFA1
Vendor Master (General Section)
LIFNR
BSAK LNRAN BSAK MANDT ANEK
Document Header Asset Posting
MANDT
BSAK LNRAN BSAK ANFBU ANEK
Document Header Asset Posting
BUKRS
BSAK LNRAN BSAK ANLN1 ANEK
Document Header Asset Posting
ANLN1
BSAK LNRAN BSAK ANLN2 ANEK
Document Header Asset Posting
ANLN2
BSAK LNRAN BSAK ANFBJ ANEK
Document Header Asset Posting
GJAHR
BSAK LNRAN BSAK LNRAN ANEK
Document Header Asset Posting
LNRAN
BSAK PSWSL BSAK MANDT TCURC
Currency Codes
MANDT
BSAK PSWSL BSAK PSWSL TCURC
Currency Codes
WAERS
BSAK UZAWE BSAK MANDT T042F
Payment method supplements
MANDT
BSAK UZAWE BSAK UZAWE T042F
Payment method supplements
UZAWE
BSAK VNAME BSAK MANDT T8JV
Joint Venture
MANDT
BSAK VNAME BSAK BUKRS T8JV
Joint Venture
BUKRS
BSAK VNAME BSAK VNAME T8JV
Joint Venture
VNAME