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 28 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 28 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnObjectCharcValForKeyDate view from COMPOSITE Clfn Charc Val of Obj for Key Date
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 (28)

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 1
KEY ClfnObjectType ClfnObjectType 1
CharacteristicAuthor CharacteristicAuthor,CharcAuthor 2
CharcFromAmount CharcFromAmount 2
CharcFromDate CharcFromDate 2
CharcFromDecimalValue CharcFromDecimalValue 2
CharcFromNumericValue CharcFromNumericValue 2
CharcFromNumericValueUnit CharacteristicMinimumValueUnit,CharcFromNumericValueDspUnit,CharcFromNumericValueUnit 3
CharcFromTime CharcFromTime 2
CharcToAmount CharcToAmount 2
CharcToDate CharcToDate 2
CharcToDecimalValue CharcToDecimalValue 2
CharcToNumericValue CharcToNumericValue 2
CharcToNumericValueUnit CharacteristicMaximumValueUnit,CharcToNumericValueDspUnit,CharcToNumericValueUnit 3
CharcToTime CharcToTime 2
CharcValue CharacteristicValue,CharcValue 3
CharcValueIntervalType CharacteristicValueDpndcyCode,CharcValueDependency,CharcValueIntervalType 3
ClfnObjectInternalID ClfnObjectInternalID 2
Currency Currency 2
IsDeleted IsDeleted 1
LastChangeDateTime LastChangeDateTime 2
ValidityEndDate CharcValidityEndDate,ValidityEndDate 3
ValidityStartDate CharcValidityStartDate,ValidityStartDate 3 
@AccessControl.authorizationCheck: #MANDATORY
@AbapCatalog.sqlViewName: 'INGCCLFN11'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Clfn Characteristic Value of Object'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_FACT
@ObjectModel.supportedCapabilities:
   [ #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,  
     #SQL_DATA_SOURCE ]
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
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      

    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
    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.CharcValue,
      Valuation.CharcFromNumericValue,  
      Valuation.CharcFromNumericValueUnit,
      Valuation.CharcToNumericValue,     
      Valuation.CharcToNumericValueUnit,
      Valuation.CharcFromDecimalValue,
      Valuation.CharcToDecimalValue,
      @Semantics.amount.currencyCode: 'Currency'
      Valuation.CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'
      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