| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIntegrated Product and Process Engineering |
| 1 | CPRTYPE | Customizing: iPPE Relationships | 13 | APPLREL_TYPE | iPPE Application Object Type | nvarchar | 4 | 0 | | |
| 2 | PRELACT | Relationships for the SNP and Workshop Plan | 14 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 3 | PRELDEX | External Indicator Deleted iPPE Relationships | 10 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 4 | PRELID | iPPE Relationship: Time-Independent ID and Attributes | 10 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 5 | PRGEN | GEN Relationships - Relationships Table | 14 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 6 | PRPVR | Relationship Between Variants: Identification and Attributes | 12 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 7 | PRSET | Set Relationships: Table of Links | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 8 | PRTST | Test Relationships - Relationships Table | 15 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| TOPLogistical Requirements |
| 9 | /ISDFPS/PRMPAID | iPPE Relationship: Time-Independent ID and Attributes | 10 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| TOPMaterial Categories |
| 10 | /ISDFPS/PRMPOCID | iPPE Relationship: Time-Independent ID and Attributes | 10 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 11 | /ISDFPS/PRMPOID | iPPE Relationship: Time-Independent ID and Attributes | 10 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| TOPResourcen Management |
| 12 | PREQR | RMS-RCP: iPPE Relationship: Equipment Requirement | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 13 | PRPOBA | RMS-RCP: iPPE Relationship: Operation-Action | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 14 | PRPOBI | RMS-RCP: iPPE Relationship: Assignment Relationshps f. Items | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 15 | PRPOBO | RMS-RCP: iPPE Relationship: Stage-Operation | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 16 | PRPOBR | RMS-RCP: iPPE Relationship: Relationships Between Operations | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| 17 | PRPOBS | RMS-RCP: iPPE Relationship: Recipe-Stage, Process-Stage | 13 | APPLREL_TYPE | Relationship Application Type | nvarchar | 4 | 0 | | |
| TOPWarranty Claim Processing |
| 18 | PRWTY | iPPE Relationship: Time-Ind. Ident./Attributes Warranty | 10 | APPLREL_TYPE | | nvarchar | 4 | 0 | | |
