ADRP
Persons (Business Address Services)
ADRP is an SAP database table in S/4HANA. Persons (Business Address Services). It contains 45 fields. 45 CDS views read from this table.
CDS Views using this table (45)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BSNAGT/P_ADRP | view | from | ADRP | |
| /dmbe/i_User | view | from | Deal User | |
| ESH_LIMITATIONS_GRPBY | view | from | View with group by | |
| ESH_N_USER_USER_NAME | view | from | User Name | |
| FACVD_CLRIT_05 | view | left_outer | Open items of incoming payment for manual clearing | |
| FACVD_CLRIT_06 | view | left_outer | Open items of outgoing payment for manual clearing | |
| fiscds_bkpf_usr | view | left_outer | Line Item Browser: DDL Source | |
| fiscds_bkpf_usr | view | inner | Line Item Browser: DDL Source | |
| I_AddressPersonName | view_entity | from | BASIC | Person Name |
| I_BPRelshpCntctPersnAddrVersTP | view_entity | left_outer | TRANSACTIONAL | RAP BO Contact Person Address Versions |
| I_BusPartPersonFullName | view | from | BASIC | Person data of business partner |
| I_CmmdtyDrvtvOrderUserDetails | view | left_outer | BASIC | Basic View for User Details |
| I_ContactPerson | view | left_outer | BASIC | Contact Person |
| I_DocumentInfoRecordUserVH | view | inner | COMPOSITE | Document Info Record User |
| I_LCMPerson | view | from | BASIC | Person |
| I_Mpattachment | view | inner | BASIC | Master Project Attachment |
| I_NominationScheduleUserText | view | left_outer | BASIC | Trip created by user value help |
| I_PrmtHbCreatorContactCard | view | inner | BASIC | Creator Data for Contact Card |
| I_SADL_GW_CPLUSER | view | inner | User details in system | |
| I_ScriptedAddress | view | left_outer | BASIC | Interational Address Version |
| I_ScriptedPersonAddress | view | from | BASIC | Interational Address Version for Persons |
| I_UserDescription | view | left_outer | BASIC | Beschreibung |
| m_v_m2s_pd_itm | view | left_outer | View for Purchasing Document Item | |
| m_v_m2s_pr_itm | view | left_outer | CDS View for Purchase Requisition | |
| P_BPUsrPerson | view | inner | BASIC | Business User - Private View |
| P_BusinessUser | view | inner | BASIC | Business User |
| P_CN_CADEPersonName | view | from | BASIC | |
| P_DDMRPController | view | left_outer | BASIC | |
| P_ON_DEMAND_PRICE_ORDER | view | left_outer | BASIC | |
| P_PersonAddress | view | from | COMPOSITE | |
| P_REASON_CODE_TRACE | view | left_outer | BASIC | |
| P_SapOfficeUserSearch | view | inner | BASIC | |
| P_SDM_ADRP_XPCPT | view | from | BASIC | SDM View for ADRP-XPCPT |
| P_Usercontactcard_Fs | view | left_outer | BASIC | |
| Rv_P_User | view | left_outer | ||
| TSI_CONTACT_entry | view | left_outer | ||
| v_sd_ci_item_party | view | left_outer | ||
| v_sd_ci_party | view | left_outer | ||
| VFCLM_BAM_DDL_BPUSERFULLNAME | view | inner | User name for Business Parnter | |
| VFCLM_BAM_DDL_USERFULLNAME | view | left_outer | User full name view | |
| VFCP_DDL_BCM | view | left_outer | ||
| VFCP_DDL_FI | view | left_outer | ||
| VFCP_DDL_MEMO | view | left_outer | ||
| VFCP_DDL_MEMO_BASE | view | left_outer | ||
| VFCP_DDL_TRM | view | left_outer |
Fields (45)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | MANDT | |
| KEY | persnumber | AD_PERSNUM | |
| KEY | date_from | AD_DATE_FR | |
| KEY | nation | AD_NATION | |
| date_to | AD_DATE_TO | ||
| title | AD_TITLE | ||
| name_first | AD_NAMEFIR | ||
| name_last | AD_NAMELAS | ||
| name2 | AD_NAME2_P | ||
| namemiddle | AD_NAMEMID | ||
| name_last2 | AD_NAMLAS2 | ||
| name_text | AD_NAMTEXT | ||
| converted | AD_NAMCONV | ||
| title_aca1 | AD_TITLE1 | ||
| title_aca2 | AD_TITLE2 | ||
| prefix1 | AD_PREFIX | ||
| prefix2 | AD_PREFIX2 | ||
| title_sppl | AD_TITLES | ||
| nickname | AD_NICKNAM | ||
| initials | AD_INITS | ||
| nameformat | AD_FORMAT | ||
| namcountry | AD_NAMCTRY | ||
| profession | AD_PROFESS | ||
| sex | AD_SEX | ||
| langu | SPRAS | ||
| pers_group | AD_GROUP_P | ||
| flaggroups | AD_FLGGP_P | ||
| sort1 | AD_SORT1 | ||
| sort2 | AD_SORT2 | ||
| sort_phn | AD_SRTPHN | ||
| addr_comp | AD_ADDRCOM | ||
| addr_pers | AD_ADDRPER | ||
| flperstel | AD_FLPTEL | ||
| flperscomm | AD_FLPCOMM | ||
| persorigin | AD_ORIGINP | ||
| mc_namefir | AD_MC_NMFI | ||
| mc_namelas | AD_MC_NMLA | ||
| mc_name2 | AD_MC_NAM2 | ||
| langu_crea | AD_LANGUCR | ||
| adrp_uuid | AD_UUID | ||
| uuid_belated | AD_UUID_BELATED | ||
| id_category | AD_ID_CATEGORY | ||
| adrp_err_status | AD_ERR_STATUS | ||
| _dataaging | DATA_TEMPERATURE | ||
| xpcpt | AD_XPCPT |