ADRP

Transparent Table Application Table
45 Fields 60 CDS Views

Persons (Business Address Services)

ADRP is an SAP database table in S/4HANA. Persons (Business Address Services). It contains 45 fields. 60 CDS views read from this table.

CDS Views using this table (60)

ViewTypeJoinVDMDescription
/BSNAGT/P_ADRP view from ADRP
/dmbe/i_User view from Deal User
/SAM4U/BTL_L_USER view left_outer User
CUAN_ME_QR_REUSE_USED_IN view_entity left_outer Messages That Use Reusable Blocks
CUAN_ME_QR_TOOLBOX_BLOCKS view_entity left_outer Toolbox Blocks in Message Design View
CUAN_TG_WITH_NAMES_SEARCH view_entity left_outer AT_SEARCH_TARGET_GROUP_WITH_NAMES
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
hrpy_pcc_activity view_entity left_outer Payroll Activities
HRPY_PCC_recurrence view left_outer Recurrence Data
HRPY_PCC_step view_entity left_outer Step Recurrence
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_addressremark_copy 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_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_PMContactPerson view_entity inner BASIC Plant Maintenance Contact Person
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
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)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY persnumber AD_PERSNUM Person Number
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
date_to AD_DATE_TO To
title AD_TITLE Title Key
name_first AD_NAMEFIR First Name
name_last AD_NAMELAS Last Name
name2 AD_NAME2_P Name at Birth
namemiddle AD_NAMEMID 2nd First Name
name_last2 AD_NAMLAS2 2nd Family Name
name_text AD_NAMTEXT Full Name
converted AD_NAMCONV Converted
title_aca1 AD_TITLE1 Academic Title
title_aca2 AD_TITLE2 2nd Academic
prefix1 AD_PREFIX Prefix Key
prefix2 AD_PREFIX2 2nd prefix
title_sppl AD_TITLES Name Supplement
nickname AD_NICKNAM Nickname
initials AD_INITS Initials
nameformat AD_FORMAT Name Format
namcountry AD_NAMCTRY Country/Region
profession AD_PROFESS Profession
sex AD_SEX Gender
langu SPRAS Language
pers_group AD_GROUP_P Person group
flaggroups AD_FLGGP_P Flag: There are other person group assignments
sort1 AD_SORT1 Search Term 1
sort2 AD_SORT2 Search Term 2
sort_phn AD_SRTPHN Phonet. Sort.
addr_comp AD_ADDRCOM 1st Cmpny. Addr
addr_pers AD_ADDRPER 1st Pers. Addr.
flperstel AD_FLPTEL Pers. telephone
flperscomm AD_FLPCOMM Pers.comm.no.
persorigin AD_ORIGINP Personal source
mc_namefir AD_MC_NMFI First Name
mc_namelas AD_MC_NMLA Last Name
mc_name2 AD_MC_NAM2 Name at Birth
langu_crea AD_LANGUCR Creation lang.
adrp_uuid AD_UUID Address UUID
uuid_belated AD_UUID_BELATED Subsequent UUID
id_category AD_ID_CATEGORY ID Category
adrp_err_status AD_ERR_STATUS Error Status
_dataaging DATA_TEMPERATURE Data Aging
xpcpt AD_XPCPT PurposeComplete Flag

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Persons (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADRP (
    CLIENT,           -- Client [MANDT]
    PERSNUMBER,       -- Person Number [AD_PERSNUM]
    DATE_FROM,        -- From [AD_DATE_FR]
    NATION,           -- Address Version [AD_NATION]
    DATE_TO,          -- To [AD_DATE_TO]
    TITLE,            -- Title Key [AD_TITLE]
    NAME_FIRST,       -- First Name [AD_NAMEFIR]
    NAME_LAST,        -- Last Name [AD_NAMELAS]
    NAME2,            -- Name at Birth [AD_NAME2_P]
    NAMEMIDDLE,       -- 2nd First Name [AD_NAMEMID]
    NAME_LAST2,       -- 2nd Family Name [AD_NAMLAS2]
    NAME_TEXT,        -- Full Name [AD_NAMTEXT]
    CONVERTED,        -- Converted [AD_NAMCONV]
    TITLE_ACA1,       -- Academic Title [AD_TITLE1]
    TITLE_ACA2,       -- 2nd Academic [AD_TITLE2]
    PREFIX1,          -- Prefix Key [AD_PREFIX]
    PREFIX2,          -- 2nd prefix [AD_PREFIX2]
    TITLE_SPPL,       -- Name Supplement [AD_TITLES]
    NICKNAME,         -- Nickname [AD_NICKNAM]
    INITIALS,         -- Initials [AD_INITS]
    NAMEFORMAT,       -- Name Format [AD_FORMAT]
    NAMCOUNTRY,       -- Country/Region [AD_NAMCTRY]
    PROFESSION,       -- Profession [AD_PROFESS]
    SEX,              -- Gender [AD_SEX]
    LANGU,            -- Language [SPRAS]
    PERS_GROUP,       -- Person group [AD_GROUP_P]
    FLAGGROUPS,       -- Flag: There are other person group assignments [AD_FLGGP_P]
    SORT1,            -- Search Term 1 [AD_SORT1]
    SORT2,            -- Search Term 2 [AD_SORT2]
    SORT_PHN,         -- Phonet. Sort. [AD_SRTPHN]
    ADDR_COMP,        -- 1st Cmpny. Addr [AD_ADDRCOM]
    ADDR_PERS,        -- 1st Pers. Addr. [AD_ADDRPER]
    FLPERSTEL,        -- Pers. telephone [AD_FLPTEL]
    FLPERSCOMM,       -- Pers.comm.no. [AD_FLPCOMM]
    PERSORIGIN,       -- Personal source [AD_ORIGINP]
    MC_NAMEFIR,       -- First Name [AD_MC_NMFI]
    MC_NAMELAS,       -- Last Name [AD_MC_NMLA]
    MC_NAME2,         -- Name at Birth [AD_MC_NAM2]
    LANGU_CREA,       -- Creation lang. [AD_LANGUCR]
    ADRP_UUID,        -- Address UUID [AD_UUID]
    UUID_BELATED,     -- Subsequent UUID [AD_UUID_BELATED]
    ID_CATEGORY,      -- ID Category [AD_ID_CATEGORY]
    ADRP_ERR_STATUS,  -- Error Status [AD_ERR_STATUS]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    XPCPT,            -- PurposeComplete Flag [AD_XPCPT]
    PRIMARY KEY (CLIENT, PERSNUMBER, DATE_FROM, NATION)
);

Learn More