/APE/C_Check

DDL: /APE/C_CHECK Type: view CONSUMPTION

Check ID

/APE/C_Check is a Consumption CDS View that provides data about "Check ID" in SAP S/4HANA. It reads from 1 data source (/APE/I_Check_TP) and exposes 9 fields. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_Check_TP /APE/I_Check_TP from

Associations (2)

CardinalityTargetAliasCondition
[1..*] /APE/C_CheckResultAssign _ResultAssign $projection.check_id_uuid = _ResultAssign.check_id_uuid
[0..1] /APE/C_CheckCust _CheckCust $projection.check_id_uuid = _CheckCust.check_id_uuid

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_VCHECK view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Check ID view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (9)

KeyFieldSource TableSource FieldDescription
proc_cluster proc_cluster
check_id check_id Question Check ID
class class User Group
method method Validation Method
brf_func_id brf_func_id BRFplus Func. ID
market_role market_role
config_layer config_layer
_ResultAssign _ResultAssign
_CheckCust _CheckCust

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_Check.
-- 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_Check AS
SELECT
  proc_cluster,
  check_id,
  class,
  method,
  brf_func_id,
  market_role,
  config_layer
FROM /APE/I_Check_TP
LEFT OUTER JOIN /APE/C_CheckResultAssign AS _ResultAssign ON check_id_uuid = _ResultAssign.check_id_uuid  -- association [1..*]
LEFT OUTER JOIN /APE/C_CheckCust AS _CheckCust ON check_id_uuid = _CheckCust.check_id_uuid  -- association [0..1]
;