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
- Vendor Master Tables
- Customer Master Tables
- Company Codes Tables
- Tax Code Tables
- Gl Account Tables
- Gl Account Master Tables
- Bank Account Tables
- Withholding Tax Tables
- Payment Term Tables
- Region Tables
- Bank Details Tables
- Company Code Tables
- Payment Method Tables
- Asset Tables
- Transaction Type Tables
- Tax Jurisdiction Tables
- Customer Tables
- Vendor Tables
- Business Area Tables
- Payment Tables
- Plant Company Code Tables
- Account Assignment Tables