I_EngmntProjResourceType

DDL: I_ENGMNTPROJRESOURCETYPE SQL: IEPRESTYPE Type: view BASIC Package: CPD_CDS
2 Fields 1 Data Sources 1 Associations

Resource Type in Engagement Project

I_EngmntProjResourceType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Engagement Project Resource Type · R&D Engineering

I_EngmntProjResourceType is a Basic CDS View (Dimension) that provides data about "Resource Type in Engagement Project" in SAP S/4HANA. It reads from 1 data source (/cpd/fc_rty) and exposes 2 fields with key field EngagementProjectResourceType. It has 1 association to related views. Part of development package CPD_CDS.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessR&D Engineering
Application ComponentCA-CPD-SS
CapabilitiesData Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageR&D/Engineering for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are the resource types that I can use to plan customer or internal projects?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
/cpd/fc_rty /cpd/fc_rty from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EngmntProjResourceTypeText _Text $projection.EngagementProjectResourceType = _Text.EngagementProjectResourceType

Annotations (17)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IEPRESTYPE view
EndUserText.label Resource Type in Engagement Project view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey EngagementProjectResourceType view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name EngagementProjectResourceType view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 000 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectResourceType /cpd/fc_rty res_type_id Resource Type ID
_Text _Text

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_EngmntProjResourceType.
-- 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.
-- SQL view name: IEPRESTYPE

CREATE VIEW I_EngmntProjResourceType AS
SELECT
  /cpd/fc_rty.res_type_id AS EngagementProjectResourceType
FROM /cpd/fc_rty
LEFT OUTER JOIN I_EngmntProjResourceTypeText AS _Text ON EngagementProjectResourceType = _Text.EngagementProjectResourceType  -- association [0..*]
;

Learn More