Using table TMAPSTLOC to get Plants for an EWM Report/Output
I'm trying to create a report that extracts material details including the plant from which the material was produced.
The plant comes from using the table /SCWM/TMAPSTLOC. From what I know it's used to connect ECC data with that of EWM. I'm linking this to the table /SCWM/AQUA and /SCWM/BINMAT for other details.
When the data comes out I've noticed that a record is almost identifical except for the field, TMAPSTLOC-AVLGRP.
I would like to know if:
- This is the correct way to query data from EWM tables. Example, am I using the correct tables etc. I'm doing this because I have to pull data into an external report/output for auditing purposes. The end user will not have or should not need access into the EWM system itself.
- Why do I find two almost identical records with only AVLGRP as the difference? Should I focus only on one type of AVLGRP? I've noticed different statuses for te description of AVLGRP such as Goods for Putaway and Goods Completely Available. Should I filter in only one or should I keep both? If I have to only leave certain avaiability groups within the system, which one?