How to maintain ACDOCA table fields? Problem with FAGLB03

[former_member615053]

When I execute FAGLB03 transaction (GL Account balance display) in S4H for Ledger 0L and want to see details for debit or credit amounts, the line items displayed are showing fields assignment (ZUONR) and text (SGTXT) as empty. When debugging I noted the standard code fetches data from ACDOCA in join with BKPF and finsc_ledger_rep tables. At BSEG table I can see the text and Assignment fields and they have contents (and this table have less line items than ACDOCA) and info is same than FB03 transaction (bseg-zuonr, bseg-sgtxt). Seems the transaction FAGLB03 is selecting from ACDOCA other line items where Assignment and text are empty.

Easy solution is maintain the line items at ACDOCA where text and Assignment is empty. How data is maintained in that table? Or how we indicate FAGLB03 drill down to select correct line items?

[iklovski]

If the fields are already defined, clear the buffers via BALVBUFDEL program. Also, RFXPRA33might help.

You can consult this OSS note for more info:

2516732 - FBL*N/FAGLL03: Special fields are not available for selection in the layout or the values are blank

[João_FI_FIN-CS]

Dear eli.klovski,

Some notes as these you mentioned are recomended to SAP HANA and some notes are recomended to "all S/4HANA versions". When says just SAP HANA can we considered to S/4HANA?

Warm regards.

João Paulo Almeida

[iklovski]

Yes, definitely. Anyway, the eligibility of an OSS note is checked when you try to implement it.

[iklovski]

Hi,

Please, define these fields as 'Special fields' for display. You can follow instructions on this OSS note:

2227123 - FAGLL03 displays incorrect assignment field (ZUONR)

Regards,

Eli

[sanilbhandari]

Hello gilberto.parga.avila

Ideally at a line item level, the reference and assignment field values should be the same in BSEG and ACCDOCA. Can you check if the below:

1. If the values are being entered manually by end use while booking the transaction. In that case, i would see that as a product issue and raise an incident to Product Support

2. If the data is being updated by a substitution or an enhancement, than you need to check the same, if you are only updating the BSEG through direct update and will need to adapt the same for S/4HANA.

Thanks & regards

Sanil Bhandari

[João_FI_FIN-CS]

Dear Gilberto,

I guess you can run FBL3N and FBL3H to compare and check if the text is ok. It could be substitution rule but it does not make sense because in one tcode appears and in another the field is empty.

João Paulo Almeida