Cds with aggregation between adcoda and vendor information

[Anthony]

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 

[naveen_k1]

Hi,

[naveen_k1]

Hello ,

I'm not certain if what I have provided meets your requirements. Here the example CDS view 

The result looks as below

[Anthony]

thanks for your answer. In your example, are you using ACDOCA or BSEG and BKPF ?

Has your PL account in your exemple the information of the vendor on the line item or do you get it another way ?

Best regards

[naveen_k1]

Hi, I am using the data from ACDOCA and BSEG. The Vendor information in the results screen shot is coming from BSEG.