BSID is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for Customers data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for BSID. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

BSID — Meta Data

Description: Accounting: Secondary Index for Customers
Main Category: FI
Sub Category: Financial Accounting
Table type: Transparent Table (TRANSP)

BSID — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 BUKRS Company Code X CHAR 4 T001
    3 KUNNR Customer X CHAR 10 KNA1
    4 UMSKS Transact.type X CHAR 1
    5 UMSKZ Special G/L ind X CHAR 1
    6 AUGDT Clearing X DATS 8
    7 AUGBL Clrng doc. X CHAR 10
    8 ZUONR Assignment X CHAR 18
    9 GJAHR Fiscal Year X NUMC 4
    10 BELNR Document Number X CHAR 10
    11 BUZEI Posting row X NUMC 3
    12 BUDAT Posting Date DATS 8
    13 BLDAT Document Date DATS 8
    14 CPUDT Entered on DATS 8
    15 WAERS Currency CUKY 5 TCURC
    16 XBLNR Reference CHAR 16
    17 BLART Document Type CHAR 2 T003
    18 MONAT Period NUMC 2
    19 BSCHL Posting key CHAR 2 TBSL
    20 ZUMSK Target Special G/L Indicator CHAR 1
    21 SHKZG Debit/Credit CHAR 1
    22 GSBER Business Area CHAR 4 TGSB
    23 MWSKZ Tax code CHAR 2 T007A
    24 DMBTR Amount in LC CURR 23
    25 WRBTR Amount CURR 23
    26 MWSTS Tax Amount in Local Currency CURR 23
    27 WMWST Tax Amount in Document Currency CURR 23
    28 BDIFF Valuation diff. CURR 23
    29 BDIF2 Valuation diff. 2 CURR 23
    30 SGTXT Name CHAR 50
    31 PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16
    32 AUFNR Order CHAR 12 AUFK
    33 ANLN1 Asset CHAR 12 ANLH
    34 ANLN2 Asset Subnumber CHAR 4 ANLA
    35 SAKNR G/L Account CHAR 10 SKB1
    36 HKONT G/L CHAR 10 SKB1
    37 FKONT Financial Budget Item NUMC 3
    38 FILKD Branch CHAR 10
    39 ZFBDT Baseline date DATS 8
    40 ZTERM Payt terms CHAR 4
    41 ZBD1T Days DEC 3
    42 ZBD2T Days DEC 3
    43 ZBD3T Days net DEC 3
    44 ZBD1P Cash discount 1 DEC 5
    45 ZBD2P Cash discount 2 DEC 5
    46 SKFBT Disc. base CURR 23
    47 SKNTO Discount amt CURR 23
    48 WSKTO Disc. amount CURR 23
    49 ZLSCH Pymt method CHAR 1 T042Z
    50 ZLSPR Pmnt block CHAR 1 T008
    51 ZBFIX Fixed CHAR 1
    52 HBKID Short key for a house bank CHAR 5 T012
    53 BVTYP Partner bank type CHAR 4
    54 REBZG Invoice ref. CHAR 10
    55 REBZJ Fiscal year NUMC 4
    56 REBZZ Line item NUMC 3
    57 SAMNR Collect.inv. NUMC 8
    58 ANFBN Document Number of the Bill of Exchange Payment Request CHAR 10
    59 ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document NUMC 4
    60 ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted CHAR 4 T001
    61 ANFAE Bill of Exchange Payment Request Due Date DATS 8
    62 MANSP Dunn. block CHAR 1 T040S
    63 MSCHL Dunning key CHAR 1 T040
    64 MADAT Last dunned DATS 8
    65 MANST Dunning level NUMC 1
    66 MABER Dunning Area CHAR 2 T047M
    67 XNETB Indicator: Document Posted Net ? CHAR 1
    68 XANET Indicator: Down payment in net procedure ? CHAR 1
    69 XCPDD Indicator: Address and Bank Data Set Individually CHAR 1
    70 XINVE Indicator: Capital Goods Affected? CHAR 1
    71 XZAHL Pymt tran. CHAR 1
    72 MWSK1 Tax Code for Distribution CHAR 2 T007A
    73 DMBT1 Amount in Local Currency for Tax Distribution CURR 23
    74 WRBT1 Amount in Foreign Currency for Tax Breakdown CURR 23
    75 MWSK2 Tax Code for Distribution CHAR 2 T007A
    76 DMBT2 Amount in Local Currency for Tax Distribution CURR 23
    77 WRBT2 Amount in Foreign Currency for Tax Breakdown CURR 23
    78 MWSK3 Tax Code for Distribution CHAR 2 T007A
    79 DMBT3 Amount in Local Currency for Tax Distribution CURR 23
    80 WRBT3 Amount in Foreign Currency for Tax Breakdown CURR 23
    81 BSTAT Doc.status CHAR 1
    82 VBUND Trading Partner CHAR 6 T880
    83 VBELN Sales Document CHAR 10
    84 REBZT Following Document Type CHAR 1
    85 INFAE CHAR08 CHAR 8
    86 STCEG VAT registration number CHAR 20
    87 EGBLD Country of Destination for Delivery of Goods CHAR 3 T005
    88 EGLLD Supplying Country for Delivery of Goods CHAR 3 T005
    89 RSTGR Reason code CHAR 3 T053R
    90 XNOZA Character Field of Length 1 CHAR 1
    91 VERTT Contract Type CHAR 1
    92 VERTN Contract Number CHAR 13
    93 VBEWA Flow Type CHAR 4
    94 WVERW Usage CHAR 1
    95 PROJK WBS element NUMC 8
    96 FIPOS Commitment Item CHAR 14
    97 NPLNR Network Number for Account Assignment CHAR 12
    98 AUFPL Routing number of operations in the order NUMC 10
    99 APLZL General counter for order NUMC 8
    100 XEGDR Indicator: Triangular deal within the EU ? CHAR 1
    101 DMBE2 Amt loc.curr.2 CURR 23
    102 DMBE3 Amt loc. curr.3 CURR 23
    103 DMB21 Amount in Second Local Currency for Tax Breakdown CURR 23
    104 DMB22 Amount in Second Local Currency for Tax Breakdown CURR 23
    105 DMB23 Amount in Second Local Currency for Tax Breakdown CURR 23
    106 DMB31 Amount in Third Local Currency for Tax Breakdown CURR 23
    107 DMB32 Amount in Third Local Currency for Tax Breakdown CURR 23
    108 DMB33 Amount in Third Local Currency for Tax Breakdown CURR 23
    109 BDIF3 Valuation diff. 3 CURR 23
    110 XRAGL Indicator: Clearing Was Reversed CHAR 1
    111 UZAWE Pmt meth.supl. CHAR 2 T042F
    112 XSTOV Indicator: Document Is Flagged for Reversal CHAR 1
    113 MWST2 Tax Amount in Second Local Currency CURR 23
    114 MWST3 Tax Amount in Third Local Currency CURR 23
    115 SKNT2 Cash Discount Amount in Second Local Currency CURR 23
    116 SKNT3 Cash Discount Amount in Third Local Currency CURR 23
    117 XREF1 Reference key 1 CHAR 12
    118 XREF2 Reference key 2 CHAR 12
    119 XARCH Character Field of Length 1 CHAR 1
    120 PSWSL G/L currency CUKY 5 TCURC
    121 PSWBT General ledger amt CURR 23
    122 LZBKZ State central bank indicator CHAR 3 T015L
    123 LANDL Supplying Country CHAR 3 T005
    124 IMKEY Real Estate Key CHAR 8
    125 VBEL2 Sales Document CHAR 10
    126 VPOS2 Numerical Field (Length 6) NUMC 6
    127 POSN2 Item NUMC 6
    128 ETEN2 Schedule Line NUMC 4 VBEP
    129 FISTL Funds Center CHAR 16
    130 GEBER Fund CHAR 10
    131 DABRZ Reference Date DATS 8
    132 XNEGP Negative pstng CHAR 1
    133 KOSTL Cost Center CHAR 10
    134 RFZEI Pmnt card item NUMC 3
    135 KKBER Cred.contr.area CHAR 4 T014
    136 EMPFB Payee/Payer CHAR 10
    137 PRCTR Profit Center CHAR 10
    138 XREF3 Reference key 3 CHAR 20
    139 QSSKZ Withholding Tax Code CHAR 2 T059Q
    140 ZINKZ Exempted from Interest Calculation CHAR 2
    141 DTWS1 Instruct.key 1 NUMC 2
    142 DTWS2 Instruct. key 2 NUMC 2
    143 DTWS3 Instruct. key 3 NUMC 2
    144 DTWS4 Instruct. key 4 NUMC 2
    145 XPYPR Payment sent CHAR 1
    146 KIDNO Payment Ref. CHAR 30
    147 ABSBT Hedged amount CURR 23
    148 CCBTC Settlement CHAR 10
    149 PYCUR Payment cur. CUKY 5 TCURC
    150 PYAMT Amt in pyt cur. CURR 23
    151 BUPLA Business Place CHAR 4 J_1BBRANCH
    152 SECCO Section Code CHAR 4 SECCODE
    153 CESSION_KZ AR Pledging Ind CHAR 2 TCESSION
    154 PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23
    155 PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) CURR 23
    156 PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) CURR 23
    157 KBLNR Document number for earmarked funds CHAR 10 KBLK
    158 KBLPOS Earmarked Funds: Document Item NUMC 3 KBLP
    159 GRANT_NBR Grant CHAR 20
    160 GMVKZ Item is in Execution CHAR 1
    161 SRTYPE Type of Additional Receivable CHAR 2
    162 LOTKZ Lot Number for Documents CHAR 10
    163 FKBER Functional Area CHAR 16
    164 INTRENO Internal Key of Real Estate Object CHAR 13
    165 PPRCT Partner PC CHAR 10 CEPC
    166 BUZID Line item ID CHAR 1
    167 AUGGJ Clrg Fiscal Yr NUMC 4
    168 HKTID ID for Account Details CHAR 5 T012K
    169 BUDGET_PD Budget Period CHAR 10
    170 PAYS_PROV Payment Service Provider CHAR 4
    171 PAYS_TRAN Payment Reference of Payment Service Provider CHAR 35
    172 MNDID SEPA Mandate: Unique Reference to Mandate per Creditor CHAR 35
    173 _DATAAGING Data Filter Value for Data Aging DATS 8
    174 KONTT Account Assignment Category for Industry Solution CHAR 2
    175 KONTL Acct Assignment String for Industry-Specific Acct Assignmnts CHAR 50
    176 UEBGDAT DATS Field Type DATS 8
    177 VNAME Joint venture CHAR 6 T8JV
    178 EGRUP Equity Group CHAR 3 T8JF
    179 BTYPE Billing Category CHAR 2 T8JA
    180 PROPMANO Real Estate Management Mandate CHAR 13
    181 GKONT Offsetting acct CHAR 10
    182 GKART Offst.acct type CHAR 1
    183 GHKON CHAR 10

SAP Help, Wiki Resources, and Forum Discussions on BSID

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
BSAD Accounting: Secondary Index for Customers (Cleared Items) FI - Financial Accounting
BSEG Accounting Document Segment FI - Financial Accounting
BSIK Accounting: Secondary Index for Vendors FI - Financial Accounting
BSIS Accounting: Secondary Index for G/L Accounts FI - Financial Accounting
BSAK Accounting: Secondary Index for Vendors (Cleared Items) FI - Financial Accounting
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items) FI - Financial Accounting
VBRK Billing Document: Header Data SD - Billing

Transaction Codes for SAP Table BSID

TCODE Description Functional Area
FBL5N Customer Line Items FI - Information System
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
MIRO Enter Incoming Invoice MM - Invoice Verification
FBL3N G/L Account Line Items FI - Information System
SE16 Data Browser Basis - Workbench Utilities
SE38 ABAP Editor Basis - ABAP Editor

FMs for SAP Table BSID

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
REUSE_ALV_HIERSEQ_LIST_DISPLAY Hierarchical sequential list output BC - SAP List Viewer
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
READ_LFA1 Direct read operation of vendor master information A segment FI - Financial Accounting

ABAP Reports for SAP Table BSID

ABAP REPORT Description Functional Area
KONTO Program for Object Type BUS3014: Account FI - Financial Accounting
BWOM2_TIMEST BWOM2_TIMEST: Time-stamp Maintenance CO - Information System, iViews
RFITEMAR Customer Line Item Display FI - Information System
RSAP0001 Program for object type SAP0001 : BapiService Basis - BW Service API
RFDOPR10 Customer Open Item Analysis by Balance of Overdue Items FI - Information System
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SPRSL TEXT 630 - Workbench Tools: Editors
RECON Include RECON PP - Material Identification and Reconciliation

BW Datasources for SAP Table BSID

BW DATASOURCE Description Functional Area
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
0FI_AR_3 Customers: Line Items FI - Accounts Receivable
0FI_AP_3 Vendors: Line Items FI - Accounts Payable
0FI_TX_4 Taxes: Line Items by Means of Delta Extraction FI - General Ledger Accounting
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
0FI_AR_5 Customers: Payment History FI - Accounts Receivable

Authorization Objects for SAP Table BSID

AUTHORIZATION OBJECT Description Functional Area
F_BKPF_BUK Accounting Document: Authorization for Company Codes
E_GRID Authorization Object for Grid
V_VBAK_VKO Sales Document: Authorization for Sales Areas
F_BKPF_BED Accounting Document: Account Authorization for Customers
F_BKPF_KOA Accounting Document: Authorization for Account Types
CMS_CAG Authorization object for CAG