| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduct Catalog |
1 | TWIC8000 | Online store: Profile for product presentation | 3 | CSTSCM | Product presentation profile | nvarchar | 4 | 0 | | |
2 | TWIC8001 | Online store: Profile for customer management | 3 | CSTSCM | Customer management profile | nvarchar | 4 | 0 | | |
3 | TWIC8002 | Online store: Profile for quotation and order control | 3 | CSTSCM | Profile for quotation and order control | nvarchar | 4 | 0 | | |
TOPSAP Retail Store |
4 | TWIC0100 | General Settings for SAP Retail Store Goods Receipt | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
5 | TWIC0101 | Grouping of Reference Document Categs and Business Processes | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
6 | TWIC0110 | Retail Store GR: Basic Settings for Goods Receipt | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
7 | TWIC0200 | General Settings for SAP Retail Store Goods Movements | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
8 | TWIC0210 | SAP Retail Store GM: Basic Settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
9 | TWIC0220 | SAP Retail Store GM: Basic Settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
10 | TWIC0250 | General Business Transactions for SAP Retail Store GR | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
11 | TWIC0252 | Retail Store GM: Assignment of Business Transaction Group | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
12 | TWIC0300 | SAP Retail Store PO: Basic Settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
13 | TWIC0301 | SAP Retail Store PO: Allowed Document Types | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
14 | TWIC0302 | SAP Retail Store PO: Allowed Reasons for Ordering | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
15 | TWIC0400 | SAP Retail Store II: Incoming Invoice Basic Settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
16 | TWIC0401 | SAP Retail Store II: Permitted Reference Document Categories | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
17 | TWIC0403A | SAP Retail Store II: Accounts for Cash Payment | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
18 | TWIC0403B | SAP Retail Store II: Accounts for Cash Payment | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
19 | TWIC0403BT | SAP Retail Store II: Accounts for Cash Payment | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
20 | TWIC0404 | SAP Retail Store II: Permitted Reversal Reasons | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
21 | TWIC0500 | Store Retail Store: Order Entry, Basic Data | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
22 | TWIC0501 | Store Retail Store: Order Entry, Allowed Order Types | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
23 | TWIC0504 | Delivery Lock with Downpayments | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
24 | TWIC0510 | In-Store MIM: Sales Order Basic Data | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
25 | TWIC0511 | In-Store MIM: Basic Data for Lean Order | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
26 | TWIC0515 | In-Store MIM: Customizing for SO condition types | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
27 | TWIC0518 | Retail Store: Customer Maint. - Customizing Baisic Data | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
28 | TWIC0600 | SAP Retail Store: Physical Inventory Basic Data | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
29 | TWIC0610 | SRS:Physical Inventory for handheld-basic data | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
30 | TWIC0623 | SRS Inventory Lookup basic settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
31 | TWIC0700 | Global Control of Store Order Function in Retail Store | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
32 | TWIC0750 | Global Control for Assortment Lists in Retail Store | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
33 | TWIC0800 | SAP Retail Store: Basic Data for Sales Prices Screen | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
34 | TWIC0900 | SAP Retail Store: Promotion Basic Data | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
35 | TWIC1001 | SRS: Definition of Tabstrips | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
36 | TWIC1001F | SRS Stammdaten: Fields on Tabstrip | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
37 | TWIC1001T | SRS Master Data: Tab Title Texts | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
38 | TWIC1002 | SAP Retail Store Master Data: Buttons on Initial Screen | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
39 | TWIC1002T | SAP Retail Store Master Data: Buttons on Initial Screen | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
40 | TWIC1010A | SRSII: Define Grouping Schema and Assign Chart of Accounts | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
41 | TWIC1010B | SAP Retail Store II: Assignn Permitted G/L Accounts | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
42 | TWIC1010BT | SAP Retail Store II: Costs- Texts f. G/L Accounts per Schema | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
43 | TWIC1020 | SAP Retail Store: Permitted Units of Measure | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
44 | TWIC1100 | SRS Vendor Master: Basic Settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
45 | TWIC1200 | Basic Settings for SAP Retail Store Article Master Maint. | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
46 | TWIC1290 | SAP Retail Store Material Search: Basic settings | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
47 | TWIC1291 | SAP Retail Store Material Search: Plant range grouping | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
48 | TWIC1301A | Retail Store HH: Handheld Device Type Definition | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
49 | TWIC1301B | Retail Store HH: Assign Handheld Tasks | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
50 | TWIC1301C | Retail Store HH: Assign Handheld Function Keys | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
51 | TWIC1310 | Retail Store HH: Assign Handheld Applications | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
52 | TWIC1310A | Retail Store HH: Assign Handheld Applications | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
53 | TWIC1310B | Retail Store HH: Assign Handheld Applications | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
54 | TWIC1320 | Assignment of menu items | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
55 | TWIC1320T | Assignment of menu item texts | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
56 | TWICMESSAGE | SAP Retail Store: Define Characteristics of System Messages | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
57 | TWICSCM | IACs Retail: Customizing schemas | 3 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
58 | TWICSCMF | SAP Retail Store: Assignment of Customizing Schemas to Site | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |
59 | TWICSCMT | IACs Retail: Customizing Schema Texts | 4 | CSTSCM | Retail IACs: Customizing or Grouping Schema | nvarchar | 4 | 0 | | |