What is the table for plant and company code in SAP?
T001W
SAP Plant Company Code Tables
| # | TABLE | Description |
|---|---|---|
| 1 | T001W | plants/Branches |
| 2 | MARC | plant Data for Material |
| 3 | T001 | company codes |
| 4 | MARA | General Material Data |
How do I find out what plants are assigned to company code?
Step 1 : – Execute t-code “OX18” in command field from SAP easy access screen. Step 2 : – On change view “Assignment plant – company code” overview screen, choose new entries button for assignment of company code to plant in SAP.
How do I assign a plant to company code in SAP?
Step 1: SPRO=>IMG=>Enterprise Structure=>Assignment=>logistics- General=> Assign plant to company code. Step 2: Double click on “Assign plant to company code”. And after that Click on new entries button & update company code in “cocd field” and plant code in “Plnt field” and press enter.
How do I find the company code in SAP table?
Generally table T001 is for company code info.
How do you show plant code in SAP?
WB03 SAP tcode – Display plant.
What is the SAP table for plants?
WERKS is a standard field within SAP Table t001w that stores Plant information….Attributes from SAP Table field T001W-WERKS.
| Short Description: | Plant…See data element details |
|---|---|
| Reference table: | |
| Can field have NULL value?: | Yes |
| Data Element / Component Type: | WERKS_D |
| Domain name: | WERKS |
How do I find my plant code in SAP?
Where can I find plant code in SAP?
Retrieve Plant from Company Code in SAP
- SELECT K~BUKRS INTO LV_BUKRS.
- FROM T001K AS K.
- INNER JOIN T001W AS W.
- ON K~BWKEY = W~BWKEY.
- WHERE W~WERKS = P_WERKS.
What is the plant table in SAP?
SAP Plant Tables
| # | TABLE | Description |
|---|---|---|
| 1 | PLANTID | plant ID |
| 2 | PLANT | Sequence table for MRP units – scope of planning |
| 3 | PLANT_DETAILS | plant details |
| 4 | PLANTNAMES | plants |
What is the table name for plant in SAP?
T001W-WERKS Plant SAP Table field attributes inc. WERKS_D Data Element. WERKS is a standard field within SAP Table t001w that stores Plant information.
How do you show Plant code in SAP?
How to assign company code to a plant?
Help to improve this answer by adding a comment. If you have a different answer for this question, then please use the Your Answer form at the bottom of the page instead. SPRO ->Logistics-General ->Basic Settings ->Assign Company code to plant displays company code and plant relationship.
Which is the field for plant in SAP?
The main tables for Plant in SAP are: The Field for SAP Plant is WERKS (typed as WERKS_D). Plant & Company Code Tips Retrieve Plant from Company Code in SAP
How to find sap plant based on company code?
The Field for SAP Plant is WERKS (typed as WERKS_D ). In order to retrieve the plant based on company code, try this join query : SELECT K~BUKRS INTO LV_BUKRS FROM T001K AS K INNER JOIN T001W AS W ON K~BWKEY = W~BWKEY WHERE W~WERKS = P_WERKS. WHERE W ~ WERKS = P _ WERKS.
Which is an example of a company code in SAP?
Below is an example of a Company Code in SAP Transaction Code: OBY6 can be used to check the list of Company Codes created in SAP. Or, transaction Code OX02 can be used to check the list of Company Code in SAP. Alternatively, we can check the list of Company codes from SAP Table T001.