P_EngmntProjSupEmplDelivOrg

DDL: P_ENGMNTPROJSUPEMPLDELIVORG SQL: PEPSUPEMPDELORG Type: view COMPOSITE
25 Fields 1 Data Sources

P_EngmntProjSupEmplDelivOrg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectPlnDataVersion) and exposes 25 fields.

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectPlnDataVersion B inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PEPSUPEMPDELORG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (25)

KeyFieldSource TableSource FieldDescription
EngagementProject I_EngmntProjectPlnDataVersion EngagementProject Engmnt Project ID
WorkPackage I_EngmntProjectPlnDataVersion WorkPackage Plan Item
ResourceDemandUUID I_EngmntProjectPlnDataVersion ResourceDemandUUID Demand Key
ResourceDemand I_EngmntProjectPlnDataVersion ResourceDemand Resource Demand
EngmtProjFinPlanVersion I_EngmntProjectPlnDataVersion EngmtProjFinPlanVersion Plan Version ID
EngagementProjectServiceOrg I_EngmntProjectPlnDataVersion EngagementProjectServiceOrg Service Org.
CustomerProjectServiceOrg A EngagementProjectServiceOrg Service Org.
IsMyProject A IsMyProject
EngmntProjReviewYearPeriod A EngmntProjReviewYearPeriod
EngagementProjectReviewStatus A EngagementProjectReviewStatus
ProjectManagerExternalID A ProjectManagerExternalID
ProjectAccountantExternalID A ProjectAccountantExternalID
ProjectControllerExternalID A ProjectControllerExternalID
ProjectPartnerExternalID A ProjectPartnerExternalID
EngagementProjectCategory A EngagementProjectCategory
EngagementProjectType A EngagementProjectType
Customer A Customer Sold-to Party
ProjectVisibility A ProjectVisibility
EngagementProjectStage A EngagementProjectStage
EngagementProjectCostCenter A EngagementProjectCostCenter
EngmntProjectHeaderCompanyCode A EngmntProjectHeaderCompanyCode
ProfitCenter A ProfitCenter Profit Center
ProjectProfileCode A ProjectProfileCode Project Profile
ControllingArea A ControllingArea Controlling Area
LastChangeDateTime A LastChangeDateTime Timestamp

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 P_EngmntProjSupEmplDelivOrg.
-- 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: PEPSUPEMPDELORG

CREATE VIEW P_EngmntProjSupEmplDelivOrg AS
SELECT
  B.EngagementProject AS EngagementProject,
  B.WorkPackage AS WorkPackage,
  B.ResourceDemandUUID AS ResourceDemandUUID,
  B.ResourceDemand AS ResourceDemand,
  B.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  B.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  A.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  A.IsMyProject AS IsMyProject,
  A.EngmntProjReviewYearPeriod AS EngmntProjReviewYearPeriod,
  A.EngagementProjectReviewStatus AS EngagementProjectReviewStatus,
  A.ProjectManagerExternalID AS ProjectManagerExternalID,
  A.ProjectAccountantExternalID AS ProjectAccountantExternalID,
  A.ProjectControllerExternalID AS ProjectControllerExternalID,
  A.ProjectPartnerExternalID AS ProjectPartnerExternalID,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectType AS EngagementProjectType,
  A.Customer AS Customer,
  A.ProjectVisibility AS ProjectVisibility,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.ProfitCenter AS ProfitCenter,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.ControllingArea AS ControllingArea,
  A.LastChangeDateTime AS LastChangeDateTime
INNER JOIN I_EngmntProjectPlnDataVersion AS B ON /* join condition not captured in parsed metadata */
;

Learn More