R_ManagerWorkAssignmentVH

DDL: R_MANAGERWORKASSIGNMENTVH Type: view_entity COMPOSITE Package: ODATA_CA_BUM_WF
8 Fields 2 Associations 1 OData Services

Manager

R_ManagerWorkAssignmentVH is a Composite CDS View that provides data about "Manager" in SAP S/4HANA. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F6097A). Part of development package ODATA_CA_BUM_WF.

Associations (2)

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

Annotations (12)

NameValueLevelField
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manager view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view
ObjectModel.representativeKey WorkAssignmentExternalID view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F6097A ASQL_F6097A C2 NOT_RELEASED

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentExternalID _AssignmentKeyMap WorkAssignmentExternalID WFA Ext. ID
KEY CompanyCodeendasCompanyCode
FullName _WorkforcePersonBP BusinessPartnerFullName Broker Name
FirstName _WorkforcePersonBP FirstName First Name
LastName _WorkforcePersonBP LastName Last Name
ManagerAssignmentExternalID _AssignmentDetailsManager ManagerAssignmentExternalID
BusinessPartner _AssignmentKeyMap BusinessPartner Issuing Authority
WorkforcePersonExternalID _AssignmentKeyMap WorkforcePersonExternalID External Person 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_ManagerWorkAssignmentVH.
-- 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_ManagerWorkAssignmentVH AS
SELECT
  _AssignmentKeyMap.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  case when _AssignmentDetailsManager.CompanyCode is not initial then _AssignmentDetailsManager.CompanyCode else _AssignmentDetails.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  _WorkforcePersonBP.BusinessPartnerFullName AS FullName,
  _WorkforcePersonBP.FirstName AS FirstName,
  _WorkforcePersonBP.LastName AS LastName,
  _AssignmentDetailsManager.ManagerAssignmentExternalID AS ManagerAssignmentExternalID,
  _AssignmentKeyMap.BusinessPartner AS BusinessPartner,
  _AssignmentKeyMap.WorkforcePersonExternalID AS WorkforcePersonExternalID
LEFT OUTER JOIN I_WorkforceAssignmentDetails AS _AssignmentDetails ON _AssignmentDetails.WorkforceAssignment = _AssignmentKeyMap.WorkforceAssignment AND _AssignmentDetails.WorkforceAssignmentStatus = '1'  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartner AS _WorkforcePersonBP ON _WorkforcePersonBP.BusinessPartner = _AssignmentKeyMap.BusinessPartner  -- association [1..1]
;

Learn More