I_RETAILSTOREUSERASSIGNMENT

CDS View
1 Fields 12 CDS Views

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)

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- User Assigned Store in Retail Store Apps
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RETAILSTOREUSERASSIGNMENT (
    STORE,
    PRIMARY KEY (STORE)
);

Learn More