I_RetailCharacteristicValueT

DDL: I_RETAILCHARACTERISTICVALUET SQL: IRTLCHARCVALT Type: view BASIC Package: VDM_RFM_PRODUCT

Retail Characteristic Value - Text

I_RetailCharacteristicValueT is a Basic CDS View that provides data about "Retail Characteristic Value - Text" in SAP S/4HANA. It reads from 1 data source (wrf_charvalt) and exposes 7 fields with key fields CharacteristicInternalID, RetailCharacteristicValue, Language. It has 3 associations to related views. Part of development package VDM_RFM_PRODUCT.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
wrf_charvalt wrf_charvalt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristicForKeyDate _Characteristic $projection.CharacteristicInternalID = _Characteristic.CharcInternalID
[1..1] I_RetailCharacteristicValue _RetailCharacteristicValue $projection.CharacteristicInternalID = _RetailCharacteristicValue.CharacteristicInternalID and $projection.RetailCharacteristicValue = _RetailCharacteristicValue.RetailCharacteristicValue
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IRTLCHARCVALT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey RetailCharacteristicValue view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Retail Characteristic Value - Text view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CharacteristicInternalID atinn
KEY RetailCharacteristicValue atwrt
KEY Language spras
RetailCharacteristicValueDesc atwtb
_Characteristic _Characteristic
_RetailCharacteristicValue _RetailCharacteristicValue
_Language _Language 
@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
}

Learn More