C_ProjDmndResourceContactCard

DDL: C_PROJDMNDRESOURCECONTACTCARD Type: view CONSUMPTION
8 Fields 1 Data Sources

Contact Card for Person Work Agreement

C_ProjDmndResourceContactCard is a Consumption CDS View that provides data about "Contact Card for Person Work Agreement" in SAP S/4HANA. It reads from 1 data source (I_WorkforcePerson) and exposes 8 fields with key field PersonWorkAgreement.

Data Sources (1)

SourceAliasJoin Type
I_WorkforcePerson WForcePerson inner

Annotations (15)

NameValueLevelField
EndUserText.label Contact Card for Person Work Agreement view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPDMNDRESCCARD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey PersonWorkAgreement view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Person view
UI.headerInfo.typeNamePlural Persons view
UI.headerInfo.typeImageUrl sap-icon: title: { type: #STANDARD, value: view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement
BusinessPartnerUUID I_WorkforcePerson BusinessPartnerUUID UUID
PersonFullName WAgreement PersonFullName Full Name
NormalizedPhoneNumber Phone Number
MblNormalizedPhoneNumber Mobile Phone Number
DefaultEmailAddress Default Email Address
Person I_WorkforcePerson Person Person/ Farm/ Field
_BusinessPartner I_WorkforcePerson _BusinessPartner

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 C_ProjDmndResourceContactCard.
-- 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.

CREATE VIEW C_ProjDmndResourceContactCard AS
SELECT
  cast( WAgreement.PersonWorkAgreement as tv_proj_dmnd_persno ) AS PersonWorkAgreement,
  WForcePerson.BusinessPartnerUUID AS BusinessPartnerUUID,
  WAgreement.PersonFullName AS PersonFullName,
  WForcePerson._WorkplaceAddress.NormalizedPhoneNumber AS NormalizedPhoneNumber,
  WForcePerson._WorkplaceAddress.MblNormalizedPhoneNumber AS MblNormalizedPhoneNumber,
  WForcePerson._WorkplaceAddress.DefaultEmailAddress AS DefaultEmailAddress,
  WForcePerson.Person AS Person,
  WForcePerson._BusinessPartner AS _BusinessPartner
INNER JOIN I_WorkforcePerson AS WForcePerson ON /* join condition not captured in parsed metadata */
;

Learn More