| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPLogistics Basic Data |
1 | WCMP | Category Management: Project | 8 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
TOPMerchandise and Assortment Planning |
2 | TWISPC_ANREI | Parameter for Updating Fields in Info Structures | 2 | PLSZN | Planning scenario for enhancement | nvarchar | 10 | 0 | | |
3 | TWISPC_BW_TIME | Assignment of Infocubes to Time Field in Planning Scenario | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
4 | TWISPC_CUA | Retail Planning: Customer-specific CUA Status and Title | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
5 | TWISPC_DPLVA | Retail Planning: Manual Planning Variants | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
6 | TWISPC_DPLVAT | Retail Planning: Texts for Manual Planning Variants | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
7 | TWISPC_DPLVV | Retail Planning: Default Parameters for Manual Plng Variants | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
8 | TWISPC_FCODES | Retail Planning: Customer-specific CUA Functions | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
9 | TWISPC_INT_ALLOC | Interface Parameters for "Allocation Table" Interface Cat. | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
10 | TWISPC_INT_LISTG | Interface Parameter for Interface Type "Listing" | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
11 | TWISPC_INT_PROMO | MAP: Planning Interface Category "Promotions" | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
12 | TWISPC_KENNF | Retail Planning: Key Figure Formula for Planning Steps | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
13 | TWISPC_KENNFG | Retail Planning: Formula Groups for Planning Steps | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
14 | TWISPC_KENNFGT | Retail Planning: Formula Groups for Planning Step Texts | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
15 | TWISPC_KENNFZ | Retail Planning: Formula Lines for Arithmetic Formulas | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
16 | TWISPC_KENNPAR | Retail Planning: Control Parameters for Key Figures | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
17 | TWISPC_KENNZ | Retail Planning: Additional Key Figures | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
18 | TWISPC_LEVELS | Retail Planning: Meaning of Individual Planning Levels | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
19 | TWISPC_MASCHPL | Retail Planning: Automatic Planning | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
20 | TWISPC_MASCHPLT | Text Tables for Automatic Planning | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
21 | TWISPC_MDATTR | Master Data Attributes | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
22 | TWISPC_MPLSCH | Reports/Tcodes for Planning Step Method Program/Transaction | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
23 | TWISPC_PLINT | MAP: Planning Interfaces - General Definitions | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
24 | TWISPC_PLINTT | Text Tables for Planning Interfaces | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
25 | TWISPC_PLSCH | Retail Planning: Planning Step | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
26 | TWISPC_PLSCHT | Retail Planning: Texts for Planning Step | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
27 | TWISPC_PLSCH_BW | BW Enhancements at Planning Step Level | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
28 | TWISPC_PLSCH_W | Retail Planning: Plng Step for Add. Table for Retail Applic. | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
29 | TWISPC_PLSZN | Retail Planning: Planning Scenario | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
30 | TWISPC_PLSZNT | Retail Planning: Texts for Planning Scenario | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
31 | TWISPC_PLSZN_BW | Retail Planning: Planning Scenario, BW Data Enhancement | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
32 | TWISPC_PLVER | Retail Planning: Planning Step Links | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
33 | TWISPC_PLVERT | Text Table for Planning Step Links | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
34 | TWISPC_REQHEAD | MAP: Customizing for External Applications | 3 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
35 | TWISPC_VRSIO | Retail Planning: Add-Ons to the LIS Plan Version | 4 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
36 | TWISPC_ZBRINT | Assignment of Break-Downs to Interfaces | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
37 | TWISPC_ZCUBE | Assignment of Cube Fields to MAP | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
38 | TWISPC_ZINTPL | Assignment of Interfaces to Planning Layouts | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
39 | TWISPC_ZKENN | Retail Planning: Assignment of Key Figs to the Planning Step | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
40 | TWISPC_ZKENN_W | Retail Planning: Assign. KeyFig/PlStep (Add. Retail Table) | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
41 | TWISPC_ZKNZINT | Assignment of Key Figures to Interfaces | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
42 | TWISPC_ZMERINT | Assignment of Characteristics to Interfaces | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
43 | TWISPC_ZMERK | Retail Planning: Assignment of Characteristics to Plng Step | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
44 | TWISPC_ZMERK_W | Retail Planning: Assign. Character/PlStep (Add.Retail Table) | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
45 | TWISPC_ZPSPL | Retail Planning: Assign. Planning Layouts to Plan Steps | 2 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
46 | TWISPS_NOALLOC1 | Parameters for Allocation Tables Generated in MAP | 7 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
47 | TWISPS_NOLISTG1 | Parameters for Allocation Tables Generated in MAP | 7 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |
48 | TWISPS_NOPROMO1 | Parameters for Promotions Created in MAP | 11 | PLSZN | Planning Scenario | nvarchar | 10 | 0 | | |