I_RetailStoreApplicationStore

DDL: I_RETAILSTOREAPPLICATIONSTORE SQL: IRTSTAPPLSTORE Type: view COMPOSITE

Retail Store Application and Store

I_RetailStoreApplicationStore is a Composite CDS View that provides data about "Retail Store Application and Store" in SAP S/4HANA. It reads from 2 data sources (I_RetailStoreApplication, I_Site) and exposes 3 fields with key fields Store, RetailStoreApplication.

Data Sources (2)

SourceAliasJoin Type
I_RetailStoreApplication I_RetailStoreApplication cross
I_Site I_Site from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRTSTAPPLSTORE view
EndUserText.label Retail Store Application and Store view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey RetailStoreApplication view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Store Site
KEY RetailStoreApplication RetailStoreApplication
RetailStoreApplicationCategory RetailStoreApplicationCategory
@AbapCatalog.sqlViewName: 'IRTSTAPPLSTORE'
@EndUserText.label: 'Retail Store Application and Store'

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

@VDM.viewType: #COMPOSITE
@ObjectModel: {
    compositionRoot: true,
    representativeKey: 'RetailStoreApplication',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #M,
    usageType.dataClass: #MIXED
}

define view I_RetailStoreApplicationStore
  as select from I_Site
    cross join   I_RetailStoreApplication
{
  key Site as Store,
  key RetailStoreApplication,
      RetailStoreApplicationCategory
}