R_EvtBsdRptvMfgProdnProcess

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 R_EvtBsdRptvMfgProdnProcess.
-- 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: REBREMPRODPROC

CREATE VIEW R_EvtBsdRptvMfgProdnProcess AS
SELECT
  cast(ProductionProcess.kalnr as ckml_alprocnr) AS ProcurementAlternative,
  ProductionProcess.werks AS Plant,
  cast(ProductionProcess.matnr as productnumber) AS Product,
  cast(ProductionProcess.btyp as ckml_btyp) AS ProcessCategory,
  cast(ProductionProcess.proc_kalnr as ckml_f_procnr) AS ProductionProcess,
  cast(ProductionProcess.verid_nd as verid) AS ProductionVersion,
  cast(ProductionProcess.stlan_nd as stlan) AS SourceBOMUsage,
  cast(ProductionProcess.stlal_nd as stlal) AS SourceBOMAlternative,
  cast(ProductionProcess.plnty_nd as plnty) AS TaskListType,
  cast(ProductionProcess.plnnr_nd as plnnr) AS TaskListGroup,
  cast(ProductionProcess.plnal_nd as plnal) AS TaskListGroupCounter
FROM ckmlmv001 AS ProductionProcess
INNER JOIN I_ProductCostCtrlgOrder AS _OrderMaster ON /* join condition not captured in parsed metadata */
;