C_WrkCtrObjPgPlannedOrd

DDL: C_WRKCTROBJPGPLANNEDORD Type: view_entity CONSUMPTION
23 Fields 1 Data Sources 1 Associations

Work Center Object Page Planned Orders

C_WrkCtrObjPgPlannedOrd is a Consumption CDS View that provides data about "Work Center 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.

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 Work Center 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

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_WrkCtrObjPgPlannedOrd.
-- 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_WrkCtrObjPgPlannedOrd 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