I_RETAILCHARACTERISTICVALUET

CDS View

Retail Characteristic Value - Text

I_RETAILCHARACTERISTICVALUET is a CDS View in S/4HANA. Retail Characteristic Value - Text. It contains 2 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 2 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_SupDmndOvwTotDmndQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndTotSlsOrdQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndTotSTOQuery view left_outer CONSUMPTION Query View for Total Demand
I_RFM_ProductCharcValue1Txt view inner BASIC Product characteristics value 1
I_RFM_ProductCharcValue2Txt view inner BASIC Product characteristics value 2
I_RFM_ProductCharcValue3Txt view inner BASIC Product characteristics value 3

Fields (2)

KeyField CDS FieldsUsed in Views
KEY Language Language 3
RetailCharacteristicValueDesc ProductCharacteristic1Desc,ProductCharacteristic2Desc,ProductCharacteristic3Desc 6 
@AbapCatalog.sqlViewName              : 'IRTLCHARCVALT'
@AbapCatalog.compiler.compareFilter   : true
@AccessControl.authorizationCheck     : #CHECK
@ClientHandling.algorithm             : #SESSION_VARIABLE
@VDM: {
  viewType                            : #BASIC,
  lifecycle.contract.type             : #PUBLIC_LOCAL_API
}
@ObjectModel: {
    dataCategory                      : #TEXT,
    representativeKey                 : 'RetailCharacteristicValue',
    usageType: {
        serviceQuality                : #A,
        sizeCategory                  : #M,
        dataClass                     : #MASTER
   },
   supportedCapabilities              : [ #SQL_DATA_SOURCE,
                                          #CDS_MODELING_DATA_SOURCE,
                                          #CDS_MODELING_ASSOCIATION_TARGET,
                                          #LANGUAGE_DEPENDENT_TEXT ],
   modelingPattern                    :   #LANGUAGE_DEPENDENT_TEXT
}
@Metadata.ignorePropagatedAnnotations : true
@EndUserText.label                    : 'Retail Characteristic Value - Text'

define view I_RetailCharacteristicValueT
  as select from wrf_charvalt
  association [1..1] to I_ClfnCharacteristicForKeyDate  as _Characteristic            on  $projection.CharacteristicInternalID  = _Characteristic.CharcInternalID
  association [1..1] to I_RetailCharacteristicValue     as _RetailCharacteristicValue on  $projection.CharacteristicInternalID  = _RetailCharacteristicValue.CharacteristicInternalID
                                                                                      and $projection.RetailCharacteristicValue = _RetailCharacteristicValue.RetailCharacteristicValue
  association [0..1] to I_Language                      as _Language                  on  $projection.Language                  = _Language.Language
{
      @ObjectModel.foreignKey.association : '_Characteristic'
  key atinn as CharacteristicInternalID,
      @ObjectModel.foreignKey.association : '_RetailCharacteristicValue'
  key atwrt as RetailCharacteristicValue,
      @ObjectModel.foreignKey.association : '_Language'
      @Semantics.language                 : true
  key spras as Language,
      @Semantics.text                     : true
      atwtb as RetailCharacteristicValueDesc,
      /* Associations */
      _Characteristic,
      _RetailCharacteristicValue,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WRF_CHARVALT"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_LANGUAGE",
"I_RETAILCHARACTERISTICVALUE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More