P_OperationActivityPlndMatlRet

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_OperationActivityPlndMatlRet.
-- 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: PMPEOAPLNDMATRET

CREATE VIEW P_OperationActivityPlndMatlRet AS
SELECT
  OperationActyPlndMatlRetQts.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActyPlndMatlRetQts.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActyPlndMatlRetQts.Reservation AS Reservation,
  OperationActyPlndMatlRetQts.ReservationItem AS ReservationItem,
  OperationActyPlndMatlRetQts.RecordType AS RecordType,
  cast(OperationActyPlndMatlRetQts.Material as mpe_component_matnr preserving type ) AS Material,
  OperationActyPlndMatlRetQts.Plant AS Plant,
  OperationActyPlndMatlRetQts.StorageLocation AS StorageLocation,
  OperationActyPlndMatlRetQts.ProductionPlant AS ProductionPlant,
  OperationActyPlndMatlRetQts.ManufacturingOrder AS ManufacturingOrder,
  OperationActyPlndMatlRetQts.MaterialIsCoProduct AS MaterialIsCoProduct,
  OperationActyPlndMatlRetQts.ManufacturingOrderItem AS ManufacturingOrderItem,
  OperationActyPlndMatlRetQts.AssemblySequenceNumber AS AssemblySequenceNumber,
  OperationActyPlndMatlRetQts.BaseUnit AS BaseUnit,
  cast(round(fltp_to_dec( OperationActyPlndMatlRetQts.RequiredQuantity as abap.dec(13,4) ), 3) as co_menge ) as RequiredQuantity AS dec1343asco_mengeasRequiredQuantity,
  cast(OperationActyPlndMatlRetQts.MaterialComponentQuantity as returned_quantity preserving type ) AS MaterialComponentQuantity,
  OperationActyPlndMatlRetQts.QuantityInEntryUnit AS QuantityInEntryUnit,
  OperationActyPlndMatlRetQts.EntryUnit AS EntryUnit,
  OperationActyPlndMatlRetQts.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OperationActyPlndMatlRetQts.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OperationActyPlndMatlRetQts.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OperationActyPlndMatlRetQts.VariableSizeItemUnit AS VariableSizeItemUnit,
  OperationActyPlndMatlRetQts.FormulaKey AS FormulaKey,
  OperationActyPlndMatlRetQts.VariableSizeDimension1 AS VariableSizeDimension1,
  OperationActyPlndMatlRetQts.VariableSizeDimension2 AS VariableSizeDimension2,
  OperationActyPlndMatlRetQts.VariableSizeDimension3 AS VariableSizeDimension3,
  OperationActyPlndMatlRetQts.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  OperationActyPlndMatlRetQts.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OperationActyPlndMatlRetQts.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OperationActyPlndMatlRetQts.RelatedReservationItem AS RelatedReservationItem,
  OperationActyPlndMatlRetQts.RelatedRecordType AS RelatedRecordType,
  OperationActyPlndMatlRetQts.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OperationActyPlndMatlRetQts.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OperationActyPlndMatlRetQts.LeadingReservation AS LeadingReservation,
  OperationActyPlndMatlRetQts.LeadingReservationItem AS LeadingReservationItem,
  OperationActyPlndMatlRetQts.LeadingReservationRecordType AS LeadingReservationRecordType,
  OperationActyPlndMatlRetQts.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OperationActyPlndMatlRetQts.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OperationActyPlndMatlRetQts.BillOfMaterial AS BillOfMaterial,
  OperationActyPlndMatlRetQts.BOMItem AS BOMItem,
  OperationActyPlndMatlRetQts.BillOfMaterialVersion AS BillOfMaterialVersion,
  cast (OperationActyPlndMatlRetQts.BillOfMaterialInternalID as mpe_exec_stnum preserving type ) AS BillOfMaterialInternalID,
  OperationActyPlndMatlRetQts.BillOfMaterialVariant AS BillOfMaterialVariant,
  OperationActyPlndMatlRetQts.InheritedBOMItemNode AS InheritedBOMItemNode,
  OperationActyPlndMatlRetQts.BOMItemCategory AS BOMItemCategory,
  OperationActyPlndMatlRetQts.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OperationActyPlndMatlRetQts.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OperationActyPlndMatlRetQts.LogicalComponent AS LogicalComponent,
  OperationActyPlndMatlRetQts.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OperationActyPlndMatlRetQts.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OperationActyPlndMatlRetQts.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OperationActyPlndMatlRetQts.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OperationActyPlndMatlRetQts.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  OperationActyPlndMatlRetQts.PlannedInventoryUsabilityCode AS PlannedInventoryUsabilityCode,
  OperationActyPlndMatlRetQts.SerialNumberProfile AS SerialNumberProfile,
  OperationActyPlndMatlRetQts.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  OperationActyPlndMatlRetQts.StockCheckMessageType AS StockCheckMessageType,
  OperationActyPlndMatlRetQts.IsBatchManagementRequired AS IsBatchManagementRequired,
  OperationActyPlndMatlRetQts.MatlCompAssembleControl AS MatlCompAssembleControl,
  OperationActyPlndMatlRetQts.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OperationActyPlndMatlRetQts.EffectivityParameterVariant AS EffectivityParameterVariant,
  OperationActyPlndMatlRetQts.Assembly AS Assembly,
  OperationActyPlndMatlRetQts._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OperationActyPlndMatlRetQts._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OperationActyPlndMatlRetQts._OperationActivityInstance AS _OperationActivityInstance,
  OperationActyPlndMatlRetQts._ReservationHeader AS _ReservationHeader,
  OperationActyPlndMatlRetQts._BOMItemCategory AS _BOMItemCategory,
  OperationActyPlndMatlRetQts._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OperationActyPlndMatlRetQts._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OperationActyPlndMatlRetQts._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  OperationActyPlndMatlRetQts._MfgOrder AS _MfgOrder
FROM P_OperationActyPlndMatlRetQts AS OperationActyPlndMatlRetQts
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
LEFT OUTER JOIN I_CompDisassemblyPermanence AS _CompDisassemblyPermanence ON CompDisassemblyPermanence = _CompDisassemblyPermanence.CompDisassemblyPermanence  -- association [1..1]
;