C_RetailPromotion_F4674

DDL: C_RETAILPROMOTION_F4674 SQL: CRTLPROMF4674 Type: view CONSUMPTION Package: RFM_STORE_MY_STORE_OVERVIEW

Retail Promotion Overview by Store

C_RetailPromotion_F4674 is a Consumption CDS View that provides data about "Retail Promotion Overview by Store" in SAP S/4HANA. It reads from 2 data sources (I_RetailStoreUserAssignment, P_RtlPromnAggrgdPerStore_F4674) and exposes 10 fields with key fields Store, RetailPromotion, SalesUnit. It is exposed through 1 OData service (UI_RFM_STORE_MYSTOREOVW). It is used in 1 Fiori application: My Store Overview. Part of development package RFM_STORE_MY_STORE_OVERVIEW.

2 data source(s) Exposed by 1 service(s) Used in 1 Fiori app(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_RetailStoreUserAssignment I_RetailStoreUserAssignment inner
P_RtlPromnAggrgdPerStore_F4674 PromotionByStore from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CRTLPROMF4674 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_STORE_MYSTOREOVW UI_RFM_STORE_MYSTOREOVW V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4674 My Store Overview Transactional This app enables store managers to monitor and analyze key KPIs of their stores such as promotions, goods receipts and sales performance.

My Store Overview

Business Role: Retail Store Manager

This app enables store managers to monitor and analyze key KPIs of their stores such as promotions, goods receipts and sales performance.

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Store P_RtlPromnAggrgdPerStore_F4674 Store
KEY RetailPromotion RetailPromotion
KEY SalesUnit SalesUnit
RetailPromotionName
RtlPromnPlndSalesQtyPerStore RtlPromnPlndSalesQtyPerStore
RetailPromotionSalesFromDate RetailPromotionSalesFromDate
RetailPromotionSalesToDate RetailPromotionSalesToDate
RtlPromnSlsFrmDteOffstInDays RtlPromnSlsFrmDteOffstInDays
RtlPromnSlsToDteOffstInDays RtlPromnSlsToDteOffstInDays
_RetailPromotion _RetailPromotion 
@AbapCatalog.sqlViewName: 'CRTLPROMF4674'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
define view C_RetailPromotion_F4674
  as select from P_RtlPromnAggrgdPerStore_F4674 as PromotionByStore
    inner join   I_RetailStoreUserAssignment on  I_RetailStoreUserAssignment.AssignedUser = $session.user
                                             and I_RetailStoreUserAssignment.Store        = PromotionByStore.Store
{
  key PromotionByStore.Store,
      @ObjectModel.text.element: ['RetailPromotionName']
  key RetailPromotion,
  key SalesUnit,

      _RetailPromotion._Text[1: Language = $session.system_language].RetailPromotionName,

      RtlPromnPlndSalesQtyPerStore,

      RetailPromotionSalesFromDate,
      RetailPromotionSalesToDate,
      RtlPromnSlsFrmDteOffstInDays,
      RtlPromnSlsToDteOffstInDays,

      _RetailPromotion
}

Learn More