| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /PLMI/ECR_CLF_CL | ECR Classification default classes | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 2 | ZECR_DETAILS | ecr | 6 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| TOPCross-Application Components |
| 3 | /IXOS/AX_TDATYPE | Data type matching ABAP <-> ECR | 2 | ECR_TYPE | ECR Data type | nvarchar | 15 | 0 | | |
| TOPEngineering Change Record |
| 4 | /PLMI/ECR_CRT_AT | ECN Creation attributes at ECR Header | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 5 | /PLMI/ECR_HID_FL | List of fields those can be hidden | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 6 | /PLMI/ECR_IT_CRA | ECN Creation attributes at ECR Item | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 7 | /PLMI/ECR_IT_OBJ | ECN Creation at ECR Item--Maintain Objects | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 8 | /PLMI/ECR_IT_STP | ECN Creation at ECR Item--Maintain Status Values | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 9 | /PLMI/ECR_SIG | Engineering Record: Signature Assignment table | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 10 | /PLMI/ECR_STS_PF | ECN Creation at ECR header | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 11 | /PLMI/ECR_TYPE | Record Type | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
| 12 | /PLMI/ECR_TY_VV | ECR - Relation between Record type and view variant | 2 | ECR_TYPE | Change Record Type | nvarchar | 4 | 0 | | |
