Using table TMAPSTLOC to get Plants for an EWM Report/Output

[Former Member]

Hi,

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.

Raphael

[christian_reinhardt · Accepted solution]

Hi Raphael,

the /SCWM/TMAPSTLOC is used for mapping for the ERP storage location to an EWM availability group (that will later be used for stock type determination). Therefor the entries are similar and the number of entries is usually low.

As I do no 100% understand your requierement I'm not sure if this table is right for you.

I understand that you want to determine the production plant. May be the inbound delivery could be a better source. Via partners you should be able to identify the source.

Best regards,

Christian

[Former Member · Accepted solution]

Good day Christian,

Thank you for the response. Could you please elaborate further on what you mean by using Inbound delivery?

I've done a bit of checking and found these tables. Are they the ones that you mean by using "Inbound Delivery".

/SCDL/DB_PROCH_I  Inbound Delivery: Header

/SCDL/DB_PROCI_I   Inbound Delivery Item

Thank you.

Raphael.

[christian_reinhardt · Accepted solution]

Hi Ramos,

these are the tables I was talking about. But you should not select the tables directly but use the query method of /SCWM/CL_DLV_MANAGEMENT_PRD to derrive he deliver data. Via the partner data you should be able to determine the source of a product...

However this will be difficult to determine the source after the final putaway when the delivery reference is deleted.

Best regards,

Christian

[former_member600986]

Hi,

I would also suggest looking at some of the function modules used inside the monitor to check for stock etc.  Check this function group:

/SCWM/STOCK_OVERVIEW_MON

Has a list of FM that you can call to querry stock.

Regarding the AVL group you need to define what the users want to see.  Since EWM in most cases uses two AVL GRPs, stock first is available in one (at receipt) then moves to the second during putaway.  

Thanks,

Faical