/APE/C_ProcessStepMapBuffered

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 /APE/C_ProcessStepMapBuffered.
-- 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.

CREATE VIEW /APE/C_ProcessStepMapBuffered AS
SELECT
  StepMap.config_key AS config_key,
  StepMap.ape_root_key AS ape_root_key,
  PredProcId.proc_id AS src_proc_id,
  PredVersion.version AS src_version,
  StepMap.map_no AS map_no,
  StepMap.mandatory AS mandatory,
  StepMap.source_path AS source_path,
  StepMap.source_field AS source_field,
  StepMap.source_value AS source_value,
  StepMap.target_path AS target_path,
  StepMap.target_field AS target_field,
  StepMap.map_method AS map_method
FROM /ape/prstpmap AS StepMap
INNER JOIN /ape/prstpcond AS StepCond ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/prstp AS PredStep ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/proc AS PredProc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/procid AS PredProcId ON PredProc.proc_id_uuid = PredProcId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS PredProcCluster ON PredProc.proc_cluster_uuid = PredProcCluster.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/version AS PredVersion ON PredProc.version_uuid = PredVersion.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/prstpid AS PredStepId ON PredStep.proc_step_id_uuid = PredStepId.config_key  -- association [0..1]
;