Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Thank you.


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question