Skip to Content

BSEG Field mapping in table ACDOCA in S/4 HANA.

We have migrated to S/4 HANA-1610 and trying to find related fields in ACDOCA because BSEG entries are now moving into ACDOCA and we have to convert our select queries from BSEG to ACDOCA.

But i've seen scenarios where entries are getting maintained in both(BSEG & ACDOCA) tables. So if entries are getting maintained in both the tables then why to change all select queries ?. SCI is reporting around 300 errors for BSEG only in custom programs.

Also is it true that we will see all entries getting updated in both tables or there are few scenarios only for which entries will be moved to ACDOCA. If that is the case then which all cases are excluded from BSEG.

An example from custom program :

e.g.

SELECT * FROM bseg INTO wa_bseg FOR ALL ENTRIES IN gt_pos_posted
WHERE bukrs = gt_pos_posted-bukrs
AND belnr = gt_pos_posted-belnr
AND gjahr = gt_pos_posted-gjahr
AND buzei = gt_pos_posted-buzei

In this query all the fields are selected from BSEG, or even if we consider a case where few fields are selected , still we need exact field mappings with corresponding fields in ACDOCA which i'm not able to find .I've checked SAP Note 2156822 which has a pdf attached for field mapping but it doesn't have all fields mapping. So what would be the remediation in this case for custom programs ?

Thanks,

Vimal

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 23 at 06:42 AM

    Hi Vimal,

    Please note ACDOCA is not made out of BSEG, BSEG is still a proper table and it stores entry view line items of the accounting document. FAGLFLXA (Along with BSIS, BSAS, BSID, BSAD, BSAK, BSIK, Asset tables, CO Tables and ML tables) and FAGLFLEXT get migrated to ACDOCA and ACDOCT respectively. Main Finance tables in S/4 HANA are BKPF, BSEG, ACDOCA, and ACDOCT.

    Coming to your queries:

    1. If you have any program/report written on any of the eliminated tables before S/4 HANA migration, you don't need to change any selection criteria. All report shall work as it is. Of course some of the HANA compatibility adjustment need to be done in the programs and reports.

    All previous written report shall work on migrated S/4 HANA system as all eliminated tables are available as view in S/4 HANA.

    2. If you are writing any new report based on Entry view you should call BKPF and BSEG and if your report is little detailed )Ledger view then you shall call BKPF & ACDOCA.

    Note: If you want to enhance the report with new tables then you may change the logic, and it would require functional testing as well as business testing as it is like you are writing a new report in S/4 HANA System.

    Regards

    Shakeel

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 05, 2017 at 11:20 AM

    Hi Virmal,

    Please check notes 1976487 , 2511926, 2156822, 2408083.

    Remember you can access BSEG as read-only, no updates or delete.

    Kind Regards

    Add comment
    10|10000 characters needed characters exceeded