CDS view for Text field within the sales order

[former_member480404]

Hello,

I want to build a report which has to contain the information from the item level, tab "Texts". I've attached a screenshot for the location of the information.

Can anyone tell me which CDS view contains this information?

I've searched Material and SalesOrderItem CDS views and I couldn't find it anywhere.

Regards,

Alexandru Rogozea

[Andrew · Accepted solution]

Hi Alexandru,

I've not been able to find a CDS view exposing this either, but the SalesOrder API

https://api.sap.com/api/API_SALES_ORDER_SRV/resource

does have SalesOrderItemTexts exposed. As a workaround then, you could use the API to import the data to excel for example and build a report there.

Regards,

[former_member480404]

Hi Andrew,

Thank you for your answer but I don't think this is a good option.

As far as I understand you advise me to build the report in an Excel file using the SalesOrder API.

I can't go back to my customer who bought the Cloud system and tell him that he has to build a report in Excel.

Regards,

Alex