Address Table: Company Code, Customer, Vendor | SAP
In this article, we will explore various tables related to
- Company Code
- Vendor
- Customer
And the linkage between different SAP tables.
Table of Contents
Company Code Address Details:
We maintain SAP Company Code in Transaction / TCode: OX02.
Table T001 stored Company Code details.
Table ADRC Stored Address Details of all SAP object, including Company Code Address.
- Go to Transaction / Tcode: SE16 or SE16N
- Enter Table: T001
Enter Company Code and execute. - Check the value in column “Address“, technical field name: “ADRNR“.
Use this value in the next table. - In SE16 / SE16N, enter table ADRC, and enter ADRNR copied in the previous step in field “Address Number” (technical field name: ADDRNUMBER).
- Here you can see the details you have entered in the transaction / tcode OX02 while creating the company code.
For detailed information on “How to create Company Code in SAP?” and the relationship between “Company Code table” and “Company code address table”, please refer the link “SAP Company Code Table and Transaction“.
Various Tables related to Company Code in SAP
| Table Name | Table Description |
|---|---|
| T001 | Company Codes Details. Details entered in TCode OX02 or OBY6 |
| T001Z | Additional Specifications for Company Code. Details entered in TCode OBY6 -> Additional Data |
| ADRC | SAP Comapny Code Addresses Table (Business Address Services). Details entered in OX02 -> Address details. Or in Transaction Code OBY6 -> Address Details. ADRC-ADDRNUMBER should be equal to T001-ADRNR number. |
Business Partner (Customer) Details:
We maintain SAP Business Partners (Customer) in transaction XD01. XD02 and XD03
Table KNA1 and KNB1 stores Customer Master details, and
Table ADRC stores Address Details.
- Go to Transaction / TCode: SE16 or SE16N
- Enter Table: KNA1, and then enter the Customer Number in the field “Customer” (technical name: KUNNR) and execute.
- Check the value in the column “Address” (technical name ADRNR).
Use this value in the next field. - In SE16 / SE16N, enter table ADRC, and enter ADRNR copied in the previous step in field “Address Number” (technical field name: ADDRNUMBER).
- Here you can see the address details, maintained in customer master.
Various Tables related to Customer and Vendor in SAP
| Table Name | Table Description |
|---|---|
| LFA1 | Supplier Master (General Section) or Vendor Master Table at Country level. |
| LFB1 | Vendor Master (Company Code). |
| LFBK | Vendor Master (Bank Details) |
| LFB5 | Vendor master (dunning data) |
| LFBW | Vendor master record (withholding tax types) X |
| ADRC | SAP Vendor Addresses Table (Business Address Services). ADRC-ADDRNUMBER should be equal to LFA1-ADRNR Address number. |
| KNA1 | General Data in Customer Master at Country Level |
| KNB1 | Customer Master (Company Code) |
| KNBK | Customer Master (Bank Details) |
| KNB5 | Customer master (dunning data) |
| KNBW | Customer master record (withholding tax types) X |
| ADRC | SAP Customer Addresses Table (Business Address Services). ADRC-ADDRNUMBER should be equal to KNA1-ADRNR Address number. |
Hope this post answers your query related to Company Code Tables, Vendor Tables and Customer Tables.
You can post your comments if you want to know something specific.
Do let us know your experience in the comment section below.
I like the valuable information you provide in your articles. I’ll bookmark your blog and check again here regularly. I am quite sure I will learn plenty of new stuff right here! Best of luck for the next!