| 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 | 12 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
2 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 303 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
3 | /XFT/QMPPAPT001 | QM Sampling Header Table | 12 | PLNNR | Task List Group Key | nvarchar | 8 | 0 | | |
4 | PDS_OPR_MAPPING | Persistant operation mapping for PDS integration | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
5 | SGT_PLKOS | Task list - header - Segmentation | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
6 | ZPS1 | IDES Text Pools | 7 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
7 | ZPS12 | Project system: Text symbol assign. Standard netw/Routing | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
8 | ZPS12F | Project system: Text symbol assign. Standard netw/Routing | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
9 | ZPS13 | Proj.system: Text symbol assign. proced. std.netw./wrk ctr | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
10 | ZPS1_OLD | IDES: Assign text pool to standard structure | 7 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPActive Quality Control |
11 | QDQL | Quality level | 5 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPActual CostingMaterial Ledger |
12 | CKMLMV013 | Assignment table: Process for production order | 20 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
13 | FCML_ALT | Alternatives | 11 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
14 | FCML_PROC | Business Processes | 13 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPBasic Data |
15 | MKAL | Production Versions of Material | 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPCapacity Leveling |
16 | PIBA | Process planning interface: Production requirements | 15 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
17 | TCYTM | Transition matrix | 16 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPComputer Aided Process Planning |
18 | PLPH | CAPP: Sub-operations | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPControl Plan |
19 | QPCPD_ITEM | Item of Control Plan | 11 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
20 | MMAPL | Allocation of task lists to materials | 5 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
21 | MMARC | Plant Data for Material | 107 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
22 | PLLPO | Task list - operation/activity | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPDistribution Requirements Planning |
23 | PLPLAN_PARAM | BOM-dependent planning parameter | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPEnvironment, Health and Safety |
24 | EHQMT_IP_MEMORY | EH&S-QM: Memorize Created Inspection Plans | 2 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPFlow Manufacturing |
25 | LDLBP | Line balance items | 11 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPInspection Planning |
26 | PLMK | Inspection plan characteristics | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
27 | PLMW | MAPL-Dependent Charac. Specifications (Inspection Plan) | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
28 | QMIPD_SPECIP_MAT | Mapping Table Between Inspection Plan and EHS Specification | 5 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
29 | QMIPD_SPECMATLOG | Status of Synchr. Between Inspection Plan and Specification | 5 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPIntegrated Product and Process Engineering |
30 | CMIG_MAPPING | Mapping Table (Classic PP and iPPE Objekt Key) | 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
31 | CMIG_STATUS | Status Table (iPPE Migration) | 6 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPLO Integration |
32 | CURTO_PDS_CHG | Change Pointer for Production Data Structure | 9 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPLogbook |
33 | ADFSH_PRTDET | Flight Scheduling: PRT Detail | 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
34 | ADFSH_PRTMAS | Flight Scheduling: PRT Master | 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaintenance History |
35 | HIKO | Order master data history | 25 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
36 | HIVG | PM order history - operations | 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaintenance Notifications |
37 | QMIH | Quality message - maintenance data excerpt | 35 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaintenance Program Definition |
38 | MPDITEM | Maintenance Plan Items | 15 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
39 | MPDPSD | MPD: MPD and MP header data | 35 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaintenance Task Lists |
40 | EAPL | Allocation of task lists to pieces of equipment | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
41 | MPOS | Maintenance item | 16 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
42 | PLWP | Allocation of maintenance packages to task list operations | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
43 | TAPL | Allocation of task lists to functional locations | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaster Data |
44 | PLAF | Planned Order | 61 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
45 | SAFK | Run Schedule Master Data | 34 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaster Data Distribution |
46 | /ISDFPS/TL1 | Task List - Operation/Activity | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaster Recipe |
47 | CPC_CMX_DB_COR | Master Recipe: Context Table for Recipe Header | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
48 | CPC_CMX_DB_COS | Master Recipe: Context Table for Recipe Operations/Phases | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
49 | CPC_CMX_DB_R_COR | Routing: Context Table for Plan Header | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
50 | CPC_CMX_DB_R_COS | Routing: Context Table for Operations | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
51 | PLFT | Process Instructions | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
52 | PLFV | PI Characteristics/Sub-Operation Parameter Values | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPMaterial Master |
53 | MARC | Plant Data for Material | 107 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
54 | MARC_TMP | File for Incorrect Data in Direct Input | 110 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
55 | MVRC | Cross-version fields for MARC | 107 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPNetwork and Activity |
56 | MLST | Milestone | 13 | PLNNR | Standard network number | nvarchar | 8 | 0 | | |
57 | PLAB | Relationships | 3 | PLNNR | Number of the Standard Network | nvarchar | 8 | 0 | | |
TOPNetwork Objects |
58 | GHO_IFLOT_EXT | Function location extension table | 16 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPPermits |
59 | IHSG | Object-Related Permits in Plant Maintenance | 26 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPPlant Maintenance |
60 | S180 | APO: Long-Term Planning | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
61 | S180E | S180 - Structure Information | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
62 | Z9I_STK_VORGANG | Terminkontrolle Stillstandsplanung: Relevante Vorgänge | 8 | PLNNR | Schlüssel der Plangruppe | nvarchar | 8 | 0 | | |
63 | Z9MIANF | Stillstanndsplanung - Daten für Anfragen | 7 | PLNNR | Schlüssel der Plangruppe | nvarchar | 8 | 0 | | |
64 | Z9MISTP | Stillstandsplanung | 5 | PLNNR | Schlüssel der Plangruppe | nvarchar | 8 | 0 | | |
TOPProcess Order |
65 | AFFT | Order - Process Instructions | 7 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
66 | AFFV | Order - Process Instruction Values | 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPProduct Cost by Period |
67 | CHZP | Reporting Points - Change History | 23 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
68 | CKPE | CO-PC Cost Object Hierarchy: Individual Objects | 13 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPProduct Cost Planning |
69 | KALM | Costing Run: Costing Objects | 23 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
70 | KALO | Costing Run: Costing Objects (KVMK) | 17 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
71 | KEKO | Product Costing - Header Data | 26 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPProduct Lifecycle Management |
72 | DIWPS_CR | Work Package Cross-Reference Notification | 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
73 | DIWPS_NOTI_PCOMP | Table for Partically Completed Notifications | 4 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
74 | DIWPS_RV_CR | Revision: Cross-Reference Notification | 7 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPProduction Campaign |
75 | PCMO3 | Pegged production campaign: recipe | 9 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPProduction Orders |
76 | AFFL | Work order sequence | 5 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
77 | AFKO | Order Header Data PP Orders | 19 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
78 | AFVC | Operation within an order | 9 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPQuality Inspection |
79 | QALS | Inspection lot record | 68 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPResourcen Management |
80 | MRTRST_HDR | RMS-MRTRS : MR Transformation Header | 22 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
81 | RMXTT_Q11 | Building Blocks for Stability Study: Planning Data | 14 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
82 | RMXTT_TRIAL_QMPL | Trial: Assigned Inspection Plans for Post-Process Control | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPRouting |
83 | MAPL | Assignment of Task Lists to Materials | 5 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
84 | PLAS | Task list - selection of operations/activities | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
85 | PLFH | Task list - production resources/tools | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
86 | PLFL | Task list - sequences | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
87 | PLKO | Task list - header | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
88 | PLKZ | Task list: main header | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
89 | PLMZ | Allocation of bill of material items to operations | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
90 | PLPO | Task list - operation/activity | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
91 | PLPR | Log collector for task lists | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
92 | PLSR | Scheduling results | 6 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
93 | PLZU | Routing data for group | 3 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPRouting EBOM Assignment |
94 | /PLMI/RTGRCALNKH | Routing Component Assignment Link | 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPSales Plan |
95 | P445E | Planning Object Index for Rough-Cut Planning Profiles | 6 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPSamples and SPC |
96 | QASH | Quality control chart | 7 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPScheduling |
97 | KBED | Capacity Requirements Records | 38 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
98 | KBKO | Header Record for Capacity Requirements | 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPSCM Basis |
99 | CIF_IMPPM | Int. Model Reference Table for Production Process Model | 9 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
100 | CIF_MD_CHANGES | Changes to BOM, Routing and Production Version | 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
TOPSimulation |
101 | VSAFFL_CN | Version: Order sequences PP orders | 6 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
102 | VSAFKO_CN | Version: Order header data for PP orders | 20 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
103 | VSAFVC_CN | Version: Operation in order | 10 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
104 | VSKBED_CN | Version: Capacity requirement records | 39 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
105 | VSKBKO_CN | Version: Capacity requirements header for an order | 9 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |
106 | VSMLST_CN | Version: Milestone | 14 | PLNNR | Standard network number | nvarchar | 8 | 0 | | |
107 | VSPLAF_CN | Version: Planned order | 61 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | | |