SAP table BSIX (Index table for customer bills of exchange used)
SAP table BSIX has 7 primary key fields being MANDT,BUKRS,HKONT,ZUONR,BELNR,GJAHR,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
ZUONR
Assignment number
CHAR
18
0
DZUONR
BELNR
Document Number of an Accounting Document
CHAR
10
0
BELNR_D
GJAHR
Fiscal Year
NUMC
4
0
GJAHR
BUZEI
Number of Line Item Within Accounting Document
NUMC
3
0
BUZEI
KUNNR
Customer Number
CHAR
10
0
KUNNR
SAKNR
G/L Account Number
CHAR
10
0
SAKNR
UMSKZ
Special G/L Indicator
CHAR
1
0
UMSKZ
UMSKS
Special G/L Transaction Type
CHAR
1
0
UMSKS
BSCHL
Posting Key
CHAR
2
0
BSCHL
SHKZG
Debit/Credit Indicator
CHAR
1
0
SHKZG
H
Credit
S
Debit
WAERS
Currency Key
CUKY
5
0
WAERS
WRBTR
Amount in document currency
CURR
23
2
WRBTR
DMBTR
Amount in local currency
CURR
23
2
DMBTR
ZFBDT
Baseline Date for Due Date Calculation
DATS
8
0
DZFBDT
WELGF
Life of a Bill of Exchange
DEC
3
0
WELGF
BLART
Document Type
CHAR
2
0
BLART
BUDAT
Posting Date in the Document
DATS
8
0
BUDAT
XBLNR
Reference Document Number
CHAR
16
0
XBLNR1
VBUND
Company ID of Trading Partner
CHAR
6
0
RASSC
GSBER
Business Area
CHAR
4
0
GSBER
BUPLA
Business Place
CHAR
4
0
BUPLA
WVERW
Bill of Exchange Usage Type
CHAR
1
0
WVERW
D
Discounting
F
Forfeiting
I
Collection
DISBN
Number of Bill of Exchange Usage Document (Discount Doc.)
CHAR
10
0
DISBN
DISBJ
Fiscal Year of Bill of Exchange Usage Document
NUMC
4
0
DISBJ
DISBZ
Line Item Within the Bill of Exchange Usage Document
NUMC
3
0
DISBZ
BSCHLDIS
Posting Key
CHAR
2
0
BSCHL
HKONTDIS
General Ledger Account
CHAR
10
0
HKONT
GSBERDIS
Business Area
CHAR
4
0
GSBER
VBUNDDIS
Company ID of Trading Partner
CHAR
6
0
RASSC
ZUONRDIS
Assignment number
CHAR
18
0
DZUONR
BUDATDIS
Posting Date in the Document
DATS
8
0
BUDAT
DMBE2
Amount in Second Local Currency or Global Currency
CURR
23
2
DMBE2
DMBE3
Amount in Third Local Currency or First Freely-Def. Currency