| 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 | 19 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
2 | /SMERP/STG_PM007 | Data staging - Equip List Set - Char Values - complex table | 27 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
3 | /SMERP/STG_PM011 | Data staging - Func Loc. LSet - Classifications - Cmplx Tab | 19 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
4 | /SMERP/STG_PM012 | Data staging - Func Loc LSet - Char Values - complex table | 27 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
5 | AUSP_CONV | Characteristic Values | 20 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
6 | CNV_10400_SETUP | Settings for characteristic conversion | 17 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
7 | KSSK_CONV | Allocation Table: Object to Class | 12 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
8 | PDS_OPR_MAPPING | Persistant operation mapping for PDS integration | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPABAP List-Based PI Sheet |
9 | COTRP | PI Sheet: Process Parameter Texts (Versions) | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPAssortment Maintenance |
10 | TWSAI | (Annual) Seasons | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
11 | TWSAJ | Annual seasons (distribution chain-specific) | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
12 | WSOP | Modules SAP Retail / Item Data | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPBasic Data |
13 | MKAL_AEND | Change History of Production Version (Recipes Only) | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPBills of Material |
14 | STAS | BOMs - Item Selection | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
15 | STKO | BOM Header | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
16 | STPO | BOM item | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
17 | T415A | Alternative BOM Determination | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPCharacteristics |
18 | CABN | Characteristic | 48 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
19 | CABNNEW | Characteristic | 48 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
20 | CABNT | Characteristic Descriptions | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
21 | CAWN | Characteristic values | 15 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
22 | CAWNT | Value Texts | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
23 | CUFM | Customizing: Class/Config: Screendesigner Form | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
24 | CUSD | Customizing: Class/Config: Screendesigner | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
25 | CUSDT | Customizing: Class/Config: Screendesigner Descriptions | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
26 | CUSF | Customizing: Class/Config: Screendesigner Frame | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
27 | CUSFT | Customizing: Class/Config: Screendesigner Frame Desc. | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPClasses |
28 | AUSP | Characteristic Values | 20 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
29 | INOB | Link between Internal Number and Object | 15 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
30 | KSML | Characteristics of a Class | 12 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
31 | KSSK | Allocation Table: Object to Class | 12 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPComputer Aided Process Planning |
32 | PLPH | CAPP: Sub-operations | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPConfiguration management |
33 | IBINCM | IB: Config.Mang.: Component/Instance | 14 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPCross-Application Component CA Enhancements |
34 | MILL_CLPROFP | Profile for Selection by Characteristics: Items | 31 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
35 | MMAPL | Allocation of task lists to materials | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
36 | PLLPO | Task list - operation/activity | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPDemand Management |
37 | TPHVP | Header: Planning Profile | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
38 | TPLVP | Planning Profile | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
39 | TPSVP | Planning profile lines | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPDistribution Requirements Planning |
40 | PLPLAN_PARAM | BOM-dependent planning parameter | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPEngineering Change Management |
41 | AEDT | Engineering Change Management: Alternative Dates | 4 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
42 | AENR | Change Master | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
43 | AEPLST | Identical object in explosion (item) | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPEnvironment |
44 | LCABN | Characteristic | 48 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
45 | LCABNT | Characteristic descriptions | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
46 | LKSML | Characteristics of a Class | 12 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
47 | LKSSK | Allocation Table: Object to Class | 12 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPInspection Planning |
48 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 14 | DATUV | Valid-from date | nvarchar | 8 | 0 | | |
49 | QMSP | QM: material specification | 4 | DATUV | Date, for Which the Change Is Planned | nvarchar | 8 | 0 | | |
TOPInstalled Base |
50 | IBIN | IB: IBase Components - Condition | 14 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPMaintenance Task Lists |
51 | EAPL | Allocation of task lists to pieces of equipment | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
52 | PLWP | Allocation of maintenance packages to task list operations | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
53 | TAPL | Allocation of task lists to functional locations | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPMaster Data |
54 | T439G | PPplanning periods: header table | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPMaster Data Distribution |
55 | /ISDFPS/TL1 | Task List - Operation/Activity | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPMaster Recipe |
56 | PLFT | Process Instructions | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
57 | PLFV | PI Characteristics/Sub-Operation Parameter Values | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPNetwork and Activity |
58 | MLST | Milestone | 4 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
59 | PLAB | Relationships | 12 | DATUV | Valid-from date | nvarchar | 8 | 0 | | |
TOPObject Dependencies |
60 | CUCVRNT | Variants of Constraints | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
61 | CUEX | Dependency Storage - Compilation | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
62 | CUKB | Administrative Information for Dependency Maintenance | 20 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
63 | CUKBT | Text Table for Dependency Maintenance Admin. Information | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
64 | CUKN | Dependency Storage - Variants/Configuration | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
65 | CUOB | Assignment of Object to Dependency | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
66 | CURSADD | Dependency Net Additional Data | 10 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
67 | CURSVAR | Internal Variables of Constraints | 15 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
68 | CUVTLN | Line object of variant table | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
69 | CUXREF | Object Dependency Cross References | 11 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
70 | PA0243 | Infotype 0243 - illnesses CZ | 26 | DATUV | Date for exception | nvarchar | 8 | 0 | | |
TOPProcess Management |
71 | COCC | PP-PI: Attributes for Characteristics | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
72 | COCC2 | PP-PI: Customer-Specific Attributes for Characteristics | 4 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPProduct Safety |
73 | TCGRULPOSMREST | EHS: Easy Expert Set of Rules, Characteristic Restrictions | 85 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPProduction ResourcesTools |
74 | CRFH | CIM production resource/tool master data | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPPurchasing |
75 | AMPL | Table of Approved Manufacturer Parts | 7 | DATUV | Date as of which the MPN materail may be procured | nvarchar | 8 | 0 | | |
76 | AMPL_REJECTION | Rejection of AMPL Row | 7 | DATUV | Date as of which the MPN materail may be procured | nvarchar | 8 | 0 | | |
TOPReporting |
77 | MCSHIERB | Tree for general hierarchy | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPResourcen Management |
78 | MRTRST_QM_REL | RMS-MRTRS : QM of GR Element to QM of MR Element | 11 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPRouting |
79 | MAPL | Assignment of Task Lists to Materials | 9 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
80 | PLAS | Task list - selection of operations/activities | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
81 | PLFH | Task list - production resources/tools | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
82 | PLFL | Task list - sequences | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
83 | PLKO | Task list - header | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
84 | PLMZ | Allocation of bill of material items to operations | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
85 | PLPO | Task list - operation/activity | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPSAP Ambulatory Care Management |
86 | N2HM_INDIKKEY | Heilmittelverordnung: Indikationsschlüssel | 4 | DATUV | Datum gültig ab | nvarchar | 8 | 0 | | |
87 | N2HM_KPF | ACM: Kopfdaten zum Heilmittelkatalog | 5 | DATUV | Datum gültig ab | nvarchar | 8 | 0 | | |
TOPSimulation |
88 | VSMLST_CN | Version: Milestone | 5 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPTariffs, Duties and Permits |
89 | OIH01 | Excise Duty Rates Table | 6 | DATUV | Excise duty rate valid from date | nvarchar | 8 | 0 | | |
90 | OIH01A | Excise Duty Rates Table | 9 | DATUV | Excise duty rate valid from date | nvarchar | 8 | 0 | | |
91 | OIH09 | Excise duty defaults for Stock Transfers | 10 | DATUV | Date from | nvarchar | 8 | 0 | | |
TOPVariant Configuration |
92 | CECUFM | Configuration editor: design: format | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
93 | CECUSD | Configuration editor: design: basic data | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
94 | CECUSDT | Configuration editor: design: descriptions | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
95 | CECUSF | Configuration editor: design: borders | 7 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
96 | CECUSFT | Configuration editor: design: Border descriptions | 8 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
97 | CUCO | Additional Data for Configurable Objects | 18 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
98 | KRIF | Richie Riffle | 6 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |
TOPVendor Evaluation |
99 | ELBM | Vendor Evaluation: Material-Related Item | 10 | DATUV | Date | nvarchar | 8 | 0 | | |
TOPWarranties |
100 | BGMP | Master Warranty Item | 22 | DATUV | Valid-From Date | nvarchar | 8 | 0 | | |