/APE/I_CheckActionTP_C

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/I_CheckActionTP_C.
-- 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/I_CheckActionTP_C AS
SELECT
  config_key,
  _ProcessCluster.proc_cluster AS proc_cluster,
  _CheckActionID.action_code AS action_code,
  priority,
  market_role,
  config_layer,
  created_at,
  created_by,
  changed_at,
  changed_by
FROM /APE/I_CheckAction_C
LEFT OUTER JOIN /APE/I_CheckActionCode_C AS _CheckActionID ON _CheckActionID.config_key = action_code_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessCluster_C AS _ProcessCluster ON _ProcessCluster.config_key = proc_cluster_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/I_CheckActionCodeText_C AS _CheckActionIDText ON _CheckActionIDText.ape_parent_key = action_code_uuid  -- association [1..*]
LEFT OUTER JOIN /APE/I_ProcessClusterText_C AS _ProcessClusterText ON _ProcessClusterText.ape_parent_key = proc_cluster_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _ConfigurationLayerText ON _ConfigurationLayerText.Name = '/APE/D_CONFIG_LAYER' AND _ConfigurationLayerText.ValueCode = config_layer  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _DeploymentTargetText ON _DeploymentTargetText.Name = '/APE/D_DEPLOYMENT_TARGET' AND _DeploymentTargetText.ValueCode = deploy_target  -- association [0..*]
LEFT OUTER JOIN /APE/I_MarketRoleTextTP_C AS _MarketRoleText ON _MarketRoleText.market_role = market_role  -- association [0..*]
;