Help extracting sales text into Crystal Report

[Former Member]

I am working on a Crystal Report where I need to pull shipping information from the sales order line text fields.  I understand from looking at other posts that the text data exists in the STXH and STXL tables but I have not been able to find a way to pull the required information in from those tables in Crystal.  Is this the right place to look for the data or is it stored somewhere else as well?

Any assistance is appreciated.

[former_member206632]

Hello Mathew,

Are you considering making a RFC call to SAP from your CR report? That will be the only way to read the text data, since this type of data is stored in SAP in what SAP calls "Clustered tables".

I will wait your reply before going further in details,

Regards,

João

[Former Member]

Mathew -

You can call Function module -Read_Text to read value from sales order line item. Go to SE37 ---Read_Text and pass the following values

Import parameters               Value

CLIENT                          Client  

ID                                  TEXTID

LANGUAGE                    EN

NAME                            Order Number (10 Char) +Item(6 Char) (0100000255000100) in this case 100000255 is order number and 100 is item number.

OBJECT                          VBBP

You will get your text in LINES

Try this,if it helps

Regards

Amit