SAP4TECH

SAP and ABAP Free Tutorials
Menu
  • SAP Technical
    • ABAP Code Snippets
    • ABAP WebDynPro
    • SAP GW
    • SAP IDOC (ALE)
    • SAP PI (XI)
    • SAP Screen Personas
    • SAP Workflow
  • SAP Functional
    • SAP FI
    • SAP FSCM
    • SAP HR
    • SAP SD & SAP MM
    • SAP PM
    • SAP PP
    • SAP PS
    • SAP QM
    • SAP VIM
    • SAP WM
  • SAP Fiori
  • SAP HANA
  • SAP BW
  • SAP CRM
  • SAP SRM
  • SAP4TECH
    • About Us
    • Contact Us
    • Terms & Conditions
    • Privacy and Cookie Policy

SAP4TECH » SAP Plant Table and SAP Company Code Table with useful ABAP Tips

SAP SD & SAP MM

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

October 10, 2016 John

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.

Table of Contents

  • SAP Company Code Tables
    • SAP Company Code Overview
    • SAP Company Code Tables
  • SAP Plant Table
    • SAP Plant Overview
    • Main SAP Plant Tables
  • Plant & Company Code Tips
    • Retrieve Plant from Company Code in SAP
    • Get Address of a Company Code Tables Join
    • Link between BUKRS (Company code) and VKORG (Sales organization)

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 definition 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

Read also List of Important SAP SD Tables (Sales and Distribution).

Main SAP Plant Tables

The main tables for Plant in SAP are:

SAP Plant TablesDescription
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 :

ABAP
1
2
3
4
5
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

ABAP
1
2
3
4
5
SELECT VKORG BUKRS
FROM TVKO
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

*source: SAP MM – Defining Organizational Structure

Prev Article
Next Article
Tags:SAP Tables SAP Transaction Codes

Related Articles

SAP MASS
Mass Update Personal Numbers of Customer KNVP: This sample ABAP …

Mass Update Personal Numbers of Customer KNVP – Full ABAP Code

SAP Material
In this article, you will find the main SAP Material …

The Main Important SAP Material Master Tables (Data & Customizing)

Search on SAP4TECH

The Most Populars

  • The Most Important SAP ISU Tables
    The Most Important SAP ISU Tables
  • SAP Users Tables
    SAP Users Tables (for Personal, Logon, and Address Data)
  • List of SAP Purchase Order Tables in SAP MM SAP PO Tables
    SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • Full list of SAP Movement Types
    SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP GL Account Tcodes SAP GL Account Tables
    The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables
    SAP BOM Tables for BOM Header, Items and components and Category

Related Posts

  • Connection1
    Manage SAP SLG1 – Application Log in ABAP with samples
  • page not found 688965 1280 e1467294731652
    SAP ST22 SNAP – The SAP Tables for Dumb Message
  • calendar 1231038 1280 e1458046112993
    How to Link Between PLKO and PLPO for Routine in SAP
  • SAP Purchase Order ME21N Exit e1472546229483
    Complete list of SAP Purchase Document ME21N Exit and BADI
  • Sap Sales ORrganization
    Sap Sales Organization Overview (Tables, Definition, Tcodes and SAP SD Sales Org)

SAP4TECH

SAP and ABAP Free Tutorials

Trending Posts

  • The Most Important SAP ISU Tables
  • SAP Users Tables (for Personal, Logon, and Address Data)
  • SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables for BOM Header, Items and components and Category

The Most Recents

  • The Most Important SAP ISU Tables
  • SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd Lecture
  • The Main SAP Dunning Transaction Codes
  • SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
  • The Most Important SAP Payment Terms Tables (ZTERM, Text…)

Search

SAP Tutorials by Topics

  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets
  • Top SAP Courses
  • Top SAP Books
Copyright © 2021 SAP4TECH

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy