on 2020 Nov 06 9:59 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
39 | |
8 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.