P_SchedOpersLiveCacheMap

DDL: P_SCHEDOPERSLIVECACHEMAP SQL: PSCHOPERLC Type: view COMPOSITE
24 Fields 3 Data Sources 2 Associations

P_SchedOpersLiveCacheMap is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_SchedProdnChgOp, I_SchedProdnPlngDets, P_SchedChngOpersLiveCacheMap) and exposes 24 fields with key fields SimulationSessionID, OrderID, CapacityRequirementItem, CapacityRqmtItemCapacity, OrderCategory. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_SchedProdnChgOp _chgoper left_outer
I_SchedProdnPlngDets _plngdets left_outer
P_SchedChngOpersLiveCacheMap P_SchedChngOpersLiveCacheMap from

Parameters (2)

NameTypeDefault
P_StartDate datum
P_EndDate datum

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_SchedProdnPlantTimeZone _Plant _Plant.werks = CapRqmtItmCap.Plant
[1..1] I_WorkCenter _SimulatedWorkCenter _SimulatedWorkCenter.WorkCenterInternalID = _chgoper.WorkCenterInternalID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSCHOPERLC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SimulationSessionID I_SchedProdnPlngDets SimulationSessionID Simulation Session ID
KEY OrderID CapRqmtItmCap OrderID Order ID
KEY CapacityRequirementItem CapRqmtItmCap CapacityRequirementItem Counter
KEY CapacityRqmtItemCapacity CapRqmtItmCap CapacityRqmtItemCapacity
KEY OrderCategory CapRqmtItmCap OrderCategory Order Category
SchedProdnAppName I_SchedProdnPlngDets SchedProdnAppName Application Name
IndustryType CapRqmtItmCap IndustryType Type of Industry
OperationIsPhase CapRqmtItmCap OperationIsPhase
SuperiorOperationInternalID CapRqmtItmCap SuperiorOperationInternalID Sup. Op. Node
OrderInternalID CapRqmtItmCap OrderInternalID Plan No.f.Oper.
OrderOperationInternalID CapRqmtItmCap OrderOperationInternalID
LiveCacheOrderID CapRqmtItmCap LiveCacheOrderID
LiveCacheActivityID CapRqmtItmCap LiveCacheActivityID
LiveCacheOrderStatus
OperationasvornrendasOperation
SupOperation CapRqmtItmCap SupOperation
CapacityInternalIDendasResourceID
ScheduledBasicStartDate ScheduledBasicStartDate Sched. start
ScheduledBasicStartTime ScheduledBasicStartTime
ScheduledBasicEndDate ScheduledBasicEndDate Sched. finish
ScheduledBasicEndTime ScheduledBasicEndTime
PlantTimeZone _Plant PlantTimeZone Time Zone
LastChangeDateTime CapRqmtItmCap LastChangeDateTime Timestamp
LiveCachePlannedStatus CapRqmtItmCap LiveCachePlannedStatus

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_SchedOpersLiveCacheMap.
-- 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: PSCHOPERLC
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_SchedOpersLiveCacheMap AS
SELECT
  _plngdets.SimulationSessionID AS SimulationSessionID,
  CapRqmtItmCap.OrderID AS OrderID,
  CapRqmtItmCap.CapacityRequirementItem AS CapacityRequirementItem,
  CapRqmtItmCap.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  CapRqmtItmCap.OrderCategory AS OrderCategory,
  _plngdets.SchedProdnAppName AS SchedProdnAppName,
  CapRqmtItmCap.IndustryType AS IndustryType,
  CapRqmtItmCap.OperationIsPhase AS OperationIsPhase,
  CapRqmtItmCap.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  CapRqmtItmCap.OrderInternalID AS OrderInternalID,
  CapRqmtItmCap.OrderOperationInternalID AS OrderOperationInternalID,
  CapRqmtItmCap.LiveCacheOrderID AS LiveCacheOrderID,
  CapRqmtItmCap.LiveCacheActivityID AS LiveCacheActivityID,
  CapRqmtItmCap. LiveCacheOrderStatus AS LiveCacheOrderStatus,
  case when _chgoper.OrderID is null or _chgoper.ProductionVersIsChgd = '' then cast ( CapRqmtItmCap.Operation as vornr ) else cast( _chgoper.Operation as vornr ) end as Operation AS OperationasvornrendasOperation,
  CapRqmtItmCap.SupOperation AS SupOperation,
  case when _chgoper.OrderID is null or _chgoper.ProductionVersIsChgd = '' then concat(concat(concat(CapRqmtItmCap.WorkCenterInternalID,'A'),CapRqmtItmCap.Plant), CapacityInternalID) else concat(concat(concat(_chgoper.WorkCenterInternalID,'A'),CapRqmtItmCap.Plant), _SimulatedWorkCenter.CapacityInternalID) end as ResourceID AS CapacityInternalIDendasResourceID,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  _Plant.PlantTimeZone AS PlantTimeZone,
  CapRqmtItmCap.LastChangeDateTime AS LastChangeDateTime,
  CapRqmtItmCap.LiveCachePlannedStatus AS LiveCachePlannedStatus
FROM P_SchedChngOpersLiveCacheMap
LEFT OUTER JOIN I_SchedProdnPlngDets AS _plngdets ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SchedProdnChgOp AS _chgoper ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SchedProdnPlantTimeZone AS _Plant ON _Plant.werks = CapRqmtItmCap.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _SimulatedWorkCenter ON _SimulatedWorkCenter.WorkCenterInternalID = _chgoper.WorkCenterInternalID  -- association [1..1]
;

Learn More