BSIK is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for Vendors 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 BSIK. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

BSIK — Meta Data

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

BSIK — 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 LIFNR Vendor X CHAR 10 LFA1
    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 EBELN Purchasing Doc. CHAR 10 EKKO
    36 EBELP ARIBA item number NUMC 5 EKPO
    37 SAKNR G/L Account CHAR 10 SKB1
    38 HKONT G/L CHAR 10 SKB1
    39 FKONT Financial Budget Item NUMC 3
    40 FILKD Branch CHAR 10
    41 ZFBDT Baseline date DATS 8
    42 ZTERM Payt terms CHAR 4
    43 ZBD1T Days DEC 3
    44 ZBD2T Days DEC 3
    45 ZBD3T Days net DEC 3
    46 ZBD1P Cash discount 1 DEC 5
    47 ZBD2P Cash discount 2 DEC 5
    48 SKFBT Disc. base CURR 23
    49 SKNTO Discount amt CURR 23
    50 WSKTO Disc. amount CURR 23
    51 ZLSCH Pymt method CHAR 1 T042Z
    52 ZLSPR Pmnt block CHAR 1 T008
    53 ZBFIX Fixed CHAR 1
    54 HBKID Short key for a house bank CHAR 5 T012
    55 BVTYP Partner bank type CHAR 4
    56 REBZG Invoice ref. CHAR 10
    57 REBZJ Fiscal year NUMC 4
    58 REBZZ Line item NUMC 3
    59 SAMNR Collect.inv. NUMC 8
    60 ZOLLT Customs Tariff Number CHAR 8
    61 ZOLLD Customs Date DATS 8
    62 LZBKZ State central bank indicator CHAR 3 T015L
    63 LANDL Supplying Country CHAR 3 T005
    64 DIEKZ Service indicator (foreign payment) CHAR 1
    65 MANSP Dunn. block CHAR 1 T040S
    66 MSCHL Dunning key CHAR 1 T040
    67 MADAT Last dunned DATS 8
    68 MANST Dunning level NUMC 1
    69 MABER Dunning Area CHAR 2 T047M
    70 XNETB Indicator: Document Posted Net ? CHAR 1
    71 XANET Indicator: Down payment in net procedure ? CHAR 1
    72 XCPDD Indicator: Address and Bank Data Set Individually CHAR 1
    73 XESRD Indicator: Must POR Subscriber Number Be Set? CHAR 1
    74 XZAHL Pymt tran. CHAR 1
    75 MWSK1 Tax Code for Distribution CHAR 2 T007A
    76 DMBT1 Amount in Local Currency for Tax Distribution CURR 23
    77 WRBT1 Amount in Foreign Currency for Tax Breakdown CURR 23
    78 MWSK2 Tax Code for Distribution CHAR 2 T007A
    79 DMBT2 Amount in Local Currency for Tax Distribution CURR 23
    80 WRBT2 Amount in Foreign Currency for Tax Breakdown CURR 23
    81 MWSK3 Tax Code for Distribution CHAR 2 T007A
    82 DMBT3 Amount in Local Currency for Tax Distribution CURR 23
    83 WRBT3 Amount in Foreign Currency for Tax Breakdown CURR 23
    84 QSSKZ Withholding Tax Code CHAR 2 T059Q
    85 QSSHB W/tax base amount CURR 23
    86 QBSHB Wit./tax amount CURR 23
    87 BSTAT Doc.status CHAR 1
    88 ANFBN Document Number of the Bill of Exchange Payment Request CHAR 10
    89 ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document NUMC 4
    90 ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted CHAR 4 T001
    91 VBUND Trading Partner CHAR 6 T880
    92 REBZT Following Document Type CHAR 1
    93 STCEG VAT registration number CHAR 20
    94 EGBLD Country of Destination for Delivery of Goods CHAR 3 T005
    95 EGLLD Supplying Country for Delivery of Goods CHAR 3 T005
    96 QSZNR Certificate Number of Withholding Tax Exemption CHAR 10
    97 QSFBT W/tax exempt amt CURR 23
    98 XINVE Indicator: Capital Goods Affected? CHAR 1
    99 PROJK WBS element NUMC 8
    100 FIPOS Commitment Item CHAR 14
    101 NPLNR Network Number for Account Assignment CHAR 12
    102 AUFPL Routing number of operations in the order NUMC 10
    103 APLZL General counter for order NUMC 8
    104 XEGDR Indicator: Triangular deal within the EU ? CHAR 1
    105 DMBE2 Amt loc.curr.2 CURR 23
    106 DMBE3 Amt loc. curr.3 CURR 23
    107 DMB21 Amount in Second Local Currency for Tax Breakdown CURR 23
    108 DMB22 Amount in Second Local Currency for Tax Breakdown CURR 23
    109 DMB23 Amount in Second Local Currency for Tax Breakdown CURR 23
    110 DMB31 Amount in Third Local Currency for Tax Breakdown CURR 23
    111 DMB32 Amount in Third Local Currency for Tax Breakdown CURR 23
    112 DMB33 Amount in Third Local Currency for Tax Breakdown CURR 23
    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 BDIF3 Valuation diff. 3 CURR 23
    118 XRAGL Indicator: Clearing Was Reversed CHAR 1
    119 RSTGR Reason code CHAR 3 T053R
    120 UZAWE Pmt meth.supl. CHAR 2 T042F
    121 KOSTL Cost Center CHAR 10
    122 LNRAN Sequence number of asset line items in fiscal year NUMC 5
    123 XSTOV Indicator: Document Is Flagged for Reversal CHAR 1
    124 KZBTR Original Reduction Amount in Local Currency CURR 23
    125 XREF1 Reference key 1 CHAR 12
    126 XREF2 Reference key 2 CHAR 12
    127 XARCH Character Field of Length 1 CHAR 1
    128 PSWSL G/L currency CUKY 5 TCURC
    129 PSWBT General ledger amt CURR 23
    130 IMKEY Real Estate Key CHAR 8
    131 ZEKKN Sequential Number of Account Assignment NUMC 2
    132 FISTL Funds Center CHAR 16
    133 GEBER Fund CHAR 10
    134 DABRZ Reference Date DATS 8
    135 XNEGP Negative pstng CHAR 1
    136 EMPFB Payee/Payer CHAR 10
    137 PRCTR Profit Center CHAR 10
    138 XREF3 Reference key 3 CHAR 20
    139 DTWS1 Instruct.key 1 NUMC 2
    140 DTWS2 Instruct. key 2 NUMC 2
    141 DTWS3 Instruct. key 3 NUMC 2
    142 DTWS4 Instruct. key 4 NUMC 2
    143 XPYPR Payment sent CHAR 1
    144 KIDNO Payment Ref. CHAR 30
    145 PYCUR Payment cur. CUKY 5 TCURC
    146 PYAMT Amt in pyt cur. CURR 23
    147 BUPLA Business Place CHAR 4 J_1BBRANCH
    148 SECCO Section Code CHAR 4 SECCODE
    149 PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23
    150 PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) CURR 23
    151 PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) CURR 23
    152 PENLC1 Penalty Charge Amount in First Local Currency CURR 23
    153 PENLC2 Penalty Charge Amount in Second Local Currency CURR 23
    154 PENLC3 Penalty Charge Amount in Third Local Currency CURR 23
    155 PENFC Penalty Charge Amount in Document Currency CURR 23
    156 PENDAYS Number of Days for Penalty Charge Calculation INT4 10
    157 PENRC Reason for Late Payment CHAR 2
    158 VERTT Contract Type CHAR 1
    159 VERTN Contract Number CHAR 13
    160 VBEWA Flow Type CHAR 4
    161 KBLNR Document number for earmarked funds CHAR 10 KBLK
    162 KBLPOS Earmarked Funds: Document Item NUMC 3 KBLP
    163 GRANT_NBR Grant CHAR 20
    164 GMVKZ Item is in Execution CHAR 1
    165 SRTYPE Type of Additional Receivable CHAR 2
    166 LOTKZ Lot Number for Documents CHAR 10
    167 ZINKZ Exempted from Interest Calculation CHAR 2
    168 FKBER Functional Area CHAR 16
    169 INTRENO Internal Key of Real Estate Object CHAR 13
    170 PPRCT Partner PC CHAR 10 CEPC
    171 BUZID Line item ID CHAR 1
    172 AUGGJ Clrg Fiscal Yr NUMC 4
    173 HKTID ID for Account Details CHAR 5 T012K
    174 BUDGET_PD Budget Period CHAR 10
    175 _DATAAGING Data Filter Value for Data Aging DATS 8
    176 KONTT Account Assignment Category for Industry Solution CHAR 2
    177 KONTL Acct Assignment String for Industry-Specific Acct Assignmnts CHAR 50
    178 UEBGDAT DATS Field Type DATS 8
    179 VNAME Joint venture CHAR 6 T8JV
    180 EGRUP Equity Group CHAR 3 T8JF
    181 BTYPE Billing Category CHAR 2 T8JA
    182 PROPMANO Real Estate Management Mandate CHAR 13
    183 GKONT Offsetting acct CHAR 10
    184 GKART Offst.acct type CHAR 1
    185 GHKON CHAR 10

SAP Help, Wiki Resources, and Forum Discussions on BSIK

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

  • Relation  between BSIK,BSIK  and BSEG | SCN

    There are a series of related tables which are quite easy to understand if you look at the table name prefixes and suffixes... the BSI prefixed tables are open items and BSA are cleared items... and the suffix is like the account type field, KOART i.e. K = "Kreditor" (vendor), D - "Debtor" (customer) items, and S = GL (can't remember the German equivalent)... thus BSAD = Cleared "Debtor" (Customer)...

    http://scn.sap.com/message/5590455

  • Link Between bsak,BSIK & bseg,bkpf | SCN

    Dear Experts,

    i need PO number EBELN for one report.

    problem is it stores while MIRO in BSEG/BKPF and

    Account doc.no stores in BSAK/BSIK.

    So, i need link between BSIK/BSAK and BSEG/BKPF

    please help as soon as possible

    thanks

    Nayan Lad

    Edited by: Nayan Lad on Sep 17, 2008 9:50 AM

    http://scn.sap.com/message/6188034

  • Residual payment in F-58 not appearing in table BSIK

    When you clear any invoice the invoice line item will disapper from the BSIK table and creates two items in the BSAK table.

    http://scn.sap.com/message/7639661

  • BSIK-belnr = RSEG-BELNR? | SCN

    Hi,

    Is the belnr in BSIK same with the belnr in rseg?

    Or is it the augbl of BSIK same with the belnr in rseg?

    Thanks.

    http://scn.sap.com/message/5320430

  • How we will select all the invoices from table BSIK AND BSAK

    how we will select all the invoices for vendors based on the date from table BSIK AND BSAK ?

    http://scn.sap.com/message/6341511

  • Which table is better? BSEG or BSIS,BSAK or BSIK | SCN

    i want to know whihc table is better for the reterival of data for whether the payment of vendor is done or not?

    http://scn.sap.com/message/5522323

  • When BSIK table profit center will be populated? | SCN

    Well, now it's really a functional question. I don't know if it would be possible to configure your system to have the profit center appear on vendor line items. It's normal to have things like profit center, cost center, etc. appear on the GL item, not the vendor item.

    http://scn.sap.com/message/1656109

  • BSIK select data | SCN

    I am fetching the data from BSAK and BSIK table based on the reference no. from BKPF table.

    http://scn.sap.com/message/8013668

  • Wrong updating of amount in BSIK Table | SCN

    I posted one FB60 vendor invoice of 150$. Document was saved and number 100000998 was generated.

    http://scn.sap.com/message/10590902

  • Invoice number in BKPF, BSEG, BSIK, BSAK, BSID and BSAK tables?

    I am working with the FI reports for the first time and I do not have any idea on FI functional flow. I have some basic questions like

    http://scn.sap.com/message/3991424

  • BSEG // BSIK // EBELN - Toolbox for IT Groups

    in order to be able to use BSIK in queries I need fields EBELN and EBELP to be filled out. This is not the case. However they are filled out in FI item lines table BSEG. Does anyone now how come or how to get this data to the INDEX tables ?

    http://sap.ittoolbox.com/groups/technical-functional/sap-acct/bseg-bsik-ebeln-1023731


Related Tables

TABLE Description Functional Area
BSAK Accounting: Secondary Index for Vendors (Cleared Items) FI - Financial Accounting
BSEG Accounting Document Segment FI - Financial Accounting
BSID Accounting: Secondary Index for Customers FI - Financial Accounting
BSIS Accounting: Secondary Index for G/L Accounts FI - Financial Accounting
BSAD Accounting: Secondary Index for Customers (Cleared Items) FI - Financial Accounting
BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items) FI - Financial Accounting
LFB1 Vendor Master (Company Code) FI - Financial Accounting

Transaction Codes for SAP Table BSIK

TCODE Description Functional Area
FBL1N Vendor Line Items FI - Information System
MIRO Enter Incoming Invoice MM - Invoice Verification
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
FBL3N G/L Account Line Items FI - Information System
SE16 Data Browser Basis - Workbench Utilities
FB60 Enter Incoming Invoices FI - Financial Accounting
FB03 Display Document FI - Financial Accounting

FMs for SAP Table BSIK

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
CONVERSION_EXIT_ALPHA_INPUT Conversion exit ALPHA, external->internal Basis - Syntax, Compiler, Runtime
F4_FILENAME F4 for filename / Filemanager support to locate file in a directory PM - Plant Maintenance
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer

ABAP Reports for SAP Table BSIK

ABAP REPORT Description Functional Area
BWOM2_TIMEST BWOM2_TIMEST: Time-stamp Maintenance CO - Information System, iViews
RECON Include RECON PP - Material Identification and Reconciliation
RFITEMAP Vendor Line Item Display FI - Information System
SPRSL TEXT 630 - Workbench Tools: Editors
BALVBUFDEL Reset ALV buffer Basis - SAP List Viewer
BC_ALV_DEMO_HTML_D0100 Include BC_ALV_DEMO_HTML_D0100 Basis - SAP List Viewer
RFPOSXEXTEND Correction: Change/Activate RFPOSXEXT FI - Information System
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony

BW Datasources for SAP Table BSIK

BW DATASOURCE Description Functional Area
0FI_AP_4 Vendors: Line Items with Delta Extrcation FI - Accounts Payable
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0FI_AR_4 Customers: Line Items with Delta Extraction FI - Accounts Receivable
0FI_AP_3 Vendors: Line Items FI - Accounts Payable
0FI_AR_3 Customers: Line Items FI - Accounts Receivable
0FI_AP_6 Vendor Sales Figures via Delta Extraction FI - Accounts Payable
0FI_GL_10 General Ledger: Leading Ledger Balances FI - General Ledger Accounting
2LIS_02_ITM Purchasing Data (Item Level) MM - Materials Management

Authorization Objects for SAP Table BSIK

AUTHORIZATION OBJECT Description Functional Area
F_BKPF_BUK Accounting Document: Authorization for Company Codes
E_VARIANT Authorization Object for Variants
P_TCODE HR: Transaction codes
F_BKPF_KOA Accounting Document: Authorization for Account Types
J_1IEWTCER Authorization check for Certificate Printing- EWT
I_TCODE PM: Transaction Code
C_PFS PP-PI: External Planning Tool

Most searched SAP Financial Accounting Tables