Here is a list of possible Cross-plant material status related tables in SAP. using . You could also view this information on your SAP system if you enter . Table for Plant/Supplying Plant Assignment for Extended Source Determ. It comes under the package MG. Example for general level, status is set at basic data 1 view. The quick way to identify materials that have a cross-plant status is to use the SE16 or SE16N transaction searching for materials (MARC) and material/plant (MARC) that have a status (MARC-MMSTA) that is non-blank. The field is super helpful in blocking certain materials usabilityina particular plants. It's hard to tell whether you also wish to report on materials that have no cross-plant status, but that would mean reporting on . The material is blocked for Purchasing. Below you can find the technical details of the fields that make up this table. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). For internal type, leave it as blank so the system assign material number . You will get more details about each SAP table by clicking on the table name. Step 2 : - On create material master initial screen, update the following details. In order to retrieve the plant based on company code, try this join query : WHERE W ~ WERKS = P _ WERKS. 02. The Material Number A material number is used to uniquely identify a material in the SAP system. This field is often used to manage the lifecycle of the material also in the context of SAP RD. . The second method is based on SAP Plant Data. It belongs to the package WAUF . EBEW - Valuation of sales order stock. Package : VKON. In this post, I will explain 2 methods to retrieve the list of Plant who manufacter a Product. The only table to remember for sap company code is t001. The blocked material can then be seen in table MARA, with filtering values 01 and 02 for field MSTAE. It is a unique 18 character field, which is assigned to each material in either of the following two ways: Internally Refers to the number that the mySAP ERP system assigns to a material while creating its master record Externally Retrieve Plant from Company Code in SAP. As a result, you block the plant material both for Inventory Management . KOTW001. 685579. MM02 Follow-up material -> update termination 29 281. Sap plant table sap plant overview. On the one hand, these status are used in the material master database tables to mark whether datas from the respective user department are maintained. QBEW - Valuation of project stock. Plant Status Table. IS-OIL / IS-MINE : Upgrade 472 - Table Conversions. Additionally we provide an overview of foreign key relationships, if any, that link MARA to other SAP tables. 744834. Client Specific Blocked . Willem Hoek on Jan 11, 2013. . In SAP, how do I find a deleted document . MARD: Storage Location Data for Material. We use cookies and similar technologies to give you a better experience, improve performance, analyze traffic, and to personalize content. You can blocked material at client level when we require at all plant same status. Manufacturing Plants for a SAP material list is some times it is tricky. WERKS for the Plant id. Here is a list of possible Plant-sp.matl status related tables in SAP. You can add a date from which on the status becomes active. Performance during search for material variants. MARC: Plant Data for Material. MM17: MARC-PLNTY cannot be changed. Keep in mind that this table will have records for all material/plant/storage location combinations; You can use the transaction code SE16 to . MARA is a standard Material Master Transparent Table in SAP Logistics application, which stores General Material Data data. Key fields are marked in blue. Table for Matl grp 2/Matl grp 3/Price list. If the basic data 1 tab has an "X-plant matl status" block. MLAN - Material Master: Tax indicator. Data Modeling Table for IS-M: Cross-Plant Mix for Material Type. SAP Table Plant Tables : AUSB - Plant Status Table Tcode, T2709 - Master data table: Plant Tcode, CIF_IMPLT - Integration Model Reference Table for Plants Tcode, TWEKT - IS-R Labeling: Text Table Customer/Plant Groups Tcode, TWEK - IS-R Labeling: Check Table Customer/Plant Groups Tcode Maintenance status are predefined by SAP. 2. Table for Plant/Material/Unit of Measure Table Type : TRANSP Package : VKON Module : AP-PRC-PR; KOTH003 Table for Customer/Plant/Material Table Type : TRANSP Package : VKON Module : AP-PRC-PR; KOTH023 Table for Plant/Material Table Type : TRANSP Package : VKON Module : AP-PRC-PR; KOTH024 Table for Movement Type/Plant/Material Table Type . This can be used to determine how much of a certain type of material is required for production. 850440. RMDATIND: Quantity fields multiplied by factor 1000. This is done in database tables: On the other hand, these status are also used in customizing. I hope it will help you Regards, Murali. Below you can view the Table Structure, columns (fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for MARA. Table for Material dependent status of the number range Table Type : TRANSP Package : MGVERS Module : LO-MD-MM; MISTATUS Table for Status Table for Material Identification on Mat./Batch Level Table Type : TRANSP Package : VHUMI Module : PP-PI-MIR; MSTA Table for Material Master Status Table Type : TRANSP Package : MG Module : CRM; OIO_MT_STATUS SAP Material Master - SAP GUI on the left and SAP WEB-UI on the right Specification As far as the specification is concerned here we have several possible ways of managing the lifecycle: The keys for this table are: MATNR for the Material Number. You will get more details about each SAP table by clicking on the table name. Key fields are marked in blue. Table Type : TRANSP. After you create the status in customizing you can go into its configuration details and setup the the response for everything the material can be related to (Purchasing, BOM's, Routing/recipe, etc.) In the SAP Material Master is a field "X-plant material status". Table Type : TRANSP. MVER - Material Master: Consumption. Logistics -> Material Management -> Material Master -> Material -> Change -> Immediately Enter material number, select Sales: Sales Org Data 1 and enter the values for sales area you want to change, Through DChain-Spec status field you can block obsolete material, you can choose DChain-spec value from F4 The Table name (X-Plant status) is 'MARA' and the field is 'MSTAE' and field name for X-Distribution chnl is 'MSTAV' and Plant-Specific Material Status, table is 'MARC' and field is 'MMSTA'. The parent entry could be found in PROD_ROOT: MMSTA is a standard field within SAP Table MARC that stores Plant-Specific Material Status information. The table AUSB ( Plant Status Table) is a standard table in SAP ERP. Based on the definition and design of the materail in the life cycle we can defined the items as described below: In general we have list of statuses and their meaning in the life cycle of the product X-Plant status - Meaning of that number 01 - Obsolete 03 - Hibernate/standby 05 - Discontinue 10 - Concept 11 - Pending production Module : AP-PRC-PR. Here is a list of possible Se16 plant related tables in SAP. Its submitted by dispensation in the best field. SAP - Create new material status. Not sure why it's throwing an error message while raising Sales order for purchased goods alone. SAP Table MARC Plant Data for Material. MVKE - Material Master: Sales. MARC stored the Plant related data for SAP Material. It comes under the package MG. Table MSTA technical data SAP MSTA Table Fields Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MSTA table. This date field is right of the . SAP MM Tables. By continuing to browse this website you agree to the use of cookies. The field X-plant Mat.Status, short for Cross-Plant Material status indicator sits in the Material Master, Basic Data 1 view in SAP S4/HANA, Material Management SAP MM and PP domain. The First Method is based on SAP Production Order. Plant specific. SAP Table MARA General Material Data MARA (General Material Data) is a standard table in SAP R\3 ERP systems. Advertisement If we start this configuration activity, it would bring the below screen showing a view to define material Statuses. MARC is a SAP standard transparent table used for storing Plant Data for Material related data in SAP. Find SAP product documentation, Learning Journeys, and more. Client Level. 717233. JVSDT134MIX. A material status can be set at general level, and affects all plants that share this material master, or you set the status only for a specific plant at plant level in material master. Query this table with the draft uuid found from SM12 against field PARENTDRAFTUUID, and you can find one corresponding entry for draft instance in Fiori UI. You have the following material statuses: 01. MCH1 - Material Master: X Plant Batches. 1. Here we would like to draw your attention to MARC table in SAP. Go to MM03 transaction enter the material select the views then select the organisational data here you enter the plant details then press enter if the material maintained in that plant system will display the record other wise system will give the message the material xxxx not maintaining for the plant xxx. MSTA is a SAP standard transparent table used for storing Material Master Status related data in SAP. No status is maintained in these fields (Status fields in Sales org 1 tab) and kept blank and updated only customized status Z* (designed in a way that it blocks all activities and throws an error) at Plant specific material status in MRP1 tab. You will get more details about each SAP table by clicking on the table name. In tcode BOBX, open BO I_PRODUCTWD and double click node I_PRODUCTSALESWD, you can find out table name PROD_SALES. The "plant specific material status table in sap" is a tool that SAP has created to help users understand what the plant-specific material status is. X-Plant material status means that the material can be procured or blocked or not blocked, etc. Table Type : TRANSP. Below is the standard documentation available and a few details of the fields which make up this Table. Plant-Specific Material Status: MMSTA: T141: CHAR: 2: 0: MMSTD: Date from which the plant-specific material status is valid: MMSTD: DATS: 8: 0: MAABC: ABC . It belongs to the package MG. Technical Information. Technical Data Prerequisites To use this DataSource, activate the writing of ALE change pointers for the message type MAT_FULL. A008. Material Master: Tax indicator MAPR - Material Master: Forecast MCH1 - Material Master: X Plant Batches MCHA - Material Master: Batches MCHB - Material Master: Batch Stock MDMA - MRP Area data DBVM - MRP Planning File Entry: MRP Area MOFF - Outstanding Material Master Records (Maintenance status) . The table MARC (Plant Data for Material) is a standard table in SAP ERP. You can also check the standard view V_T001K_ASSIGN, you will have the company code and plant assignment table. All SAP tables with fields that use this Data Element Contribution section Attributes of SAP Data Element MSTAE Related Data Elements in SAP /PLMB/MSTAE - Cross-Plant Material Status BBP_MSTAE - Cross-plant material status from MM/PP view FIP_MSTAE - Cross-Plant Material Status MSTAE - Cross-Plant Material Status 2. Plant-Specific Material Status: MMSTA: CHAR: 2: T141: MMSTD: Date from which the plant-specific material status is valid: MMSTD: DATS: 8: MAABC: ABC Indicator: MAABC: CHAR: 1: MARC (Plant Data for Material) is a standard table in SAP R\3 ERP systems. Below is the list of attribute values for the MMSTA field including its length, data type, description text, associated data element, search help etc. In SAP, the definition of a PLANT is : "A place where materials are produced, or goods and services are provided.". MAPR - Material Master: Forecast. Material Status can be blocked at 1. . T141T is a standard SAP Table which is used to store Descriptions of Material Status from MM/PP View data and is available within R/3 SAP systems depending on the version and release level. Plant specific Material Status: When we require block status on plant specific then use to maintain this view. Step 1 : - Execute t-code "MM01" in command field from SAP easy access screen. Table for Plant/Additional selling plant. The two DataSources ( 0RT_MAT_PLANT_ATTR and 0MAT_PLANT_ATTR) have identical structures and are used to retrieve attributes for the combination of product and location from the database table MARC. 4. And if you used MM06 as a material deletion flag, you can see the blocked material from Table MARA with field LVORM filtering value X. DVER - Material Master: Consumption. Thanks, Satyajit Add a Comment Alert Moderator 2 comments Former Member Jul 03, 2009 at 07:37 AM Anoop, I am not sure about Material status field in APO. Here is IMG menu path to perform the configuration: SPRO -> Logistics -> General -> Material Master -> Settings for Key Fields -> Define Material Statuses The transaction code for this menu path is OMS4. Material group and material is stored in table stored at client level mara. Here is what SAP says about the field X-Plant Mat.Status: T024W_CCP. Material : - For external type, enter the alphabetic keys that defines as material code. The material is blocked for Inventory Management. It is the internal Plants to company of course who produce the SAP material. Below you can find the technical details of the fields that make up this table. You assign material status 01 to the material at plant level, and material status 02 at cross-plant level (that is, at client level). SAP MM Training. LGORT : Storage location