I_OrderMissingPart

DDL: I_ORDERMISSINGPART Type: view_entity COMPOSITE Package: VDM_PP_SFC
42 Fields 2 Data Sources 1 Associations

Missing Parts of Orders

I_OrderMissingPart is a Composite CDS View that provides data about "Missing Parts of Orders" in SAP S/4HANA. It reads from 2 data sources (I_OrderMissingPartBasic, I_OrderComponent) and exposes 42 fields with key fields Reservation, ReservationItem, ReservationRecordType. It has 1 association to related views. Part of development package VDM_PP_SFC.

Data Sources (2)

SourceAliasJoin Type
I_OrderMissingPartBasic ftind from
I_OrderComponent resb inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Missing Parts of Orders view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_OrderMissingPartBasic Reservation Reservation
KEY ReservationItem I_OrderMissingPartBasic ReservationItem Reservation Item
KEY ReservationRecordType I_OrderMissingPartBasic ReservationRecordType Record type
Material I_OrderMissingPartBasic Material Vehicle Model
Plant I_OrderMissingPartBasic Plant Valuation Area
StorageLocation I_OrderComponent StorageLocation StorageLocation
Batch I_OrderComponent Batch Lot No.
SalesOrder I_OrderComponent SalesOrder SD Document
SalesOrderItem I_OrderComponent SalesOrderItem Sales Order Item
WBSElementInternalID I_OrderComponent WBSElementInternalID WBS Internal ID
RequirementType I_OrderComponent RequirementType RequirementType
InventorySpecialStockType I_OrderComponent InventorySpecialStockType Special Stock Type
OrderID I_OrderMissingPartBasic OrderID Order ID
RequirementDate I_OrderMissingPartBasic RequirementDate Requirement Date
QuantityIsFixed I_OrderComponent QuantityIsFixed Qty. is fixed
BaseUnit I_OrderComponent BaseUnit Unit of Measure
ConfirmedAvailableQuantity I_OrderComponent ConfirmedAvailableQuantity Available Quantity
RequiredQuantity I_OrderComponent RequiredQuantity Requirement qty
WithdrawnQuantity I_OrderComponent WithdrawnQuantity Withdrawn Quantity
MaterialQtyToBaseQtyNmrtr I_OrderComponent MaterialQtyToBaseQtyNmrtr Numerator
MaterialQtyToBaseQtyDnmntr I_OrderComponent MaterialQtyToBaseQtyDnmntr Denominator
MaterialRevisionLevel I_OrderComponent MaterialRevisionLevel Revision Level
AlternativeItemGroup I_OrderComponent AlternativeItemGroup AltItemGroup
AlternativeItemStrategy I_OrderComponent AlternativeItemStrategy Strategy
AlternativeItemPriority I_OrderComponent AlternativeItemPriority Priority
MaterialCompIsAlternativeItem I_OrderComponent MaterialCompIsAlternativeItem Alternat. item
BillOfMaterialCategory I_OrderComponent BillOfMaterialCategory BOM category
BillOfMaterialInternalID I_OrderComponent BillOfMaterialInternalID
BOMItem I_OrderComponent BOMItem
BOMItemInternalChangeCount I_OrderComponent BOMItemInternalChangeCount Counter
BOMItemCategory I_OrderComponent BOMItemCategory Item Category
BillOfMaterialItemNumber I_OrderComponent BillOfMaterialItemNumber Item
Supplier I_OrderComponent Supplier Supplier
OrderOperation I_OrderComponent OrderOperation Operation or Phase
OrderPathValue I_OrderComponent OrderPathValue Order path
OrderLevelValue I_OrderComponent OrderLevelValue Order level
UsageProbabilityPercent I_OrderComponent UsageProbabilityPercent Usage Prob.
MatlCompDiscontinuationType I_OrderComponent MatlCompDiscontinuationType Share of scrap
OrderCategory I_OrderComponent OrderCategory Order Category
OrderType I_OrderComponent OrderType Order Type
_Material _Material
_Order I_OrderMissingPartBasic _Order

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 I_OrderMissingPart.
-- 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 I_OrderMissingPart AS
SELECT
  ftind.Reservation AS Reservation,
  ftind.ReservationItem AS ReservationItem,
  ftind.ReservationRecordType AS ReservationRecordType,
  ftind.Material AS Material,
  ftind.Plant AS Plant,
  resb.StorageLocation AS StorageLocation,
  resb.Batch AS Batch,
  resb.SalesOrder AS SalesOrder,
  resb.SalesOrderItem AS SalesOrderItem,
  resb.WBSElementInternalID AS WBSElementInternalID,
  resb.RequirementType AS RequirementType,
  resb.InventorySpecialStockType AS InventorySpecialStockType,
  ftind.OrderID AS OrderID,
  ftind.RequirementDate AS RequirementDate,
  resb.QuantityIsFixed AS QuantityIsFixed,
  resb.BaseUnit AS BaseUnit,
  resb.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  resb.RequiredQuantity AS RequiredQuantity,
  resb.WithdrawnQuantity AS WithdrawnQuantity,
  resb.MaterialQtyToBaseQtyNmrtr AS MaterialQtyToBaseQtyNmrtr,
  resb.MaterialQtyToBaseQtyDnmntr AS MaterialQtyToBaseQtyDnmntr,
  resb.MaterialRevisionLevel AS MaterialRevisionLevel,
  resb.AlternativeItemGroup AS AlternativeItemGroup,
  resb.AlternativeItemStrategy AS AlternativeItemStrategy,
  resb.AlternativeItemPriority AS AlternativeItemPriority,
  resb.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  resb.BillOfMaterialCategory AS BillOfMaterialCategory,
  resb.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  resb.BOMItem AS BOMItem,
  resb.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  resb.BOMItemCategory AS BOMItemCategory,
  resb.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  resb.Supplier AS Supplier,
  resb.OrderOperation AS OrderOperation,
  resb.OrderPathValue AS OrderPathValue,
  resb.OrderLevelValue AS OrderLevelValue,
  resb.UsageProbabilityPercent AS UsageProbabilityPercent,
  resb.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  resb.OrderCategory AS OrderCategory,
  resb.OrderType AS OrderType,
  ftind._Order AS _Order
FROM I_OrderMissingPartBasic AS ftind
INNER JOIN I_OrderComponent AS resb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
;

Learn More