I_CLFNCHARCVALUEDESC

CDS View

Clfn Characteristic Value Description

I_CLFNCHARCVALUEDESC is a CDS View in S/4HANA. Clfn Characteristic Value Description. It contains 9 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 9 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnCharcValueDescDEX view_entity from BASIC Clfn Charc Value Description DEX
I_ClfnCharcValueDescForKeyDate view from COMPOSITE Desc of Clfn Charc Val for Key Date
P_CharcCtlgClfnCValueDesc view_entity from COMPOSITE Charac Catalog Classification Charac Value Descriptions
R_ClfnHistlClChVlDscOvrwrtnTP view_entity from TRANSACTIONAL Clfn Histl Class Charc Val Desc Overwritten - TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ChangeNumber ChangeNumber 3
KEY CharcInternalID CharcInternalID,OverwrittenCharcInternalID 2
KEY CharcValuePositionNumber CharcValuePositionNumber 3
KEY Language Language 3
KEY ValidityEndDate ValidityEndDate 3
CharcValueDescription CharcValueDescription 4
IsDeleted IsDeleted 2
TimeIntervalNumber TimeIntervalNumber 2
ValidityStartDate ValidityStartDate 3 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'INGCCHR18'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Clfn Characteristic Value Description'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities:
  [  #LANGUAGE_DEPENDENT_TEXT,
     #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API     
@VDM.viewType: #BASIC     
define view I_ClfnCharcValueDesc  as select from cawnt as CharacteristicValueDesc
  
      association [0..1] to I_Language as _Language 
        on $projection.Language = _Language.Language
             
{
  key   cast ( CharacteristicValueDesc.atinn as atinn_no_conv preserving type ) as CharcInternalID,
        @ObjectModel.foreignKey.association: null
  key   CharacteristicValueDesc.atzhl as CharcValuePositionNumber,
        @ObjectModel.foreignKey.association: '_Language'
        @Semantics.language: true
  key   CharacteristicValueDesc.spras as Language,
        @ObjectModel.foreignKey.association: null
  key   CharacteristicValueDesc.adzhl as TimeIntervalNumber,
        @Semantics.text: true
        CharacteristicValueDesc.atwtb as CharcValueDescription,
//        CharacteristicValueDesc.techv as TechnicalStatusForm,

        CharacteristicValueDesc.aennr as ChangeNumber,
        @Semantics.businessDate.from: true
        CharacteristicValueDesc.datuv as ValidityStartDate,
        @Semantics.businessDate.to: true
        CharacteristicValueDesc.datub as ValidityEndDate,
        CharacteristicValueDesc.lkenz as IsDeleted,
        
        _Language
}

Learn More