Skip to Content
0
Jan 11, 2011 at 02:08 PM

How to fetch data from ET_TEXT in CRM_ORDER_READ

524 Views

Hi,

I've a requirement to extract the 'Text' values from the Service Contracts in to SAP BI for reporting. I'm planning to enhance the standard datasource by implementing a BAdI.

The function module 'CRM_ORDER_READ' will give the table 'ET_TEXT' which stores the 'Text' values. However, it seems that the extraction is not a straight forward process as the actual texts are stored in a different table under 'LINES' field. It seems like a Hierarchy.

Can you please suggest the best way to extract the 'Texts' from ET_TEXT in CRM_ORDER_READ into SAP BI?

Thanks and Regards,

Sri.