P_Sched_Past_Operations

DDL: P_SCHED_PAST_OPERATIONS SQL: PSCHEDPASTOPERS Type: view COMPOSITE
19 Fields 4 Data Sources

Past orders for Deallocate action

P_Sched_Past_Operations is a Composite CDS View that provides data about "Past orders for Deallocate action" in SAP S/4HANA. It reads from 4 data sources (I_LogisticsOrder, I_SchedCapacityRqmtItemCap, I_SchedCapacityRqmtItemCap, I_PlannedOrder) and exposes 19 fields with key fields orderid, CapacityRequirementItem, CapacityRqmtItemCapacity, CapacityRequirement, CapacityRequirementItem.

Data Sources (4)

SourceAliasJoin Type
I_LogisticsOrder _Order from
I_SchedCapacityRqmtItemCap CapRqmtItmCap inner
I_SchedCapacityRqmtItemCap CapRqmtItmCap inner
I_PlannedOrder PlannedOrder union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSCHEDPASTOPERS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Past orders for Deallocate action view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY orderid
KEY CapacityRequirementItem I_SchedCapacityRqmtItemCap CapacityRequirementItem
KEY CapacityRqmtItemCapacity CapacityRqmtItemCapacity
KEY CapacityRequirement I_SchedCapacityRqmtItemCap CapacityRequirement Id number
Operation
OperationLatestStartDate OperationLatestStartDate Ltst Start Date
OperationLatestStartTime OperationLatestStartTime Ltst Start Time
OperationLatestEndDate OperationLatestEndDate Ltst End Date
OperationLatestEndTime OperationLatestEndTime Ltst End Time
KEY CapacityRequirementItem I_SchedCapacityRqmtItemCap CapacityRequirementItem
KEY OrderCategory
KEY CapacityRqmtItemCapacity I_SchedCapacityRqmtItemCap CapacityRqmtItemCapacity
KEY CapacityRequirement I_SchedCapacityRqmtItemCap CapacityRequirement Id number
Operation
OperationLatestStartDate OperationLatestStartDate Ltst Start Date
OperationLatestStartTime OperationLatestStartTime Ltst Start Time
OperationLatestEndDate OperationLatestEndDate Ltst End Date
OperationLatestEndTime OperationLatestEndTime Ltst End Time
OperationIsPhase I_SchedCapacityRqmtItemCap OperationIsPhase Phase

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_Sched_Past_Operations.
-- 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: PSCHEDPASTOPERS

CREATE VIEW P_Sched_Past_Operations AS
SELECT
  cast( _Order.OrderID as pph_cfs_ordernumber ) AS orderid,
  CapRqmtItmCap.CapacityRequirementItem AS CapacityRequirementItem,
  CapacityRqmtItemCapacity,
  CapRqmtItmCap.CapacityRequirement AS CapacityRequirement,
  cast( CapRqmtItmCap.Operation as vornr) AS Operation,
  OperationLatestStartDate,
  OperationLatestStartTime,
  OperationLatestEndDate,
  OperationLatestEndTime,
  cast(PlannedOrder.PlannedOrderCategory as pph_cfs_sch_ordercategory) AS OrderCategory,
  CapRqmtItmCap.OperationIsPhase AS OperationIsPhase
FROM I_LogisticsOrder AS _Order
INNER JOIN I_SchedCapacityRqmtItemCap AS CapRqmtItmCap ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PlannedOrder
;

Learn More