BSAS is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for G/L Accounts (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 BSAS. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
BSAS — Meta Data
Description: | Accounting: Secondary Index for G/L Accounts (Cleared Items) |
Main Category: | FI |
Sub Category: | Financial Accounting |
Table type: | Transparent Table (TRANSP) |
BSAS — 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 | |
3 | HKONT | G/L | X | CHAR | 10 | |
4 | AUGDT | Clearing | X | DATS | 8 | |
5 | AUGBL | Clrng doc. | X | CHAR | 10 | |
6 | ZUONR | Assignment | X | CHAR | 18 | |
7 | GJAHR | Fiscal Year | X | NUMC | 4 | |
8 | BELNR | Document Number | X | CHAR | 10 | |
9 | BUZEI | Posting row | X | NUMC | 3 | |
10 | BUDAT | Posting Date | DATS | 8 | ||
11 | BLDAT | Document Date | DATS | 8 | ||
12 | WAERS | Currency | CUKY | 5 | ||
13 | XBLNR | Reference | CHAR | 16 | ||
14 | BLART | Document Type | CHAR | 2 | ||
15 | MONAT | Period | NUMC | 2 | ||
16 | BSCHL | Posting key | CHAR | 2 | ||
17 | SHKZG | Debit/Credit | CHAR | 1 | ||
18 | GSBER | Business Area | CHAR | 4 | ||
19 | MWSKZ | Tax code | CHAR | 2 | ||
20 | FKONT | Financial Budget Item | NUMC | 3 | ||
21 | DMBTR | Amount in LC | CURR | 23 | ||
22 | WRBTR | Amount | CURR | 23 | ||
23 | MWSTS | Tax Amount in Local Currency | CURR | 23 | ||
24 | WMWST | Tax Amount in Document Currency | CURR | 23 | ||
25 | SGTXT | Name | CHAR | 50 | ||
26 | PROJN | Old: Project number : No longer used --> PS_POSNR | CHAR | 16 | ||
27 | AUFNR | Order | CHAR | 12 | ||
28 | WERKS | Plant | CHAR | 4 | ||
29 | KOSTL | Cost Center | CHAR | 10 | ||
30 | ZFBDT | Baseline date | DATS | 8 | ||
31 | XOPVW | OI management | CHAR | 1 | ||
32 | VALUT | Value date | DATS | 8 | ||
33 | BSTAT | Doc.status | CHAR | 1 | ||
34 | BDIFF | Valuation diff. | CURR | 23 | ||
35 | BDIF2 | Valuation diff. 2 | CURR | 23 | ||
36 | VBUND | Trading Partner | CHAR | 6 | ||
37 | PSWSL | G/L currency | CUKY | 5 | ||
38 | WVERW | Usage | CHAR | 1 | ||
39 | DMBE2 | Amt loc.curr.2 | CURR | 23 | ||
40 | DMBE3 | Amt loc. curr.3 | CURR | 23 | ||
41 | MWST2 | Tax Amount in Second Local Currency | CURR | 23 | ||
42 | MWST3 | Tax Amount in Third Local Currency | CURR | 23 | ||
43 | BDIF3 | Valuation diff. 3 | CURR | 23 | ||
44 | RDIF3 | Exchange Rate Difference Realized for Third Local Currency | CURR | 23 | ||
45 | XRAGL | Indicator: Clearing Was Reversed | CHAR | 1 | ||
46 | PROJK | WBS element | NUMC | 8 | PRPS | |
47 | PRCTR | Profit Center | CHAR | 10 | ||
48 | XSTOV | Indicator: Document Is Flagged for Reversal | CHAR | 1 | ||
49 | XARCH | Character Field of Length 1 | CHAR | 1 | ||
50 | PSWBT | General ledger amt | CURR | 23 | ||
51 | XNEGP | Negative pstng | CHAR | 1 | ||
52 | RFZEI | Pmnt card item | NUMC | 3 | ||
53 | CCBTC | Settlement | CHAR | 10 | ||
54 | XREF3 | Reference key 3 | CHAR | 20 | ||
55 | BUPLA | Business Place | CHAR | 4 | ||
56 | PPDIFF | Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) | CURR | 23 | ||
57 | PPDIF2 | Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) | CURR | 23 | ||
58 | PPDIF3 | Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) | CURR | 23 | ||
59 | BEWAR | Transactn Type | CHAR | 3 | ||
60 | IMKEY | Real Estate Key | CHAR | 8 | ||
61 | DABRZ | Reference Date | DATS | 8 | ||
62 | INTRENO | Internal Key of Real Estate Object | CHAR | 13 | ||
63 | GRANT_NBR | Grant | CHAR | 20 | ||
64 | FKBER | Functional Area | CHAR | 16 | ||
65 | FIPOS | Commitment Item | CHAR | 14 | ||
66 | FISTL | Funds Center | CHAR | 16 | ||
67 | GEBER | Fund | CHAR | 10 | ||
68 | PPRCT | Partner PC | CHAR | 10 | ||
69 | BUZID | Line item ID | CHAR | 1 | ||
70 | AUGGJ | Clrg Fiscal Yr | NUMC | 4 | ||
71 | UZAWE | Pmt meth.supl. | CHAR | 2 | ||
72 | SEGMENT | Segment | CHAR | 10 | ||
73 | PSEGMENT | Partner Segment | CHAR | 10 | ||
74 | PGEBER | Partner Fund | CHAR | 10 | ||
75 | PGRANT_NBR | Partner Grant | CHAR | 20 | ||
76 | MEASURE | Funded Program | CHAR | 24 | ||
77 | BUDGET_PD | Budget Period | CHAR | 10 | ||
78 | PBUDGET_PD | Par. BudPer | CHAR | 10 | ||
79 | FIPEX | Commitment Item | CHAR | 1 | ||
80 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
81 | KIDNO | Payment Ref. | CHAR | 30 | ||
82 | PRODPER | Joint Venture Production Date | ACCP | 6 | ||
83 | QSSKZ | Withholding Tax Code | CHAR | 2 | ||
84 | PROPMANO | Real Estate Management Mandate | CHAR | 13 | ||
85 | GKONT | Offsetting acct | CHAR | 10 | ||
86 | GKART | Offst.acct type | CHAR | 1 | ||
87 | GHKON | CHAR | 10 | |||
88 | LOGSYSTEM_SENDER | Logical destination (specified in function call) | CHAR | 10 | ||
89 | BUKRS_SENDER | Company Code | CHAR | 4 | ||
90 | BELNR_SENDER | Accounting Document Number | CHAR | 10 | ||
91 | GJAHR_SENDER | Fiscal Year of Document in Sender System | NUMC | 4 | ||
92 | BUZEI_SENDER | Number of Line Item Within Accounting Document | NUMC | 3 |
SAP Help, Wiki Resources, and Forum Discussions on BSAS
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Performance issue with BSAS table | SCN
I am considering 1 lac gls for BSAS selection. It is giving runtime error DBIF_RSQL_INVALID_RSQL and exception CX_SY_OPEN_SQL_DB.
http://scn.sap.com/message/3017115
-
What is the field significance in xref3 in BSAS and bsis
Hi
I am new FI area...
I need to get open items using tables BSAS, bsis, bseg, ekpo and mseg.
can anyone explain me what is the meaning of this:
Get GR Movement Type
here open item contains data from BSAS or bsis table depends sy-datum fld.
If Document Type BSEG-BLART = WE
Select BWART Movement Type
From MSEG where M...
http://scn.sap.com/message/3032049
-
Get zuonr of table bsis and BSAS | SCN
Need your advise on program optimization and rephrasing my program statements especially the case statements.
http://scn.sap.com/message/9101291
-
Table BSAS don't contain Cleared FI Document | SCN
When we post an FI document we have normally as result an entry in the Tables : BSEG and BSIS
http://scn.sap.com/message/8321695
-
Runtime Error :ITAB_DUPLICATE_KEY Select on BSIS and BSAS Table
We get a frequent dump on the below select in Production system for dupliacte key
http://scn.sap.com/message/13882757
-
Difference between FAGLFLEXA and BSIS/BSAS | SCN
Working on SAP ECC 5 and new general ledger activated. Here the problem is there is a mismatch between tables FAGLFLEXA and BSIS/BSAS. That too some documents were not updated in tables FAGLFLEXA with document type 'AB' and general entry view is not showing for these documents.
http://scn.sap.com/message/5607024
-
JOIN for BSEG, BSIS, BSAS, MSEG, BKPF and MKPF | SCN
I am developing a report related to G/L . i am using the Tables BSEG BSIS BSAS MSEG BKPF MKPF ............please give me the Joinings of these tables.......how exactly we can join and get the prefect Data....
http://scn.sap.com/message/5522590
-
BSIS/BSAS tables not populated | SCN
I have found that the reason is that tables BSIS and BSAS are not being populated with line items. however tables BKPF and BSEG in addition to FAGLFLEXA are all populated.
http://scn.sap.com/message/11162330
-
Data source for BSIS & BSAS data | SCN
Skip to Content We're sorry, but you're attempting to access SCN content that was not migrated to the new SAP Community experience. ...
http://scn.sap.com/message/5762169
-
Regarding; Creation of data source for BSAS table with FM extractor for Del
http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a0f46157-e1c4-2910-27aa-e3f4a9c8df33?QuickLink=index&overridelayout=true
http://scn.sap.com/message/10666844
-
Clearing details i could not getting at BSIS & BSAS table. after Payment
Itm PK BusA Acct no. Description Tx Amount in INR
http://scn.sap.com/message/3559961
Related Tables
TABLE | Description | Functional Area |
---|---|---|
BSIS | Accounting: Secondary Index for G/L Accounts | FI - Financial Accounting |
BSEG | Accounting Document Segment | FI - Financial Accounting |
BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | FI - Financial Accounting |
BSIK | Accounting: Secondary Index for Vendors | FI - Financial Accounting |
BSAD | Accounting: Secondary Index for Customers (Cleared Items) | FI - Financial Accounting |
BSID | Accounting: Secondary Index for Customers | FI - Financial Accounting |
BSIM | Secondary Index, Documents for Material | MM - Invoice Verification |
Transaction Codes for SAP Table BSAS
TCODE | Description | Functional Area |
---|---|---|
FBL3N | G/L Account Line Items | FI - Information System |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
MIRO | Enter Incoming Invoice | MM - Invoice Verification |
FB03 | Display Document | FI - Financial Accounting |
SE16 | Data Browser | Basis - Workbench Utilities |
FS10N | Balance Display | FI - Financial Accounting |
FS00 | G/L acct master record maintenance | FI - Basic Functions |
FMs for SAP Table BSAS
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
CONVERSION_EXIT_ALPHA_INPUT | Conversion exit ALPHA, external->internal | Basis - Syntax, Compiler, Runtime |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
BAPI_GL_ACC_GETPERIODBALANCES | Posting period balances for each G/L account | FI - Basic Functions |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
BAPI_GL_GETGLACCPERIODBALANCES | Posting period balances for each G/L account | FI - Basic Functions |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
SAPGUI_PROGRESS_INDICATOR | Display progress indicator in current window | C - Graphical User Interface |
ABAP Reports for SAP Table BSAS
ABAP REPORT | Description | Functional Area |
---|---|---|
RFSEPA02 | Switch On Open Item Management by Changing Master Record | FI - Financial Accounting |
RFSEPA01 | Switch On Line Item Display by Changing Master Record | FI - Financial Accounting |
BALVBUFDEL | Reset ALV buffer | Basis - SAP List Viewer |
KONTO | Program for Object Type BUS3014: Account | FI - Financial Accounting |
SAPF181 | Profit and Loss Adjustment | FI - Basic Functions |
COMMENTS | Include COMMENTS | PP - Material Identification and Reconciliation |
RFSEPA03 | Switch Off Open Item Management by Changing Master Record | FI - Financial Accounting |
SAPF190 | Financial Accounting Comparative Analysis | FI - Financial Accounting |
BW Datasources for SAP Table BSAS
BW DATASOURCE | Description | Functional Area |
---|---|---|
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_4 | Vendors: Line Items with Delta Extrcation | FI - Accounts Payable |
2LIS_02_ITM | Purchasing Data (Item Level) | MM - Materials Management |
0GL_ACCOUNT_T011_HIER | G/L account number | FI - Financial Accounting |
2LIS_03_BX | Stock Initialization for Inventory Management | MM - Materials Management |
0FI_GL_6 | General Ledger Sales Figures via Delta Extraction | FI - General Ledger Accounting |
2LIS_03_BF | Goods Movements From Inventory Management | MM - Materials Management |
Authorization Objects for SAP Table BSAS
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
F_BKPF_BUK | Accounting Document: Authorization for Company Codes | |
J_1IEWTCER | Authorization check for Certificate Printing- EWT | |
CMS_CAG | Authorization object for CAG | |
F_BKPF_BES | Accounting Document: Account Authorization for G/L Accounts | |
ECM_REQ | Change Management: Change Request | |
J_1IEWT_HC | health check for Migration to EWT | |
I_TCODE | PM: Transaction Code | |
S_RFC | Authorization Check for RFC Access |
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