SAP Plant Table and SAP Company Code Table with usefull ABAP Tips

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 :

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

The SAP table to consider here is TVKO for Organizational Unit: Sales Organizations

 

*source: SAP MM – Defining Organizational Structure

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ...Sab