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

[vimal]

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

[Shakeel_Ahmed · Accepted solution]

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

[former_member605599 · Accepted solution]

Hi Shakil,

Presently I am working in a S4HANA 1809 conversion project. We are facing some issue related to BSIS and BSAS table. We have created two append structure in BSIS and BSAS in our ECC system. But in S4HANA BSIS is now defined as a DDL view and we are not able to find those append structure into that ddl source of BSIS and BSAS. Please suggest how to get back those field in S4HANA converted system.

Please help me on that.

Thank You.

[charliee · Accepted solution]

Hi Shakeel,

How are the appends with custom fields in old tables such as BSIS are being handled now?
BSIS is obsolete. And those appends are now part of BSIS_BCK. But the new BSIS view does not seem to be able to recognize them.

One option would probably be changing the code to read the data from ACDOCA rather than through view BSIS.

Any thought?
Thanks,

-Elham

[Gustavo_Vazquez]

Hi Virmal,

Please check notes 1976487 , 2511926, 2156822, 2408083.

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

Kind Regards