A_ClfnCharcValueForKeyDate

DDL: A_CLFNCHARCVALUEFORKEYDATE SQL: ANGCCHR05 Type: view_entity CONSUMPTION

Characteristic Values

A_ClfnCharcValueForKeyDate is a Consumption CDS View that provides data about "Characteristic Values" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcValForKeyDateTP) and exposes 21 fields with key fields CharcInternalID, CharcValuePositionNumber. It has 1 association to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcValForKeyDateTP I_ClfnCharcValForKeyDateTP from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_ClfnCharcValueDescForKeyDate _CharcValueDesc

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Values view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true 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 (21)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharacteristicValue CharcInternalID
KEY CharcValuePositionNumber CharacteristicValue CharcValuePositionNumber
CharcValueDependency CharacteristicValue CharcValueDependency
CharcValue CharacteristicValue CharcValue
CharcFromNumericValue CharacteristicValue CharcFromNumericValue
CharcToNumericValue CharacteristicValue CharcToNumericValue
IsDefaultValue CharacteristicValue IsDefaultValue
CharcFromNumericValueUnit CharacteristicValue CharcFromNumericValueUnit
CharcToNumericValueUnit CharacteristicValue CharcToNumericValueUnit
LongTextID CharacteristicValue LongTextID
ChangeNumber CharacteristicValue ChangeNumber
DocumentType CharacteristicValue DocumentType
DocNumber CharacteristicValue DocNumber
DocumentPart CharacteristicValue DocumentPart
DocumentVersion CharacteristicValue DocumentVersion
ValidityStartDate CharacteristicValue ValidityStartDate
ValidityEndDate CharacteristicValue ValidityEndDate
KeyDate
CharcLastChangedDateTime CharacteristicValue CharcLastChangedDateTime
_CharcValueDesc _CharcValueDesc
_Characteristic _Characteristic 
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.sqlViewName: 'ANGCCHR05'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

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

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

@ObjectModel.representativeKey: 'CharcValuePositionNumber'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.filter.businessDate.at: true
define view entity A_ClfnCharcValueForKeyDate
  with parameters
    @Semantics.businessDate.at: true  
    @Consumption.hidden: true 
    P_KeyDate :sydate
  as select from I_ClfnCharcValForKeyDateTP( P_KeyDate: $parameters.P_KeyDate ) as CharacteristicValue  

      composition [0..*] of A_ClfnCharcValueDescForKeyDate as _CharcValueDesc

      association to parent A_ClfnCharacteristicForKeyDate as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID
{
      @ObjectModel.foreignKey.association: '_Characteristic'
  key CharacteristicValue.CharcInternalID,
  key CharacteristicValue.CharcValuePositionNumber,
      CharacteristicValue.CharcValueDependency,
      CharacteristicValue.CharcValue,
      CharacteristicValue.CharcFromNumericValue,
      CharacteristicValue.CharcToNumericValue,
      CharacteristicValue.IsDefaultValue,
      CharacteristicValue.CharcFromNumericValueUnit,
      CharacteristicValue.CharcToNumericValueUnit,
//      CharacteristicValue.CharcFromDecimalValue,

//      CharacteristicValue.CharcToDecimalValue,

//      CharacteristicValue.CharcFromDate,

//      CharacteristicValue.CharcToDate,

//      CharacteristicValue.CharcFromTime,

//      CharacteristicValue.CharcToTime,

//      @Semantics.amount.currencyCode: 'Currency'

//      CharacteristicValue.CharcFromAmount,

//      @Semantics.amount.currencyCode: 'Currency'

//      CharacteristicValue.CharcToAmount,

//      @Semantics.currencyCode: true

//      CharacteristicValue.Currency,       

      CharacteristicValue.LongTextID,
      CharacteristicValue.ChangeNumber,
      CharacteristicValue.DocumentType,
      CharacteristicValue.DocNumber,
      CharacteristicValue.DocumentPart,
      CharacteristicValue.DocumentVersion,
//      @ObjectModel.readOnly: true

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

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

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

      CharacteristicValue.CharcLastChangedDateTime,
      
      _CharcValueDesc,
      _Characteristic
}

Learn More