P_SpnsrdPgmWBSElmnt

DDL: P_SPNSRDPGMWBSELMNT Type: view COMPOSITE
30 Fields 1 Data Sources 2 Associations

WUSPDPGM WBS Elements

P_SpnsrdPgmWBSElmnt is a Composite CDS View that provides data about "WUSPDPGM WBS Elements" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectTask) and exposes 30 fields with key fields SpnsrdPgmWhereUsedObjType, SponsoredProgram, TaskUUID, WBSElement. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectTask I_PPM_ProjectTask from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PPM_Project _Root $projection.ProjectUUID = _Root.ProjectUUID
[1..1] I_WBSElementBasicData _PublicSectorData $projection.WBSElementInternalID = _PublicSectorData.WBSElementInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWUSPDPGMDWBS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label WUSPDPGM WBS Elements view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SpnsrdPgmWhereUsedObjType
KEY SponsoredProgram _PublicSectorData SponsoredProgram Sponsored Program
KEY TaskUUID TaskUUID
KEY WBSElement WBSElement WBS Internal ID
WBSDescription WBSDescription WBS Element Name
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectUUID ProjectUUID Project UUID
ProcessingStatus ProcessingStatus Worklist Status
Project _Root Project WBS Element
ProjectDescription _Root ProjectName Long Text
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
ProjectType _Root ProjectType Project Type
ProjectTypeName
ProcessingStatusText
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ResponsibleCostCenterName
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
_ControllingArea _ControllingArea
_ResponsibleCostCenter _ResponsibleCostCenter
_PublicSectorData _PublicSectorData
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_Root _Root

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_SpnsrdPgmWBSElmnt.
-- 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 P_SpnsrdPgmWBSElmnt AS
SELECT
  cast ('1WBS' as psm_s4c_gm_spdpgm_wu_objtypevh ) AS SpnsrdPgmWhereUsedObjType,
  _PublicSectorData.SponsoredProgram AS SponsoredProgram,
  TaskUUID,
  WBSElement,
  WBSDescription,
  WBSElementInternalID,
  ProjectUUID,
  ProcessingStatus,
  _Root.Project AS Project,
  _Root.ProjectName AS ProjectDescription,
  PlannedStartDate,
  PlannedEndDate,
  ActualStartDate,
  ActualEndDate,
  _Root.ProjectType AS ProjectType,
  _Root._ProjectType._Text[ LanguageCode = $session.system_language ].ProjectTypeName AS ProjectTypeName,
  _ProcessingStatus._Text[ Language = $session.system_language ].ProcessingStatusText AS ProcessingStatusText,
  ResponsibleCostCenter,
  _ResponsibleCostCenter._Text[ Language = $session.system_language ].CostCenterName AS ResponsibleCostCenterName,
  WBSIsStatisticalWBSElement,
  ControllingArea,
  ProfitCenter
FROM I_PPM_ProjectTask
LEFT OUTER JOIN I_PPM_Project AS _Root ON ProjectUUID = _Root.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _PublicSectorData ON WBSElementInternalID = _PublicSectorData.WBSElementInternalID  -- association [1..1]
;

Learn More