Bseg Table In Sap Abap

Table used for accounting document segment bseg table is coming under crm and crm module.

Bseg table in sap abap. Bseg is a standard sap cluster table which is used to store accounting document segment data and is available within r 3 sap systems depending on the version and release level. Bsas g l accounts cleared items when financial entry is created for gl open item managed accounts it updates bseg and bsis. The best online sap object repository. So sap has created index tables for bseg which are updated with specific data based on classification and are much faster than bseg.

Abap select data from sap table bseg into internal table. Domain data element table table cluster pool view search help. Sap stack sap fico sap hr sap mm sap sd sap pm sap ps sap abap sap netweaver sap tables sap tcodes menu. Sap abap table bseg add entry view of accounting document for additional ledgers hierarchy sap fin software component sap fin fi gl application component general ledger accounting fagl db persistency package db tables read write accesses for fi documents.

It is not advisable to join two large tables in abap query. Bsis gl open items. Material data and is available within r 3 sap systems depending on the version and release level. Additionally we provide an overview of foreign key relationships if any that link bseg to other sap tables.

Below is a number of abap code snippets to demonstrate how to select data from sap bseg table and store it within an internal table including using the newer data inline declaration methods. Mseg is a standard sap table which is used to store document segment. Details of sap bseg table its fields. Bseg accounting document segment is a standard table in sap r 3 erp systems.

Key fields are marked in blue. Below is the standard documentation available and a few details of the fields which make up this cluster table. Bseg stores the line items for accounting. Get example source abap code based on a different sap table get abap code.

All the accounting documents open and closed are stored in bkpf and bseg tables and querying these tables takes lot of time. Below is the standard documentation available and a few details of the fields which make up this table. I would also look for logical databases to write queries off these tables. Bseg has all financial entries including all open items cleared items from all module.

It also shows you various ways to process this data using abap work. Software component application component package. When it is cleared it is removed from bsis and updated in bsas. I have tried to use sapquery sq01 to join 2 sap tables bseg and bkpf.