I_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 I_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: IMPEOAPLNDMATRET

CREATE VIEW I_OperationActivityPlndMatlRet AS
SELECT
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyComponentAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyComponentAssignment.Reservation AS Reservation,
  OpActyComponentAssignment.ReservationItem AS ReservationItem,
  OpActyComponentAssignment.RecordType AS RecordType,
  ReservationItem.matnr AS Material,
  ReservationItem.werks AS Plant,
  ReservationItem.pwerk AS ProductionPlant,
  cast(ReservationItem.lgort as pph_lgort preserving type) AS StorageLocation,
  cast(ReservationItem.aufnr as manufacturingorder preserving type) AS ManufacturingOrder,
  ReservationItem.kzkup AS MaterialIsCoProduct,
  ReservationItem.afpos AS ManufacturingOrderItem,
  OpActyComponentAssignment.AssemblySequenceNumber AS AssemblySequenceNumber,
  ReservationItem.meins AS BaseUnit,
  OpActyComponentAssignment.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  OpActyComponentAssignment.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageNetQty,
  cast( ReservationItem.schgt as boolean preserving type ) AS IsBulkMaterialComponent,
  cast( ReservationItem.rgekz as boolean preserving type ) AS MatlCompIsMarkedForBackflush,
  ReservationItem.xwaok AS GoodsMovementIsAllowed,
  ReservationItem.kzaus AS MatlCompDiscontinuationType,
  ReservationItem.roame AS VariableSizeItemUnit,
  ReservationItem.rform AS FormulaKey,
  ReservationItem.roms1 AS VariableSizeDimension1,
  ReservationItem.roms2 AS VariableSizeDimension2,
  ReservationItem.roms3 AS VariableSizeDimension3,
  ReservationItem.romei AS VariableSizeDimensionUnit,
  cast(ReservationItem.romen as pph_romen preserving type ) AS VariableSizeComponentQuantity,
  cast(ReservationItem.rokme as pph_rokme preserving type ) AS VariableSizeComponentUnit,
  ReservationItem.objnr AS MaterialComponentObject,
  ReservationItem.aufpl AS OrderInternalID,
  ReservationItem.aplzl AS OrderOperationInternalID,
  OpActyComponentAssignment.RelatedReservation AS RelatedReservation,
  OpActyComponentAssignment.RelatedReservationItem AS RelatedReservationItem,
  OpActyComponentAssignment.RelatedRecordType AS RelatedRecordType,
  OpActyComponentAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyComponentAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  ReservationItem.stlnr AS BillOfMaterialInternalID,
  ReservationItem.stlnr2 AS BillOfMaterial,
  ReservationItem.stlal AS BillOfMaterialVariant,
  ReservationItem.stvkn AS InheritedBOMItemNode,
  cast(ReservationItem.stlkn as pph_stlkn preserving type) AS BOMItem,
  ReservationItem.bom_versn AS BillOfMaterialVersion,
  ReservationItem.stpoz AS BOMItemInternalChangeCount,
  cast(ReservationItem.postp as pph_postp preserving type) AS BOMItemCategory,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyComponentAssignment.LogicalComponent AS LogicalComponent,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyComponentAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyComponentAssignment.MatlCompAssemblyIsNotRequired AS MatlCompAssemblyIsNotRequired,
  OpActyComponentAssignment.PlannedInventoryUsabilityCode AS PlannedInventoryUsabilityCode,
  ReservationItem.techs AS EffectivityParameterVariant,
  ReservationItem.baugr AS Assembly,
  OpActyComponentAssignment._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyComponentAssignment._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic,
  OpActyComponentAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OpActyComponentAssignment._ReservationHeader AS _ReservationHeader,
  OpActyComponentAssignment._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OpActyComponentAssignment._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyComponentAssignment._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
INNER JOIN P_MfgOrderOpReservationItem AS ReservationItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
;