I_EngmntProjActyRsceType

DDL: I_ENGMNTPROJACTYRSCETYPE Type: view COMPOSITE
9 Fields 2 Data Sources 2 Associations

Engmnt Project Resource, Type and Description

I_EngmntProjActyRsceType is a Composite CDS View that provides data about "Engmnt Project Resource, Type and Description" in SAP S/4HANA. It reads from 2 data sources (P_EngmntProjCCActivityType, I_EngmntProjRsceType) and exposes 9 fields with key fields EngagementProjectResourceType, EngagementProjectResource, ResourceType, ActivityType. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_EngmntProjCCActivityType CCActivityType left_outer
I_EngmntProjRsceType ResourceType from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CostCenterActivityTypeText _Text CCActivityType.ControllingArea = _Text.ControllingArea and ResourceType.EngagementProjectResource = _Text.CostCtrActivityType and _Text.ValidityEndDate >= $session.system_date and _Text.ValidityStartDate <= $session.system_date and _Text.Language = $session.system_language
[0..1] I_EngmtProjExpenseTypeText _ExpenseText _ExpenseText.EngagementProjectExpenseType = ResourceType.EngagementProjectResource and _ExpenseText.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPROJACTYRSCTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey EngagementProjectResource view
EndUserText.label Engmnt Project Resource, Type and Description view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectResourceType I_EngmntProjRsceType EngagementProjectResourceType ResourceTypeID
KEY EngagementProjectResource I_EngmntProjRsceType EngagementProjectResource Resource ID
KEY ResourceType I_EngmntProjRsceType EngagementProjectResourceType ResourceTypeID
KEY ActivityType I_EngmntProjRsceType EngagementProjectResource Resource ID
ControllingArea P_EngmntProjCCActivityType ControllingArea Controlling Area
CostCtrActivityTypeQtyUnit P_EngmntProjCCActivityType CostCtrActivityTypeQtyUnit
_Text _Text
_UnitOfMeasure _UnitOfMeasure
_ControllingArea P_EngmntProjCCActivityType _ControllingArea

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_EngmntProjActyRsceType.
-- 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_EngmntProjActyRsceType AS
SELECT
  ResourceType.EngagementProjectResourceType AS EngagementProjectResourceType,
  ResourceType.EngagementProjectResource AS EngagementProjectResource,
  ResourceType.EngagementProjectResourceType AS ResourceType,
  ResourceType.EngagementProjectResource AS ActivityType,
  CCActivityType.ControllingArea AS ControllingArea,
  CCActivityType.CostCtrActivityTypeQtyUnit AS CostCtrActivityTypeQtyUnit,
  CCActivityType._ControllingArea AS _ControllingArea
FROM I_EngmntProjRsceType AS ResourceType
LEFT OUTER JOIN P_EngmntProjCCActivityType AS CCActivityType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _Text ON CCActivityType.ControllingArea = _Text.ControllingArea AND ResourceType.EngagementProjectResource = _Text.CostCtrActivityType AND _Text.ValidityEndDate >= $session.system_date AND _Text.ValidityStartDate <= $session.system_date AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EngmtProjExpenseTypeText AS _ExpenseText ON _ExpenseText.EngagementProjectExpenseType = ResourceType.EngagementProjectResource AND _ExpenseText.Language = $session.system_language  -- association [0..1]
;

Learn More