In a query I want to identfy a TO as cancelled .
The field name in LT21 for the Confirm status is QSTAT in RL03T which
appears to be a structure ! .
Any help in what table this status field is ? any table?
Transfer order related tables are LTAK, LTAP.
If you go into trx LT21 and check the F1 help for field RL03T-QSTAT you will see that this is a calculated field.
- LT15 ("real" cancellation): if you cancel a TO the LTAP-VSOLM= (-1) x LTAP-VDIFM
- LT0G (not "real" cancellation): in this case the trash bin is not diaplayed in report LT22 / LT21 for the TO item > in sales document flow (table VBFA) you can see what's happened (maybe you can extract the information from somwhere else as well).