P_EmplPrivCommData

DDL: P_EMPLPRIVCOMMDATA SQL: PEMPLPRVCOMMDATA Type: view BASIC
8 Fields 1 Data Sources

P_EmplPrivCommData is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (adcp) and exposes 8 fields with key fields AddressID, Person.

Data Sources (1)

SourceAliasJoin Type
adcp root from

Annotations (3)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PEMPLPRVCOMMDATA view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AddressID adcp addrnumber Address Number
KEY Person adcp persnumber Person Number
DestinationLocationCountry
PhoneNumber
PhoneNumberExtension
MblPhoneDestinationLocCountry
MobilePhoneNumber
DefaultEmailAddress

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_EmplPrivCommData.
-- 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: PEMPLPRVCOMMDATA

CREATE VIEW P_EmplPrivCommData AS
SELECT
  root.addrnumber AS AddressID,
  root.persnumber AS Person,
  _phone[1: r3_user = '1' ].country AS DestinationLocationCountry,
  _phone[1: r3_user = '1' ].tel_number AS PhoneNumber,
  _phone[1: r3_user = '1' ].tel_extens AS PhoneNumberExtension,
  _phone[1: r3_user = '3' ].country AS MblPhoneDestinationLocCountry,
  _phone[1: r3_user = '3' ].tel_number AS MobilePhoneNumber,
  _mail[1: flgdefault = 'X'].smtp_addr AS DefaultEmailAddress
FROM adcp AS root
;

Learn More