A_ClfnCharcDescForKeyDate

DDL: A_CLFNCHARCDESCFORKEYDATE SQL: ANGCCHR02 Type: view_entity CONSUMPTION

Characteristic Descriptions

A_ClfnCharcDescForKeyDate is a Consumption CDS View that provides data about "Characteristic Descriptions" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcDescForKeyDateTP) and exposes 9 fields with key fields CharcInternalID, Language.

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcDescForKeyDateTP I_ClfnCharcDescForKeyDateTP from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (11)

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

Fields (9)

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

//@AbapCatalog.sqlViewName: 'ANGCCHR02'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

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

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

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'CharcInternalID'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.filter.businessDate.at: true
define view entity A_ClfnCharcDescForKeyDate
with parameters
    @Semantics.businessDate.at: true  
    @Consumption.hidden: true
    P_KeyDate :sydate
  as select from I_ClfnCharcDescForKeyDateTP( P_KeyDate: $parameters.P_KeyDate ) as CharacteristicDesc
  
      association to parent A_ClfnCharacteristicForKeyDate as _Characteristic on $projection.CharcInternalID = _Characteristic.CharcInternalID
  
{
  key CharacteristicDesc.CharcInternalID,
      @Semantics.language: true
  key CharacteristicDesc.Language,
      @Semantics.text: true
      CharacteristicDesc.CharcDescription,
      CharacteristicDesc.ChangeNumber,      
//      @ObjectModel.readOnly: true

      CharacteristicDesc.ValidityStartDate,
//      @ObjectModel.readOnly: true

      CharacteristicDesc.ValidityEndDate,
//      @ObjectModel.readOnly: true

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

      CharacteristicDesc.CharcLastChangedDateTime,
      
      _Characteristic
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCDESCFORKEYDATETP"
],
"ASSOCIATED":
[
"A_CLFNCHARACTERISTICFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/