Manufacturing Plants for a SAP material list is some times it is tricky.
In this post, I will explain 2 methods to retrieve the list of Plant who manufacter a Product.
It is the internal Plants to company of course who produce the SAP material.
The First Method is based on SAP Production Order
The second method is based on SAP Plant Data.
Table of Contents
The main table to retrieve list of Manufacturing Plants for a SAP material can be found by joining the SAP table MSEG ( for SAP Stock Movement ) and SAP Table AFPO ( for SAP Production Order).
Check this book about Implementing SAP Manufacturing Execution (SAP ME).
First Retrieve the lines from MSEG with:
With the entrie retrieved, query the SAP AFPO ( Production Order Table ) with the Production Order Numlber AUFNR retrieved from MSEG.
The AFPO gives you the following information:
By selecting all the line of MSEG, you can retrieve from the SAP Production Orders historical Data, all the SAP Manufact. for your material.
Check the Different SAP Good Movement Types
Manufacturing Plants can be also retrieved from SAP Plant Master Data.
The SAP main tables MARD and MARC give you an overview of the SAP Material Storage location and Plant.
Set the MARC-BESKZ to ‘E’ ( for In-house Production) and execute.
You will have the list of Plants who product the required SAP Materail.
Also, check the table TCO43 which is maintained by the SAP Tcode OPKP.
Read also List of Important SAP SD Tables (Sales and Distribution) and SAP Good Movement Types ? Full list of SAP Movement Types.
The list of differents Procurement Type a Plant can have a
The Values are as Fixed value on BESKZ domain .
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…