ADRP
Personen (Business Address Services)
ADRP is an SAP database table in S/4HANA. Personen (Business Address Services). It contains 45 fields. 57 CDS views read from this table.
CDS Views using this table (57)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /BSNAGT/P_ADRP | view | from | ADRP | |
| /SAM4U/BTL_L_USER | view | left_outer | User | |
| CUAN_CDS_TARGET_GROUP_SRCH | view | left_outer | Search Target Groups | |
| CUAN_ME_QR_REUSE_USED_IN | view | left_outer | Messages that use reusable blocks | |
| CUAN_ME_QR_TOOLBOX_BLOCKS | view | left_outer | Toolbox blocks in message design view | |
| CUAN_MKTPL_USR_BY_T_MBR_SEARCH | view | left_outer | Search User by Mktg Plan Team Member | |
| CUAN_MPO_CONSTRAINT_PLAN_SRCH | view | left_outer | DDL SQL View CUAN_MPO_CONS_PL | |
| CUAN_OFFER_MSG_PI_CONT_SEARCH | view | left_outer | Offer Integration in Content Studio | |
| CUAN_PRED_INITIATIVES | view | left_outer | AT_SR_INITIATIVES | |
| CUAN_PREDICTIVE_MODEL | view | left_outer | AT_SEARCH_PREDICTIVE_MODEL | |
| CUAN_PREDICTIVE_SCENARIO | view | left_outer | AT_SEARCH_PRED_SCENARIO | |
| CUAN_TG_TEAM_MEMBER_SEARCH | view | left_outer | AT_TG_TEAM_MEMBER_SEARCH | |
| CUAN_TG_WITH_NAMES_SEARCH | view | left_outer | AT_SEARCH_TARGET_GROUP_WITH_NAMES | |
| CUAN_USER_BY_INI_TEAM_MEMBER_S | view | left_outer | AT_SEARCH_USER_BY_INITIATIVE_TEAM_MEMBER | |
| cuan_user_search | view | left_outer | User Search | |
| 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 | inner | Line Item Browser: DDL Source | |
| fiscds_bkpf_usr | view | left_outer | Line Item Browser: DDL Source | |
| GEN_RESULT_SET_W_O_MEM_COUNT | view_entity | left_outer | Query Result Sets by Elements | |
| GSEG_CDS_BUILDING_BLOCK_COLD | view_entity | left_outer | Search Cold Building Blocks | |
| GSEG_CDS_BUILDING_BLOCK_SRCH | view_entity | left_outer | Search Building Blocks | |
| GSEG_CDS_SEG_MODEL_COLD | view_entity | left_outer | Search Cold Segmentation Models | |
| GSEG_CDS_SEG_MODEL_SRCH | view_entity | left_outer | Search Segmentation Models | |
| I_AddressPersonName | view_entity | from | BASIC | Person Name |
| I_AddressPersonName_2 | view_entity | right_outer | BASIC | Person Name |
| I_AddressRemark | view_entity | left_outer | Address Texts | |
| 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_FormattedNameAndAddress | view_entity | left_outer | BASIC | Address, Person and Address types |
| I_LCMPerson | view | from | BASIC | Person |
| I_Mpattachment | view | inner | BASIC | Master Project Attachment |
| 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_entity | inner | BASIC | Business User - Private View |
| P_BusinessUser | view_entity | inner | BASIC | Business User |
| P_CN_CADEPersonName | view | from | BASIC | Person Name |
| P_DDMRPController | view_entity | left_outer | BASIC | MRP Controller Details |
| P_PersonAddress | view | from | COMPOSITE | Address Info for Person |
| P_SapOfficeUserSearch | view | inner | BASIC | P_SapOfficeUserSearch |
| P_SDM_ADRP_XPCPT | view | from | BASIC | SDM View for ADRP-XPCPT |
| P_Usercontactcard_Fs | view | left_outer | BASIC | Private Factsheet - User Name |
| Rv_P_User | view | left_outer | User | |
| TSI_CONTACT_entry | view | left_outer | My Vendor Invoices: Contact | |
| v_sd_ci_item_party | view | left_outer | Customer Invoice Item Party | |
| v_sd_ci_party | view | left_outer | Party information of Customer Invoices | |
| VFCLM_BAM_DDL_BPUSERFULLNAME | view | inner | User name for Business Parnter | |
| VFCLM_BAM_DDL_USERFULLNAME | view | left_outer | User full name view |
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 |