SAP Address – important Tables and BAPI

SAP Address – Some important Read BAPI: Regroups list of important SAP BAPI to Read SAP Address Details with list of Address Tables (ADRC… ). Find also how to retrieve SAP Business Address Services for Company and User. 

SAP Address Tables

The most important SAP tables Address are

  • ADRC: Addresses (Business Address Services)
  • ADR12 :FTP and URL (Business Address Services)
  • ADR2 :Telephone Numbers (Business Address Services)
  • ADR3 :Fax Numbers (Business Address Services)
  • ADR4 :Teletex Numbers (Business Address Services)
  • ADR5 :Telex Numbers (Business Address Services)
  • ADR6 :E-Mail Addresses (Business Address Services)
  • ADR7 :Remote Mail Addresses (SAP – SAP – Communication)
  • ADR8 :X.400 Numbers (Business Address Services)
  • ADRP :Persons (Business Address Services)

check here the definition of Business Address Services (BC-SRV-ADR)

Check also   The 3 ways to Mass Update Contacts of Customer in SAP

SAP Address for Company

In order to link SAP Address to SAP company, check the KNA1-ADRNR for Address Number.
You can retrieve directly data from ADRC et list of SAP Address Tables above.

SAP Address for User

SU01 user master record can be retrieved with the BAPI BAPI_USER_GET_DETAIL
The input is : USERNAME User Name like BAPIBNAME-BAPIBNAME.
You will retrieve all User data within the address information in

  • ADDRESS for Address Data
  • ADDTEL for BAPI Structure Telephone Numbers
  • ADDFAX for BAPI Structure Fax Numbers
  • ADDTTX for BAPI Structure Teletex Numbers
  • ADDTLX for BAPI Structure Telex Numbers
  • ADDSMTP for E-Mail Addresses BAPI Structure
  • ADDURI for BAPI Structure: URL, FTP, and so on

SAP Addresses Types

SAP Business Address Types are set on Domain AD_ADRTYPE.
The 3 different Types of Address are:

  • 1=Organization
  • 2=Person
  • 3=Contact person

Important BAPI to Read Address in SAP

ADDRESS_INTO_PRINTFORM

ADDRESS_INTO_PRINTFORM will format address according to different Country criteria.
This FM is for Address Format According to Post Office Guidelines.

Check also   Important SAP Profit Center Table in SAP CO (EC-PCA)

For example, the output ADDRESS_DATA_CARRIER_0 contains the right format for Street name with Street Number.

Tips: PO Box is filled, PO BOX is more prioritaire that STREET Data. 
So in order to force taking into account STREET, set the input field STREET_HAS_PRIORITY Flag: Street has priority over PO Box. 

ADDR_GET_COMPLETE

This Function Module ADDR_GET_COMPLETE Read the complete address object (incl. all communication tables).
The input is Address Number (Key of Database Table).

Before calling ADDR_GET_COMPLETE, make a call to ADDR_MEMORY_CLEAR to refresh Address Buffer.

ADDR_GET

The BAPI ADDR_GET will Read an address without dialog.
It will format also Street name and number to the right format in the structures ADDRESS_VALUE Return data for an address and SADR for Return the old address structure.

ADDR_REFERENCE_GET

The FM ADDR_REFERENCE_GET is a tool for Where-used list functions for SAP Address.
The input is ADDRESS_NUMBER gives you in output the tables and fields using this address.

For example, the output for a SAP Address used as Company Address will be :

  • APPL_TABLE KNA1
  • APPL_FIELD ADRNR
  • APPL_KEY 500    ABC    ( Mandant + Customer Id )
  • ADDR_GROUP BP
  • OWNER X

 

check more posts about address 

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

Leave a Reply

Your email address will not be published. Required fields are marked *