I_RtlPromnStoreGroup

DDL: I_RTLPROMNSTOREGROUP Type: view_entity BASIC

Retail Promotion Store Group

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

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
wagu wagu from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_RtlPromnLocalStoreGroup _RtlPromnLocalStoreGroup $projection.RetailPromotion = _RtlPromnLocalStoreGroup.RetailPromotion and $projection.StoreGroupInternalID = _RtlPromnLocalStoreGroup.StoreGroupInternalID
[0..1] I_ClassHeader _ClassHeader $projection.StoreGroupInternalID = _ClassHeader.ClassInternalID
[0..*] I_ClassText _ClassText $projection.StoreGroupInternalID = _ClassText.ClassInternalID
[1..1] I_RetailPromotion _RetailPromotion $projection.RetailPromotion = _RetailPromotion.RetailPromotion

Annotations (9)

NameValueLevelField
Analytics.technicalName IRTLPROMNSTGRP view
EndUserText.label Retail Promotion Store Group view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.representativeKey StoreGroupInternalID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY RetailPromotion aktnr
KEY StoreGroupInternalID clint
_RtlPromnLocalStoreGroup _RtlPromnLocalStoreGroup
_ClassText _ClassText
_ClassHeader _ClassHeader
PromnListingStartDate alivo
PromnListingEndDate alibi
RetailPromotionSalesFromDate avkvo
RetailPromotionSalesToDate avkbi
PromotionAnnouncementDate abekm
PromotionAnncmntReplyDate rudat
RtlPromnLatestPossibleGRDate awefi
RtlPromnStoreGroupCategory stplgr
_RetailPromotion _RetailPromotion 
@Analytics.technicalName: 'IRTLPROMNSTGRP'
@EndUserText: {label: 'Retail Promotion Store Group'}

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

@VDM.viewType: #BASIC
@ObjectModel: {
//    semanticKey: [''] ,

    representativeKey: 'StoreGroupInternalID',
    usageType: {
        serviceQuality: #A,
        sizeCategory: #M,
        dataClass: #TRANSACTIONAL
   }
}

define view entity I_RtlPromnStoreGroup
  as select from wagu

  association [0..1] to I_RtlPromnLocalStoreGroup as _RtlPromnLocalStoreGroup on  $projection.RetailPromotion      = _RtlPromnLocalStoreGroup.RetailPromotion
                                                                              and $projection.StoreGroupInternalID = _RtlPromnLocalStoreGroup.StoreGroupInternalID
  association [0..1] to I_ClassHeader             as _ClassHeader             on  $projection.StoreGroupInternalID = _ClassHeader.ClassInternalID                                                                            
  association [0..*] to I_ClassText               as _ClassText               on  $projection.StoreGroupInternalID = _ClassText.ClassInternalID
  association [1..1] to I_RetailPromotion         as _RetailPromotion         on  $projection.RetailPromotion      = _RetailPromotion.RetailPromotion
{
      @ObjectModel.foreignKey.association: '_RetailPromotion'
  key aktnr  as RetailPromotion,
  key clint  as StoreGroupInternalID,
      _RtlPromnLocalStoreGroup,
      _ClassText,
      _ClassHeader,

      alivo  as PromnListingStartDate,
      alibi  as PromnListingEndDate,

      avkvo  as RetailPromotionSalesFromDate,
      avkbi  as RetailPromotionSalesToDate,

      abekm  as PromotionAnnouncementDate,
      rudat  as PromotionAnncmntReplyDate,
      awefi  as RtlPromnLatestPossibleGRDate,

      stplgr as RtlPromnStoreGroupCategory,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _RetailPromotion
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WAGU"
],
"ASSOCIATED":
[
"I_CLASSHEADER",
"I_CLASSTEXT",
"I_RETAILPROMOTION",
"I_RTLPROMNLOCALSTOREGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More