P_MfgOrderOperationCompMatl

DDL: P_MFGORDEROPERATIONCOMPMATL SQL: PMPEORDOPCOMPMAT Type: view CONSUMPTION

P_MfgOrderOperationCompMatl is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MfgOrderOperationComponent, I_MatlPlntCompAssembleControl) and exposes 49 fields with key fields Reservation, ReservationItem, RecordType. It has 1 association to related views.

2 data source(s) 49 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrderOperationComponent MfgOrderOperationComponent from
I_MatlPlntCompAssembleControl MfgOrderProductPlant inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MatlCompAssembleControl _MatlCompAssembleControl $projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEORDOPCOMPMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MfgOrderOperationComponent Reservation
KEY ReservationItem I_MfgOrderOperationComponent ReservationItem
KEY RecordType I_MfgOrderOperationComponent RecordType
MaterialGroup I_MfgOrderOperationComponent MaterialGroup
Material I_MfgOrderOperationComponent Material
Plant I_MfgOrderOperationComponent Plant
ManufacturingOrderCategory I_MfgOrderOperationComponent ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderOperationComponent ManufacturingOrderType
ManufacturingOrder I_MfgOrderOperationComponent ManufacturingOrder
ManufacturingOrderSequence I_MfgOrderOperationComponent ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationComponent ManufacturingOrderOperation
ProductionPlant I_MfgOrderOperationComponent ProductionPlant
OrderInternalBillOfOperations I_MfgOrderOperationComponent OrderInternalBillOfOperations
OrderIntBillOfOperationsItem I_MfgOrderOperationComponent OrderIntBillOfOperationsItem
ReservationIsFinallyIssued I_MfgOrderOperationComponent ReservationIsFinallyIssued
MatlCompIsMarkedForDeletion I_MfgOrderOperationComponent MatlCompIsMarkedForDeletion
MaterialComponentIsMissing I_MfgOrderOperationComponent MaterialComponentIsMissing
IsBulkMaterialComponent I_MfgOrderOperationComponent IsBulkMaterialComponent
MatlCompIsMarkedForBackflush I_MfgOrderOperationComponent MatlCompIsMarkedForBackflush
BillOfMaterialCategory I_MfgOrderOperationComponent BillOfMaterialCategory
BillOfMaterialInternalID I_MfgOrderOperationComponent BillOfMaterialInternalID
BillOfMaterialVariantUsage I_MfgOrderOperationComponent BillOfMaterialVariantUsage
BillOfMaterialVariant I_MfgOrderOperationComponent BillOfMaterialVariant
BillOfMaterial I_MfgOrderOperationComponent BillOfMaterial
BOMItem I_MfgOrderOperationComponent BOMItem
BillOfMaterialVersion I_MfgOrderOperationComponent BillOfMaterialVersion
BOMItemInternalChangeCount I_MfgOrderOperationComponent BOMItemInternalChangeCount
StorageLocation I_MfgOrderOperationComponent StorageLocation
Batch I_MfgOrderOperationComponent Batch
GoodsMovementType I_MfgOrderOperationComponent GoodsMovementType
BaseUnit I_MfgOrderOperationComponent BaseUnit
RequiredQuantity I_MfgOrderOperationComponent RequiredQuantity
SerialNumberProfile I_MatlPlntCompAssembleControl SerialNumberProfile
SerialNumberIsRqdForAssembly I_MatlPlntCompAssembleControl SerialNumberIsRqdForAssembly
StockCheckMessageType I_MatlPlntCompAssembleControl StockCheckMessageType
IsBatchManagementRequired I_MatlPlntCompAssembleControl IsBatchManagementRequired
_ManufacturingOrder I_MfgOrderOperationComponent _ManufacturingOrder
_Material I_MfgOrderOperationComponent _Material
_MfgOrder I_MfgOrderOperationComponent _MfgOrder
_MfgOrderOperation I_MfgOrderOperationComponent _MfgOrderOperation
_MfgOrderOperationBySemanKey I_MfgOrderOperationComponent _MfgOrderOperationBySemanKey
_Plant I_MfgOrderOperationComponent _Plant
_Product I_MfgOrderOperationComponent _Product
_ProductionPlant I_MfgOrderOperationComponent _ProductionPlant
_ProductPlant I_MfgOrderOperationComponent _ProductPlant
_Reservation I_MfgOrderOperationComponent _Reservation
_ReservationItem I_MfgOrderOperationComponent _ReservationItem
_StorageLocation I_MfgOrderOperationComponent _StorageLocation
_MatlCompAssembleControl _MatlCompAssembleControl 
@AbapCatalog.sqlViewName: 'PMPEORDOPCOMPMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view P_MfgOrderOperationCompMatl
  as select from I_MfgOrderOperationComponent  as MfgOrderOperationComponent
    inner join   I_MatlPlntCompAssembleControl as MfgOrderProductPlant on  MfgOrderOperationComponent.Material        = MfgOrderProductPlant.Product
                                                                       and MfgOrderOperationComponent.ProductionPlant = MfgOrderProductPlant.Plant

  association [1..1] to I_MatlCompAssembleControl as _MatlCompAssembleControl on $projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl
{
  key MfgOrderOperationComponent.Reservation,
  key MfgOrderOperationComponent.ReservationItem,
  key MfgOrderOperationComponent.RecordType,
      MfgOrderOperationComponent.MaterialGroup,
      MfgOrderOperationComponent.Material,
      MfgOrderOperationComponent.Plant,
      MfgOrderOperationComponent.ManufacturingOrderCategory,
      MfgOrderOperationComponent.ManufacturingOrderType,
      MfgOrderOperationComponent.ManufacturingOrder,
      MfgOrderOperationComponent.ManufacturingOrderSequence,
      MfgOrderOperationComponent.ManufacturingOrderOperation,
      MfgOrderOperationComponent.ProductionPlant,
      MfgOrderOperationComponent.OrderInternalBillOfOperations,
      MfgOrderOperationComponent.OrderIntBillOfOperationsItem,
      MfgOrderOperationComponent.ReservationIsFinallyIssued,
      MfgOrderOperationComponent.MatlCompIsMarkedForDeletion,
      MfgOrderOperationComponent.MaterialComponentIsMissing,
      MfgOrderOperationComponent.IsBulkMaterialComponent,
      MfgOrderOperationComponent.MatlCompIsMarkedForBackflush,
      MfgOrderOperationComponent.BillOfMaterialCategory,
      MfgOrderOperationComponent.BillOfMaterialInternalID,
      MfgOrderOperationComponent.BillOfMaterialVariantUsage,
      MfgOrderOperationComponent.BillOfMaterialVariant,
      MfgOrderOperationComponent.BillOfMaterial,
      MfgOrderOperationComponent.BOMItem,
      MfgOrderOperationComponent.BillOfMaterialVersion,
      MfgOrderOperationComponent.BOMItemInternalChangeCount,
      MfgOrderOperationComponent.StorageLocation,
      MfgOrderOperationComponent.Batch,
      MfgOrderOperationComponent.GoodsMovementType,
      MfgOrderOperationComponent.BaseUnit,
      MfgOrderOperationComponent.RequiredQuantity,

      MfgOrderProductPlant.SerialNumberProfile,
      MfgOrderProductPlant.SerialNumberIsRqdForAssembly,
      MfgOrderProductPlant.StockCheckMessageType,
      MfgOrderProductPlant.IsBatchManagementRequired,
      cast(case
        when MfgOrderOperationComponent.MatlCompIsMarkedForBackflush = 'X' then 4
        when MfgOrderOperationComponent.IsBulkMaterialComponent = 'X' then 5
        else MfgOrderProductPlant.MatlCompAssembleControl
      end as mpe_comp_assemble_control preserving type ) as MatlCompAssembleControl,

      MfgOrderOperationComponent._ManufacturingOrder,
      MfgOrderOperationComponent._Material,
      MfgOrderOperationComponent._MfgOrder,
      MfgOrderOperationComponent._MfgOrderOperation,
      MfgOrderOperationComponent._MfgOrderOperationBySemanKey,
      MfgOrderOperationComponent._Plant,
      MfgOrderOperationComponent._Product,
      MfgOrderOperationComponent._ProductionPlant,
      MfgOrderOperationComponent._ProductPlant,
      MfgOrderOperationComponent._Reservation,
      MfgOrderOperationComponent._ReservationItem,
      MfgOrderOperationComponent._StorageLocation,
      _MatlCompAssembleControl
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATLPLNTCOMPASSEMBLECONTROL",
"I_MFGORDEROPERATIONCOMPONENT"
],
"ASSOCIATED":
[
"I_MANUFACTURINGORDER",
"I_MATERIAL",
"I_MATLCOMPASSEMBLECONTROL",
"I_MFGORDER",
"I_MFGORDEROPERATIONBASIC",
"I_MFGORDEROPERATIONBYSEMANKEY",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTPLANT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONDOCUMENTITEM",
"I_STORAGELOCATION"
],
"BASE":
[
"I_MFGORDEROPERATIONCOMPONENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More