how to read ACDOCA

[kjyothiraditya]

Hi,

we are having a custom report, where we need to fetch data from ACDOCA table based on Comp code, Year and Document number. But Ledger is also part of key of the table, so we can have more than one entry. How do we fetch the correct entry in such case ? Any pointers would be helpful.

Regards,

Aditya

[Paulo_Vitoriano]

Hi Aditya,

I would suggest to make a Ledger as a mandatory selection parameter to make you report flexible. Leading ledger is normally 0L.

Regards,

Paulo

[sanilbhandari]

I am not sure, what exactly you need, but if you need data for the leading ledger you can pass the data only for the leading ledger from ACDOCA. If you need other ledgers, than you can pass the data accordingly, where's the issue?

[kjyothiraditya]

How to get leading ledger ? Is it dependent on company code ? Or any other parameters ?

[sanilbhandari]

You can add it as selection parameter in the report, so that the user can select the same. If not you can set it up as fixed variable in the report variant using TVARVC.

[João_FI_FIN-CS]

As paulo.vitoriano said you can select by leading ledger but I considered check this date in the BSEG table because in theis table you've only leading ledger and I'd check some date in the BKPF table.

João Paulo Almeida

[raymond_giuseppi]

Ask functional for the required ledger. If none, then add it as a parameter with parameter id GLN_FLEX, you can provide the leading ledger by default

• reading table FINSC_LEDGER for RLDNR where XLEADING = 'X'.
• reading table FINSC_VERSN_LD for RLDNR where VERSN = '000' (for CoArea)
• etc.