Company Code Table in SAP: A Complete Guide for SQL Queries

In SAP’s Financial Accounting (FI) module, the company code is a fundamental organizational unit representing an independent accounting entity. Understanding how to manage and retrieve company code data is crucial for backend developers and those new to SAP. This comprehensive guide explores the primary table associated with company codes, addresses common queries, and provides SQL examples to facilitate efficient data handling.

Understanding the Company Code in SAP

A company code in SAP denotes a legally independent entity for which financial statements like balance sheets and profit & loss statements are prepared. It serves as the smallest organizational unit in external accounting, ensuring compliance with legal reporting requirements.

Key Table for Company Code Data: T001

The central repository for company code information in SAP is the T001 table. This table stores essential details for each company code, including its name, address, currency, and country.

Important Fields in T001

• BUKRS: Company Code
• BUTXT: Company Code Name
• ORT01: City
• LAND1: Country Key
• WAERS: Currency Key
• KTOPL: Chart of Accounts
• BUKRS_ALT: Alternative Company Code

These fields are pivotal when constructing SQL queries to retrieve specific company code information.

Comprehensive Guide to the EKPO Table in SAP

Retrieving Company Code Data Using SQL Queries

For backend developers, efficiently extracting company code data is essential. Below are SQL query examples to assist in this process.

Fetching All Company Codes

To retrieve a list of all company codes along with their names and countries:

SELECT BUKRS, BUTXT, LAND1
FROM T001;

This query provides an overview of all company codes and their respective countries.

Retrieving Company Code Details by Country

To obtain company codes located in a specific country, such as Germany (country key ‘DE’):

SELECT BUKRS, BUTXT, ORT01
FROM T001
WHERE LAND1 = 'DE';

This query lists all company codes operating in Germany, including their cities.

Identifying Company Codes with Specific Currency

To find company codes that use a particular currency, like the Euro (currency key ‘EUR’):

SELECT BUKRS, BUTXT, WAERS
FROM T001
WHERE WAERS = 'EUR';

This query helps identify company codes that operate using the Euro currency.

Commonly Asked Questions About Company Codes in SAP

How to Retrieve Company Code Address Information?

While the T001 table contains basic address details, comprehensive address information is stored in the ADR tables. To fetch detailed address data for a company code:

SELECT a.BUKRS, a.BUTXT, b.NAME1, b.STRAS, b.PSTLZ, b.ORT01, b.LAND1
FROM T001 a
JOIN ADRC b ON a.ADRNR = b.ADDRNUMBER
WHERE a.BUKRS = '1000';

This query retrieves the full address for the specified company code.

How to List Plants Assigned to a Company Code?

Plants are linked to company codes through the T001W table. To list all plants assigned to a specific company code:

SELECT WERKS, NAME1
FROM T001W
WHERE BUKRS = '1000';

This query provides a list of plants associated with the specified company code.

How to Find Users Assigned to a Company Code?

User assignments to company codes can be determined by linking user master records with organizational assignments. One approach is to use the PA0001 table (Organizational Assignment) and PA0105 table (Communication) to find users associated with a company code:

SELECT p.PERNR, u.USRID
FROM PA0001 p
JOIN PA0105 u ON p.PERNR = u.PERNR
WHERE p.BUKRS = '1000';

This query lists personnel numbers and user IDs for users assigned to the specified company code.

Best Practices for Managing Company Code Data

• Data Consistency: Ensure that company code data is consistently maintained across all related tables to prevent discrepancies.
• Regular Audits: Periodically review company code assignments and related organizational data to maintain accuracy.
• Access Control: Implement appropriate authorization checks to control access to sensitive company code information.

Conclusion

Understanding and managing company code data in SAP is fundamental for backend operations and financial reporting. By familiarizing yourself with the T001 table and related SQL queries, you can efficiently retrieve and maintain company code information, ensuring accurate and reliable data management within the SAP system.

Learn about BKPF Table in SAP