| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | YIT_INFOBASE_XD | IDES Infobase: Application Data Assignments | 7 | KEY_EXT4 | Infobase Key Field for Data Assignment | nvarchar | 15 | 0 | | |
2 | YIT_INITIAL | Infobase: Initialtabelle für Views | 4 | KEY_EXT4 | Infobase: Platzhalter Key | nvarchar | 1 | 0 | | |
3 | YIT_O1COE | IDA: Original Table COE | 4 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
4 | YIT_O1COS | IDA: Original Table COS | 4 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
5 | YIT_O1OBJ | IDA: Original Table OBJ | 4 | KEY_EXT4 | Object ID | nvarchar | 8 | 0 | | |
6 | YIT_O1PRC | IDA: Original Table COS | 4 | KEY_EXT4 | Controlling Area | nvarchar | 4 | 0 | | |
7 | YIT_O1ROU | IDA: Original Table ROU | 4 | KEY_EXT4 | Group Counter | nvarchar | 2 | 0 | | |
8 | YIT_O1__2 | IDA: Original Table __2 Application Customizing | 4 | KEY_EXT4 | Key organizational unit | nvarchar | 15 | 0 | | |
9 | YIT_O2COE | IDA: Original Table COE | 4 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
10 | YIT_O2COS | IDA: Original Table COS | 4 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
11 | YIT_O2OBJ | IDA: Original Table OBJ | 4 | KEY_EXT4 | Object ID | nvarchar | 8 | 0 | | |
12 | YIT_O2PRC | IDA: Original Table PRC | 4 | KEY_EXT4 | Controlling Area | nvarchar | 4 | 0 | | |
13 | YIT_O2ROU | IDA: Original Table ROU | 4 | KEY_EXT4 | Group Counter | nvarchar | 2 | 0 | | |
14 | YIT_O2__2 | IDA: Original Table __2 Application Customizing | 4 | KEY_EXT4 | Key organizational unit | nvarchar | 15 | 0 | | |
15 | YIT_O3COE | IDA: Original Table COE | 5 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
16 | YIT_O3COS | IDA: Original Table COS | 5 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
17 | YIT_O3OBJ | IDA: Original Table OBJ | 5 | KEY_EXT4 | Object ID | nvarchar | 8 | 0 | | |
18 | YIT_O3PRC | IDA: Original Table COS | 5 | KEY_EXT4 | Controlling Area | nvarchar | 4 | 0 | | |
19 | YIT_O3ROU | IDA: Original Table ROU | 4 | KEY_EXT4 | Group Counter | nvarchar | 2 | 0 | | |
20 | YIT_O3__2 | IDA: Original Table __2 Application Customizing | 5 | KEY_EXT4 | Key organizational unit | nvarchar | 15 | 0 | | |
21 | YIT_R1COE | IDA: Reference Table COE | 6 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
22 | YIT_R1COS | IDA: Reference Table COS | 6 | KEY_EXT4 | IDA: Datum valid to, analogous to DATBI | nvarchar | 8 | 0 | | |
23 | YIT_R1OBJ | IDA: Reference table OBJ | 6 | KEY_EXT4 | Object ID | nvarchar | 8 | 0 | | |
24 | YIT_R1PRC | IDA: Reference Table COS | 6 | KEY_EXT4 | Controlling Area | nvarchar | 4 | 0 | | |
25 | YIT_R1ROU | IDA: Reference table ROU | 6 | KEY_EXT4 | Group Counter | nvarchar | 2 | 0 | | |
26 | YIT_R1__2 | IDA: Reference Table __2 Application Customizing | 6 | KEY_EXT4 | Key organizational unit | nvarchar | 15 | 0 | | |