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