I_OrderMissingPart

DDL: I_ORDERMISSINGPART Type: view_entity COMPOSITE Package: VDM_PP_SFC

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.

2 data source(s) 42 fields

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
KEY ReservationItem I_OrderMissingPartBasic ReservationItem
KEY ReservationRecordType I_OrderMissingPartBasic ReservationRecordType
Material I_OrderMissingPartBasic Material
Plant I_OrderMissingPartBasic Plant
StorageLocation I_OrderComponent StorageLocation
Batch I_OrderComponent Batch
SalesOrder I_OrderComponent SalesOrder
SalesOrderItem I_OrderComponent SalesOrderItem
WBSElementInternalID I_OrderComponent WBSElementInternalID
RequirementType I_OrderComponent RequirementType
InventorySpecialStockType I_OrderComponent InventorySpecialStockType
OrderID I_OrderMissingPartBasic OrderID
RequirementDate I_OrderMissingPartBasic RequirementDate
QuantityIsFixed I_OrderComponent QuantityIsFixed
BaseUnit I_OrderComponent BaseUnit
ConfirmedAvailableQuantity I_OrderComponent ConfirmedAvailableQuantity
RequiredQuantity I_OrderComponent RequiredQuantity
WithdrawnQuantity I_OrderComponent WithdrawnQuantity
MaterialQtyToBaseQtyNmrtr I_OrderComponent MaterialQtyToBaseQtyNmrtr
MaterialQtyToBaseQtyDnmntr I_OrderComponent MaterialQtyToBaseQtyDnmntr
MaterialRevisionLevel I_OrderComponent MaterialRevisionLevel
AlternativeItemGroup I_OrderComponent AlternativeItemGroup
AlternativeItemStrategy I_OrderComponent AlternativeItemStrategy
AlternativeItemPriority I_OrderComponent AlternativeItemPriority
MaterialCompIsAlternativeItem I_OrderComponent MaterialCompIsAlternativeItem
BillOfMaterialCategory I_OrderComponent BillOfMaterialCategory
BillOfMaterialInternalID I_OrderComponent BillOfMaterialInternalID
BOMItem I_OrderComponent BOMItem
BOMItemInternalChangeCount I_OrderComponent BOMItemInternalChangeCount
BOMItemCategory I_OrderComponent BOMItemCategory
BillOfMaterialItemNumber I_OrderComponent BillOfMaterialItemNumber
Supplier I_OrderComponent Supplier
OrderOperation I_OrderComponent OrderOperation
OrderPathValue I_OrderComponent OrderPathValue
OrderLevelValue I_OrderComponent OrderLevelValue
UsageProbabilityPercent I_OrderComponent UsageProbabilityPercent
MatlCompDiscontinuationType I_OrderComponent MatlCompDiscontinuationType
OrderCategory I_OrderComponent OrderCategory
OrderType I_OrderComponent OrderType
_Material _Material
_Order I_OrderMissingPartBasic _Order 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Missing Parts of Orders'
// Missing parts of any order category, field list according to structure MDVA


define view entity I_OrderMissingPart
  as select from   I_OrderMissingPartBasic as ftind
    inner join     I_OrderComponent        as resb  on  resb.Reservation     = ftind.Reservation
                                                    and resb.ReservationItem = ftind.ReservationItem
                                                    and resb.RecordType      = ftind.ReservationRecordType
                                                    
  association [1..1] to I_Material    as _Material  on  $projection.Material = _Material.Material
{
  key ftind.Reservation,
  key ftind.ReservationItem,
  key ftind.ReservationRecordType,

      ftind.Material,
      ftind.Plant,
      resb.StorageLocation,
      resb.Batch,
      resb.SalesOrder,
      resb.SalesOrderItem,
      resb.WBSElementInternalID,
      resb.RequirementType,
      resb.InventorySpecialStockType,
      ftind.OrderID,
      ftind.RequirementDate,
      resb.QuantityIsFixed,
      resb.BaseUnit,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM
      resb.ConfirmedAvailableQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM
      resb.RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      @Aggregation.default: #SUM
      resb.WithdrawnQuantity,
      resb.MaterialQtyToBaseQtyNmrtr,
      resb.MaterialQtyToBaseQtyDnmntr,
      resb.MaterialRevisionLevel,
      resb.AlternativeItemGroup,
      resb.AlternativeItemStrategy,
      resb.AlternativeItemPriority,
      resb.MaterialCompIsAlternativeItem,
      resb.BillOfMaterialCategory,
      resb.BillOfMaterialInternalID,
      resb.BOMItem,
      resb.BOMItemInternalChangeCount,
      resb.BOMItemCategory,
      resb.BillOfMaterialItemNumber,
      resb.Supplier,
      resb.OrderOperation,
      resb.OrderPathValue,
      resb.OrderLevelValue,
      resb.UsageProbabilityPercent,
      resb.MatlCompDiscontinuationType,
      resb.OrderCategory,
      resb.OrderType,
      
      //Association

      _Material,
      ftind._Order     //(for DCLS)

}
where resb.MatlCompIsMarkedForDeletion = '' and
      resb.ReservationIsFinallyIssued  = '';

Learn More