I_ClfnObjectClassBasic

DDL: I_CLFNOBJECTCLASSBASIC SQL: INGCCLFN24 Type: view BASIC Package: NGC_CORE_VDM

Classification Class of Object

I_ClfnObjectClassBasic is a Basic CDS View that provides data about "Classification Class of Object" in SAP S/4HANA. It reads from 1 data source (kssk) and exposes 13 fields with key fields ClfnObjectID, ClfnObjectType, ClassType, ClassInternalID, TimeIntervalNumber. Part of development package NGC_CORE_VDM.

Data Sources (1)

SourceAliasJoin Type
kssk ObjectClass from

Annotations (11)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName INGCCLFN24 view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Classification Class of Object view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID kssk objek Object
KEY ClfnObjectType kssk mafid Record type
KEY ClassType kssk klart Class Type
KEY ClassInternalID kssk clint Int class no.
KEY TimeIntervalNumber kssk adzhl Int. counter
ClfnStatus kssk statu Vehicle Status
ValidityStartDate kssk datuv Valid-from date
ValidityEndDate kssk datub Valid to
IsDeleted kssk lkenz Deletion Ind.
ChangeNumber kssk aennr Change Number
ClassPositionNumber kssk zaehl Sort pos.
ClassIsStandardClass
BOMIsRecursive kssk rekri Recursive

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_ClfnObjectClassBasic.
-- 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: INGCCLFN24

CREATE VIEW I_ClfnObjectClassBasic AS
SELECT
  ObjectClass.objek AS ClfnObjectID,
  ObjectClass.mafid AS ClfnObjectType,
  ObjectClass.klart AS ClassType,
  ObjectClass.clint AS ClassInternalID,
  ObjectClass.adzhl AS TimeIntervalNumber,
  ObjectClass.statu AS ClfnStatus,
  ObjectClass.datuv AS ValidityStartDate,
  ObjectClass.datub AS ValidityEndDate,
  ObjectClass.lkenz AS IsDeleted,
  ObjectClass.aennr AS ChangeNumber,
  ObjectClass.zaehl AS ClassPositionNumber,
  cast ( ObjectClass.stdcl as classisstandardclass preserving type ) AS ClassIsStandardClass,
  ObjectClass.rekri AS BOMIsRecursive
FROM kssk AS ObjectClass
;