I_PrjPrtfloItemCapPlanData

DDL: I_PRJPRTFLOITEMCAPPLANDATA Type: view_entity BASIC
22 Fields 3 Data Sources 1 Associations

Prj Prtflo Cap Plan Data for Item

I_PrjPrtfloItemCapPlanData (Basic)

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

PrjPrtfloItemCapacityPlanning · R&D Engineering

I_PrjPrtfloItemCapPlanData is a Basic CDS View (Fact) that provides data about "Prj Prtflo Cap Plan Data for Item" in SAP S/4HANA. It reads from 3 data sources (I_PrjPrtfloItmCapCategory, I_PrjPrtfloItmCapacityGroup, I_PrjPrtfloItemCapacityPlan) and exposes 22 fields with key fields PrjPrtfloItmCapacityPlanUUID, PrjPrtfloItmCapacityPlanType, FiscalYear, FiscalPeriod, PrjPrtfloItmCapPlnCategoryUUID. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Portfolio Management
Data CategoryFact
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: What is the relevant capacity planning data per period for selected Project Portfolio Item(s)? Customizing Project Portfolio Financial View

Structure
Measures and Attributes Some important attributes are PrjPrtfloItmCapacityPlanUUID, PrjPrtfloItmCapacityPlanType, PrjPrtfloItmCapPlanPeriodDate, PrjPrtfloItmCapPlnCategoryUUID including other entity related information such as PrjPrtfloItmCapPlnCategoryId, PrjPrtfloItmCapacityPlanAmount, ProjectPortfolioItemUUID, etc.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPPM-PFM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source for Data Extraction
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (3)

SourceAliasJoin Type
I_PrjPrtfloItmCapCategory ItemCapacityCategory inner
I_PrjPrtfloItmCapacityGroup ItemCapacityGroup inner
I_PrjPrtfloItemCapacityPlan ItemCapacityPlan from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PrjPrtfloItemCapacityGroup _Extension $projection.PrjPrtfloItmCapacityPlanUUID = _Extension.PrjPrtfloItmCapPlanGroupUUID

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Prj Prtflo Cap Plan Data for Item view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PrjPrtfloItemCapacityPlanning view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PrjPrtfloItmCapacityPlanUUID I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapacityPlanUUID Guid for application objects
KEY PrjPrtfloItmCapacityPlanType I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapacityPlanType Capacity View Type
KEY FiscalYear I_PrjPrtfloItemCapacityPlan FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_PrjPrtfloItemCapacityPlan FiscalPeriod Fiscal Period
KEY PrjPrtfloItmCapPlnCategoryUUID I_PrjPrtfloItmCapCategory PrjPrtfloItmCapPlnCategoryUUID Guid for application objects
PrjPrtfloItmCapPlanPeriodDate I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapPlanPeriodDate Tax Period
PrjPrtfloItmCapPlnChgdDateTime I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapPlnChgdDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
PrjPrtfloItmCapPlnChangedBy I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapPlnChangedBy Last Changed By
PrjPrtfloItmCapacityPlanAmount I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapacityPlanAmount Capacity Amount
PrjPrtfloItmCapacityPlanUnit I_PrjPrtfloItemCapacityPlan PrjPrtfloItmCapacityPlanUnit Capacity Unit
PrjPrtfloItmCapPlnCategoryId I_PrjPrtfloItmCapCategory PrjPrtfloItmCapPlnCategoryId Violation Category
PrjPrtfloItmCapPlnCatParUUID I_PrjPrtfloItmCapCategory PrjPrtfloItmCapPlnCatParUUID Guid for application objects
PrjPrtfloItmCapPlnCatIsActive I_PrjPrtfloItmCapCategory PrjPrtfloItmCapPlnCatIsActive Usage Active
PrjPrtfloItmCapPlnCatIsOrigl I_PrjPrtfloItmCapCategory PrjPrtfloItmCapPlnCatIsOrigl Original flag
ProjectPortfolioItemUUID I_PrjPrtfloItmCapCategory PrjPrtfloItmCapPlnCatParUUID Guid for application objects
PrjPrtfloItmCapPlnGroupId I_PrjPrtfloItmCapacityGroup PrjPrtfloItmCapPlnGroupId UUID
PrjPrtfloItmCapPlnGrpSponsor I_PrjPrtfloItmCapacityGroup PrjPrtfloItmCapPlnGrpSponsor Sponsor
PrjPrtfloItmCapPlnGrpParUUID I_PrjPrtfloItmCapacityGroup PrjPrtfloItmCapPlnGrpParUUID Guid for application objects
PrjPrtfloItmCapPlanGrpIsActive I_PrjPrtfloItmCapacityGroup PrjPrtfloItmCapPlanGrpIsActive Usage Active
PrjPrtfloItmCapPlnGrpIsOrigl I_PrjPrtfloItmCapacityGroup PrjPrtfloItmCapPlnGrpIsOrigl Original flag
ProjectPortfolioUUID _Item ProjectPortfolioUUID Guid for application objects
_Item _Item

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_PrjPrtfloItemCapPlanData.
-- 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_PrjPrtfloItemCapPlanData AS
SELECT
  ItemCapacityPlan.PrjPrtfloItmCapacityPlanUUID AS PrjPrtfloItmCapacityPlanUUID,
  ItemCapacityPlan.PrjPrtfloItmCapacityPlanType AS PrjPrtfloItmCapacityPlanType,
  ItemCapacityPlan.FiscalYear AS FiscalYear,
  ItemCapacityPlan.FiscalPeriod AS FiscalPeriod,
  ItemCapacityCategory.PrjPrtfloItmCapPlnCategoryUUID AS PrjPrtfloItmCapPlnCategoryUUID,
  ItemCapacityPlan.PrjPrtfloItmCapPlanPeriodDate AS PrjPrtfloItmCapPlanPeriodDate,
  ItemCapacityPlan.PrjPrtfloItmCapPlnChgdDateTime AS PrjPrtfloItmCapPlnChgdDateTime,
  ItemCapacityPlan.PrjPrtfloItmCapPlnChangedBy AS PrjPrtfloItmCapPlnChangedBy,
  ItemCapacityPlan.PrjPrtfloItmCapacityPlanAmount AS PrjPrtfloItmCapacityPlanAmount,
  ItemCapacityPlan.PrjPrtfloItmCapacityPlanUnit AS PrjPrtfloItmCapacityPlanUnit,
  ItemCapacityCategory.PrjPrtfloItmCapPlnCategoryId AS PrjPrtfloItmCapPlnCategoryId,
  ItemCapacityCategory.PrjPrtfloItmCapPlnCatParUUID AS PrjPrtfloItmCapPlnCatParUUID,
  ItemCapacityCategory.PrjPrtfloItmCapPlnCatIsActive AS PrjPrtfloItmCapPlnCatIsActive,
  ItemCapacityCategory.PrjPrtfloItmCapPlnCatIsOrigl AS PrjPrtfloItmCapPlnCatIsOrigl,
  ItemCapacityCategory.PrjPrtfloItmCapPlnCatParUUID AS ProjectPortfolioItemUUID,
  ItemCapacityGroup.PrjPrtfloItmCapPlnGroupId AS PrjPrtfloItmCapPlnGroupId,
  ItemCapacityGroup.PrjPrtfloItmCapPlnGrpSponsor AS PrjPrtfloItmCapPlnGrpSponsor,
  ItemCapacityGroup.PrjPrtfloItmCapPlnGrpParUUID AS PrjPrtfloItmCapPlnGrpParUUID,
  ItemCapacityGroup.PrjPrtfloItmCapPlanGrpIsActive AS PrjPrtfloItmCapPlanGrpIsActive,
  ItemCapacityGroup.PrjPrtfloItmCapPlnGrpIsOrigl AS PrjPrtfloItmCapPlnGrpIsOrigl,
  _Item.ProjectPortfolioUUID AS ProjectPortfolioUUID
FROM I_PrjPrtfloItemCapacityPlan AS ItemCapacityPlan
INNER JOIN I_PrjPrtfloItmCapacityGroup AS ItemCapacityGroup ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrjPrtfloItmCapCategory AS ItemCapacityCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_PrjPrtfloItemCapacityGroup AS _Extension ON PrjPrtfloItmCapacityPlanUUID = _Extension.PrjPrtfloItmCapPlanGroupUUID  -- association [1..1]
;

Learn More