| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAuthorizations and Access Control Context |
1 | /PLMB/AUTH_OBSID | Object - Secure Identifier Assignment | 10 | CHNGBY | User ID | nvarchar | 12 | 0 | | |
2 | /PLMB/AUTH_SIDRP | Secure Identifier Repository | 10 | CHNGBY | User ID | nvarchar | 12 | 0 | | |
3 | /PLMB/AUTH_UGSID | User Entity - Secure ID - Activity List Assignment | 10 | CHNGBY | User ID | nvarchar | 12 | 0 | | |
TOPCommand and Support Relationships |
4 | /ISDFPS/FORCMD | Attributes of Task Organization | 16 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
5 | /ISDFPS/FORCMDID | Supply Relationship IDs | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
6 | /ISDFPS/FORMNT | Attributes of Maintenance Relationships | 16 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
7 | /ISDFPS/FORMNTID | IDs of Maintenance Relationships | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
8 | /ISDFPS/FOROTH | Attributes of Additional Relationships | 16 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
9 | /ISDFPS/FOROTHID | IDs of Other Relationships | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
10 | /ISDFPS/FORSUP | Attributes of Supply Relationships | 16 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
11 | /ISDFPS/FORSUPID | Supply Relationship IDs | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
12 | /ISDFPS/ORCMD | Task Organizations | 22 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
13 | /ISDFPS/ORCMD1 | Task Organization, Basic Types of Dependent Attributes | 7 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
14 | /ISDFPS/ORMNT | Maintenance Relationships | 22 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
15 | /ISDFPS/ORMNT1 | Maintenance Relationships, Basic Types, Dependent Attributes | 7 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
16 | /ISDFPS/OROTH | Additional Relationships | 22 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
17 | /ISDFPS/ORSUP | Supply Relationships | 22 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
18 | /ISDFPS/ORSUP1 | Supply Relationships, Basic Types, Dependent Attributes | 7 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
19 | /ISDFPS/ORTOB | Technical Object Relationships (Maintenance) | 22 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
TOPConfiguration Control |
20 | CCMHOLE | Structure Gap Table | 11 | CHNGBY | Object Changed by: | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
21 | /PTGWFI/F_PIRAPS | Workflow Runtime Stack for Parked Invoices | 18 | CHNGBY | User Name | nvarchar | 12 | 0 | | |
TOPEngineering Change Management |
22 | EDGE | Relation Between Change Numbers | 11 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
23 | ENODE | Nodes ECH | 9 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPForce Element |
24 | /ISDFPS/FORBE | Attributes of HR - BE Relationship | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
25 | /ISDFPS/FORBEID | IDs of HR - BE Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
26 | /ISDFPS/FORCE | Force Element (Database) | 35 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
27 | /ISDFPS/FORCEM | Authorized Materials | 25 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
28 | /ISDFPS/FORCEP | Material Packages | 17 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
29 | /ISDFPS/FORCER | Reference Force Element (Database) | 11 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
30 | /ISDFPS/FORCE_PR | Individual Threshold Values for Readiness | 19 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
31 | /ISDFPS/FORCN | Attributes of REC - HR Relationship | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
32 | /ISDFPS/FORCNID | IDs of HR - REC Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
33 | /ISDFPS/FORDEL | Planned Delimitation and Deletion Operations | 16 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
34 | /ISDFPS/FOREPA | Attributes of the Force Element - EPA Relationships | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
35 | /ISDFPS/FOREPAID | IDs of the Force Element - EPA Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
36 | /ISDFPS/FORIPO | FORCER: Authorized Infrastructure: Attributes | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
37 | /ISDFPS/FORIPOID | FORCER: Authorized Infrastructure: IDs | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
38 | /ISDFPS/FORMC | Attributes of the Material Container-Force Element Relatshp | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
39 | /ISDFPS/FORMCH | Attributes of the Material Container - HR Relationship | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
40 | /ISDFPS/FORMCHID | IDs of the HR - MC Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
41 | /ISDFPS/FORMCID | IDs of Material Container - Force Element Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
42 | /ISDFPS/FORMPH | Attributes of the HR - MPO Relationship | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
43 | /ISDFPS/FORMPHID | IDs of the HR - MPO Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
44 | /ISDFPS/FORMPO | Attributes of the Force Element - MPO Relationship | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
45 | /ISDFPS/FORMPOID | IDs of the Force Element - MPO Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
46 | /ISDFPS/FORRIC | Attributes of the Force Element - RIC Relationship | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
47 | /ISDFPS/FORRICID | IDs of the Force Element - RIC Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
48 | /ISDFPS/FORRR | FORCER: RE Search Request: Attributes | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
49 | /ISDFPS/FORRRID | FORCER: RE Search Request: IDs | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
50 | /ISDFPS/FORTOB | Attributes of Relationship to Technical Objects | 16 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
51 | /ISDFPS/FORTOBID | IDs of Relationship to Technical Objects | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
52 | /ISDFPS/FORVPA | Attributes of the Force Element - PPA Relationships | 13 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
53 | /ISDFPS/FORVPAID | IDs of the Force Element - PPA Relationships | 12 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
TOPIntegrated Product and Process Engineering |
54 | CPATYPE | Customizing Table for iPPE Alternative Types | 13 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
55 | CPNTYPE | Customizing Table for iPPE Node Type | 24 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
56 | CPPECNTL | General iPPE Customizing | 26 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
57 | CPRTYPE | Customizing: iPPE Relationships | 26 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
58 | CPVSMDL | Model Associations between the PVS Objects | 11 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
59 | CPVSMDLC | Model Associations between the Customer-Spec. PVS Objects | 11 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
60 | CPVTYPE | Customizing Table for the iPPE Variant Types | 19 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
61 | INSTANCEID | Geometric Instance: Identification | 13 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
62 | LINEBAL | Line Balance Versions in iPPE | 10 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
63 | MODMIXH | Model Mix Header Data | 8 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
64 | OMC_BASIC | Basic Settings: Enhanced Dependency Editor | 6 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
65 | OMC_MCDEP | Define Scheme for Enhanced Dependency Editor | 58 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
66 | OMC_MDEP | Enhanced Dependency Editor: Assign Scheme | 31 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
67 | PALTID | iPPE Alternative: Time-Independent ID and Attributes | 13 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
68 | PCOLMR | Color Key Master Record | 6 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
69 | PFOCID | iPPE Focus Master Record | 10 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
70 | PNDALT | Alternativensegment zum Positionsknoten | 9 | CHNGBY | Name des Sachbearbeiters, der das Objekt geändert hat. | nvarchar | 12 | 0 | | |
71 | PNDREL | Positionsknotenbeziehung in der PVS | 10 | CHNGBY | Name des Sachbearbeiters, der das Objekt geändert hat. | nvarchar | 12 | 0 | | |
72 | PNODE | Positionsknoten in der PVS | 11 | CHNGBY | Name des Sachbearbeiters, der das Objekt geändert hat. | nvarchar | 12 | 0 | | |
73 | PNODID | iPPE Node: Identification | 14 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
74 | POSVID | iPPE Variant: Identification | 13 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
75 | PPECPROOBJLNK | iPPE Assignment Table: Object Links with cProjects | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
76 | PPEHDR | iPPE Access Object | 21 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
77 | PPESPRECOND | iPPE Status Precondition, Central Data | 9 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
78 | PPESSTATUS | iPPE Status, Central Data | 12 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
79 | PRELACT | Relationships for the SNP and Workshop Plan | 18 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
80 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
81 | PRGEN | GEN Relationships - Relationships Table | 18 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
82 | PROJID | iPPE Assignment Table: PS Objects | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
83 | PRPVR | Relationship Between Variants: Identification and Attributes | 16 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
84 | PRSET | Set Relationships: Table of Links | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
85 | PRTST | Test Relationships - Relationships Table | 19 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
86 | PVS_VSHEME | Variance Scheme for Structure Node | 13 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
87 | PXARCID | Table for Archiving Indicators for iPPE Objects | 16 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
88 | RPPNT | iPPE Reporting Points | 8 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
89 | USRTICLASS | Class Assignment for Tabular Maintenance of iPPE | 10 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPLine Maintenance |
90 | /ISDFPS/LM_MIS | Mission | 9 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
TOPLOGFAS |
91 | /ISDFPS/GEOLOC | Geolocation Database Table | 29 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
92 | /ISDFPS/RIC | Reportable Item Code | 17 | CHNGBY | Last Changed by | nvarchar | 12 | 0 | | |
TOPLogistical Requirements |
93 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPMaster Data Distribution |
94 | /ISDFPS/CCMHOLER | Replication Table CCMHOLE | 11 | CHNGBY | Object Changed by: | nvarchar | 12 | 0 | | |
TOPMaterial Categories |
95 | /ISDFPS/PRMPO | Attributes of BOM Relationships | 14 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
96 | /ISDFPS/PRMPOC | Attributes of Relationships Between Matl Container and MPO | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
97 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
98 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 15 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPProduct and Process Modeling |
99 | RLMFWOH | Release Order - Header Data | 12 | CHNGBY | Changed by | nvarchar | 12 | 0 | | |
100 | RLMFWOL | Release Order - Items | 24 | CHNGBY | Changed by | nvarchar | 12 | 0 | | |
TOPRecipe |
101 | RCPT_PPMIG_CLASS | RMS-RCP: Class Migration Log | 6 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
102 | RCPT_PPMIG_ROOT | RMS-RCP: PP Migration Log | 6 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
103 | RCPT_PPMIG_STATS | RMS-RCP: Migration Steps - Status | 6 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
TOPResourcen Management |
104 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
105 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
106 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
107 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
108 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
109 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 17 | CHNGBY | Name of Person Who Changed Object | nvarchar | 12 | 0 | | |
110 | RMSAT_STD_PARA_H | RMS-ATL: Header Table Parameter Standardization | 13 | CHNGBY | Changed By | nvarchar | 12 | 0 | | |
111 | RMSLA_HD | Header Data of Label Set | 6 | CHNGBY | Changed By | nvarchar | 12 | 0 | | |
TOPRouting EBOM Assignment |
112 | /PLMI/RTGRCALNKH | Routing Component Assignment Link | 19 | CHNGBY | User Who Last Changed the Object | nvarchar | 12 | 0 | | |
113 | /PLMI/RTGRCASCOH | RCA Planning Scope Version | 10 | CHNGBY | User Who Last Changed the Object | nvarchar | 12 | 0 | | |
TOPWarranty Claim Processing |
114 | PNWTYH | Warranty Claim Header (PVS Node) | 47 | CHNGBY | Name of Person Responsible Who Changed Object | nvarchar | 12 | 0 | | |
115 | PNWTYV | Warranty Claim Version (PVS Node) | 43 | CHNGBY | Name of Person Responsible Who Changed Object | nvarchar | 12 | 0 | | |
116 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 15 | CHNGBY | Name of Person Responsible Who Changed Object | nvarchar | 12 | 0 | | |
117 | PVWTY | Warranty Claim Item (PPE Variant) | 52 | CHNGBY | Name of Person Responsible Who Changed Object | nvarchar | 12 | 0 | | |
118 | WTY_PARTNER_TAB | Partner for Warranty Claim | 13 | CHNGBY | Name of Person Responsible Who Changed Object | nvarchar | 12 | 0 | | |