I_EDCCheckIdVH

DDL: I_EDCCHECKIDVH Type: view_entity COMPOSITE
10 Fields 1 Data Sources 5 Associations

EDC Enabled CheckID

I_EDCCheckIdVH is a Composite CDS View that provides data about "EDC Enabled CheckID" in SAP S/4HANA. It reads from 1 data source (R_EDCValidationCheck) and exposes 10 fields with key fields EDCCompany, EDCType, EDCValidationType, EDCCheckCategory, EDCCheckID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_EDCValidationCheck _CheckID from

Associations (5)

CardinalityTargetAliasCondition
[0..1] R_EDCCheckIDText _CheckIdText _CheckIdText.EDCCheckID = _CheckID.EDCCheckID and _CheckIdText.Language = $session.system_language
[0..1] I_CompanyCode _CompCode _CompCode.CompanyCode = _CheckID.EDCCompany
[0..1] I_EDCTypeValueHelp _EDCType _EDCType.EDCCompany = _CheckID.EDCCompany and _EDCType.EDCType = _CheckID.EDCType
[0..1] I_EDCComparisonTypeVH _EDCComparisonType _EDCComparisonType.EDCCompany = _CheckID.EDCCompany and _EDCComparisonType.EDCType = _CheckID.EDCType and _EDCComparisonType.EDCValidationType = _CheckID.EDCValidationType
[0..1] I_EDCCheckCategoryVH _EDCCheckCategory _EDCCheckCategory.EDCCheckCategory = _CheckID.EDCCheckCategory

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label EDC Enabled CheckID view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
VDM.viewType #COMPOSITE view
Consumption.ranked true view
ObjectModel.representativeKey EDCCheckID view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EDCCompany EDCCompany Value
KEY EDCType EDCType Consistency Scen.
KEY EDCValidationType EDCValidationType Comparison Type
KEY EDCCheckCategory EDCCheckCategory Check Category
KEY EDCCheckID EDCCheckID Check ID
_CheckIdText _CheckIdText
_CompCode _CompCode
_EDCType _EDCType
_EDCComparisonType _EDCComparisonType
_EDCCheckCategory _EDCCheckCategory

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 I_EDCCheckIdVH.
-- 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 I_EDCCheckIdVH AS
SELECT
  EDCCompany,
  EDCType,
  EDCValidationType,
  EDCCheckCategory,
  EDCCheckID
FROM R_EDCValidationCheck AS _CheckID
LEFT OUTER JOIN R_EDCCheckIDText AS _CheckIdText ON _CheckIdText.EDCCheckID = _CheckID.EDCCheckID AND _CheckIdText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON _CompCode.CompanyCode = _CheckID.EDCCompany  -- association [0..1]
LEFT OUTER JOIN I_EDCTypeValueHelp AS _EDCType ON _EDCType.EDCCompany = _CheckID.EDCCompany AND _EDCType.EDCType = _CheckID.EDCType  -- association [0..1]
LEFT OUTER JOIN I_EDCComparisonTypeVH AS _EDCComparisonType ON _EDCComparisonType.EDCCompany = _CheckID.EDCCompany AND _EDCComparisonType.EDCType = _CheckID.EDCType AND _EDCComparisonType.EDCValidationType = _CheckID.EDCValidationType  -- association [0..1]
LEFT OUTER JOIN I_EDCCheckCategoryVH AS _EDCCheckCategory ON _EDCCheckCategory.EDCCheckCategory = _CheckID.EDCCheckCategory  -- association [0..1]
;

Learn More