| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_PM006 | Data staging - Equip List Set - Classifications - Cmplx Tab | 20 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
2 | /SMERP/STG_PM007 | Data staging - Equip List Set - Char Values - complex table | 28 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
3 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 20 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
4 | /SMERP/STG_PM012 | Data staging - Func Loc LSet - Char Values - complex table | 28 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
5 | AUSP_CONV | Characteristic Values | 21 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
6 | CNV_10400_SETUP | Settings for characteristic conversion | 18 | LKENZ | Deletion indicator | nvarchar | 1 | 0 | | |
7 | KSSK_CONV | Allocation Table: Object to Class | 13 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPBills of Material |
8 | CSORDER_MAT | Administration of generated materials per sales order | 15 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
9 | CSPRJ_MAT | Management of generated materials to project | 14 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
10 | STAS | BOMs - Item Selection | 10 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
11 | STKO | BOM Header | 9 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
12 | STPO | BOM item | 9 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPCharacteristics |
13 | CABN | Characteristic | 51 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
14 | CABNNEW | Characteristic | 51 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
15 | CABNT | Characteristic Descriptions | 11 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
16 | CAWN | Characteristic values | 18 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
17 | CAWNT | Value Texts | 10 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPClasses |
18 | AUSP | Characteristic Values | 21 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
19 | KSML | Characteristics of a Class | 15 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
20 | KSSK | Allocation Table: Object to Class | 13 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPDemand Management |
21 | TPHVP | Header: Planning Profile | 10 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
22 | TPLVP | Planning Profile | 8 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
23 | TPSVP | Planning profile lines | 11 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPEnvironment |
24 | LCABN | Characteristic | 51 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
25 | LCABNT | Characteristic descriptions | 11 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
26 | LKSML | Characteristics of a Class | 15 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
27 | LKSSK | Allocation Table: Object to Class | 13 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPObject Dependencies |
28 | CUCVRNT | Variants of Constraints | 7 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
29 | CUEX | Dependency Storage - Compilation | 7 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
30 | CUKB | Administrative Information for Dependency Maintenance | 18 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
31 | CUKN | Dependency Storage - Variants/Configuration | 5 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
32 | CUOB | Assignment of Object to Dependency | 8 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
33 | CURSADD | Dependency Net Additional Data | 8 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
34 | CURSVAR | Internal Variables of Constraints | 13 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
35 | CUXREF | Object Dependency Cross References | 9 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPVariant Configuration |
36 | IBVALUEC | CBASE: Redundant Object Doc. on Value Changes for Instance | 15 | LKENZ | Deletion Indicator | nvarchar | 1 | 0 | | |