ADRP is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ADRP in SAP.
- Table description : Persons (Business Address Services)
- Module : BC-SRV-ADR
- Parent Module : BC
- Package : SZAD
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP ADRP Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| CLIENT | Client | MANDT | MANDT |
| PERSNUMBER | Person number | AD_PERSNUM | AD_PERSNUM |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATUM |
| NATION | Version ID for International Addresses | AD_NATION | AD_NATION |
| DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATUM |
| TITLE | Form-of-Address Key | AD_TITLE | AD_TITLE |
| NAME_FIRST | First name | AD_NAMEFIR | TEXT40 |
| NAME_LAST | Last name | AD_NAMELAS | TEXT40 |
| NAME2 | Name of person at birth | AD_NAME2_P | TEXT40 |
| NAMEMIDDLE | Middle name or second forename of a person | AD_NAMEMID | TEXT40 |
| NAME_LAST2 | Second surname of a person | AD_NAMLAS2 | TEXT40 |
| NAME_TEXT | Full Name of Person | AD_NAMTEXT | TEXT80 |
| CONVERTED | Status of Field 'Full Name' NAME_TEXT | AD_NAMCONV | AD_NAMCONV |
| TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | AD_TITLE1 |
| TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | AD_TITLE1 |
| PREFIX1 | Name Prefix (Key) | AD_PREFIX | AD_PREFIX |
| PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | AD_PREFIX |
| TITLE_SPPL | Name supplement, e.g. noble title (key) | AD_TITLES | AD_TITLES |
| NICKNAME | Nickname or name used | AD_NICKNAM | TEXT40 |
| INITIALS | "Middle Initial" or personal initials | AD_INITS | CHAR10 |
| NAMEFORMAT | Name format | AD_FORMAT | AD_NAMFORM |
| NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | LAND1 |
| PROFESSION | Profession | AD_PROFESS | TEXT40 |
| SEX | Gender key | AD_SEX | AD_SEX |
| LANGU | Language Key | SPRAS | SPRAS |
| PERS_GROUP | Person Group (Key) (Business Address Services) | AD_GROUP_P | AD_GROUP_P |
| FLAGGROUPS | Flag: There are other person group assignments | AD_FLGGP_P | XFELD |
| SORT1 | Search Term 1 | AD_SORT1 | CHAR20 |
| SORT2 | Search Term 2 | AD_SORT2 | CHAR20 |
| SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR20 |
| ADDR_COMP | (not used) | AD_ADDRCOM | AD_ADDRNUM |
| ADDR_PERS | (not used) | AD_ADDRPER | AD_ADDRNUM |
| FLPERSTEL | Flag: person has personal telephone numbers | AD_FLPTEL | XFELD |
| FLPERSCOMM | Flag: Person has personal comm. numbers (apart from Tel.) | AD_FLPCOMM | XFELD |
| PERSORIGIN | Personal data source (key) | AD_ORIGINP | AD_ORIGIN |
| MC_NAMEFIR | First name in upper case for search help | AD_MC_NMFI | CHAR25 |
| MC_NAMELAS | Last name in upper-case for search help | AD_MC_NMLA | CHAR25 |
| MC_NAME2 | NAME2 field in upper case for matchcode | AD_MC_NAM2 | CHAR25 |
| LANGU_CREA | Address record creation original language | AD_LANGUCR | SPRAS |
| ADRP_UUID | UUID Used in the Address | AD_UUID | SYSUUID |
| UUID_BELATED | Indicator: UUID was generated later | AD_UUID_BELATED | AD_UUID_BELATED |
| ID_CATEGORY | Category of an Address ID | AD_ID_CATEGORY | AD_ID_CATEGORY |
| ADRP_ERR_STATUS | Error Status of Address | AD_ERR_STATUS | AD_ERR_STATUS |
ADRP related tables
| Table | Note |
|---|---|
| ADCNTRYQU | Countries with active quarterly adjustment |
| ADCP | Person/Address Assignment (Business Address Services) |
| ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) |
| ADCP_UUID_INDEX | Index Table for ADCP-ADCP_UUID |
| ADDRC_DELI_SERV | Address Service Types |
| ADDRC_DELI_SERVT | Text Table for Address Delivery Service Types |
| ADOWNERREF | Temporary reference address storage - Master object (ALE) |
| ADQUINDX | INDX-type table for quarterly adjustment addresses |
| ADR10 | Printer (Business Address Services) |
| ADR10S | Shadow Table: Printer (Business Address Services) |
| ADR10S2 | Shadow Table 2: Printer (Business Address Services) |
| ADR11 | SSF (Business Address Services) |
| ADR11S | Shadow Table: SSF (Business Address Services) |
| ADR11S2 | Shadow Table 2: SSF (Business Address Services) |
| ADR12 | FTP and URL (Business Address Services) |
| ADR12S | Shadow Table: FTP and URL (Business Address Services) |
| ADR12S2 | Shadow Table 2: FTP and URL (Business Address Services) |
| ADR13 | Pager (Business Address Services) |
| ADR13S | Shadow Table: Pager (Business Address Services) |
| ADR13S2 | Shadow Table 2: Pager (Business Address Services) |