| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Staging |
1 | RSDSTRANSTRU | DataSource: Transfer Structures | 4 | TRANSTRU | Table Name | nvarchar | 30 | 0 | | |
2 | RSISOLTP | InfoSources (tranascation data) in source system | 4 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
3 | RSISOSMAP | Mapping Between InfoSources and OLTP Sources | 5 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
4 | RSISOSMAPSH | Shadow Table: Mapping between InfoSources and OLTPSource | 4 | TRANSTRU | Boolean | nvarchar | 1 | 0 | | |
5 | RSISSH | Shadow table: InfoSource | 6 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
6 | RSOSOLTP | InfoSources (master data, ...) in the source system | 8 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
7 | RSOSSEGMAP | Mapping between DataSource and InfoSource Segments | 6 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
8 | RSOSSEGMAPSH | Mapping between DataSource and InfoSource Segments | 5 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
9 | RSOSSH | Shadow table: InfoSources (master data, ...) | 15 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
10 | RSTRFIELDSH | Shadow table: Transfer Structure Fields | 1 | TRANSTRU | DataSource | nvarchar | 30 | 0 | | |
11 | RSTRRULESSH | Shadow table: Transfer Structure Transfer Rules | 1 | TRANSTRU | DataSource | nvarchar | 30 | 0 | | |
12 | RSTRSH | Shadow table: Transfer Structure | 1 | TRANSTRU | DataSource | nvarchar | 30 | 0 | | |
13 | RSTS | Transfer structure | 1 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
14 | RSTSABAPSH | Shadow table: ABAP routine - source code | 3 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
15 | RSTSFIELD | Transfer structure fields | 1 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
16 | RSTSFIELDSH | Shadow table: Transfer structure fields | 3 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
17 | RSTSRULES | Transfer structure transfer rules | 1 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
18 | RSTSRULESSH | Shadow table: Transfer structure transfer rules | 3 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
19 | RSTSRULESTSH | Shadow table: ABAP routine - source code | 4 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |
20 | RSTSSH | Shadow table: Transfer structure | 3 | TRANSTRU | Transfer structure between source system and BW | nvarchar | 27 | 0 | | |