| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPMerchandise and Assortment Planning |
| 1 | TWISPC_KENNF | Retail Planning: Key Figure Formula for Planning Steps | 7 | FORTP | Formula Type (Arithmetic, Previous Period, Coverage,...) | nvarchar | 2 | 0 | | |
| TOPUse Subcomponents |
| 2 | SOCS | SAPoffice: table for storage of an Office ID (SAPcomm) | 14 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 3 | SOCX | SAPoffice: table for storing SAPcomm IDs | 13 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 4 | SOFM | SAPoffice: Folder contents | 8 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 5 | SOID | SAPoffice: Inverse record for distribution list | 13 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 6 | SOMG | Table for persistence of objects MESSAGE/RECIPIENT | 16 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 7 | SOOS | SAPoffice: send process | 5 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 8 | SORS | SAPoffice: Resubmission of user | 8 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 9 | SOSC | SAPoffice: Connection table to SAPcomm and SAPconnect | 6 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
| 10 | SOST | SAPoffice: Status log table | 5 | FORTP | Forwarder: Object type from ID | nvarchar | 3 | 0 | | |
