P_ContactCardPerson

DDL: P_CONTACTCARDPERSON SQL: PCONTACTCARDPERS Type: view COMPOSITE
9 Fields 1 Data Sources 4 Associations

P_ContactCardPerson is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (adrc) and exposes 9 fields with key fields AddressID, Person. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
adrc adrc from

Associations (4)

CardinalityTargetAliasCondition
[0..1] adr2 _DefaultPhoneNumber _DefaultPhoneNumber.addrnumber = $projection.AddressID and _DefaultPhoneNumber.persnumber = $projection.Person and _DefaultPhoneNumber.r3_user = '1'
[0..1] adr3 _DefaultFaxNumber _DefaultFaxNumber.addrnumber = $projection.AddressID and _DefaultFaxNumber.persnumber = $projection.Person and flgdefault = 'X'
[0..1] adr2 _DefaultMobilePhoneNumber _DefaultMobilePhoneNumber.addrnumber = $projection.AddressID and _DefaultMobilePhoneNumber.persnumber = $projection.Person and _DefaultMobilePhoneNumber.r3_user = '3'
[0..1] adr6 _DefaultEmailAddress _DefaultEmailAddress.addrnumber = $projection.AddressID and _DefaultEmailAddress.persnumber = $projection.Person and _DefaultEmailAddress.flgdefault = 'X'

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCONTACTCARDPERS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory #L view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AddressID adrc addrnumber Address Number
KEY Person adcp persnumber Person Number
FullName adrp name_text Full Name
PhoneNumber _DefaultPhoneNumber telnr_long Telephone no.
EmailAddress _DefaultEmailAddress smtp_addr E-Mail Address
JobName adcp function Unit Func.
ContactCardPictureURL
OrganizationalUnitName adcp department Department
CompanyName

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_ContactCardPerson.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PCONTACTCARDPERS

CREATE VIEW P_ContactCardPerson AS
SELECT
  adrc.addrnumber AS AddressID,
  adcp.persnumber AS Person,
  adrp.name_text AS FullName,
  _DefaultPhoneNumber.telnr_long AS PhoneNumber,
  _DefaultEmailAddress.smtp_addr AS EmailAddress,
  adcp.function AS JobName,
  '' AS ContactCardPictureURL,
  adcp.department AS OrganizationalUnitName,
  cast(substring(replace(concat(adrc.name1, concat(' &', adrc.name2)), '&', ''),1,80) as adfullname ) AS CompanyName
FROM adrc
LEFT OUTER JOIN adr2 AS _DefaultPhoneNumber ON _DefaultPhoneNumber.addrnumber = AddressID AND _DefaultPhoneNumber.persnumber = Person AND _DefaultPhoneNumber.r3_user = '1'  -- association [0..1]
LEFT OUTER JOIN adr3 AS _DefaultFaxNumber ON _DefaultFaxNumber.addrnumber = AddressID AND _DefaultFaxNumber.persnumber = Person AND flgdefault = 'X'  -- association [0..1]
LEFT OUTER JOIN adr2 AS _DefaultMobilePhoneNumber ON _DefaultMobilePhoneNumber.addrnumber = AddressID AND _DefaultMobilePhoneNumber.persnumber = Person AND _DefaultMobilePhoneNumber.r3_user = '3'  -- association [0..1]
LEFT OUTER JOIN adr6 AS _DefaultEmailAddress ON _DefaultEmailAddress.addrnumber = AddressID AND _DefaultEmailAddress.persnumber = Person AND _DefaultEmailAddress.flgdefault = 'X'  -- association [0..1]
;

Learn More