A_ClfnCharcValueDescForKeyDate

DDL: A_CLFNCHARCVALUEDESCFORKEYDATE SQL: ANGCCHR06 Type: view_entity CONSUMPTION

Characteristic Value Descriptions

A_ClfnCharcValueDescForKeyDate is a Consumption CDS View that provides data about "Characteristic Value Descriptions" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcValDescForKeyDateTP) and exposes 11 fields with key fields CharcInternalID, CharcValuePositionNumber, Language. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcValDescForKeyDateTP I_ClfnCharcValDescForKeyDateTP from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_ClfnCharacteristicForKeyDate _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Value Descriptions view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey CharcValuePositionNumber view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
Consumption.filter.businessDate.at true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharcInternalID
KEY CharcValuePositionNumber CharcValuePositionNumber
KEY Language Language
CharcValueDescription CharcValueDescription
ChangeNumber ChangeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
KeyDate
CharcLastChangedDateTime CharcLastChangedDateTime
_CharacteristicValue _CharacteristicValue
_Characteristic _Characteristic 
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.sqlViewName: 'ANGCCHR06'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Characteristic Value Descriptions'
//@VDM.viewType: #COMPOSITE

@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'CharcValuePositionNumber'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.filter.businessDate.at: true
define view entity A_ClfnCharcValueDescForKeyDate
  with parameters
    @Semantics.businessDate.at: true
    @Consumption.hidden: true 
    P_KeyDate :sydate
  as select from I_ClfnCharcValDescForKeyDateTP( P_KeyDate: $parameters.P_KeyDate )
  
      association to parent A_ClfnCharcValueForKeyDate  as _CharacteristicValue
        on  $projection.CharcInternalID          = _CharacteristicValue.CharcInternalID
        and $projection.CharcValuePositionNumber = _CharacteristicValue.CharcValuePositionNumber
        
      association [1..1] to A_ClfnCharacteristicForKeyDate as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID  
{
      @ObjectModel.foreignKey.association: '_Characteristic'
  key CharcInternalID, 
  key CharcValuePositionNumber,
      @Semantics.language: true 
  key Language,  
      @Semantics.text: true
      CharcValueDescription, 
      ChangeNumber, 
      ValidityStartDate, 
      ValidityEndDate, 
//      @ObjectModel.readOnly: true

      $parameters.P_KeyDate as KeyDate, 
//      @ObjectModel.readOnly: true 

      CharcLastChangedDateTime,
  
      _CharacteristicValue,
      _Characteristic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCVALDESCFORKEYDATETP"
],
"ASSOCIATED":
[
"A_CLFNCHARACTERISTICFORKEYDATE",
"A_CLFNCHARCVALUEFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More