I_CLFNOBJECTCHARCVALUEBASIC

CDS View

Clfn Obj Characteristic Valuation Basic

I_CLFNOBJECTCHARCVALUEBASIC is a CDS View in S/4HANA. Clfn Obj Characteristic Valuation Basic. It contains 27 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 27 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnObjectCharcValue view from BASIC Clfn Characteristic Value of Object
I_ClfnObjectCharcValueDEX view_entity from BASIC Clfn Characteristic Value of Object DEX
I_MCHierNodeCVRstrn view_entity inner BASIC MCHN Characteristic Value Restriction
I_MrchdsCatCharcValRstrcn view_entity inner BASIC Charcteristic Value Restriction

Fields (27)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 2
KEY CharcValuePositionNumber CharcValuePositionNumber,ClfnCharcValuePositionNumber 4
KEY ClassType ClassType 2
KEY ClfnObjectType ClfnObjectType 2
KEY TimeIntervalNumber TimeIntervalNumber 2
ChangeNumber ChangeNumber 2
CharacteristicAuthor CharacteristicAuthor,CharcAuthor 2
CharcFromAmount CharcFromAmount 4
CharcFromDate CharcFromDate 4
CharcFromDecimalValue CharcFromDecimalValue 4
CharcFromNumericValue CharcFromNumericValue 4
CharcFromNumericValueUnit CharcFromNumericValueUnit 4
CharcFromTime CharcFromTime 4
CharcToAmount CharcToAmount 4
CharcToDate CharcToDate 4
CharcToDecimalValue CharcToDecimalValue 4
CharcToNumericValue CharcToNumericValue 4
CharcToNumericValueUnit CharcToNumericValueUnit 4
CharcToTime CharcToTime 4
CharcValue CharcValue 4
CharcValueIntervalType CharcValueDependency,CharcValueIntervalType 4
CharcValueSortPosition CharcValueSortPosition 2
ClfnObjectID ClfnObjectID 2
Currency Currency 4
IsDeleted IsDeleted 4
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'INGCCLFN23'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Clfn Obj Characteristic Valuation Basic'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC
define view I_ClfnObjectCharcValueBasic
  as select from ausp as Valuation
{
  key Valuation.objek               as ClfnObjectID,
  key cast ( Valuation.atinn as atinn_no_conv preserving type ) as CharcInternalID,
  key Valuation.atzhl               as CharcValuePositionNumber,
  key Valuation.mafid               as ClfnObjectType,
  key Valuation.klart               as ClassType,
  key Valuation.adzhl               as TimeIntervalNumber,            
      Valuation.atcod               as CharcValueIntervalType,
      Valuation.atcod               as CharcValueDependency,       // deprecated, use CharcValueIntervalType

      Valuation.atwrt               as CharcValue,
      Valuation.atflv               as CharcFromNumericValue,  
      Valuation.atawe               as CharcFromNumericValueUnit,
      Valuation.atflb               as CharcToNumericValue,     
      Valuation.ataw1               as CharcToNumericValueUnit,
      Valuation.dec_value_from      as CharcFromDecimalValue,
      Valuation.dec_value_to        as CharcToDecimalValue,      
      @Semantics.amount.currencyCode: 'Currency'      
      Valuation.curr_value_from     as CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'  
      Valuation.curr_value_to       as CharcToAmount,
      Valuation.currency            as Currency,
      Valuation.date_from           as CharcFromDate,
      Valuation.date_to             as CharcToDate,
      Valuation.time_from           as CharcFromTime,
      Valuation.time_to             as CharcToTime, 
      Valuation.ataut               as CharacteristicAuthor,      
      Valuation.aennr               as ChangeNumber,
      Valuation.atsrt               as CharcValueSortPosition,
      Valuation.datuv               as ValidityStartDate,
      Valuation.datub               as ValidityEndDate,
      Valuation.lkenz               as IsDeleted
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUSP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More