I_RoutingOrderSpecificComp

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_RoutingOrderSpecificComp.
-- 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: IRTGODRCMP

CREATE VIEW I_RoutingOrderSpecificComp AS
SELECT
  rtgvcmp.plnty AS BillOfOperationsType,
  rtgvcmp.plnnr AS BillOfOperationsGroup,
  rtgvcmp.plnal AS BillOfOperationsVariant,
  rtgvcmp.versn AS BillOfOperationsVersion,
  rtgvcmp.delta_cmp_cnt AS OrdSpcfcBOONumberOfBOMItem,
  rtgvcmp.delta_type AS OrdSpcfcBOOBOMItemType,
  rtgvcmp.aufnr AS ProductionOrder,
  rtgvcmp.stlan AS MBOMUsage,
  rtgvcmp.werks AS Plant,
  rtgvcmp.matnr AS Material,
  rtgvcmp.stlty AS BillOfMaterialCategory,
  cast (rtgvcmp.stlnr as mpe_exec_stnum preserving type) AS BillOfMaterial,
  cast( rtgvcmp.stlal as stlal preserving type ) AS AlternativeBillOfMaterial,
  rtgvcmp.bom_versn AS BillOfMaterialVersion,
  rtgvcmp.stlkn AS BOMItem,
  rtgvcmp.stvkn AS BOMItemReferenceID,
  rtgvcmp.stvkn_versn AS ProdnRtgOpBOMItemIntVersion,
  rtgvcmp.stlkn_reference AS OrdSpcfcBOOCompBOMItemRef,
  rtgvcmp.top_ref_stlkn AS TopReferenceBillOfMaterialItem,
  rtgvcmp.insmk AS StockType,
  rtgvcmp.assembly_type AS ComponentAssemblyType,
  rtgvcmp.oan_element_number AS OpActyNtwkElement,
  cast( rtgvcmp.idnrk as idnrk preserving type ) AS BillOfMaterialComponent,
  rtgvcmp.pswrk AS IssuingPlant,
  rtgvcmp.postp AS BillOfMaterialItemCategory,
  cast( rtgvcmp.posnr as vdm_sposn preserving type ) AS BillOfMaterialItemNumber,
  rtgvcmp.matkl AS MaterialGroup,
  rtgvcmp.meins AS PlanningMaterialBaseUnit,
  rtgvcmp.menge AS BillOfMaterialItemQuantity,
  rtgvcmp.fmeng AS QuantityIsFixed,
  rtgvcmp.ausch AS ComponentScrapPercent,
  rtgvcmp.avoau AS OperationScrapPercent,
  rtgvcmp.netau AS IsNetScrap,
  rtgvcmp.schgt AS IsBulkMaterial,
  rtgvcmp.lgort AS ProdOrderIssueLocation,
  rtgvcmp.itsob AS BOMItemSpecialProcurementType,
  rtgvcmp.prvbe AS ProductionSupplyArea,
  rtgvcmp.potx1 AS BOMItemText1,
  rtgvcmp.potx2 AS BOMItemText2,
  rtgvcmp.created_by AS CreatedByUser,
  rtgvcmp.created_at AS CreationDateTime,
  rtgvcmp.changed_by AS LastChangedByUser,
  rtgvcmp.changed_at AS LastChangeDateTime,
  cast(0 as roanz) AS VariableSizeItemQuantity,
  cast(0 as roms1) AS VariableSizeDimension1,
  cast(0 as roms2) AS VariableSizeDimension2,
  cast(0 as roms3) AS VariableSizeDimension3,
  cast('' as romei) AS VariableSizeDimensionUnit,
  cast(0 as romen) AS QuantityVariableSizeItem,
  cast('' as rform) AS VariableSizeCompFormulaKey
FROM mpe_rtgv_ord_cmp AS rtgvcmp
;