I_CLFNOBJECTCLASS

CDS View

Classification Class of Object

I_CLFNOBJECTCLASS is a CDS View in S/4HANA. Classification Class of Object. It contains 15 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 15 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ClfnObjectClassForKeyDate view from COMPOSITE Clfn Class of Object for Key Date
R_ClfnHistlObjectClassTP view_entity from TRANSACTIONAL Clfn Historical Object Class - TP
R_ClfnObjectTP view_entity from TRANSACTIONAL Classification Object - TP

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ChangeNumber ChangeNumber 2
KEY ClassInternalID ClassInternalID 2
KEY ClassType ClassType 2
KEY ClfnObjectID ClfnObjectID 3
KEY ClfnObjectTable ClfnObjectTable 3
_Class _Class 1
BOMIsRecursive BOMIsRecursive 1
ClassIsStandardClass ClassIsStandardClass 2
ClassPositionNumber ClassPositionNumber 2
ClfnObjectInternalID ClfnObjectInternalID 2
ClfnStatus ClfnStatus 2
IsDeleted IsDeleted 1
LastChangeDateTime LastChangeDateTime 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2 
@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'

Learn More