P_OpActyInstanceAssembledComp2

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_OpActyInstanceAssembledComp2.
-- 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: PMPEOAIAMAT2

CREATE VIEW P_OpActyInstanceAssembledComp2 AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceAssembledComp.Reservation AS Reservation,
  OpActyInstanceAssembledComp.ReservationItem AS ReservationItem,
  OpActyInstanceAssembledComp.RecordType AS RecordType,
  OpActyInstanceAssembledComp.Material AS Material,
  OpActyInstanceAssembledComp.Plant AS Plant,
  OpActyInstanceAssembledComp.StorageLocation AS StorageLocation,
  OpActyInstanceAssembledComp.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyInstanceAssembledComp.MfgOrderComponentUsageNetQty AS MfgOrderComponentUsageNetQty,
  cast( LogisticsOrderBasic.OrderPlannedTotalQty as esmng ) * OpActyInstanceAssembledComp.MfgOrderComponentUsageNetQty AS RequiredQuantity,
  cast(OpActyInstanceAssembledComp.MaterialComponentQuantity as mpe_consumed_qty_in_base_unit preserving type) AS ResvnItmWithdrawnQtyInBaseUnit,
  OpActyInstanceAssembledComp.BaseUnit AS BaseUnit,
  OpActyInstanceAssembledComp.EntryUnit AS EntryUnit,
  OpActyInstanceAssembledComp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyInstanceAssembledComp.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OpActyInstanceAssembledComp.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  cast( OrderOperationBasic.Operation as mpe_vornr_char preserving type ) AS ManufacturingOrderOperation,
  OrderOperationBasic.OperationText AS MfgOrderOperationText,
  OpActyInstceOpActyNtwkElmnt.OperationActivity AS OperationActivity,
  OpActyInstceOpActyNtwkElmnt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsGroup AS BillOfOperationsGroup,
  MfgOrderProductPlant.SerialNumberProfile AS SerialNumberProfile,
  MfgOrderProductPlant.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  MfgOrderProductPlant.IsBatchManagementRequired AS IsBatchManagementRequired,
  MfgOrderProductPlant.StockCheckMessageType AS StockCheckMessageType,
  _OrderComponent.BillOfMaterialCategory AS BillOfMaterialCategory,
  _OrderComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  _OrderComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  _OrderComponent.InheritedBOMItemNode AS InheritedBOMItemNode,
  cast( _OrderComponent.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) AS BillOfMaterialInternalID,
  _OrderComponent.BOMItem AS BOMItem,
  _OrderComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _OrderComponent.BOMItemCategory AS BOMItemCategory,
  _OrderComponent.FormulaKey AS FormulaKey,
  _OrderComponent.VariableSizeDimension1 AS VariableSizeDimension1,
  _OrderComponent.VariableSizeDimension2 AS VariableSizeDimension2,
  _OrderComponent.VariableSizeDimension3 AS VariableSizeDimension3,
  _OrderComponent.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  _OrderComponent.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  _OrderComponent.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyInstanceAssembledComp.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyInstanceAssembledComp.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyInstanceAssembledComp.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstceOpActyNtwkElmnt._OperationActivityText AS _OperationActivityText,
  OpActyInstceOpActyNtwkElmnt._MfgOrder AS _MfgOrder,
  _OrderComponent._BOMItemCategory AS _BOMItemCategory
FROM P_OpActyInstanceAssembledComp AS OpActyInstanceAssembledComp
INNER JOIN I_OpActyInstceNtwkElmntBasic AS OpActyInstceOpActyNtwkElmnt ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_MatlPlntCompAssembleControl AS MfgOrderProductPlant ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS OrderOperationBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
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_OpActyBOOOpBOMIndivItmAssgmt AS _OpActyBOOOpBOMIndivItmAssgmt ON OperationActivity = _OpActyBOOOpBOMIndivItmAssgmt.OperationActivity AND OperationActyVersionCounter = _OpActyBOOOpBOMIndivItmAssgmt.OperationActyVersionCounter AND BillOfOperationsType = _OpActyBOOOpBOMIndivItmAssgmt.BillOfOperationsType AND BillOfOperationsGroup = _OpActyBOOOpBOMIndivItmAssgmt.BillOfOperationsGroup AND BOOOpBOMItemInternalID = _OpActyBOOOpBOMIndivItmAssgmt.BOOOpBOMItemInternalID  -- association [0..*]
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_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
LEFT OUTER JOIN I_OrderComponent AS _OrderComponent ON Reservation = _OrderComponent.Reservation AND ReservationItem = _OrderComponent.ReservationItem AND RecordType = _OrderComponent.RecordType  -- association [0..1]
LEFT OUTER JOIN I_BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt ON MfgRefStrucBOMLeafAssgmtUUID = _BOMItmMfgRefStrucItmAssgmt.MfgRefStrucBOMLeafAssgmtUUID  -- association [0..1]
LEFT OUTER JOIN I_MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails ON MfgRefStructureItemDetailUUID = _MfgRefStrucItemWithDetails.MfgRefStructureItemUUID AND MfgRefStrucItmDetIsContextual = ''  -- association [0..1]
LEFT OUTER JOIN I_MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails ON MfgRefStructureItemDetailUUID = _MfgRefHierItemWithDetails.MfgRefHierarchyItemUUID AND MfgRefStrucItmDetIsContextual = 'X'  -- association [0..1]
;