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.

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 NameTable Description
T001Company Codes Details.
Details entered in TCode OX02 or OBY6
T001ZAdditional Specifications for Company Code.
Details entered in TCode OBY6 -> Additional Data
ADRCSAP 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 NameTable Description
LFA1Supplier Master (General Section) or Vendor Master Table at Country level.
LFB1Vendor Master (Company Code).
LFBKVendor Master (Bank Details)
LFB5Vendor master (dunning data)
LFBWVendor master record (withholding tax types) X
ADRC SAP Vendor Addresses Table (Business Address Services).
ADRC-ADDRNUMBER should be equal to LFA1-ADRNR Address number.
KNA1General Data in Customer Master at Country Level
KNB1Customer Master (Company Code)
KNBKCustomer Master (Bank Details)
KNB5Customer master (dunning data)
KNBWCustomer 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.

One thought on “Address Table: Company Code, Customer, Vendor | SAP”

  1. 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!

Leave a Reply