Need idea on how to add long text for both header and item data in routings

[tejaswir_7]

Hi all, my requirement is to add LTEXT field in routings ALV report , for both header and item data .

but i need them to fetch from plko and plpo tables only as i am using fm CP_EX_PLAN_READ ,

please let me know any way to get the field.

[raymond_giuseppi]

What's your problem with READ_TEXT?

[Sandra_Rossi]

Use SQL trace (ST05) in all situations where you need to know which tables are accessed, by which columns, and with which column values.

(in your case, by standard transaction code to maintain routings, maintain the concerned long text, then the SQL trace will indicate the values of columns TDID/TDNAME/TDOBJECT of long texts accessed in table STXH - provided that the data you are looking for is a long text of course)

[Sandra_Rossi]

I could see just now that you are still looking for some help on this topic although it's quite easy if you know SQL trace. Do you have difficulties with the SQL trace, do you need help?

[Sandra_Rossi]

Also, FYI, if you want to target someone, if this person has posted an Answer, use the button COMMENT, if this person is the Original Poster of the question he/she will be automatically informed, otherwise copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work/but typing this character will suggest hyperlinked names).

e.g. to target you, this is the right way: tejaswir_7

[Sandra_Rossi]

I see ROUTING, PLPO, PLKO in the SQL Trace. Don't you see it?

[Sandra_Rossi]

duplicate comment 😉

[tejaswir_7]

Hi Raymond , i could fetch only operation text with read_text program but i need header text also .

[Sandra_Rossi]

Please use the COMMENT button for comments, asking for complements, adding details, replying to a comment or a proposed solution or to the OP question, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

If you want to target someone, if this person has posted an Answer, use the button COMMENT, if this person is the Original Poster of the question he/she will be automatically informed, otherwise copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work/but typing this character will suggest hyperlinked names).