1. Home
  2. Resources
  3. SAP Tables
  4. BSIW - Index table for customer bills of exchange used

SAP Table BSIW

Index table for customer bills of exchange used

BSIW (Index table for customer bills of exchange used) 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 BSIW to other SAP tables.

BSIW table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS KNB1 CHAR 4 0
HKONT General Ledger Account HKONT CHAR 10 0
ZUONR Assignment Number DZUONR CHAR 18 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
KUNNR Customer Number KUNNR CHAR 10 0
SAKNR G/L Account Number SAKNR CHAR 10 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
BSCHL Posting Key BSCHL CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
WAERS Currency Key WAERS CUKY 5 0
WRBTR Amount in document currency WRBTR CURR 13 2
DMBTR Amount in Local Currency DMBTR CURR 13 2
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
WELGF Life of a bill of exchange WELGF DEC 3 0
BLART Document Type BLART CHAR 2 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
VBUND Company ID VBUND CHAR 6 0
GSBER Business Area GSBER CHAR 4 0
WVERW Bill of exchange usage type WVERW CHAR 1 0
D Discounting
F Forfeiting
I Collection
DISBN Number of Bill of Exchange Usage Document (Discount Doc.) DISBN CHAR 10 0
DISBJ Fiscal Year of Bill of Exchange Usage Document DISBJ NUMC 4 0
DISBZ Line Item within the Bill of Exchange Usage Document DISBZ NUMC 3 0
BSCHLDIS Posting Key BSCHL CHAR 2 0
HKONTDIS General Ledger Account HKONT CHAR 10 0
GSBERDIS Business Area GSBER CHAR 4 0
VBUNDDIS Company ID VBUND CHAR 6 0
ZUONRDIS Assignment Number DZUONR CHAR 18 0
BUDATDIS Posting Date in the Document BUDAT DATS 8 0

BSIW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BSIW BUKRS BSIW BUKRS KNB1 Customer Master (Company Code) BUKRS
BSIW BUKRS BSIW MANDT KNB1 Customer Master (Company Code) MANDT
BSIW BUKRS BSIW KUNNR KNB1 Customer Master (Company Code) KUNNR