I_ClfnObjectClass

DDL: I_CLFNOBJECTCLASS SQL: INGCCLFN9 Type: view BASIC

Classification Class of Object

I_ClfnObjectClass is a Basic CDS View that provides data about "Classification Class of Object" in SAP S/4HANA. It reads from 2 data sources (I_ClfnObjectClassBasic, P_ClfnObjectHeader) and exposes 16 fields with key fields ClfnObjectID, ClfnObjectTable, ClassInternalID, ClassType, TimeIntervalNumber. It has 1 association to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_ClfnObjectClassBasic ObjectClassBasic from
P_ClfnObjectHeader ObjectHeader inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ClfnClass _Class $projection.ClassInternalID = _Class.ClassInternalID and $projection.ValidityStartDate <= _Class.ValidityEndDate and $projection.ValidityEndDate >= _Class.ValidityStartDate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName INGCCLFN9 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Classification Class of Object view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID P_ClfnObjectHeader ClfnObjectID
KEY ClfnObjectTable P_ClfnObjectHeader ClfnObjectTable
KEY ClassInternalID I_ClfnObjectClassBasic ClassInternalID
KEY ClassType I_ClfnObjectClassBasic ClassType
KEY TimeIntervalNumber I_ClfnObjectClassBasic TimeIntervalNumber
ClfnObjectInternalID P_ClfnObjectHeader ClfnObjectInternalID
ClfnStatus I_ClfnObjectClassBasic ClfnStatus
ClassPositionNumber I_ClfnObjectClassBasic ClassPositionNumber
ClassIsStandardClass I_ClfnObjectClassBasic ClassIsStandardClass
BOMIsRecursive I_ClfnObjectClassBasic BOMIsRecursive
IsDeleted I_ClfnObjectClassBasic IsDeleted
ChangeNumber I_ClfnObjectClassBasic ChangeNumber
ValidityStartDate I_ClfnObjectClassBasic ValidityStartDate
ValidityEndDate I_ClfnObjectClassBasic ValidityEndDate
LastChangeDateTime P_ClfnObjectHeader LastChangeDateTime
_Class _Class 
@AbapCatalog.sqlViewName: 'INGCCLFN9'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Classification Class of Object'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API     
define view I_ClfnObjectClass
  as select from I_ClfnObjectClassBasic as ObjectClassBasic
    inner join P_ClfnObjectHeader as ObjectHeader
      on  ObjectClassBasic.ClassType      = ObjectHeader.ClassType
      and ObjectClassBasic.ClfnObjectType = ObjectHeader.ClfnObjectType
      and ObjectClassBasic.ClfnObjectID   = ObjectHeader.objekp   

      association [1..1] to I_ClfnClass as _Class 
        on $projection.ClassInternalID    = _Class.ClassInternalID  
       and $projection.ValidityStartDate <= _Class.ValidityEndDate
       and $projection.ValidityEndDate   >= _Class.ValidityStartDate    
{
  key ObjectHeader.ClfnObjectID,
  key ObjectHeader.ClfnObjectTable,
  key ObjectClassBasic.ClassInternalID,
  key ObjectClassBasic.ClassType,
  key ObjectClassBasic.TimeIntervalNumber,
      ObjectHeader.ClfnObjectInternalID,
      ObjectClassBasic.ClfnStatus,
      ObjectClassBasic.ClassPositionNumber,
      ObjectClassBasic.ClassIsStandardClass,
      ObjectClassBasic.BOMIsRecursive,
      ObjectClassBasic.IsDeleted,                  
      ObjectClassBasic.ChangeNumber,
      ObjectClassBasic.ValidityStartDate,
      ObjectClassBasic.ValidityEndDate,
      ObjectHeader.LastChangeDateTime,
      
      _Class
}  
  where ObjectClassBasic.ClfnObjectType = 'O'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNOBJECTCLASSBASIC",
"P_CLFNOBJECTHEADER"
],
"ASSOCIATED":
[
"I_CLFNCLASS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More