I_CLFNCHARCVALUE

CDS View

Value of Classification Characteristic

I_CLFNCHARCVALUE is a CDS View in S/4HANA. Value of Classification Characteristic. It contains 30 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 30 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnCharcValueDEX view_entity from BASIC Value of Clfn Characteristic DEX
I_ClfnCharcValueForKeyDate view from COMPOSITE Value of Clfn Charc for Key Date
P_CharcCtlgClfnCharcValueBasic view from COMPOSITE
P_CharcCtlgClfnCValueInclDel1 view union COMPOSITE

Fields (30)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 2
KEY CharcValuePositionNumber CharcValuePositionNumber 2
KEY ValidityEndDate ValidityEndDate 2
ChangeNumber ChangeNumber 2
CharcFromAmount CharcFromAmount 2
CharcFromDate CharcFromDate 2
CharcFromDecimalValue CharcFromDecimalValue 2
CharcFromNumericValue CharcFromNumericValue 2
CharcFromNumericValueUnit CharcFromNumericValueUnit 2
CharcFromTime CharcFromTime 2
CharcToAmount CharcToAmount 2
CharcToDate CharcToDate 2
CharcToDecimalValue CharcToDecimalValue 2
CharcToNumericValue CharcToNumericValue 2
CharcToNumericValueUnit CharcToNumericValueUnit 2
CharcToTime CharcToTime 2
CharcValue CharcValue 2
CharcValueHasChild CharcValueHasChild 2
CharcValueIntervalType CharcValueDependency,CharcValueIntervalType 2
CharcValueParentPositionNumber CharcValueParentPositionNumber 2
Currency Currency 2
DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber 2
DocumentInfoRecordDocPart DocumentInfoRecordDocPart 2
DocumentInfoRecordDocType DocumentInfoRecordDocType 2
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion 2
IsDefaultValue IsDefaultValue 2
IsDeleted IsDeleted 1
LongTextID LongTextID 1
TimeIntervalNumber TimeIntervalNumber 1
ValidityStartDate ValidityStartDate 2 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'INGCCHR17'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Value of Classification Characteristic'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE ]
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC 
define view I_ClfnCharcValue
  as select from cawn as CharacteristicValue

      association [0..1] to I_Currency as _Currency
        on  $projection.Currency        = _Currency.Currency
        
{ 
  key cast ( CharacteristicValue.atinn as atinn_no_conv preserving type ) as CharcInternalID,
  key CharacteristicValue.atzhl as CharcValuePositionNumber,
  key CharacteristicValue.adzhl as TimeIntervalNumber,
      CharacteristicValue.atzhh as CharcValueParentPositionNumber,
      CharacteristicValue.atwhi as CharcValueHasChild,
      CharacteristicValue.atcod as CharcValueIntervalType,
      CharacteristicValue.atwrt as CharcValue,
      CharacteristicValue.atflv as CharcFromNumericValue,
      CharacteristicValue.atflb as CharcToNumericValue,
      CharacteristicValue.atstd as IsDefaultValue,
      CharacteristicValue.atawe as CharcFromNumericValueUnit,
      CharacteristicValue.ataw1 as CharcToNumericValueUnit,
      CharacteristicValue.dec_from as CharcFromDecimalValue,
      CharacteristicValue.dec_to as CharcToDecimalValue,
      CharacteristicValue.date_from as CharcFromDate,
      CharacteristicValue.date_to as CharcToDate,
      CharacteristicValue.time_from as CharcFromTime,
      CharacteristicValue.time_to as CharcToTime,
      @Semantics.amount.currencyCode: 'Currency'
      CharacteristicValue.curr_from as CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'
      CharacteristicValue.curr_to as CharcToAmount,
      @ObjectModel.foreignKey.association: '_Currency'
      @Semantics.currencyCode: true
      CharacteristicValue.currency as Currency,      
      CharacteristicValue.txtnr as LongTextID,
      CharacteristicValue.aennr as ChangeNumber,
      @Semantics.businessDate.from: true
      CharacteristicValue.datuv as ValidityStartDate,
      @Semantics.businessDate.to: true
      CharacteristicValue.datub as ValidityEndDate,
      CharacteristicValue.lkenz as IsDeleted,
      CharacteristicValue.doknr as DocumentInfoRecordDocNumber,
      CharacteristicValue.doktl as DocumentInfoRecordDocPart,
      CharacteristicValue.dokvr as DocumentInfoRecordDocVersion,    
      CharacteristicValue.dokar as DocumentInfoRecordDocType,
      CharacteristicValue.atidn as CharcIdentificationCode,

      _Currency
}

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

Learn More