Delivery Header Text in SAP Query SQ01

[Anjhi]

Hi Friends,

My requirement is that I need to display the Header Text contents in Outbound delivery in a Query report using SQ01.

As far as I know, we can pull only table fields in SQ01.

Is it possible to include Text contents in SAP Query? Can we develop or enhance it?

Regards,

AK

[raymond_giuseppi]

You can add structure and code in a dataset using SQ02, then it will be available to use in SQ01, but a long text can consist of many lines, and so you may require to truncate the text - read [SAP Query|http://help.sap.com/saphelp_NW70EHP1core/helpdata/en/d2/cb3efb455611d189710000e8322d00/frameset.htm] documentation

- [Creating Additional Structures|http://help.sap.com/saphelp_NW70EHP1core/helpdata/en/d9/9958d4c50a11d396f80000e82de14a/frameset.htm]

- [Further Code|http://help.sap.com/saphelp_NW70EHP1core/helpdata/en/d2/cb4504455611d189710000e8322d00/frameset.htm] (I suggest record processing or after the query get the table with the text id)

So create a structure with some text fields, and fill it for every record read in futher code part.

Regards,

Raymond

[Anjhi]

Thanks. I already done that way. Yes, you are also right. Hence, I given you the points

[Former Member]

I'm sorry to hijack this thread. But this thread is closely similar to what i am trying to accomplish

I'm trying to create an InfoSet for table EKPO

Case: In PIR, user enters text in the TEXTS tab where there is Info Memo and Purchase Order Text.

The text in Purchase Order Text will be shown in our PO print out. ABAPer has added it to the PO Smart Forms

My objective is to extract all materials and its related text in PIR with it. I've checked from the SMART FORMS that the ABAPer got the data from Text Object: EKPO and TEXT ID: F05

How am i able to extract it using InfoSet?