| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /PLMI/GSS_R2M_SU | GSS Recipe -> Master Recipe: Sync Units Table | 13 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
2 | SGT_PLKOS | Task list - header - Segmentation | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
3 | ZPS12 | Project system: Text symbol assign. Standard netw/Routing | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
4 | ZPS12F | Project system: Text symbol assign. Standard netw/Routing | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPActive Quality Control |
5 | QDQL | Quality level | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPActual CostingMaterial Ledger |
6 | CKMLMV013 | Assignment table: Process for production order | 21 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
7 | FCML_ALT | Alternatives | 12 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
8 | FCML_PROC | Business Processes | 14 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPCapacity Leveling |
9 | PIBA | Process planning interface: Production requirements | 16 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
10 | TCYTM | Transition matrix | 17 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPControl Plan |
11 | QPCPD_ITEM | Item of Control Plan | 12 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
12 | MMAPL | Allocation of task lists to materials | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPData Collection |
13 | S161 | Inspection Results: General | 29 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
14 | S162 | Quantitative Inspection Results | 29 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
15 | S163 | Quantitative Inspection Result: Vendor | 30 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
16 | S164 | Quantitative Inspection Result: Vendor | 30 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
17 | S165 | Inspection Results (General): Customers | 29 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
18 | S166 | Quantitative Inspection Results: Customer | 30 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPDistribution Requirements Planning |
19 | PLPLAN_PARAM | BOM-dependent planning parameter | 12 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPEnvironment, Health and Safety |
20 | EHQMT_IP_MEMORY | EH&S-QM: Memorize Created Inspection Plans | 3 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPFlow Manufacturing |
21 | LDLBP | Line balance items | 12 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPInspection Planning |
22 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 13 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
23 | QMIPD_SPECIP_MAT | Mapping Table Between Inspection Plan and EHS Specification | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
24 | QMIPD_SPECMATLOG | Status of Synchr. Between Inspection Plan and Specification | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPIntegrated Product and Process Engineering |
25 | CMIG_MAPPING | Mapping Table (Classic PP and iPPE Objekt Key) | 11 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPLogbook |
26 | ADFSH_PRTDET | Flight Scheduling: PRT Detail | 11 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
27 | ADFSH_PRTMAS | Flight Scheduling: PRT Master | 11 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPMaintenance History |
28 | HIKO | Order master data history | 26 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPMaintenance Notifications |
29 | QMIH | Quality message - maintenance data excerpt | 36 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPMaintenance Orders |
30 | /CUM/AFCU | CU: CU Instances | 4 | PLNAL | CU: Group Counter for Plant in Task List | nvarchar | 2 | 0 | | |
31 | /CUM/CUNITWERK | CU: TL selection: group center for plant, virtual CUI deter. | 3 | PLNAL | CU: Group Counter for Plant in Task List | nvarchar | 2 | 0 | | |
TOPMaintenance Program Definition |
32 | MPDITEM | Maintenance Plan Items | 16 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
33 | MPDPSD | MPD: MPD and MP header data | 36 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPMaintenance Task Lists |
34 | EAPL | Allocation of task lists to pieces of equipment | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
35 | MPOS | Maintenance item | 17 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
36 | PLWP | Allocation of maintenance packages to task list operations | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
37 | TAPL | Allocation of task lists to functional locations | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPMaster Data |
38 | PLAF | Planned Order | 62 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPMaster Recipe |
39 | CPC_CMX_DB_COR | Master Recipe: Context Table for Recipe Header | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
40 | CPC_CMX_DB_R_COR | Routing: Context Table for Plan Header | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPNetwork and Activity |
41 | MLST | Milestone | 15 | PLNAL | Alternative to a standard network | nvarchar | 2 | 0 | | |
42 | PLAB | Relationships | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPNetwork Objects |
43 | GHO_IFLOT_EXT | Function location extension table | 17 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPPermits |
44 | IHSG | Object-Related Permits in Plant Maintenance | 27 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPPlant Maintenance |
45 | S180 | APO: Long-Term Planning | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
46 | S180E | S180 - Structure Information | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
47 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 9 | PLNAL | Plangruppenzähler | nvarchar | 2 | 0 | | |
48 | Z9MIANF | Stillstanndsplanung - Daten für Anfragen | 8 | PLNAL | Plangruppenzähler | nvarchar | 2 | 0 | | |
49 | Z9MISTP | Stillstandsplanung | 6 | PLNAL | Plangruppenzähler | nvarchar | 2 | 0 | | |
TOPProduct Cost by Period |
50 | CHZP | Reporting Points - Change History | 24 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
51 | CKPE | CO-PC Cost Object Hierarchy: Individual Objects | 8 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPProduct Cost Planning |
52 | KALM | Costing Run: Costing Objects | 24 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
53 | KALO | Costing Run: Costing Objects (KVMK) | 18 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
54 | KEKO | Product Costing - Header Data | 28 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPProduct Lifecycle Management |
55 | DIWPS_CR | Work Package Cross-Reference Notification | 11 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
56 | DIWPS_NOTI_PCOMP | Table for Partically Completed Notifications | 5 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
57 | DIWPS_RV_CR | Revision: Cross-Reference Notification | 8 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPProduction Campaign |
58 | PCMO3 | Pegged production campaign: recipe | 10 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPProduction Orders |
59 | AFFL | Work order sequence | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
60 | AFKO | Order Header Data PP Orders | 21 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
61 | AFVC | Operation within an order | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPQuality Inspection |
62 | QALS | Inspection lot record | 70 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPResourcen Management |
63 | MRTRST_HDR | RMS-MRTRS : MR Transformation Header | 23 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
64 | RMXTT_Q11 | Building Blocks for Stability Study: Planning Data | 15 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
65 | RMXTT_TRIAL_QMPL | Trial: Assigned Inspection Plans for Post-Process Control | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPRouting |
66 | MAPL | Assignment of Task Lists to Materials | 6 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
67 | PLAS | Task list - selection of operations/activities | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
68 | PLFH | Task list - production resources/tools | 18 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
69 | PLFL | Task list - sequences | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
70 | PLKO | Task list - header | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
71 | PLKZ | Task list: main header | 4 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
72 | PLMZ | Allocation of bill of material items to operations | 11 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
73 | PLSR | Scheduling results | 7 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPRouting EBOM Assignment |
74 | /PLMI/RTGRCALNKH | Routing Component Assignment Link | 9 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPSales Plan |
75 | P445E | Planning Object Index for Rough-Cut Planning Profiles | 7 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPSamples and SPC |
76 | QASH | Quality control chart | 8 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPScheduling |
77 | KBED | Capacity Requirements Records | 39 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
78 | KBKO | Header Record for Capacity Requirements | 9 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
TOPSimulation |
79 | VSAFFL_CN | Version: Order sequences PP orders | 7 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
80 | VSAFKO_CN | Version: Order header data for PP orders | 22 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
81 | VSAFVC_CN | Version: Operation in order | 7 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
82 | VSKBED_CN | Version: Capacity requirement records | 40 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
83 | VSKBKO_CN | Version: Capacity requirements header for an order | 10 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |
84 | VSMLST_CN | Version: Milestone | 16 | PLNAL | Alternative to a standard network | nvarchar | 2 | 0 | | |
85 | VSPLAF_CN | Version: Planned order | 62 | PLNAL | Group Counter | nvarchar | 2 | 0 | | |