S_Ccl_Code_T_A

DDL: S_CCL_CODE_T_A SQL: S_V_CCL_CODE_T_A Type: view
7 Fields 1 Data Sources 2 Associations

Code List Code Value Text Core View

S_Ccl_Code_T_A is a CDS View that provides data about "Code List Code Value Text Core View" in SAP S/4HANA. It reads from 1 data source (sccl_code_t) and exposes 7 fields with key fields CodeListID, Code, Language. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
sccl_code_t sccl_code_t from

Associations (2)

CardinalityTargetAliasCondition
[1..1] S_Ccl_Code_A _Code $projection.CodeListID = _Code.CodeListID and $projection.Code = _Code.Code
[1..1] S_Ccl_List_A _List $projection.CodeListID = _List.CodeListID

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName S_V_CCL_CODE_T_A view
ClientDependent false view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Code List Code Value Text Core View view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CodeListID codelistid Code List ID
KEY Code code Water Hazard Cl.
KEY Language language Report Text Language
Description description Well Code Des.
Transported transported Truth Value
_List _List
_Code _Code

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 S_Ccl_Code_T_A.
-- 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.
-- SQL view name: S_V_CCL_CODE_T_A

CREATE VIEW S_Ccl_Code_T_A AS
SELECT
  CodeListID,
  Code,
  Language,
  Description,
  Transported
FROM sccl_code_t
LEFT OUTER JOIN S_Ccl_Code_A AS _Code ON CodeListID = _Code.CodeListID AND Code = _Code.Code  -- association [1..1]
LEFT OUTER JOIN S_Ccl_List_A AS _List ON CodeListID = _List.CodeListID  -- association [1..1]
;

Learn More