A_ClfnCharcRefForKeyDate

DDL: A_CLFNCHARCREFFORKEYDATE SQL: ANGCCHR03 Type: view_entity CONSUMPTION

Characteristic References

A_ClfnCharcRefForKeyDate is a Consumption CDS View that provides data about "Characteristic References" in SAP S/4HANA. It reads from 1 data source (I_ClfnCharcRefForKeyDateTP) and exposes 6 fields with key fields CharcInternalID, CharcReferenceTable, CharcReferenceTableField.

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcRefForKeyDateTP I_ClfnCharcRefForKeyDateTP from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (9)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharacteristicRef CharcInternalID
KEY CharcReferenceTable CharacteristicRef CharcReferenceTable
KEY CharcReferenceTableField CharacteristicRef CharcReferenceTableField
KeyDate
CharcLastChangedDateTime CharacteristicRef CharcLastChangedDateTime
_Characteristic _Characteristic
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog.sqlViewName: 'ANGCCHR03'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

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

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

@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.filter.businessDate.at: true
define view entity A_ClfnCharcRefForKeyDate
  with parameters
    @Semantics.businessDate.at: true
    @Consumption.hidden: true 
    P_KeyDate :sydate
  as select from I_ClfnCharcRefForKeyDateTP( P_KeyDate:$parameters.P_KeyDate ) as CharacteristicRef
  
      association to parent A_ClfnCharacteristicForKeyDate as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID
{
  key CharacteristicRef.CharcInternalID,
  key CharacteristicRef.CharcReferenceTable,
  key CharacteristicRef.CharcReferenceTableField,
//      @ObjectModel.readOnly: true

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

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