2011 Oct 05 8:50 AM
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
2011 Oct 05 9:11 AM
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
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
2011 Oct 05 9:11 AM
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
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |