select query for sales order for particular customer oder text and storage

[Former Member]

Hi All,

I am trying to retriev customer order text and customer storage bin from the following select query, but it's giving huge number of records, I want to restrict the number of records.

Select customer order text, customer storage bin

Select STXH–TDOBJECT, STXH–TDID

Where TDOBJECT = VBBP

TDID = Y001

TDID = Y007

Please let me know how to restirct the number of records.

Thanks,

Ranjan

[Former Member · Accepted solution]

Try using the FM 'READ_TEXT'.

NAME will be the order number concatenated with the item number.

And you have the ID and OBJECT. You may also need to use the LANGUAGE.

Message was edited by:

Matt Nagel