SAP Store Operations Tables

Are you looking for the right table related to SAP Store Operations Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Store Operations (LO-RFM-STO) module.

Top 10 tables in Store Operations

TableDescription
IVIEW_CO_GR_DTLast run date of application
TWICSCMIACs Retail: Customizing schemas
RTST_C_SCHEMEOdata Service Retail Store: Customizing schemas
RTST_C_SCH_SITEOdata Service Retail Store: Assignment of Customizing Schema
RTST_C_SCHEME_TOdata Service Retail Store: Customizing schema Descriptions
TWIC0250General Business Transactions for SAP Retail Store GR
TWIC0500Store Retail Store: Order Entry, Basic Data
TWICAPPL_WDJSAP Retail Store: Technical Data on Web Dynpro for Java
WSTI_DB_TMP_ITEMSAP Retail Store temporary persistence item table
TWIC0403BTSAP Retail Store II: Accounts for Cash Payment

List of tables in Store Operations

TableDescription
IVIEW_CO_GR_DTLast run date of application
TWICSCMIACs Retail: Customizing schemas
RTST_C_SCHEMEOdata Service Retail Store: Customizing schemas
RTST_C_SCH_SITEOdata Service Retail Store: Assignment of Customizing Schema
RTST_C_SCHEME_TOdata Service Retail Store: Customizing schema Descriptions
TWIC0250General Business Transactions for SAP Retail Store GR
TWIC0500Store Retail Store: Order Entry, Basic Data
TWICAPPL_WDJSAP Retail Store: Technical Data on Web Dynpro for Java
WSTI_DB_TMP_ITEMSAP Retail Store temporary persistence item table
TWIC0403BTSAP Retail Store II: Accounts for Cash Payment
WSGM_ITEM_DB_TMPSRS GM: Temporary Persistence for Item Data
TWIC0600SAP Retail Store: Physical Inventory Basic Data
WGMH_SRSHead for SRS PDC Goodsmovement
TWIC0600CLNTGeneral Settings for Physical Inventory During Opening Hours
IVIEW_CO_GRCustomer order good receipt IView - Sales orders
WSGM_HEAD_DB_TMPSRS GM: Temporary Persistence for Header Data
TWIC0401SAP Retail Store II: Permitted Reference Document Categories
WSAO_WORK_CTRLRetail Store Store Order: Worklist Control
TWIC0251Retail Store GM: Key for Business Transaction Group
TWIC0101Grouping of Reference Document Categs and Business Processes
WOSCR_EXI_001SRS Conv. Retailing - Groups for Expense Invoice Accounts
WOSCR_EXI_COCODEVendor Invoice - Assignment for Each Company Code
TWIC0403ASAP Retail Store II: Accounts for Cash Payment
TWIC0504Delivery Lock with Downpayments
TWICAPPLSAP Retail Store Application
TWIC1001SRS: Definition of Tabstrips
WOSCR_RSN_GRPGroup for Reasons for Deviations
TWIC1000FMSAP Retail Store: Master for Fields on Tabstrips
WOSCR_EXI_CURRCurrencies for Expense Invoice
WOSCR_GRP_004TSRS Convenience Retailing - Breakdown of Accounts
TWIC0110Retail Store GR: Basic Settings for Goods Receipt
TWIC0511In-Store MIM: Basic Data for Lean Order
TWIC1301CRetail Store HH: Assign Handheld Function Keys
WOSCR_GRP_003SRS Convenience Retailing - Account Lines
TWIC1010BTSAP Retail Store II: Costs- Texts f. G/L Accounts per Schema
TWIC0700Global Control of Store Order Function in Retail Store
TWIC1290SAP Retail Store Material Search: Basic settings
WOSCR_CBL_COCODECash Balancing: Settings for Each Company Code
WOSCR_EXI_SITEExpense Invoice - General Store Settings
TWIC1200Basic Settings for SAP Retail Store Article Master Maint.
TWIC0251TRetail Store GM: Text for Business Transaction Group
TWIC0501Store Retail Store: Order Entry, Allowed Order Types
TWICHHDEVTRetail Store HH: Unit Type Definition - Texts
WOSASAP Retail Store, Store Orders: Entities Table
TWIC1321AAssigment of buttons to device type: Device assignment
TWIC0403BSAP Retail Store II: Accounts for Cash Payment
TWIC1301BRetail Store HH: Assign Handheld Tasks
WGMP_SRSItems for SRS PDC Goodsmovement
TWIC1320TAssignment of menu item texts
TWIC1200CLNTCross-Plant Settings for Material Master Maintenance
TWIC1321BAssigment of buttons to device type: Device, task assignment
WSTI_DB_TMP_HEADSAP Retail Store temporay persistence header table
TWICOBJTIACs Retail: Customizing objects, texts
WOSAVSAP Retail Store, Store Orders: Document Links
TWIC0750Global Control for Assortment Lists in Retail Store
WOSCR_EXI_003Tax Code Lines for Expense Invoice
WSTI_PDC_EVENTRetail Store Physical Inventory: PDC Transactions
TWIC1321CTAssigment of buttons to device type: Device, task, buttons
WSTI_ART_RELPhysical Inventory During Open Time: Material Assignment
WOSCR_EXI_001TText Table - Groups for Expense Invoice Accounts
TWICOBJIACs Retail: Customizing objects
TWICHHDEVKEYTRetail Store HH: Define Function Keys
TWIC1010BSAP Retail Store II: Assignn Permitted G/L Accounts
TWIC0210SAP Retail Store GM: Basic Settings
TWIC1291PLRSAP Retail Store Material Search: Related Plants
TWIC1020SAP Retail Store: Permitted Units of Measure
WOSCR_EXI_002TText Table - G/L Accounts for Expense Invoice
WSGR_HEAD_DB_TMPSRS GM: Temporary Persistence for Header Data
TWIC1002TSAP Retail Store Master Data: Buttons on Initial Screen
TWIC1000TSKTSAP Retail Store: Texts for Tasks for Field Attribute Cntrl
TWICAPPLTSAP Retail Store: Texts for Application
WOSCR_GRP_002TSRS Convenience Retailing - Subgrouping of Accounts
TWICHIDEVKEYRetail Store HH: Define Function Keys
TWICAPPL_HIIn-Store MIM Mobile Applications: Technical Data
TWICSKEYTSAP Retail Store: Selection Box Key Texts
TWICSCMFSAP Retail Store: Assignment of Customizing Schemas to Site
TWICSCMTIACs Retail: Customizing Schema Texts
TWIC1320Assignment of menu items
WOSCR_EXI_003TText Table - Tax Code Lines for Expense Invoice
TWIC1000TSKSAP Retail Store: Tasks for Field Attribute Control
TWIC0220SAP Retail Store GM: Basic Settings
WOSCR_EXI_ST_02Vendor Invoice - Store Settings (FI/CO)
TWICSKEYSAP Retail Store: Key for Selection in Selection Boxes
TWICHHDEVKEYRetail Store HH: Define Function Keys
WSGR_ITEM_DB_TMPSRS GR: Temporary Persistence for Item Data
TWIC0623SRS Inventory Lookup basic settings
TWIC0518Retail Store: Customer Maint. - Customizing Baisic Data
TWIC1310ARetail Store HH: Assign Handheld Applications
TWIC1321CAssigment of buttons to device type: Device, task, buttons
TWIC0800SAP Retail Store: Basic Data for Sales Prices Screen
TWICHHDEVRetail Store HH: Handheld Devices Definition
RFM_EPC_MEMORYEPC Memory
TWICMESSAGESAP Retail Store: Define Characteristics of System Messages
WOSCR_EXI_002G/L Accounts for Expense Invoice
TWIC0510In-Store MIM: Sales Order Basic Data
WOSCR_CBL_VALTAdd-In Filter Value Table: Postings in 'Cash Balancing'
WOSCR_GRP_004SRS Convenience Retailing - Breakdown of Accounts
TWIC1100CLNTCross-Plant Settings for Vendor Master Maintenance
WOSCR_GRP_002SRS Convenience Retailing - Subgrouping of Accounts
WOSCR_GRP_001SRS Convenience Retailing - Grouping of Accounts
WOSCR_GRP_003TSRS Convenience Retailing - Account Lines
TWIC0100General Settings for SAP Retail Store Goods Receipt
WOSCR_RSNTReasons for Deviations (SRS Cash Balancing)
WOSCR_RSNReasons for Deviations (SRS Cash Balancing)
TWIC0610SRS:Physical Inventory for handheld-basic data
WSAO_T439SRS STO: Order Times in Planning Calendar
WSVD_DB_VNDR_PLTSRS Vendor Master: Maint. Authorization for Store-Vendor
WOSCR_EXI_VALAdd-In Filter Value Talbe: Expense Invoice Postings
WOSCR_SITE_GRPCash Balancing: Settings for Each Group of Accounts
WSAM_DB_PRICATSRS Article Master: Entering Site
TWIC0252Retail Store GM: Assignment of Business Transaction Group
TWIC1310Retail Store HH: Assign Handheld Applications
TWIC1001FSRS Stammdaten: Fields on Tabstrip
WSRS_DB_PLNT_CCSAP Retail Store: Assignment of Cost Centers to Plants
WSTI_MKPF_INDEXPhys. Inventory During Open Time: Material Doc. Index
WOSCR_RSN_GRPTGroup for Reasons for Deviations
TWIC0200General Settings for SAP Retail Store Goods Movements
WSTI_POS_EVENTPhysical Inventory in an Opened Store: POS Trans by Receipt
TWIC1291PLRTSAP Retail Store Material Search: Related Plants Text
WOSCR_EXI_VALTAdd-In Filter Value Talbe: Expense Invoice Postings
TWIC1301ARetail Store HH: Handheld Device Type Definition
WOSCR_GRP_001TSRS Convenience Retailing - Grouping of Accounts/Texts
WOSCR_CBL_VALAdd-In Filter Value Table: Postings in 'Cash Balancing'
TWIC0300SAP Retail Store PO: Basic Settings
TWIC0404SAP Retail Store II: Permitted Reversal Reasons
TWIC0301SAP Retail Store PO: Allowed Document Types
TWIC0515In-Store MIM: Customizing for SO condition types
TWIC0302SAP Retail Store PO: Allowed Reasons for Ordering
TWIC1100SRS Vendor Master: Basic Settings
TWIC1002SAP Retail Store Master Data: Buttons on Initial Screen
TWIC0400SAP Retail Store II: Incoming Invoice Basic Settings
TWIC1291SAP Retail Store Material Search: Plant range grouping
TWIC0900SAP Retail Store: Promotion Basic Data
TWIC1010ASRSII: Define Grouping Schema and Assign Chart of Accounts
TWIC1310BRetail Store HH: Assign Handheld Applications
TWIC1001TSRS Master Data: Tab Title Texts