C_AssignedStore_F4674

DDL: C_ASSIGNEDSTORE_F4674 SQL: CSASSGDSTORF4674 Type: view CONSUMPTION

C_AssignedStore_F4674 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_RetailStoreUserAssignment, I_Site) and exposes 2 fields with key field Store. It is exposed through 1 OData service (UI_RFM_STORE_MYSTOREOVW). It is used in 1 Fiori application: My Store Overview.

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

Data Sources (2)

SourceAliasJoin Type
I_RetailStoreUserAssignment I_RetailStoreUserAssignment from
I_Site I_Site inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSASSGDSTORF4674 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey Store view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER 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 (2)

KeyFieldSource TableSource FieldDescription
KEY Store Store
StoreName 
@AbapCatalog.sqlViewName: 'CSASSGDSTORF4674'

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    representativeKey: 'Store',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #S,
    usageType.dataClass: #MASTER
}
define view C_AssignedStore_F4674
  as select from I_RetailStoreUserAssignment
    inner join   I_Site on I_RetailStoreUserAssignment.Store = I_Site.Site
{
  @UI.lineItem: [{ position: 20,  importance: #HIGH }]
  key Store,
  
  @UI.lineItem: [{ position: 10, importance: #HIGH }]
      cast(I_Site.SiteName as storename preserving type) as StoreName
}
where
  AssignedUser = $session.user

Learn More