C_OpActyInstcePlndCompDsassy

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 C_OpActyInstcePlndCompDsassy.
-- 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 C_OpActyInstcePlndCompDsassy AS
SELECT
  OperationActivityPlndMatlRet.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActivityPlndMatlRet.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  OperationActivityPlndMatlRet.ManufacturingOrder AS ManufacturingOrder,
  OperationActivityPlndMatlRet.ProductionPlant AS ProductionPlant,
  OperationActivityPlndMatlRet.StorageLocation AS StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OperationActivityPlndMatlRet.AssemblySequenceNumber AS AssemblySequenceNumber,
  OperationActivityPlndMatlRet.BaseUnit AS BaseUnit,
  OperationActivityPlndMatlRet.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  OperationActivityPlndMatlRet.RequiredQuantity AS RequiredQuantity,
  OperationActivityPlndMatlRet.SerialNumberProfile AS SerialNumberProfile,
  OperationActivityPlndMatlRet.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  OperationActivityPlndMatlRet.StockCheckMessageType AS StockCheckMessageType,
  OperationActivityPlndMatlRet.IsBatchManagementRequired AS IsBatchManagementRequired,
  OperationActivityPlndMatlRet.EffectivityParameterVariant AS EffectivityParameterVariant,
  OperationActivityPlndMatlRet.Assembly AS Assembly,
  OperationActivityPlndMatlRet.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OperationActivityPlndMatlRet.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OperationActivityPlndMatlRet.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OperationActivityPlndMatlRet.FormulaKey AS FormulaKey,
  OperationActivityPlndMatlRet.VariableSizeDimension1 AS VariableSizeDimension1,
  OperationActivityPlndMatlRet.VariableSizeDimension2 AS VariableSizeDimension2,
  OperationActivityPlndMatlRet.VariableSizeDimension3 AS VariableSizeDimension3,
  OperationActivityPlndMatlRet.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  OperationActivityPlndMatlRet.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OperationActivityPlndMatlRet.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OperationActivityPlndMatlRet.MatlCompAssembleControl AS MatlCompAssembleControl,
  _MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName AS MatlCompAssembleControlName,
  OperationActivityPlndMatlRet.BOMItemCategory AS BOMItemCategory,
  _BOMItemCategory._ItemCategoryT[1: Language=$session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  OperationActivityPlndMatlRet.MfgRefStrucItmRefDesignator AS MfgRefStrucItmRefDesignator,
  OperationActivityPlndMatlRet.MfgRefStrucItmRefDsgntrName AS MfgRefStrucItmRefDsgntrName,
  OperationActivityPlndMatlRet.MfgBOMItemIsPhantomChild AS MfgBOMItemIsPhantomChild,
  OperationActivityPlndMatlRet.RelatedReservationItem AS RelatedReservationItem,
  OperationActivityPlndMatlRet.RelatedRecordType AS RelatedRecordType,
  OperationActivityPlndMatlRet.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OperationActivityPlndMatlRet.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OperationActivityPlndMatlRet.LeadingReservation AS LeadingReservation,
  OperationActivityPlndMatlRet.LeadingReservationItem AS LeadingReservationItem,
  OperationActivityPlndMatlRet.LeadingReservationRecordType AS LeadingReservationRecordType,
  OperationActivityPlndMatlRet.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OperationActivityPlndMatlRet.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  cast( OperationActivityPlndMatlRet.BillOfMaterial as mpe_exec_stnum preserving type ) AS BillOfMaterial,
  OperationActivityPlndMatlRet.BOMItem AS BOMItem,
  OperationActivityPlndMatlRet.InheritedBOMItemNode AS InheritedBOMItemNode,
  OperationActivityPlndMatlRet.BillOfMaterialVariant AS BillOfMaterialVariant,
  OperationActivityPlndMatlRet.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OperationActivityPlndMatlRet.BillOfMaterialVersion AS BillOfMaterialVersion,
  OperationActivityPlndMatlRet.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OperationActivityPlndMatlRet.BillOfOperationsType AS BillOfOperationsType,
  OperationActivityPlndMatlRet.BillOfOperationsGroup AS BillOfOperationsGroup,
  OperationActivityPlndMatlRet.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OperationActivityPlndMatlRet.LogicalComponent AS LogicalComponent,
  OperationActivityPlndMatlRet.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OperationActivityPlndMatlRet.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OperationActivityPlndMatlRet.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OperationActivityPlndMatlRet.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OperationActivityPlndMatlRet.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  OperationActivityPlndMatlRet.PlannedInventoryUsabilityCode AS PlannedInventoryUsabilityCode,
  OperationActivityPlndMatlRet._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  OperationActivityPlndMatlRet._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OperationActivityPlndMatlRet._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic
FROM P_OpActyInstcePlndCompDsassy AS OperationActivityPlndMatlRet
LEFT OUTER JOIN I_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND ProductionPlant = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItem ON BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BOMItem = _BillOfMaterialItem.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItem.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN C_MfgOrderCompAssemblyAggrgn AS _MfgOrderCompAssemblyAggrgn ON Reservation = _MfgOrderCompAssemblyAggrgn.Reservation AND ReservationItem = _MfgOrderCompAssemblyAggrgn.ReservationItem AND RecordType = _MfgOrderCompAssemblyAggrgn.RecordType AND OpActyNtwkInstance = _MfgOrderCompAssemblyAggrgn.OpActyNtwkInstance AND OpActyNtwkElement = _MfgOrderCompAssemblyAggrgn.OpActyNtwkElement AND Material = _MfgOrderCompAssemblyAggrgn.Material AND _MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem = 0  -- association [0..*]
LEFT OUTER JOIN I_AssldReltdCompInstceSrlNmbr AS _AssldReltdCompInstceSrlNmbr ON Reservation = _AssldReltdCompInstceSrlNmbr.Reservation AND ReservationItem = _AssldReltdCompInstceSrlNmbr.ReservationItem AND RecordType = _AssldReltdCompInstceSrlNmbr.RecordType AND OpActyNtwkInstance = _AssldReltdCompInstceSrlNmbr.OpActyNtwkInstance AND OpActyNtwkElement = _AssldReltdCompInstceSrlNmbr.OpActyNtwkElement AND _AssldReltdCompInstceSrlNmbr.AssemblyShopFloorItem = 0  -- association [0..*]
LEFT OUTER JOIN I_AssldReltdSerialNumberBatch AS _AssldReltdSerialNumberBatch ON Reservation = _AssldReltdSerialNumberBatch.Reservation AND ReservationItem = _AssldReltdSerialNumberBatch.ReservationItem AND RecordType = _AssldReltdSerialNumberBatch.RecordType AND OpActyNtwkInstance = _AssldReltdSerialNumberBatch.OpActyNtwkInstance AND OpActyNtwkElement = _AssldReltdSerialNumberBatch.OpActyNtwkElement AND _AssldReltdSerialNumberBatch.AssemblyShopFloorItem = 0  -- association [0..*]
LEFT OUTER JOIN I_OpActyCompInstceAssignment AS _OpActyCompInstceAssignment ON Reservation = _OpActyCompInstceAssignment.Reservation AND ReservationItem = _OpActyCompInstceAssignment.ReservationItem AND RecordType = _OpActyCompInstceAssignment.RecordType AND OpActyNtwkInstance = _OpActyCompInstceAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyCompInstceAssignment.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _MfgBOMItemWithPhantomHier ON BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory AND BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial AND BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem AND RecordType = _ReservationDocumentItem.RecordType  -- association [1..1]
;