List of main SAP Plant Table and SAP Company Code Table: List of the important Plant and Company Code Tables in SAP and the relationship between Plant and company Code.
SAP Company Code Tables
SAP Company Code Overview
“Company is the top most organizational unit after client which incorporates individual financial accounting statements of several company codes. A company can have many company codes. In SAP it is optional to create company. Following steps will take you through the procedure of creating company.”*
Use the following path to Create Company in SPRO: IMG => Enterprise Structure => Definition => Financial Accounting => Define Company
Or try directly the SAP TCode: OX15
SAP Company Code Tables
The only table to remember for SAP Company Code is T001.
The field for Company code in SAP is: BUKRS typed BUKRS
SAP Plant Table
SAP Plant Overview
Let’s start with a short defintion of Plant in SAP.
“Plant is an organizational unit within a company where activities take place. A plant will produce goods and makes goods available for the company.”*
In SPRO, the path to create Plant: IMG => Enterprise Structure => Definition => Logistic General => Define, Copy, Delete check plant
Or use the SAP Tcode: OX10
Main SAP Plant Tables
The main tables for Plant in SAP are:
- T001W: Plants/branches
- T001L : Storage Locations
- T024E : Purchasing Organizations
- T024W : Valid Purchasing Organizations for Plant
- T001 : Company Codes
The Field for SAP Plant is WERKS ( typed as WERKS_D ).
Plant & Company Code Tips
Retrieve Plant from Company Code in SAP
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.
You can also check the standard view V_T001K_ASSIGN, you will have the company code and plant assignment table
Get Address of a Company Code Tables Join
In order to Get the Address of a company Code, join ADRC and T001.
ADRC with ADDRNUMBER = T001-ADRNR
Link between BUKRS ( Company code ) and VKORG ( Sales organization )
If you want to find the link between Company Code and Sales Organization, use the following query in ABAP
SELECT VKORG BUKRS
INTO TABLE LT_TVKO
WHERE VKORG = P_VKORG
AND BURKS = P_BUKRS.
The SAP table to consider here is TVKO for Organizational Unit: Sales Organizations