ABAP - how to trace from header texts back to sales orders

[Tri]

Hi,

I know that from sales orders, I can use FM read_text to read the header and item texts.

I have a scenario that for example, I need to find sales orders based on header text contents.

Is it possible to do that?

Regards,

Tri

[raymond_giuseppi · Accepted solution]

Seems you require some search-help on long text content to find the objects that carry this text?

• By default, you cannot, the long text values are stored in a clustered type table.
• So look for SAP tools such as Enabling Searching in Long Texts 

[BaerbelWinkler]

Hi Tri,

you might be able to do this via table STXH which has the generic fiield TDNAME containing the key(s) of the object, the text refers to. Standard sales order header texts have TDOBJECT = VBBK and you may also need to restrict it via TDID and SPRAS depending on your requirements.

You'll have to make sure that TDNAME is in this case only the VBELN as some of the object keys in field TDNAME are concatenations of different fields, so that you could for example have MANDT+VKORG+VBELN and you'd then have to pick the correct places from TDNAME to get only the VBELN.

Hope this helps!

Cheers

Bärbel