I_RETAILSTOREUSERASSIGNMENT

CDS View

User Assigned Store in Retail Store Apps

I_RETAILSTOREUSERASSIGNMENT is a CDS View in S/4HANA. User Assigned Store in Retail Store Apps. It contains 1 fields. 12 CDS views read from this table.

Used by 12 CDS view(s) 1 fields

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_AssignedStore_F4674 view from CONSUMPTION Assigned Store
C_AURSAssignedStore view from CONSUMPTION AURS: Assigned Store
C_AURSStoreUser view_entity from CONSUMPTION AURS: Store User
C_CSPRAssignedStore view from CONSUMPTION Count Products with RFID: Assigned Store
C_HandlingUnitGdsRcptSts_F4674 view inner CONSUMPTION Handling Unit Goods Receipt Status for Store
C_MSPRAssignedStore view from CONSUMPTION Move Products with RFID: Assigned Store
C_MSPWAssignedStore view from CONSUMPTION MPW: Assigned Store
C_RetailPromotion_F4674 view inner CONSUMPTION Retail Promotion Overview by Store
P_CoCodeCrcyByStore_F4674 view from CONSUMPTION Stores enriched by their company code currency
P_RlvtMaterialDocRecord_F4674 view from COMPOSITE Filtered Material Document Records
P_StorePOSMovementTypes_F4674 view from COMPOSITE POS relevant movement types by store
P_StoreStkAdjmtSchemaForStore view from BASIC Stock adjustment Default schema

Fields (1)

KeyField CDS FieldsUsed in Views
KEY Store Store 2 
@VDM: {
  viewType                           : #BASIC,
  lifecycle.contract.type            : #PUBLIC_LOCAL_API
}
@EndUserText.label                   : 'User Assigned Store in Retail Store Apps'
@AccessControl.authorizationCheck    : #NOT_REQUIRED
@AccessControl.personalData.blocking : #NOT_REQUIRED
@ObjectModel: {
   representativeKey                 : 'Store',
   supportedCapabilities             : [ #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET
                                        ],
   modelingPattern                   :  #NONE ,
   usageType                         : {serviceQuality: #A,sizeCategory: #M,dataClass: #MIXED }
 }
 @Analytics.technicalName            : 'IRTSTASSGNDSTORE' 
 @Metadata :{
   ignorePropagatedAnnotations       : true
}
 
define view entity I_RetailStoreUserAssignment
  as select from P_RetailStoreUserAssignment

{
  key Store,
  key AssignedUser,

      _Store

}
where
  _Store.SiteCategory = 'A'

Learn More