I_RtlPromnLocalStoreGroupT

DDL: I_RTLPROMNLOCALSTOREGROUPT Type: view_entity BASIC

Retail Promotion Local Store Group Text

I_RtlPromnLocalStoreGroupT is a Basic CDS View that provides data about "Retail Promotion Local Store Group Text" in SAP S/4HANA. It reads from 1 data source (wrf_rpr_wapgt) and exposes 7 fields with key fields RetailPromotion, StoreGroupInternalID, Language. It has 3 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
wrf_rpr_wapgt wrf_rpr_wapgt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_RtlPromnLocalStoreGroup _RtlPromnLocalStoreGroup $projection.RetailPromotion = _RtlPromnLocalStoreGroup.RetailPromotion and $projection.StoreGroupInternalID = _RtlPromnLocalStoreGroup.StoreGroupInternalID
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_RetailPromotion _RetailPromotion $projection.RetailPromotion = _RetailPromotion.RetailPromotion

Annotations (9)

NameValueLevelField
Analytics.technicalName IRTLPRMNLCSTGRPT view
EndUserText.label Retail Promotion Local Store Group Text view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey StoreGroupInternalID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY RetailPromotion aktnr
KEY StoreGroupInternalID pgrpn
KEY Language
RetailPromotionStoreGroupName pgrpnt
_RtlPromnLocalStoreGroup _RtlPromnLocalStoreGroup
_Language _Language
_RetailPromotion _RetailPromotion 
@Analytics.technicalName: 'IRTLPRMNLCSTGRPT'
@EndUserText.label: 'Retail Promotion Local Store Group Text'

@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel: {
    dataCategory: #TEXT,
//    representativeKey: 'RetailPromotionStoreGroup',

    representativeKey: 'StoreGroupInternalID',
    usageType: {
        serviceQuality: #A,
        sizeCategory: #S,
        dataClass: #CUSTOMIZING
   }
}


define view entity I_RtlPromnLocalStoreGroupT
  as select from wrf_rpr_wapgt

  association [1..1] to I_RtlPromnLocalStoreGroup as _RtlPromnLocalStoreGroup on  $projection.RetailPromotion      = _RtlPromnLocalStoreGroup.RetailPromotion
                                                                              and $projection.StoreGroupInternalID = _RtlPromnLocalStoreGroup.StoreGroupInternalID
  association [0..1] to I_Language                as _Language                on  $projection.Language = _Language.Language

  association [1..1] to I_RetailPromotion         as _RetailPromotion         on  $projection.RetailPromotion      = _RetailPromotion.RetailPromotion
{
      @ObjectModel.foreignKey.association: '_RtlPromnLocalStoreGroup'
  key aktnr as RetailPromotion,
  key pgrpn as StoreGroupInternalID,   // WAGU-CLINT


      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key cast( spras as langu preserving type )
            as Language,

      @Semantics.text: true
      pgrpnt
            as RetailPromotionStoreGroupName,

//      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]

      _RtlPromnLocalStoreGroup,
      _Language,
      _RetailPromotion

}

Learn More