CLS_C_T604T

DDL: CLS_C_T604T SQL: CLS_V_T604T Type: view

Proxy Object for T604T

CLS_C_T604T is a CDS View that provides data about "Proxy Object for T604T" in SAP S/4HANA. It reads from 4 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_TrdClassfctnNmbrSchmCntnt, I_TrdClassfctnNmbrSchmUsge, P_CommodityCodeOfclDescTblFunc) and exposes 10 fields with key fields spras, land1, stawn.

Data Sources (4)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _Activation inner
I_TrdClassfctnNmbrSchmCntnt _Content inner
I_TrdClassfctnNmbrSchmUsge _Usage inner
P_CommodityCodeOfclDescTblFunc P_CommodityCodeOfclDescTblFunc from

Annotations (8)

NameValueLevelField
EndUserText.label Proxy Object for T604T view
ObjectModel.dataCategory #TEXT view
AbapCatalog.sqlViewName CLS_V_T604T view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY spras langu Primary lang.
KEY land1 I_TrdClassfctnNmbrSchmUsge Country Venue: Ctry/Reg
KEY stawn
text1 text1 Vertikalization Text
text2 text2 Vertikalization Text
text3 text3 Vertikalization Text
text4 text4 Vertikalization Text
text5 text5 Vertikalization Text
text6 text6 Name
text7 text7 Name

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 CLS_C_T604T.
-- 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: CLS_V_T604T

CREATE VIEW CLS_C_T604T AS
SELECT
  langu AS spras,
  _Usage.Country AS land1,
  cast (cmmdty as stawn) AS stawn,
  text1,
  text2,
  text3,
  text4,
  text5,
  text6,
  text7
FROM P_CommodityCodeOfclDescTblFunc
INNER JOIN I_TrdClassfctnNmbrSchmCntntAct AS _Activation ON /* join condition not captured in parsed metadata */
INNER JOIN I_TrdClassfctnNmbrSchmCntnt AS _Content ON /* join condition not captured in parsed metadata */
INNER JOIN I_TrdClassfctnNmbrSchmUsge AS _Usage ON /* join condition not captured in parsed metadata */
;