How to get information about Sales Document Item Texts by Text Types？

[SAPSupport]

Hi there,

We need to get information about Sales Document Item Texts by text types in Embedded SAC. We did not find any suitable standard CDS views.

How we can get this information?

Thank you.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello!

The storage mechanism of Text is special. It is stored by binary characters. For this reason, it cannot be directly displayed to end users through CDS views.

Instead of CDS View, you can consider using the OData V4 API Sales Order (A2X), with GET method and "/SalesOrderText" and "filter".

For example: /sap/opu/odata4/sap/api_salesorder/srvd_a2x/sap/SalesOrderText?$top=20

You can add filter of LongTextID.

Check below for more details about this API:

• Business Accelerator Hub - Sales Order (A2X)
• Help Portal - Sales Order (A2X, OData V4)

For any further questions, you can feel free to reply under this SAP Community Q&A.

Hope this helps.