I_RETAILSTOREUSERASSIGNMENT
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.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_AssignedStore_F4674 | view | from | CONSUMPTION | |
| C_AURSAssignedStore | view | from | CONSUMPTION | |
| C_AURSStoreUser | view_entity | from | CONSUMPTION | |
| C_CSPRAssignedStore | view | from | CONSUMPTION | Count Products with RFID: Assigned Store |
| C_HandlingUnitGdsRcptSts_F4674 | view | inner | CONSUMPTION | |
| C_MSPRAssignedStore | view | from | CONSUMPTION | |
| C_MSPWAssignedStore | view | from | CONSUMPTION | |
| C_RetailPromotion_F4674 | view | inner | CONSUMPTION | |
| P_CoCodeCrcyByStore_F4674 | view | from | CONSUMPTION | |
| P_RlvtMaterialDocRecord_F4674 | view | from | COMPOSITE | |
| P_StorePOSMovementTypes_F4674 | view | from | COMPOSITE | |
| P_StoreStkAdjmtSchemaForStore | view | from | BASIC |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Store | Store | 2 |
@AbapCatalog.sqlViewName: 'IRTSTASSGNDSTORE'
@EndUserText.label: 'User-Assigned Store in Retail Store Apps'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel: {
representativeKey: 'Store',
usageType.serviceQuality: #C,
usageType.sizeCategory: #S,
usageType.dataClass: #MASTER
}
define view I_RetailStoreUserAssignment
as select from P_RetailStoreUserAssignment
{
key Store,
key AssignedUser,
_Store
}
where
_Store.SiteCategory = 'A'