R_ManagerContactCard_1

DDL: R_MANAGERCONTACTCARD_1 Type: view_entity COMPOSITE Package: WFD_WORKER_FACTSHEET_BL
10 Fields 2 Data Sources 1 Associations

Manager Details

R_ManagerContactCard_1 is a Composite CDS View that provides data about "Manager Details" in SAP S/4HANA. It reads from 2 data sources (R_WorkAssignmentBP, I_BusinessPartner) and exposes 10 fields with key field ManagerAssignmentExternalID. It has 1 association to related views. Part of development package WFD_WORKER_FACTSHEET_BL.

Data Sources (2)

SourceAliasJoin Type
R_WorkAssignmentBP _BuPaIdentification inner
I_BusinessPartner _WorkAssignmentBP inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _PersonUUID _PersonUUID.BusinessPartner = _AssignmentKeyMap.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Manager Details view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ManagerAssignmentExternalID _AssignmentKeyMap WorkforcePersonUserID User ID
FullName I_BusinessPartner BusinessPartnerFullName Broker Name
FirstName I_BusinessPartner FirstName First Name
LastName I_BusinessPartner LastName Last Name
EmailAddress _WorkplaceAddress DefaultEmailAddress
MobilePhoneNumber _WorkplaceAddress MobilePhoneNumber Telephone
PhoneNumber _WorkplaceAddress PhoneNumber Telephone no.
WorkforcePersonExternalID _AssignmentKeyMap WorkforcePersonExternalID External Person ID
WorkAssignment _AssignmentKeyMap WorkforceAssignment WorkForce Assgmt ID
PersonUUID _PersonUUID BusinessPartnerUUID UUID

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 R_ManagerContactCard_1.
-- 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 R_ManagerContactCard_1 AS
SELECT
  _AssignmentKeyMap.WorkforcePersonUserID AS ManagerAssignmentExternalID,
  _WorkAssignmentBP.BusinessPartnerFullName AS FullName,
  _WorkAssignmentBP.FirstName AS FirstName,
  _WorkAssignmentBP.LastName AS LastName,
  _WorkplaceAddress.DefaultEmailAddress AS EmailAddress,
  _WorkplaceAddress.MobilePhoneNumber AS MobilePhoneNumber,
  _WorkplaceAddress.PhoneNumber AS PhoneNumber,
  _AssignmentKeyMap.WorkforcePersonExternalID AS WorkforcePersonExternalID,
  _AssignmentKeyMap.WorkforceAssignment AS WorkAssignment,
  _PersonUUID.BusinessPartnerUUID AS PersonUUID
INNER JOIN R_WorkAssignmentBP AS _BuPaIdentification ON /* join condition not captured in parsed metadata */
INNER JOIN I_BusinessPartner AS _WorkAssignmentBP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _PersonUUID ON _PersonUUID.BusinessPartner = _AssignmentKeyMap.BusinessPartner  -- association [1..1]
;

Learn More