Custom CDS View Association

[Rawel]

Hi Good day SAP

I am Creating Custom Cds View 

Scenario External API

How can i Expose MaterialDocumentItems on MaterialDocumentHeader.

I think i am doing it wrong

Like this one 

MaterialDocumentHeader_2 = 1
_I_MaterialDocumentItem_2 = 1
_I_MaterialDocumentItem_2 = 2
_I_MaterialDocumentItem_2 = 3

MaterialDocumentHeader_2 = 2
_I_MaterialDocumentItem_2 = 1
_I_MaterialDocumentItem_2 = 2
_I_MaterialDocumentItem_2 = 3

[DilanLatifSAP · Accepted solution]

Dear @Rawel , 

I have created in my own Public Cloud same and it works. Please check the following Data source and their Join Condition. 

if you have any other question let me know. 

Thanks and BR

Dilan

[Rawel · Accepted solution]

Hi @DilanLatifSAP

I think I explained it wrong.

This is what I want to do:

I want to expose each items in the header by using ?$expand=to__I_MaterialDocumentItem_2,
but only with selected fields from I_MaterialDocumentItem_2.

Upon associating the I_MaterialDocumentItem_2. I got an error

Therefore, I am unable to publish it to my CDS view(s).

But this is the data I am getting in View Data.
The preview displays raw data without any aggregation or conversions.

In Postman there's no I_MaterialDocumentItem_2 to expand

I can see that each result line is based on Material Document item lines.

4900000000 = 10 Items = 10 Lines

[DilanLatifSAP · Accepted solution]

Dear @Rawel ,

please check this SAP Knowledge Base Article below,

https://me.sap.com/notes/3278639/E

Thanks and BR

Dilan