| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMD/MD_____00BH | SID-Tabelle fuer Internal class no. | 3 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
2 | /SMERP/STG_PM006 | Data staging - Equip List Set - Classifications - Cmplx Tab | 12 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
3 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 12 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
4 | CNV_10400_SETUP | Settings for characteristic conversion | 21 | CLINT | Internal Class Number / copy of CLINT | nvarchar | 10 | 0 | | |
5 | KSSK_CONV | Allocation Table: Object to Class | 5 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
6 | ZEIM_LIPS | SD document: Delivery: Item data | 156 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
7 | ZEIM_VBAP | Sales Document: Item Data | 170 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPBills of Material |
8 | CLST | Link class - BOM | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPCharacteristics |
9 | CABN | Characteristic | 65 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
10 | CABNNEW | Characteristic | 65 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
11 | CUFM | Customizing: Class/Config: Screendesigner Form | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
12 | CUSD | Customizing: Class/Config: Screendesigner | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
13 | CUSDT | Customizing: Class/Config: Screendesigner Descriptions | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
14 | CUSF | Customizing: Class/Config: Screendesigner Frame | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
15 | CUSFT | Customizing: Class/Config: Screendesigner Frame Desc. | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPClasses |
16 | CLAENNR | Change number-to-class alloc.: classification effectivity | 3 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
17 | INOB | Link between Internal Number and Object | 8 | CLINT | Internal Class Number of Configurable Object | nvarchar | 10 | 0 | | |
18 | KLAH | Class Header Data | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
19 | KLAT | Classes: Long Texts | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
20 | KSML | Characteristics of a Class | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
21 | KSSK | Allocation Table: Object to Class | 5 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
22 | SWOR | Classification System: Keywords | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPClassification System New |
23 | CME_ST_R3_ATTR | CME Characteristic: R/3 Attributes | 8 | CLINT | Class of User-Defined Data Type | nvarchar | 18 | 0 | | |
24 | CME_ST_R3_ATTRH | CME Characteristic: R/3 Attributes | 6 | CLINT | Class of User-Defined Data Type | nvarchar | 18 | 0 | | |
TOPConditions |
25 | KONDH | Conditions: Batch Strategy - Data Division | 13 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPConfiguration Control |
26 | MPL_C_ADAPTER | Adapter for iPPE Workbench | 7 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPCross-Application Component CA Enhancements |
27 | MILL_CLPROFC | Profile for Selection by Characteristics: Classes | 4 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPCross-Application Components |
28 | FRE_MC_MCH_KEYW | Language dependent Text for Merch.Categor. and MC-Hierarchy | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
29 | FRE_MC_MCH_NODE | Merchandise Category and MC-Hier. Node sent to F&R | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
30 | FRE_SITE_GROUP | Site Group Assignments relevant for Det.of Processing Method | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
31 | VVBAP | Sales Document: Item Data | 170 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPData Collection |
32 | S137 | Variants: Basis 2 | 11 | CLINT | Characteristics combination | nvarchar | 10 | 0 | | |
33 | S137E | S137 -Structural Information | 6 | CLINT | Characteristics combination | nvarchar | 10 | 0 | | |
34 | S138 | Variants: SIS & planning | 14 | CLINT | Characteristics combination | nvarchar | 10 | 0 | | |
35 | S138E | S138 - Structural Information | 9 | CLINT | Characteristics combination | nvarchar | 10 | 0 | | |
TOPDemand Management |
36 | TPLVP | Planning Profile | 4 | CLINT | Internal number of variant table | nvarchar | 10 | 0 | | |
37 | TPSVP | Planning profile lines | 4 | CLINT | Internal number of variant table | nvarchar | 10 | 0 | | |
TOPEngineering Change Management |
38 | AENR | Change Master | 22 | CLINT | Internal class number describing effectivity type | nvarchar | 10 | 0 | | |
39 | TCCER | Links Between Effectivity Types and Parameters | 4 | CLINT | Internal class number describing effectivity type | nvarchar | 10 | 0 | | |
TOPEnvironment |
40 | LCABN | Characteristic | 65 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
41 | LKLAH | Class Header (Special Objects) | 2 | CLINT | Internal class number | nvarchar | 10 | 0 | | |
42 | LKSML | Characteristics of a Class | 2 | CLINT | Internal class number | nvarchar | 10 | 0 | | |
43 | LKSSK | Allocation Table: Object to Class | 5 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
44 | LSWOR | Classification System: Keywords | 2 | CLINT | Internal class number | nvarchar | 10 | 0 | | |
TOPIntegrated Product and Process Engineering |
45 | CPNTYPE | Customizing Table for iPPE Node Type | 15 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
46 | CPVTYPE | Customizing Table for the iPPE Variant Types | 12 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
47 | PNODE | Positionsknoten in der PVS | 5 | CLINT | Interne Klassennummer | nvarchar | 10 | 0 | | |
48 | PNODID | iPPE Node: Identification | 7 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
49 | PPEFILTEXPL | This table is obsolete, use PPEFILTEXPLPAR | 9 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
50 | PPEFILTEXPLPAR | Explosion Parameters for the iPPE Filter | 10 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
51 | PPESCMPV | iPPE Status, BOM-Specific Data | 6 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
52 | PVCMPR | PVS Variant (CMP): Supplement to the Selection Criteria | 4 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
53 | PVS_VSHEME | Variance Scheme for Structure Node | 4 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
54 | USRGISETTINGS | User Settings for the iPPE Workbench | 6 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
55 | USRTICLASS | Class Assignment for Tabular Maintenance of iPPE | 3 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPMaster data |
56 | PACKPO | Packing Object Item | 8 | CLINT | Material class or packing instructions class | nvarchar | 10 | 0 | | |
TOPMaterial Groups |
57 | T023S | Base Material Group/Hierarchy Material Assignment | 4 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPObject Selection |
58 | GEN_TABLES_MAIN | Generated Tables for Search in Classification System | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
59 | GEN_TABLES_SUB | Generated Tables for Multiple-Value Characteristics | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPPlant Master |
60 | TWRF2 | Plant Profiles | 4 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPProduct Cost Planning |
61 | CKTC_KALNR | Database Table for Costing Numbers | 6 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPProduct Safety |
62 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 7 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPPromotion |
63 | WAGU | Validity of plant groups - IS-R | 3 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
64 | WAKRW | Promotion discounts by plant | 7 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
65 | WALE | Material to store assignment to promotion | 6 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
66 | WAZB | Module plant-group assignment | 8 | CLINT | Internal class number | nvarchar | 10 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
67 | /BEV1/RBVBAP | Sales Document: Item Data | 170 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPSales |
68 | VBAP | Sales Document: Item Data | 170 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPShipping |
69 | LIPS | SD document: Delivery: Item data | 156 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPSimulation |
70 | VSVBAP_CN | Version: Sales document: Item data | 171 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
TOPVariant Configuration |
71 | CDCND | Configuration: Direct Conditions Data Type:CHAR | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
72 | CLRK | Recursiveness Info on Objects in Classes for BOM | 5 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
73 | CUCO | Additional Data for Configurable Objects | 6 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |
74 | KRIF | Richie Riffle | 2 | CLINT | Internal Class Number | nvarchar | 10 | 0 | | |