I_RtlPromnLocalStoreGroup

DDL: I_RTLPROMNLOCALSTOREGROUP Type: view_entity BASIC

Retail Promotion Local Store Group

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

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
wrf_rpr_wapg wrf_rpr_wapg from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_RtlPromnLocalStoreGroupT _Text $projection.RetailPromotion = _Text.RetailPromotion and $projection.StoreGroupInternalID = _Text.StoreGroupInternalID
[1..1] I_RetailPromotion _RetailPromotion $projection.RetailPromotion = _RetailPromotion.RetailPromotion

Annotations (10)

NameValueLevelField
Analytics.technicalName IRTLPRMNLCSTGRP view
EndUserText.label Retail Promotion Local Store Group view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey StoreGroupInternalID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY RetailPromotion aktnr
KEY StoreGroupInternalID pgrpn
RetailPromotionStoreGroup filgr
_Text _Text
_RetailPromotion _RetailPromotion 
@Analytics.technicalName: 'IRTLPRMNLCSTGRP'
@EndUserText.label: 'Retail Promotion Local Store Group'

@AccessControl: {
    authorizationCheck: #CHECK,
    personalData.blocking: #NOT_REQUIRED
}

@VDM.viewType: #BASIC
@ObjectModel: {
    compositionRoot: true,
//    representativeKey: 'RetailPromotionStoreGroup',

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

define view entity I_RtlPromnLocalStoreGroup
  as select from wrf_rpr_wapg

  association [0..*] to I_RtlPromnLocalStoreGroupT as _Text on  $projection.RetailPromotion      = _Text.RetailPromotion
                                                            and $projection.StoreGroupInternalID = _Text.StoreGroupInternalID
  association [1..1] to I_RetailPromotion         as _RetailPromotion         on  $projection.RetailPromotion      = _RetailPromotion.RetailPromotion
{
      @ObjectModel.text.association: '_Text'
  key aktnr as RetailPromotion,
  key pgrpn as StoreGroupInternalID,   // WAGU-CLINT


      filgr as RetailPromotionStoreGroup,

      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Text,
      _RetailPromotion
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WRF_RPR_WAPG"
],
"ASSOCIATED":
[
"I_RETAILPROMOTION",
"I_RTLPROMNLOCALSTOREGROUPT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More