Finance Extraction

General Info
All accounting documents are present in BKPF/BSEG.
The Invoice documents are present in RBKP/RSEG
When there is a tax amount entered against an document, those entries are added in BSET.

BKPF is the header table and BSEG is the item level table (?). It is a cluster table which has data from tables BSIK,BSAK, BSIS,BSAD, BSIS,BSAS.

Difference between BELNR and DOCNR

• BELNR : Document Number / BUZIE  Line Item
• DOCNR : Account Document Number / DOCLN Line Item ( General ledger View )

BELNR can be found in the FI base tables : BKPF and BSEG. It the key field in finance. DOCNR is present in FAGLFLEXA table ( General Ledger: Actual Line Items ) where DOCNR is the key field. This table also has BELNR and  BUZEI ( Line Item) in the feilds. Each line item BUZIE for a BELNR can have multiple DOCLNs.
The value in the fields of BELNR and DOCNR is the same. Just the item level details are changing as DOCNR/DOCLN gives you more line level detail.

In the FAGLFLEXA, we can find the GL related postings and in the above example, the total amount for line item 1 would be 30, when seen in BSEG table.

The t-code for checking this is FB03 -> Display -> <Entry View> will give the regular item details and when <General Ledger View> is set, it will give you further details view which are the DOCLNs.

When using datasource 0FI_GL_14, this has both BELNR/BUZEI and DOCNR/DOCLN and in general, DOCNR is mapped to 0AC_DOC_NR/AC_DOC_LN and BELNR/BUZEI to AC_DOC_NO/ITEM_NO.

Useful Links : 

Asset Accounting Delta

https://www.linkedin.com/pulse/asset-accounting-data-extraction-important-steps-learning-patil

BWOM_SETTING for datasources

https://community.sap.com/t5/technology-blogs-by-members/bwom-settings-for-fi-loads-in-sap-bi/ba-p/13214134

Financial Account and Asset datasources 

https://help.sap.com/docs/SUPPORT_CONTENT/fiaccounting/3361880168.html