C_SchedProdnMissingComponent

DDL: C_SCHEDPRODNMISSINGCOMPONENT Type: view_entity CONSUMPTION Package: ODATA_PP_CAP_SCHEDPRODN

Missing Components Details

C_SchedProdnMissingComponent is a Consumption CDS View that provides data about "Missing Components Details" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 13 fields with key fields Reservation, ReservationItem, RecordType. Part of development package ODATA_PP_CAP_SCHEDPRODN.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent opComp from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Missing Components Details view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Feature FTGL_2602_MISSINGCOMPPOPOVER view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MfgOrderOperationComponent Reservation
KEY ReservationItem I_MfgOrderOperationComponent ReservationItem
KEY RecordType I_MfgOrderOperationComponent RecordType
ManufacturingOrder I_MfgOrderOperationComponent ManufacturingOrder
ManufacturingOrderCategory I_MfgOrderOperationComponent ManufacturingOrderCategory
Material I_MfgOrderOperationComponent Material
RequiredQuantity I_MfgOrderOperationComponent RequiredQuantity
ConfirmedAvailableQuantity I_MfgOrderOperationComponent ConfirmedAvailableQuantity
BaseUnit I_MfgOrderOperationComponent BaseUnit
MissingQuantity
BOMItemDescription I_MfgOrderOperationComponent BOMItemDescription
AssemblyMRPController I_MfgOrderOperationComponent AssemblyMRPController
ProductionPlant I_MfgOrderOperationComponent ProductionPlant 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Missing Components Details'
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #XL,
    dataClass: #MIXED
}
@VDM.viewType:  #CONSUMPTION
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Feature: 'FTGL_2602_MISSINGCOMPPOPOVER'
@Metadata.ignorePropagatedAnnotations: true
define view entity C_SchedProdnMissingComponent as select from I_MfgOrderOperationComponent as opComp
{
    key opComp.Reservation,
    @Semantics.text: true
    key opComp.ReservationItem,
    key opComp.RecordType,
    opComp.ManufacturingOrder,
    opComp.ManufacturingOrderCategory,
    opComp.Material,
    @Semantics.quantity.unitOfMeasure: 'BaseUnit'
    opComp.RequiredQuantity,
    @Semantics.quantity.unitOfMeasure: 'BaseUnit'
    opComp.ConfirmedAvailableQuantity,
    opComp.BaseUnit,
    @Semantics.quantity.unitOfMeasure: 'BaseUnit'
    (opComp.RequiredQuantity- opComp.ConfirmedAvailableQuantity) as MissingQuantity,
    opComp.BOMItemDescription as BOMItemDescription,
    
    opComp.AssemblyMRPController as AssemblyMRPController,
    opComp.ProductionPlant as ProductionPlant
}
where
  opComp.MaterialComponentIsMissing = 'X'
  and opComp.ReservationIsFinallyIssued = ''
  and ( opComp.ManufacturingOrderCategory = '10' or opComp.ManufacturingOrderCategory = '40' )

Learn More