| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /1ISRWP/800H0101 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 2 | /1ISRWP/800H0102 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 3 | /1ISRWP/800H0103 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 4 | /1ISRWP/800H0104 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 5 | /1ISRWP/800H0105 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 6 | /1ISRWP/800H0106 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 7 | /1ISRWP/800H0107 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 8 | /1ISRWP/800H0108 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 9 | /1ISRWP/800H0109 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 10 | /1ISRWP/800H0110 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 11 | /1ISRWP/800H0111 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 12 | /1ISRWP/800H0112 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 13 | /1ISRWP/800H0113 | Waren & Sortimentscontrolling: Planungshierarchietabelle | 1 | PLHVS | Planungshierarchie-Version | nvarchar | 3 | 0 | | |
| 14 | /1ISRWP/800H0201 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 15 | /1ISRWP/800H0202 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 16 | /1ISRWP/800H0203 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 17 | /1ISRWP/800H0204 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 18 | /1ISRWP/800H0205 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 19 | /1ISRWP/800H0206 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 20 | /1ISRWP/800H0207 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 21 | /1ISRWP/800H0208 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 22 | /1ISRWP/800H0209 | MAC: Planning Hierarchy Tables | 1 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| TOPMerchandise and Assortment Planning |
| 23 | TWISPC_PLHVS | Retail Planning: Version of Planning Hierarchy | 2 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 24 | TWISPC_PLHVST | Retail Planning: Texts for Planning Hierarchy Versions | 3 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 25 | TWISPC_VRSIO | Retail Planning: Add-Ons to the LIS Plan Version | 8 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
| 26 | TWISPH_TEMPLATE | MAC: Planning Hierarchy Tables | 2 | PLHVS | Version of a Planning Hierarchy | nvarchar | 3 | 0 | | |
