I_ClfnClassStatus

DDL: I_CLFNCLASSSTATUS SQL: INGCCLC3 Type: view BASIC Package: NGC_CORE_VDM
5 Fields 1 Data Sources 2 Associations

Status of Classification Class

I_ClfnClassStatus (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Classification Class Status · R&D Engineering

I_ClfnClassStatus is a Basic CDS View (Dimension) that provides data about "Status of Classification Class" in SAP S/4HANA. It reads from 1 data source (tclu) and exposes 5 fields with key fields ClassType, ClassStatus. It has 2 associations to related views. Part of development package NGC_CORE_VDM.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessR&D Engineering
Application ComponentCA-CL-2CL
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Analytical Dimension,Data Source in SQL Select
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageR&D/Engineering for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tclu ClassStatus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ClfnClassTypeBasic _ClassType $projection.ClassType = _ClassType.ClassType
[0..*] I_ClfnClassStatusText _ClassStatusText

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName INGCCLC3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Status of Classification Class view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ClassStatus view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.sapObjectNodeType.name ClassificationClassStatus view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ClassType tclu klart Class Type
KEY ClassStatus tclu status Workflow Status
ClassificationIsAllowed Classification Is Allowed Indicator
_ClassType _ClassType
_ClassStatusText _ClassStatusText

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_ClfnClassStatus.
-- 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: INGCCLC3

CREATE VIEW I_ClfnClassStatus AS
SELECT
  ClassStatus.klart AS ClassType,
  ClassStatus.status AS ClassStatus,
  cast ( ClassStatus.klfkz as classificationisallowed preserving type ) AS ClassificationIsAllowed
FROM tclu AS ClassStatus
LEFT OUTER JOIN I_ClfnClassTypeBasic AS _ClassType ON ClassType = _ClassType.ClassType  -- association [0..1]
LEFT OUTER JOIN I_ClfnClassStatusText AS _ClassStatusText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More