P_SchedProdnDispatchOrderDets

DDL: P_SCHEDPRODNDISPATCHORDERDETS SQL: PSCHPRODDISPDETS Type: view COMPOSITE
23 Fields 1 Data Sources 4 Associations

P_SchedProdnDispatchOrderDets is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_SchedOrdExtdDets) and exposes 23 fields with key fields OrderID, CapacityRequirementItem, CapacityRqmtItemCapacity, OrderCategory. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SchedOrdExtdDets _schedOrderDets from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SchedProdnOrderCategoryVH _OrderCategory $projection.OrderCategory = _OrderCategory.OrderCategory and _OrderCategory.Language = $session.system_language
[0..1] I_ProductText _PrdText $projection.Material = _PrdText.Product and _PrdText.Language = $session.system_language
[0..1] I_OperationSetupGroupCatText _OperationSetupGroupCatText $projection.Plant = _OperationSetupGroupCatText.Plant and $projection.OperationSetupGroupCategory = _OperationSetupGroupCatText.OperationSetupGroupCategory and _OperationSetupGroupCatText.Language = $session.system_language
[0..1] I_OperationSetupGroupText _OperationSetupGroupText $projection.Plant = _OperationSetupGroupText.Plant and $projection.OperationSetupGroup = _OperationSetupGroupText.OperationSetupGroup and $projection.OperationSetupGroupCategory = _OperationSetupGroupText.OperationSetupGroupCategory and _OperationSetupGroupText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSCHPRODDISPDETS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_SchedOrdExtdDets OrderID Order ID
KEY CapacityRequirementItem P_SchedOrdExtdDets CapacityRequirementItem
KEY CapacityRqmtItemCapacity P_SchedOrdExtdDets CapacityRqmtItemCapacity
KEY OrderCategory P_SchedOrdExtdDets OrderCategory Order Category
OrderCategoryName _OrderCategory OrderCategoryName
Material P_SchedOrdExtdDets Material Vehicle Model
ProductName _PrdText ProductName Description
OrderPlannedTotalQty P_SchedOrdExtdDets OrderPlannedTotalQty
BaseUnit P_SchedOrdExtdDets BaseUnit Unit of Measure
SchedldOrdStartDteTme P_SchedOrdExtdDets SchedldOrdStartDteTme
SchedldOrdEndDteTme P_SchedOrdExtdDets SchedldOrdEndDteTme
ReceiptDate P_SchedOrdExtdDets SchedldOrdEndDteTme
ManufacturingOrder P_SchedOrdExtdDets ManufacturingOrder Order
PlannedOrder P_SchedOrdExtdDets PlannedOrder
ProductionVersion P_SchedOrdExtdDets ProductionVersion Version ID
OperationSetupGroup P_SchedOrdExtdDets OperationSetupGroup Setup group key
OperationSetupGroupName _OperationSetupGroupText OperationSetupGroupName
OperationSetupGroupCategory P_SchedOrdExtdDets OperationSetupGroupCategory Setup group cat
OperationSetupGroupCatName _OperationSetupGroupCatText OperationSetupGroupCatName
Plant P_SchedOrdExtdDets Plant Valuation Area
LastChangeDateTime P_SchedOrdExtdDets LastChangeDateTime Timestamp
CapacityRequirement P_SchedOrdExtdDets CapacityRequirement
_PrdText _PrdText

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_SchedProdnDispatchOrderDets.
-- 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: PSCHPRODDISPDETS

CREATE VIEW P_SchedProdnDispatchOrderDets AS
SELECT
  _schedOrderDets.OrderID AS OrderID,
  _schedOrderDets.CapacityRequirementItem AS CapacityRequirementItem,
  _schedOrderDets.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  _schedOrderDets.OrderCategory AS OrderCategory,
  _OrderCategory.OrderCategoryName AS OrderCategoryName,
  _schedOrderDets.Material AS Material,
  _PrdText.ProductName AS ProductName,
  _schedOrderDets.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  _schedOrderDets.BaseUnit AS BaseUnit,
  _schedOrderDets.SchedldOrdStartDteTme AS SchedldOrdStartDteTme,
  _schedOrderDets.SchedldOrdEndDteTme AS SchedldOrdEndDteTme,
  _schedOrderDets.SchedldOrdEndDteTme AS ReceiptDate,
  _schedOrderDets.ManufacturingOrder AS ManufacturingOrder,
  _schedOrderDets.PlannedOrder AS PlannedOrder,
  _schedOrderDets.ProductionVersion AS ProductionVersion,
  _schedOrderDets.OperationSetupGroup AS OperationSetupGroup,
  _OperationSetupGroupText.OperationSetupGroupName AS OperationSetupGroupName,
  _schedOrderDets.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  _OperationSetupGroupCatText.OperationSetupGroupCatName AS OperationSetupGroupCatName,
  _schedOrderDets.Plant AS Plant,
  _schedOrderDets.LastChangeDateTime AS LastChangeDateTime,
  _schedOrderDets.CapacityRequirement AS CapacityRequirement
FROM P_SchedOrdExtdDets AS _schedOrderDets
LEFT OUTER JOIN I_SchedProdnOrderCategoryVH AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory AND _OrderCategory.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _PrdText ON Material = _PrdText.Product AND _PrdText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupGroupCatText AS _OperationSetupGroupCatText ON Plant = _OperationSetupGroupCatText.Plant AND OperationSetupGroupCategory = _OperationSetupGroupCatText.OperationSetupGroupCategory AND _OperationSetupGroupCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OperationSetupGroupText AS _OperationSetupGroupText ON Plant = _OperationSetupGroupText.Plant AND OperationSetupGroup = _OperationSetupGroupText.OperationSetupGroup AND OperationSetupGroupCategory = _OperationSetupGroupText.OperationSetupGroupCategory AND _OperationSetupGroupText.Language = $session.system_language  -- association [0..1]
;

Learn More