Deprecated
This CDS view is deprecated in S/4HANA. Use I_EngagementProject instead. View all deprecated CDS views →

C_EngmntProjectIDGenerate

DDL: C_ENGMNTPROJECTIDGENERATE SQL: CENGPROJIDGEN Type: view CONSUMPTION

Consumption View For Generating Enagagement Project ID

C_EngmntProjectIDGenerate (Consumption)

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

R&D Engineering

C_EngmntProjectIDGenerate is a Consumption CDS View that provides data about "Consumption View For Generating Enagagement Project ID" in SAP S/4HANA. It reads from 1 data source (I_EngagementProject) and exposes 9 fields with key field EngagementProject.

SAP API Hub

StateDeprecated
Line of BusinessR&D Engineering
Application ComponentCA-CPD-SS
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_EngagementProject EngagementProject from

Annotations (12)

NameValueLevelField
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName CENGPROJIDGEN view
EndUserText.label Consumption View For Generating Enagagement Project ID view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_EngagementProject view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject I_EngagementProject EngagementProject Engagement Project ID
EngagementProjectName I_EngagementProject EngagementProjectName Customer Project Name
EngagementProjectServiceOrg I_EngagementProject EngagementProjectServiceOrg Service Organization
EngmtProjectServiceOrgName Description of Organization Unit ID
EngagementProjectCategory I_EngagementProject EngagementProjectCategory Project Type
EngagementProjectType I_EngagementProject EngagementProjectType Engagement Project Type
Customer I_EngagementProject Customer Customer Number
CustomerName _Customer CustomerName Name of Customer
_Customer _Customer

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 C_EngmntProjectIDGenerate.
-- 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: CENGPROJIDGEN

CREATE VIEW C_EngmntProjectIDGenerate AS
SELECT
  EngagementProject.EngagementProject AS EngagementProject,
  EngagementProject.EngagementProjectName AS EngagementProjectName,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  _EngagementProjectServiceOrg._Text[1:Language = $session.system_language].EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  EngagementProject.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProject.EngagementProjectType AS EngagementProjectType,
  EngagementProject.Customer AS Customer,
  _Customer.CustomerName AS CustomerName
FROM I_EngagementProject AS EngagementProject
;