/APE/I_CheckTP_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_CheckTP_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_CheckTP_C AS
SELECT
  config_key,
  _ProcessCluster.proc_cluster AS proc_cluster,
  check_id,
  class,
  method,
  brf_func_id,
  market_role,
  config_layer,
  created_at,
  created_by,
  changed_at,
  changed_by
FROM /APE/I_Check_C
LEFT OUTER JOIN /APE/I_ProcessCluster_C AS _ProcessCluster ON _ProcessCluster.config_key = proc_cluster_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessClusterText_C AS _ProcessClusterText ON _ProcessClusterText.ape_parent_key = proc_cluster_uuid  -- association [0..*]
LEFT OUTER JOIN /APE/I_MarketRoleText AS _MarketRoleText ON _MarketRoleText.market_role = market_role  -- 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_CheckTextTP_C AS _CheckText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN /APE/I_CheckResultAssignTP_C AS _CheckResultAssign ON /* condition not available in parsed metadata */  -- association [0..*]
;