Sales Order Header Text

[Former Member]

Hi All,

I have a sales order with a reference number in the header text.

Using header text as my input field I need to create a report for all sales orders.

example:

Order no A123 - Reference number in the header text - FAN

Order no A223 - Reference number in the header text - AXLE

Order no A323 - Reference number in the header text - FAN

Order no A423 - Reference number in the header text - AXLE

if user enters FAN in the selection parameter - report should display A123 and A323..

I need a link between header text and other sales order data..

Please help.

Meghna

[Former Member]

Hi All,

I have a sales order with a reference number in the header text.

Using header text as my input field I need to create a report for all sales orders.

example:

Order no A123 - Reference number in the header text - FAN

Order no A223 - Reference number in the header text - AXLE

Order no A323 - Reference number in the header text - FAN

Order no A423 - Reference number in the header text - AXLE

if user enters FAN in the selection parameter - report should display A123 and A323..

I need a link between header text and other sales order data..

Please help.

Meghna

[former_member156446]

you need to get data from read_text FM and collect data, and display in output.

Search in SCN on how to use Read_text with Sales Order header test.

[FM READ_TEXT to Read the Various Text|http://www.sap-img.com/abap/use-fm--read-text-to-read-the-various-text.htm]

[Former Member]

Hi,

Thanks but for my report I don't know the sales order number.

The main purpose is to get the order details already stored in the system using reference number header text.

Can I use READ_TEXT without knowing sales order number?

Please help.

Meghna

[Former Member]

It's going to be pretty difficult to find this in a text field. I would expect that this would be put in some other field when configuration was done. Is the reference number the purchase order number?

Rob

[Former Member]

Thanks Rob.

Unfortunately the reference number in the header text is like a track number and it is not a PO number.

please help.

Meghna

[former_member156446]

name , ID, object are the mandatory field to use read_text... you need to have sales order number

[Former Member]

I think the configuration or data entry procedures should be changed to capture this in a field that can be easily selected.

Rob

[Former Member]

Hi

The problem is how u can select all Sales Order having a certain text in the header text?

U can't, that's the problem:

u should read all header text by fm READ_TEXT (just as J@Y wrote) and then check the text, everytime the report should check the header text of the all existing sales orders in your system: it's very bad for the performace.

So Rob is right: it should be choosen a field in VBAK table (or append a new field) where to store the information and use it for the selection.

Max

[former_member156446]

The approach what Meghan Rao is going would be suitable for customer facing documents(scripts/smartforms), not for an general R3 reporting.