I_WorkAssignmentByManager

DDL: I_WORKASSIGNMENTBYMANAGER Type: view_entity COMPOSITE Package: ODATA_HCM_CATS_REPORTING
1 Fields 2 Data Sources

Work assignments under a manager

I_WorkAssignmentByManager is a Composite CDS View that provides data about "Work assignments under a manager" in SAP S/4HANA. It reads from 2 data sources (I_WorkAssignment, I_BusinessUserBasic) and exposes 1 field with key field WorkAssignment. Part of development package ODATA_HCM_CATS_REPORTING.

Data Sources (2)

SourceAliasJoin Type
I_WorkAssignment _WorkAssignment inner
I_BusinessUserBasic BusinessUser from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Work assignments under a manager view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment _WorkAsgmtKeyMap WorkAssignment 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 I_WorkAssignmentByManager.
-- 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 I_WorkAssignmentByManager AS
SELECT
  _WorkAsgmtKeyMap.WorkAssignment AS WorkAssignment
FROM I_BusinessUserBasic AS BusinessUser
INNER JOIN I_WorkAssignment AS _WorkAssignment ON /* join condition not captured in parsed metadata */
;

Learn More