What is Bseg table in SAP?
BSEG is a standard Financial Accounting Cluster Table in SAP FI application, which stores Accounting Document Segment 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 BSEG.
Can we create secondary index for cluster table in SAP?
No secondary indexes can be created for a cluster table.
Is Mseg a cluster table?
First of all, MSEG is a transparent table, not a cluster table, and there are a number of SAP indexes already there.
What tables make up Bseg?
The following tables can be used with BSEG:
- BSID – Accounting: Secondary Index for Customers (Open Items)
- BSAD – Accounting: Secondary Index for Customers (Cleared Items)
- BSIK – Accounting: Secondary Index for Vendors (Open Items)
- BSAK – Accounting: Secondary Index for Vendors (Cleared Items)
What is the difference between Bseg and Acdoca?
ACDOCA volumn is quite large compared to BSEG
Number of line items in ACDOCA table can be huge, as entries are breaked down to the lowest level considering document splitting and entries also gets multiplied based on the number of ledgers implemented in the environment.
What is Bsid table?
BSID is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for Customers data.
How many secondary indexes are allowed per table?
For maximum query flexibility, you can create up to 20 global secondary indexes (default quota) and up to 5 local secondary indexes per table.
How many secondary indexes can be created in SAP?
We can create up to 9 secondary indexes.
What is Matdoc table?
It is the central table that contains all accounting and controlling documents. MATDOC is introduced with S/4 HANA Logistics. It is the central table that contains all material documents. As inventory level is calculated “on the fly”, MATDOC also replaces the inventory tables.
What is MAKT table in SAP?
MAKT (Material Descriptions) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue. Additionally we provide an overview of foreign key relationships, if any, that link MAKT to other SAP tables.
What is BKPF table in SAP?
BKPF (Accounting Document Header) is a standard table in SAP R/3 ERP systems which stores the header lines for accounting documents and consists of Company Code, Document No, Fiscal Year (as key fields).
How many fields are in Acdoca?
ACDOCA contains all fields (360+)
Is Bseg obsolete?
Even though the long-term vision is that table BSEG will be used only for open item management – and postings that do not relate to open items will no longer create entries in table BSEG. At present, SAP is not yet planning to remove of BSEG completely, but It is quite possible in future years, that BSEG gets removed.
What is Bsad table in SAP?
BSAD is a standard Financial Accounting Transparent Table in SAP FI application, which stores Accounting: Secondary Index for Customers (Cleared Items) data.
How do I update my Bsid table?
BSID is a secondary index for BSEG customer items, so updating it directly will lead to database inconsistencies and any update must go via BSEG. You can use a function module like FI_ITEMS_MASS_CHANGE . This FM updates BSEG by running a BDC for transaction FB02 (Change Document).
How many types of indexes are there in SAP?
Why do we need secondary index?
Secondary indexing provides a way to meet the different processing requirements of various applications. Secondary indexing allows you to have an index based on any field in the database, not just the key field in the root segment.
How many types of index are there in SAP?
primary index and secondary index.
What is Prcd_elements table in SAP?
PRCD_ELEMENTS is a standard Pricing and Conditions Transparent Table in SAP SD application, which stores Pricing Elements 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 PRCD_ELEMENTS.
What is MKPF?
MKPF is a standard SAP Table which is used to store Header: Material Document data and is available within R/3 SAP systems depending on the version and release level.
What is MBEW table in SAP?
MBEW is a standard Material Master Transparent Table in SAP Logistics application, which stores Material Valuation 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 MBEW.
What is the difference between Maktx and Maktg?
MAKTX is the material description and MARKTG is the same BUT, is Material description in upper case for matchcodes !
Is BKPF a cluster table?
BSEG and BKPF are cluster tables. It contains transperant tables like BSIS, BSIK etc.
What is the difference between Acdoca & Bseg?
Is Acdoca table in ECC?
One Database – ACDOCA
In ECC, the system stores SAP General Ledger (G/L), customer and vendor balances and open items in various database tables to support reporting. All the fields from sub-modules of S/4HANA Finance are available in the table ACDOCA.