I_CLFNOBJECTCHARCVALUE

CDS View

Clfn Characteristic Value of Object

I_CLFNOBJECTCHARCVALUE is a CDS View in S/4HANA. Clfn Characteristic Value of Object. It contains 31 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 31 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ClfnObjectCharcValForKeyDate view from COMPOSITE Clfn Charc Val of Obj for Key Date
I_DFS_SenstvyClfnCharcVal view_entity from BASIC Classification Basic Info
I_ProdSpecPrptyCharcValue view inner COMPOSITE Product Specification Property Value by Characteristic
I_SpecCharByValueAssgmtInst view inner COMPOSITE Specification Characteristic by VAI
R_ClfnHistlObjectCharcValTP view_entity from TRANSACTIONAL Clfn Historical Object Charc Val - TP

Fields (31)

KeyField CDS FieldsUsed in Views
KEY ChangeNumber ChangeNumber 2
KEY CharcInternalID CharacteristicInternalID,CharcInternalID 4
KEY CharcValuePositionNumber CharcValuePositionNumber,ClfnCharcValuePositionNumber 4
KEY ClassType ClassType 2
KEY ClfnObjectID ClfnObjectID 2
KEY ClfnObjectTable ClfnObjectTable 2
KEY ClfnObjectType ClfnObjectType 1
KEY TimeIntervalNumber TimeIntervalNumber 1
_Characteristic _Characteristic 1
CharacteristicAuthor CharacteristicAuthor,CharcAuthor 2
CharcFromAmount CharcFromAmount 3
CharcFromDate CharcFromDate 3
CharcFromDecimalValue CharcFromDecimalValue 3
CharcFromNumericValue CharcFromNumericValue 2
CharcFromNumericValueUnit CharacteristicMinimumValueUnit,CharcFromNumericValueUnit 3
CharcFromTime CharcFromTime 3
CharcToAmount CharcToAmount 3
CharcToDate CharcToDate 3
CharcToDecimalValue CharcToDecimalValue 3
CharcToNumericValue CharcToNumericValue 2
CharcToNumericValueUnit CharacteristicMaximumValueUnit,CharcToNumericValueUnit 3
CharcToTime CharcToTime 3
CharcValue CharacteristicValue,CharcValue 3
CharcValueDependency CharacteristicValueDpndcyCode 1
CharcValueIntervalType CharcValueDependency,CharcValueIntervalType 2
ClfnObjectInternalID ClfnObjectInternalID 2
Currency Currency 3
IsDeleted IsDeleted 1
LastChangeDateTime LastChangeDateTime 2
ValidityEndDate CharcValidityEndDate,ValidityEndDate 3
ValidityStartDate CharcValidityStartDate,ValidityStartDate 3 
@AbapCatalog.sqlViewName: 'INGCCLFN11'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Clfn Characteristic Value 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_ClfnObjectCharcValue
  as select from I_ClfnObjectCharcValueBasic as Valuation
    inner join P_ClfnObjectHeader as ObjectHeader
      on  Valuation.ClassType      = ObjectHeader.ClassType
      and Valuation.ClfnObjectType = ObjectHeader.ClfnObjectType
      and Valuation.ClfnObjectID   = ObjectHeader.objekp      

    association [1..1] to I_ClfnCharacteristic as _Characteristic 
       // Usage of validity start and end date replaces key field TimeIntervalNumber of characteristic in the condition 

      on $projection.CharcInternalID    = _Characteristic.CharcInternalID   
     and $projection.ValidityStartDate <= _Characteristic.ValidityEndDate
     and $projection.ValidityEndDate   >= _Characteristic.ValidityStartDate        
                    
{
  key ObjectHeader.ClfnObjectID,
  key ObjectHeader.ClfnObjectTable,
  key Valuation.CharcInternalID,
  key Valuation.CharcValuePositionNumber,
  key Valuation.ClfnObjectType,
  key Valuation.ClassType,
  key Valuation.TimeIntervalNumber,
      ObjectHeader.ClfnObjectInternalID,            
      Valuation.CharcValueIntervalType,
      Valuation.CharcValueIntervalType as CharcValueDependency,       // deprecated, use CharcValueIntervalType

      Valuation.CharcValue,
      Valuation.CharcFromNumericValue,  
      Valuation.CharcFromNumericValueUnit,
      Valuation.CharcToNumericValue,     
      Valuation.CharcToNumericValueUnit,
      Valuation.CharcFromDecimalValue,
      Valuation.CharcToDecimalValue,
      Valuation.CharcFromAmount,
      Valuation.CharcToAmount,
      Valuation.Currency,
      Valuation.CharcFromDate,
      Valuation.CharcToDate,
      Valuation.CharcFromTime,
      Valuation.CharcToTime, 
      Valuation.CharacteristicAuthor,   
      Valuation.IsDeleted,
      Valuation.ChangeNumber, 
      Valuation.CharcValueSortPosition,
      Valuation.ValidityStartDate,
      Valuation.ValidityEndDate,          
      ObjectHeader.LastChangeDateTime,
        
     _Characteristic
}

Learn More