on 2024 Apr 09 8:04 PM
Hello everyone,
I have to build a sac report based on a cds. We already have a cds giving for a specific profit center all documents for Profit and Loss account (based on ACDOCA Table).
What we would like to achieve is the following :
Document number - P/L Account - vendor - clearing date - amount
1800000012 - 310000 (expenses) - 1121 (Electronic Corp) - 13/03/2023 - 1200 EUR
Vendor and clearing date are not recorded on the PL account 310000 line item but instead on the vendor 1121 line item in ACDOCA.
How could we achieve in a cds the possibility to have vendor information on the PL account line item ?
thanks in advance
Mat
Vendor and clearind date is not
Request clarification before answering.
Hello ,
I'm not certain if what I have provided meets your requirements. Here the example CDS view
The result looks as below
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, I am using the data from ACDOCA and BSEG. The Vendor information in the results screen shot is coming from BSEG.
User | Count |
---|---|
54 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.