ADCPS SAP (Shadow Table: Assignment Person/Addr. (Bus. Addr. Services)) Table details
Dictionary Type: Table
Description: Shadow Table: Assignment Person/Addr. (Bus. Addr. Services)
Description: Shadow Table: Assignment Person/Addr. (Bus. Addr. Services)
Table field list including key, data, relationships and ABAP select examples
ADCPS is a standard SAP Table which is used to store Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) data and is available within R/3 SAP systems depending on the version and release level.
The ADCPS table consists of various fields, each holding specific information or linking keys about Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) data available in SAP. These include TRKORR (Request/Task), ADDRNUMBER (Address number), PERSNUMBER (Person number), DATE_FROM (Valid-from date - in current Release only 00010101 possible).. 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. .
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 ADCPS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
TRKORR | Request/Task | TRKORR | CHAR | 20 | Assigned to domain | TRKORR | |||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ADR | |
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ADRP | ALPHA | AD_PERSNUM | CDT | ADDRESS |
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | TSADV | AD_NATION | ADDRESS_NATION | ||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
COMP_PERS | Flag: Person in company (C) or private (P) address | AD_CMP_PRS | CHAR | 1 | AD_CMP_PRS | ||||
SO_KEY | SAP-Office key | AD_SO_KEY | CHAR | 10 | ALPHA | AD_SO_KEY | ADDRESS | ||
DEPARTMENT | Department | AD_DPRTMNT | CHAR | 40 | TEXT40 | ||||
FUNCTION | Function | AD_FNCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (number or code) | AD_BLDNG_P | CHAR | 10 | TEXT10 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
ID_CODE | Short name for correspondence | AD_ID_CODE | CHAR | 10 | TEXT10 | ||||
IH_MAIL | Int. mail postal code | AD_IH_MAIL | CHAR | 10 | TEXT10 | ||||
SORT1 | (Not Supported) Search Term | AD_SORTOLD | CHAR | 20 | CHAR20 | ||||
SORT2 | (Not Supported) Search Term | AD_SORTOLD | CHAR | 20 | CHAR20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ALT_COMPNY | Business address number, if different (not used) | AD_ALTCMPY | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | TSAC | AD_COMM | |||
TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | CHAR10 | ||||
FLAGCOMM2 | Flag: Telephone number(s) maintained | AD_FLGCM02 | CHAR | 1 | XFELD | ||||
FLAGCOMM3 | Flag: Fax number(s) maintained | AD_FLGCM03 | CHAR | 1 | XFELD | ||||
FLAGCOMM4 | Flag: Teletex number(s) maintained | AD_FLGCM04 | CHAR | 1 | XFELD | ||||
FLAGCOMM5 | Flag: Telex number(s) maintained | AD_FLGCM05 | CHAR | 1 | XFELD | ||||
FLAGCOMM6 | Indicator: E-Mail Address(es) Maintained | AD_FLGCM06 | CHAR | 1 | XFELD | ||||
FLAGCOMM7 | Flag: RML (remote mail) addresse(s) maintained | AD_FLGCM07 | CHAR | 1 | XFELD | ||||
FLAGCOMM8 | Flag: X.400 addresse(s) maintained | AD_FLGCM08 | CHAR | 1 | XFELD | ||||
FLAGCOMM9 | Flag: RFC destination(s) maintained | AD_FLGCM09 | CHAR | 1 | XFELD | ||||
FLAGCOMM10 | Flag: Printer maintained | AD_FLGCM10 | CHAR | 1 | XFELD | ||||
FLAGCOMM11 | Flag: SSF maintained | AD_FLGCM11 | CHAR | 1 | XFELD | ||||
FLAGCOMM12 | Flag: URI/FTP address maintained | AD_FLGCM12 | CHAR | 1 | XFELD | ||||
FLAGCOMM13 | Flag: Pager address maintained | AD_FLGCM13 | CHAR | 1 | XFELD | ||||
ADCP_UUID | UUID Used in the Address | AD_UUID | RAW | 16 | SYSUUID | ||||
UUID_BELATED | Indicator: UUID was generated later | AD_UUID_BELATED | CHAR | 1 | AD_UUID_BELATED | ||||
ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | CHAR | 1 | AD_ID_CATEGORY | ||||
ADCP_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | CHAR | 1 | AD_ERR_STATUS |
Key field | Non-key field |
How do I retrieve data from SAP table ADCPS using ABAP code
The following ABAP code Example will allow you to do a basic selection on ADCPS to SELECT all data from the tableDATA: WA_ADCPS TYPE ADCPS.
SELECT SINGLE *
FROM ADCPS
INTO CORRESPONDING FIELDS OF WA_ADCPS
WHERE...
How to access SAP table ADCPS
Within an ECC or HANA version of SAP you can also view further information about ADCPS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects