I_ClfnCharcValueDesc

DDL: I_CLFNCHARCVALUEDESC SQL: INGCCHR18 Type: view BASIC

Clfn Characteristic Value Description

I_ClfnCharcValueDesc is a Basic CDS View that provides data about "Clfn Characteristic Value Description" in SAP S/4HANA. It reads from 1 data source (cawnt) and exposes 10 fields with key fields CharcInternalID, CharcValuePositionNumber, Language, TimeIntervalNumber. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
cawnt CharacteristicValueDesc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName INGCCHR18 view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Clfn Characteristic Value Description view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID
KEY CharcValuePositionNumber cawnt atzhl
KEY Language cawnt spras
KEY TimeIntervalNumber cawnt adzhl
CharcValueDescription cawnt atwtb
ChangeNumber cawnt aennr
ValidityStartDate cawnt datuv
ValidityEndDate cawnt datub
IsDeleted cawnt lkenz
_Language _Language 
@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
}

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

Learn More