C_RetailPromotion_F4674

DDL: C_RETAILPROMOTION_F4674 SQL: CRTLPROMF4674 Type: view CONSUMPTION

C_RetailPromotion_F4674 is a Consumption CDS View 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.

2 data source(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

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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RETAILPROMOTION",
"I_RETAILPROMOTIONT",
"I_RETAILSTOREUSERASSIGNMENT",
"P_RTLPROMNAGGRGDPERSTORE_F4674"
],
"ASSOCIATED":
[
"I_RETAILPROMOTION"
],
"BASE":
[
"P_RTLPROMNAGGRGDPERSTORE_F4674"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More