/merp/core_Class_Def

DDL: /MERP/CORE_CLASS_KEY SQL: /MERP/CORE_CLASS Type: view Package: /MERP/OMDO_CA
8 Fields 2 Data Sources

CDS View: Classification Definition - Class Key

/merp/core_Class_Def is a CDS View that provides data about "CDS View: Classification Definition - Class Key" in SAP S/4HANA. It reads from 2 data sources (klah, swor) and exposes 8 fields with key field clint. Part of development package /MERP/OMDO_CA.

Data Sources (2)

SourceAliasJoin Type
klah klah from
swor swor left_outer

Parameters (2)

NameTypeDefault
p_langu spras
p_itemnum klapos

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName /MERP/CORE_CLASS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality P view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MASTER view
EndUserText.label CDS View: Classification Definition - Class Key view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY clint klah clint Int class no.
klart klah klart Class Type
class klah class User Group
statu klah statu Vehicle Status
klagr klah klagr Class group
sicht klah sicht View
verwe klah verwe Work Center Category
kschl swor kschl Tax Item Type

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 /merp/core_Class_Def.
-- 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: /MERP/CORE_CLASS
-- Parameters: p_langu : spras, p_itemnum : klapos

CREATE VIEW /merp/core_Class_Def AS
SELECT
  klah.clint AS clint,
  klah.klart AS klart,
  klah.class AS class,
  klah.statu AS statu,
  klah.klagr AS klagr,
  klah.sicht AS sicht,
  klah.verwe AS verwe,
  swor.kschl AS kschl
FROM klah
LEFT OUTER JOIN swor ON /* join condition not captured in parsed metadata */
;

Learn More