P_MfgOrderOperationCompMatl

DDL: P_MFGORDEROPERATIONCOMPMATL SQL: PMPEORDOPCOMPMAT Type: view CONSUMPTION
51 Fields 2 Data Sources 1 Associations

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

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 (51)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MfgOrderOperationComponent Reservation Reservation
KEY ReservationItem I_MfgOrderOperationComponent ReservationItem Reservation Item
KEY RecordType I_MfgOrderOperationComponent RecordType Reservation Record Type
MaterialGroup I_MfgOrderOperationComponent MaterialGroup Product Group
Material I_MfgOrderOperationComponent Material Vehicle Model
Plant I_MfgOrderOperationComponent Plant Valuation Area
ManufacturingOrderCategory I_MfgOrderOperationComponent ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrderOperationComponent ManufacturingOrderType
ManufacturingOrder I_MfgOrderOperationComponent ManufacturingOrder Order
ManufacturingOrderSequence I_MfgOrderOperationComponent ManufacturingOrderSequence
ManufacturingOrderOperation I_MfgOrderOperationComponent ManufacturingOrderOperation Activity
ProductionPlant I_MfgOrderOperationComponent ProductionPlant Prod plnt
OrderInternalBillOfOperations I_MfgOrderOperationComponent OrderInternalBillOfOperations Order Internal Bill of Operations
OrderIntBillOfOperationsItem I_MfgOrderOperationComponent OrderIntBillOfOperationsItem Order Internal Bill of Operations Item
ReservationIsFinallyIssued I_MfgOrderOperationComponent ReservationIsFinallyIssued Res Final Issue
MatlCompIsMarkedForDeletion I_MfgOrderOperationComponent MatlCompIsMarkedForDeletion
MaterialComponentIsMissing I_MfgOrderOperationComponent MaterialComponentIsMissing Missing Part
IsBulkMaterialComponent I_MfgOrderOperationComponent IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush I_MfgOrderOperationComponent MatlCompIsMarkedForBackflush Backflush
BillOfMaterialCategory I_MfgOrderOperationComponent BillOfMaterialCategory BOM category
BillOfMaterialInternalID I_MfgOrderOperationComponent BillOfMaterialInternalID BOM
BillOfMaterialVariantUsage I_MfgOrderOperationComponent BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_MfgOrderOperationComponent BillOfMaterialVariant AlternativeBOM
BillOfMaterial I_MfgOrderOperationComponent BillOfMaterial BOM
BOMItem I_MfgOrderOperationComponent BOMItem
BillOfMaterialVersion I_MfgOrderOperationComponent BillOfMaterialVersion BOM Version
BOMItemInternalChangeCount I_MfgOrderOperationComponent BOMItemInternalChangeCount Counter
StorageLocation I_MfgOrderOperationComponent StorageLocation StorageLocation
Batch I_MfgOrderOperationComponent Batch Lot No.
GoodsMovementType I_MfgOrderOperationComponent GoodsMovementType Movement Type
BaseUnit I_MfgOrderOperationComponent BaseUnit Unit of Measure
RequiredQuantity I_MfgOrderOperationComponent RequiredQuantity Requirement qty
MaterialCompIsAlternativeItem I_MfgOrderOperationComponent MaterialCompIsAlternativeItem Alternat. item
UsageProbabilityPercent I_MfgOrderOperationComponent UsageProbabilityPercent Usage Prob.
SerialNumberProfile I_MatlPlntCompAssembleControl SerialNumberProfile SerialNoProfile
SerialNumberIsRqdForAssembly I_MatlPlntCompAssembleControl SerialNumberIsRqdForAssembly
StockCheckMessageType I_MatlPlntCompAssembleControl StockCheckMessageType
IsBatchManagementRequired I_MatlPlntCompAssembleControl IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
_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

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_MfgOrderOperationCompMatl.
-- 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: PMPEORDOPCOMPMAT

CREATE VIEW P_MfgOrderOperationCompMatl AS
SELECT
  MfgOrderOperationComponent.Reservation AS Reservation,
  MfgOrderOperationComponent.ReservationItem AS ReservationItem,
  MfgOrderOperationComponent.RecordType AS RecordType,
  MfgOrderOperationComponent.MaterialGroup AS MaterialGroup,
  MfgOrderOperationComponent.Material AS Material,
  MfgOrderOperationComponent.Plant AS Plant,
  MfgOrderOperationComponent.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrderOperationComponent.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrderOperationComponent.ManufacturingOrder AS ManufacturingOrder,
  MfgOrderOperationComponent.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  MfgOrderOperationComponent.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  MfgOrderOperationComponent.ProductionPlant AS ProductionPlant,
  MfgOrderOperationComponent.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderOperationComponent.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  MfgOrderOperationComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  MfgOrderOperationComponent.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  MfgOrderOperationComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  MfgOrderOperationComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  MfgOrderOperationComponent.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  MfgOrderOperationComponent.BillOfMaterialCategory AS BillOfMaterialCategory,
  MfgOrderOperationComponent.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  MfgOrderOperationComponent.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MfgOrderOperationComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  MfgOrderOperationComponent.BillOfMaterial AS BillOfMaterial,
  MfgOrderOperationComponent.BOMItem AS BOMItem,
  MfgOrderOperationComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  MfgOrderOperationComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  MfgOrderOperationComponent.StorageLocation AS StorageLocation,
  MfgOrderOperationComponent.Batch AS Batch,
  MfgOrderOperationComponent.GoodsMovementType AS GoodsMovementType,
  MfgOrderOperationComponent.BaseUnit AS BaseUnit,
  MfgOrderOperationComponent.RequiredQuantity AS RequiredQuantity,
  MfgOrderOperationComponent.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  MfgOrderOperationComponent.UsageProbabilityPercent AS UsageProbabilityPercent,
  MfgOrderProductPlant.SerialNumberProfile AS SerialNumberProfile,
  MfgOrderProductPlant.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  MfgOrderProductPlant.StockCheckMessageType AS StockCheckMessageType,
  MfgOrderProductPlant.IsBatchManagementRequired AS IsBatchManagementRequired,
  MfgOrderOperationComponent._ManufacturingOrder AS _ManufacturingOrder,
  MfgOrderOperationComponent._Material AS _Material,
  MfgOrderOperationComponent._MfgOrder AS _MfgOrder,
  MfgOrderOperationComponent._MfgOrderOperation AS _MfgOrderOperation,
  MfgOrderOperationComponent._MfgOrderOperationBySemanKey AS _MfgOrderOperationBySemanKey,
  MfgOrderOperationComponent._Plant AS _Plant,
  MfgOrderOperationComponent._Product AS _Product,
  MfgOrderOperationComponent._ProductionPlant AS _ProductionPlant,
  MfgOrderOperationComponent._ProductPlant AS _ProductPlant,
  MfgOrderOperationComponent._Reservation AS _Reservation,
  MfgOrderOperationComponent._ReservationItem AS _ReservationItem,
  MfgOrderOperationComponent._StorageLocation AS _StorageLocation
FROM I_MfgOrderOperationComponent AS MfgOrderOperationComponent
INNER JOIN I_MatlPlntCompAssembleControl AS MfgOrderProductPlant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
;

Learn More