I_SCCL_CODE_T_TP

DDL: I_SCCL_CODE_T_TP SQL: I_V_SCCL_CDT_TP Type: view
8 Fields 1 Data Sources 2 Associations

Code List Code Value Description BO View

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

Data Sources (1)

SourceAliasJoin Type
S_Ccl_Code_T_A S_Ccl_Code_T_A from

Associations (2)

CardinalityTargetAliasCondition
[1..1] i_SCcl_Code_TP _Code $projection.CodeListID = _Code.CodeListID and $projection.Code = _Code.Code
[1..1] i_sccl_list_tp _List $projection.CodeListID = _List.CodeListID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName I_V_SCCL_CDT_TP view
ClientDependent false view
ObjectModel.writeDraftPersistence SCCL_D2_CODE_T view
ObjectModel.dataCategory #TEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Code List Code Value Description BO View view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CodeListID CodeListID Code List ID
KEY Code Code Water Hazard Cl.
KEY Language Language Report Text Language
LanguageForEdit 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 I_SCCL_CODE_T_TP.
-- 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: I_V_SCCL_CDT_TP

CREATE VIEW I_SCCL_CODE_T_TP AS
SELECT
  CodeListID,
  Code,
  Language,
  Language AS LanguageForEdit,
  Description,
  Transported
FROM S_Ccl_Code_T_A
LEFT OUTER JOIN i_SCcl_Code_TP AS _Code ON CodeListID = _Code.CodeListID AND Code = _Code.Code  -- association [1..1]
LEFT OUTER JOIN i_sccl_list_tp AS _List ON CodeListID = _List.CodeListID  -- association [1..1]
;

Learn More