I_RetailCharacteristicValue

DDL: I_RETAILCHARACTERISTICVALUE SQL: IRTLCHARCVAL Type: view BASIC

Retail Characteristic Value

I_RetailCharacteristicValue is a Basic CDS View that provides data about "Retail Characteristic Value" in SAP S/4HANA. It reads from 1 data source (wrf_charval) and exposes 8 fields with key fields CharacteristicInternalID, RetailCharacteristicValue. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
wrf_charval wrf_charval from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristicForKeyDate _Characteristic $projection.CharacteristicInternalID = _Characteristic.CharcInternalID
[0..*] I_RetailCharacteristicValueT _Text $projection.CharacteristicInternalID = _Text.CharacteristicInternalID and $projection.RetailCharacteristicValue = _Text.RetailCharacteristicValue

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRTLCHARCVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.representativeKey RetailCharacteristicValue view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Retail Characteristic Value view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CharacteristicInternalID atinn
KEY RetailCharacteristicValue atwrt
CreationDate erdat
CreatedByUser ernam
LastChangeDate aedat
LastChangedByUser aenam
_Characteristic _Characteristic
_Text _Text 
@AbapCatalog.sqlViewName              : 'IRTLCHARCVAL'
@AbapCatalog.compiler.compareFilter   : true
@AccessControl: {
    authorizationCheck                : #CHECK,
    personalData.blocking             : #NOT_REQUIRED
}
@ClientHandling.algorithm             : #SESSION_VARIABLE
@VDM: {
  viewType                            : #BASIC,
  lifecycle.contract.type             : #PUBLIC_LOCAL_API
}
@ObjectModel: {
    representativeKey                 : 'RetailCharacteristicValue',
    usageType.serviceQuality          : #A,
    usageType.sizeCategory            : #M,
    usageType.dataClass               : #MASTER,
    supportedCapabilities             : [ #SQL_DATA_SOURCE,
                                          #CDS_MODELING_DATA_SOURCE,
                                          #CDS_MODELING_ASSOCIATION_TARGET ]
}
@Metadata.ignorePropagatedAnnotations : true
@EndUserText.label                    : 'Retail Characteristic Value'

define view I_RetailCharacteristicValue
  as select from wrf_charval 
  association [1..1] to I_ClfnCharacteristicForKeyDate  as _Characteristic on  $projection.CharacteristicInternalID  = _Characteristic.CharcInternalID                                                                      
  association [0..*] to I_RetailCharacteristicValueT    as _Text           on  $projection.CharacteristicInternalID  = _Text.CharacteristicInternalID
                                                                           and $projection.RetailCharacteristicValue = _Text.RetailCharacteristicValue
{
      @ObjectModel.foreignKey.association : '_Characteristic'
  key atinn as CharacteristicInternalID,     
      @ObjectModel.text.association       : '_Text'
  key atwrt as RetailCharacteristicValue,
      // Administrative Data

      @Semantics.systemDate.createdAt     : true
      erdat as CreationDate,
      @Semantics.user.createdBy           : true
      ernam as CreatedByUser,
      @Semantics.systemDate.lastChangedAt : true
      aedat as LastChangeDate,
      @Semantics.user.lastChangedBy       : true
      aenam as LastChangedByUser,
      /* Associations */
      _Characteristic,
      _Text    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WRF_CHARVAL"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_RETAILCHARACTERISTICVALUET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More