How do I make the Line Item Text field reportable?

[SAPSupport]

how do I make the Line Item Text field of sales order reportable in our custom dispatch report?

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

[SAPSupport · Accepted solution]

Please refer to SAP KBA 0003282990

Resolution

Consider using API Sales Order (A2X) to extract the header and item texts for the sales orders:

• /A_SalesOrderItem(SalesOrder='{SalesOrder}',SalesOrderItem='{SalesOrderItem}')/to_Text (Reads the text of a sales order item).
• /A_SalesOrder('{SalesOrder}')/to_Text (Reads the header texts of a sales order).

There is currently an Influence Idea for this requirement: CDS View for Long Text. 

Within this influence request development have provided the following update:

"To offer the CDS view for long text, the text table need to be redesigned, all text data has to be migrated and the text data reading, writing, copying logic along the sales E2E process have to be updated. To make sure the replacement will work smoothly after the replacement, a proof of concept has been planned in the coming release. And the feature will be planned later based on the findings."

The next update on this will be Q2 2025.