SAP ADCP Person/Address Assignment (Business Address Services) Table data and field list

ADCP is a standard SAP Table which is used to store Person/Address Assignment (Business Address Services) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ADCP table consists of various fields, each holding specific information or linking keys about Person/Address Assignment (Business Address Services) data available in SAP. These include ADDRNUMBER (Address number), PERSNUMBER (Person number), DATE_FROM (Valid-from date - in current Release only 00010101 possible), NATION (Version ID for International Addresses)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ADCP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP ADCP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ADCP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3T000MANDT
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ADRCALPHAAD_ADDRNUMADR
PERSNUMBERPerson number AD_PERSNUMCHAR10ADRPALPHAAD_PERSNUMCDTADDRESS
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
NATIONVersion ID for International Addresses AD_NATIONCHAR1TSADVAD_NATIONADDRESS_NATION
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
COMP_PERSFlag: Person in company (C) or private (P) address AD_CMP_PRSCHAR1AD_CMP_PRS
SO_KEYSAP-Office key AD_SO_KEYCHAR10ALPHAAD_SO_KEYADDRESS
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
BUILDINGBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
ID_CODEShort name for correspondence AD_ID_CODECHAR10TEXT10
IH_MAILInt. mail postal code AD_IH_MAILCHAR10TEXT10
SORT1(Not Supported) Search Term AD_SORTOLDCHAR20CHAR20
SORT2(Not Supported) Search Term AD_SORTOLDCHAR20CHAR20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ALT_COMPNYBusiness address number, if different (not used) AD_ALTCMPYCHAR10ADRCALPHAAD_ADDRNUM
DEFLT_COMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL_EXTENSFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
FLAGCOMM2Flag: Telephone number(s) maintained AD_FLGCM02CHAR1XFELD
FLAGCOMM3Flag: Fax number(s) maintained AD_FLGCM03CHAR1XFELD
FLAGCOMM4Flag: Teletex number(s) maintained AD_FLGCM04CHAR1XFELD
FLAGCOMM5Flag: Telex number(s) maintained AD_FLGCM05CHAR1XFELD
FLAGCOMM6Indicator: E-Mail Address(es) Maintained AD_FLGCM06CHAR1XFELD
FLAGCOMM7Flag: RML (remote mail) addresse(s) maintained AD_FLGCM07CHAR1XFELD
FLAGCOMM8Flag: X.400 addresse(s) maintained AD_FLGCM08CHAR1XFELD
FLAGCOMM9Flag: RFC destination(s) maintained AD_FLGCM09CHAR1XFELD
FLAGCOMM10Flag: Printer maintained AD_FLGCM10CHAR1XFELD
FLAGCOMM11Flag: SSF maintained AD_FLGCM11CHAR1XFELD
FLAGCOMM12Flag: URI/FTP address maintained AD_FLGCM12CHAR1XFELD
FLAGCOMM13Flag: Pager address maintained AD_FLGCM13CHAR1XFELD
ADCP_UUIDUUID Used in the Address AD_UUIDRAW16SYSUUID
UUID_BELATEDIndicator: UUID was generated later AD_UUID_BELATEDCHAR1AD_UUID_BELATED
ID_CATEGORYCategory of an Address ID AD_ID_CATEGORYCHAR1AD_ID_CATEGORY
ADCP_ERR_STATUSError Status of Address AD_ERR_STATUSCHAR1AD_ERR_STATUS

Key field Non-key field



How do I retrieve data from SAP table ADCP using ABAP code

The following ABAP code Example will allow you to do a basic selection on ADCP to SELECT all data from the table
DATA: WA_ADCP TYPE ADCP.

SELECT SINGLE *
FROM ADCP
INTO CORRESPONDING FIELDS OF WA_ADCP
WHERE...

How to access SAP table ADCP

Within an ECC or HANA version of SAP you can also view further information about ADCP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).