Selecting transfer order data from LTAP

[Former Member]

Hi all. I am recuperating a file which contains material numbers. I need to select transfer order items from LTAP. If i use only the material number as a selection criteria, the select statement will not be optimal since material is not a key in LTAP.Are there any other tables i can use to make it more performing?thx

[Former Member]

Hi all. I am recuperating a file which contains material numbers. I need to select transfer order items from LTAP. If i use only the material number as a selection criteria, the select statement will not be optimal since material is not a key in LTAP.Are there any other tables i can use to make it more performing?thx

[Former Member]

Hi,

if all of your materials in the file are belonging to the same warehouse number LGNUM you can try to access table LTAP via index M with the fields warehouse number LGNUM, the PQUIT flag and the material number MATNR.

Regards,

Klaus