R_ManagerContactCard

DDL: R_MANAGERCONTACTCARD Type: view_entity COMPOSITE Package: ODATA_CA_BUM_WF
9 Fields 2 Data Sources 1 Associations 2 OData Services

Manager Details

R_ManagerContactCard 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 9 fields with key fields ManagerAssignmentExternalID, CompanyCodeendasCompanyCode. It has 1 association to related views. It is exposed through 2 OData services (UI_WORKER_FACTSHEET, UI_WORKFORCE_MANAGE). Part of development package ODATA_CA_BUM_WF.

Data Sources (2)

SourceAliasJoin Type
R_WorkAssignmentBP _BuPaIdentification inner
I_BusinessPartner _WorkAssignmentBP inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_WorkforceAssignmentDetails _AssignmentDetails _AssignmentDetails.WorkforceAssignment = _AssignmentKeyMap.WorkforceAssignment and _AssignmentDetails.WorkforceAssignmentStatus = '1'

Annotations (9)

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

OData Services (2)

ServiceBindingVersionContractRelease
UI_WORKER_FACTSHEET UI_WORKER_FACTSHEET V4 C1 NOT_RELEASED
UI_WORKFORCE_MANAGE UI_WORKFORCE_MANAGE V4 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ManagerAssignmentExternalID _AssignmentKeyMap WorkforcePersonUserID User ID
KEY CompanyCodeendasCompanyCode
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.
WorkAssignment _AssignmentKeyMap WorkforceAssignment WorkForce Assgmt ID

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.
-- 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 AS
SELECT
  _AssignmentKeyMap.WorkforcePersonUserID AS ManagerAssignmentExternalID,
  case when _AssignmentDetailsManager.CompanyCode is not initial then _AssignmentDetailsManager.CompanyCode else _AssignmentDetails.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  _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.WorkforceAssignment AS WorkAssignment
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_WorkforceAssignmentDetails AS _AssignmentDetails ON _AssignmentDetails.WorkforceAssignment = _AssignmentKeyMap.WorkforceAssignment AND _AssignmentDetails.WorkforceAssignmentStatus = '1'  -- association [1..*]
;

Learn More