P_ProcurementAlternative

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_ProcurementAlternative.
-- 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: PPROCMTALTV

CREATE VIEW P_ProcurementAlternative AS
SELECT
  cast(kalnr as ckml_alprocnr) AS ProcurementAlternative,
  cast(bwkey as bwkey) AS ValuationArea,
  werks AS Plant,
  prwrk_nd AS ProductionPlant,
  cast(matnr as productnumber) AS Material,
  cast(btyp as ckml_btyp) AS ProcessCategory,
  cast(proc_kalnr as ckml_f_procnr) AS ProcurementProcess,
  cast(verid_nd as verid) AS ProductionVersion,
  cast(plwrk_nd as vpwrk) AS PlanningPlant,
  cast(stlan_nd as stlan) AS SourceBOMUsage,
  cast(stlal_nd as stlal) AS SourceBOMAlternative,
  cast(plnty_nd as plnty) AS TaskListType,
  cast(plnnr_nd as plnnr) AS TaskListGroup,
  cast(plnal_nd as plnal) AS TaskListGroupCounter,
  cast(lifnr_nd as lifnr) AS Supplier,
  cast(ekorg_nd as ekorg) AS PurchasingOrganization,
  spez_name_nd
FROM ckmlmv001
;