BSAK is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for Vendors (Cleared Items) 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 BSAK. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
BSAK — Meta Data
Description: | Accounting: Secondary Index for Vendors (Cleared Items) |
Main Category: | FI |
Sub Category: | Financial Accounting |
Table type: | Transparent Table (TRANSP) |
BSAK — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | |
2 | BUKRS | Company Code | X | CHAR | 4 | LFB1 |
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 | ||
16 | XBLNR | Reference | CHAR | 16 | ||
17 | BLART | Document Type | CHAR | 2 | ||
18 | MONAT | Period | NUMC | 2 | ||
19 | BSCHL | Posting key | CHAR | 2 | ||
20 | ZUMSK | Target Special G/L Indicator | CHAR | 1 | ||
21 | SHKZG | Debit/Credit | CHAR | 1 | ||
22 | GSBER | Business Area | CHAR | 4 | ||
23 | MWSKZ | Tax code | CHAR | 2 | ||
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 | ||
33 | ANLN1 | Asset | CHAR | 12 | ||
34 | ANLN2 | Asset Subnumber | CHAR | 4 | ||
35 | EBELN | Purchasing Doc. | CHAR | 10 | ||
36 | EBELP | ARIBA item number | NUMC | 5 | ||
37 | SAKNR | G/L Account | CHAR | 10 | ||
38 | HKONT | G/L | CHAR | 10 | ||
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 | ||
52 | ZLSPR | Pmnt block | CHAR | 1 | ||
53 | ZBFIX | Fixed | CHAR | 1 | ||
54 | HBKID | Short key for a house bank | CHAR | 5 | ||
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 | ||
63 | LANDL | Supplying Country | CHAR | 3 | ||
64 | DIEKZ | Service indicator (foreign payment) | CHAR | 1 | ||
65 | MANSP | Dunn. block | CHAR | 1 | ||
66 | MSCHL | Dunning key | CHAR | 1 | ||
67 | MADAT | Last dunned | DATS | 8 | ||
68 | MANST | Dunning level | NUMC | 1 | ||
69 | MABER | Dunning Area | CHAR | 2 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
91 | VBUND | Trading Partner | CHAR | 6 | ||
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 | ||
95 | EGLLD | Supplying Country for Delivery of Goods | CHAR | 3 | ||
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 | ||
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 | ANEK | |
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 | ||
146 | PYAMT | Amt in pyt cur. | CURR | 23 | ||
147 | BUPLA | Business Place | CHAR | 4 | ||
148 | SECCO | Section Code | CHAR | 4 | ||
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 | ||
162 | KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | ||
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 | ||
171 | BUZID | Line item ID | CHAR | 1 | ||
172 | AUGGJ | Clrg Fiscal Yr | NUMC | 4 | ||
173 | HKTID | ID for Account Details | CHAR | 5 | ||
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 BSAK
Click the above link for the full list of resources and help pages, only the first few are posted below
-
PO Number using BSAK-BELNR | SCN
I am readying the data from BSAK table, i am getting all necessary data from the BSAK table, Using BSAK- BELNR and Company code i need to fecch the PO no.
http://scn.sap.com/message/7572142
-
How to improve performance of the following coding (select * from BSAK ) ?
i am using the following coding. i get as error (TSV_TNEW_PAGE_ALLOC_FAILED) . How can i improve
http://scn.sap.com/message/6957278
-
BSAK Table -Index Issue | SCN
I want to access BSAK table based on following fields: BUKRS, LIFNR, ZUONR, BLART and BSCHL.
http://scn.sap.com/message/9157738
-
TIME-OUT error in BSAK select query(Progress Indicator is also used)
In my report program one select query is there on BSAK table, which is as follows --
http://scn.sap.com/message/8156908
-
Database error -99999 at FET access to table BSAK | SCN
Dear All,
I found this error (runtime error) when i run customized prg (report).
<b>Database error -99999 at FET access to table BSAK</b>
Please tell me the reason and trouble shooting this issue.
Thanks in advance
http://scn.sap.com/message/3801958
-
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
-
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
-
Find attachment documents from BSAK / BKPF | SCN
I am new to working with the SAP database, so my knowledge in this field is limited - please bear with me :-)
http://scn.sap.com/message/13242506
-
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
-
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
-
BSAK-BELNR = BSAK-AUGBL, what is that ? | SCN
The best suggestion that I could recommend to you that you need to simulate it thru SAP system, and see how SAP stores this information.
http://scn.sap.com/message/13278138
Related Tables
TABLE | Description | Functional Area |
---|---|---|
BSIK | Accounting: Secondary Index for Vendors | FI - Financial Accounting |
BSEG | Accounting Document Segment | FI - Financial Accounting |
BSAD | Accounting: Secondary Index for Customers (Cleared Items) | FI - Financial Accounting |
BSID | Accounting: Secondary Index for Customers | FI - Financial Accounting |
BSIS | Accounting: Secondary Index for G/L Accounts | FI - Financial Accounting |
BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | FI - Financial Accounting |
BSIM | Secondary Index, Documents for Material | MM - Invoice Verification |
Transaction Codes for SAP Table BSAK
TCODE | Description | Functional Area |
---|---|---|
FBL1N | Vendor Line Items | FI - Information System |
MIRO | Enter Incoming Invoice | MM - Invoice Verification |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
FBL3N | G/L Account Line Items | FI - Information System |
SE16 | Data Browser | Basis - Workbench Utilities |
MIGO | Goods Movement | MM - Inventory Management |
SE38 | ABAP Editor | Basis - ABAP Editor |
FMs for SAP Table BSAK
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 |
GUI_DOWNLOAD | Download an Internal Table to the PC | Basis - Graphical User Interface |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
F4IF_INT_TABLE_VALUE_REQUEST | F4 help also returning the value to be displayed in internal table | Basis - F4 Help |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
ABAP Reports for SAP Table BSAK
ABAP REPORT | Description | Functional Area |
---|---|---|
BWOM2_TIMEST | BWOM2_TIMEST: Time-stamp Maintenance | CO - Information System, iViews |
RFITEMAP | Vendor Line Item Display | FI - Information System |
COMMENTS | Include COMMENTS | PP - Material Identification and Reconciliation |
RFKSLD00 | Vendor Balances in Local Currency | FI - Information System |
RFFOUS_C | International Payment Medium - Check (with check management) | FI - Payment Transactions |
RECON | Include RECON | PP - Material Identification and Reconciliation |
SAPF181 | Profit and Loss Adjustment | FI - Basic Functions |
SAPF180 | Post Balance Sheet Adjustment | FI - Financial Accounting |
BW Datasources for SAP Table BSAK
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 |
2LIS_02_ITM | Purchasing Data (Item Level) | MM - Materials Management |
0FI_GL_10 | General Ledger: Leading Ledger Balances | FI - General Ledger Accounting |
Authorization Objects for SAP Table BSAK
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
F_BKPF_KOA | Accounting Document: Authorization for Account Types | |
CMS_CAG | Authorization object for CAG | |
CMS_RBL | Authorization object for receivable in CMS | |
J_1ITDS | Authorization object for TDS transaction J1IN | |
M_BEST_EKO | Purchasing Organization in Purchase Order | |
S_RS_AUTH | BI Analysis Authorizations in Role | |
F_LFA1_GRP | Vendor: Account Group Authorization |
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