C_ProdnRsceObjPgPlannedOrder

DDL: C_PRODNRSCEOBJPGPLANNEDORDER Type: view_entity CONSUMPTION Package: ODATA_MPE_MFGORDER
23 Fields 1 Data Sources 1 Associations 1 OData Services

Resources Object Page Planned Orders

C_ProdnRsceObjPgPlannedOrder is a Consumption CDS View that provides data about "Resources Object Page Planned Orders" in SAP S/4HANA. It reads from 1 data source (I_PlannedOrderCapacity) and exposes 23 fields with key fields CapacityRequirement, CapacityRequirementItem, WorkCenterInternalID. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F2264). Part of development package ODATA_MPE_MFGORDER.

Data Sources (1)

SourceAliasJoin Type
I_PlannedOrderCapacity I_PlannedOrderCapacity from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CapacityCategoryText _Text $projection.CapacityCategory = _Text.CapacityCategoryCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Resources Object Page Planned Orders view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Planned Order view
UI.headerInfo.typeNamePlural Planned Orders view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2264 ASQL_F2264 C2 NOT_RELEASED

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CapacityRequirement CapacityRequirement
KEY CapacityRequirementItem CapacityRequirementItem
KEY WorkCenterInternalID WorkCenterInternalID Work Center
PlannedOrder PlannedOrder Planned Order
Material _PlannedOrder Material Material
MaterialName
Operation Operation Transaction
OperationText OperationText Description
OperationLatestStartDate OperationLatestStartDate
OperationLatestStartTime OperationLatestStartTime
OperationLatestEndDate OperationLatestEndDate
OperationLatestEndTime OperationLatestEndTime
OperationEarliestStartDate OperationEarliestStartDate
OperationEarliestStartTime OperationEarliestStartTime
OperationEarliestEndDate OperationEarliestEndDate
OperationEarliestEndTime OperationEarliestEndTime
ProductionVersion _PlannedOrder ProductionVersion Version ID
PlannedTotalQtyInBaseUnit _PlannedOrder PlannedTotalQtyInBaseUnit
PlannedScrapQtyInBaseUnit _PlannedOrder PlannedScrapQtyInBaseUnit
BaseUnit _PlannedOrder BaseUnit Unit of Measure
CapacityCategory CapacityCategory
_PlannedOrder _PlannedOrder
_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 C_ProdnRsceObjPgPlannedOrder.
-- 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 C_ProdnRsceObjPgPlannedOrder AS
SELECT
  CapacityRequirement,
  CapacityRequirementItem,
  WorkCenterInternalID,
  PlannedOrder,
  _PlannedOrder.Material AS Material,
  _PlannedOrder._Material._Text[1:Language=$session.system_language].MaterialName AS MaterialName,
  Operation,
  OperationText,
  OperationLatestStartDate,
  OperationLatestStartTime,
  OperationLatestEndDate,
  OperationLatestEndTime,
  OperationEarliestStartDate,
  OperationEarliestStartTime,
  OperationEarliestEndDate,
  OperationEarliestEndTime,
  _PlannedOrder.ProductionVersion AS ProductionVersion,
  _PlannedOrder.PlannedTotalQtyInBaseUnit AS PlannedTotalQtyInBaseUnit,
  _PlannedOrder.PlannedScrapQtyInBaseUnit AS PlannedScrapQtyInBaseUnit,
  _PlannedOrder.BaseUnit AS BaseUnit,
  CapacityCategory
FROM I_PlannedOrderCapacity
LEFT OUTER JOIN I_CapacityCategoryText AS _Text ON CapacityCategory = _Text.CapacityCategoryCode  -- association [0..*]
;

Learn More