| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBW Service API |
1 | ROOSGENSEG | Generated Objects for OLTP Source | 4 | SEGID | Old Segment ID (CHAR1) | nvarchar | 1 | 0 | | |
2 | ROOSGENTFSTR | Transfer Structure (Character) Segmented | 4 | SEGID | Segment ID (NUMC4, corresponding to RSDS_SEGID in BW) | nvarchar | 4 | 0 | | |
3 | ROOSSEG | Segments of a DataSource | 3 | SEGID | Segment ID (NUMC4, corresponding to RSDS_SEGID in BW) | nvarchar | 4 | 0 | | |
TOPData Staging |
4 | RSBERRORCHANGED | Log of Changed Records | 3 | SEGID | Segment | nvarchar | 4 | 0 | | |
5 | RSBERRORLOG | Logs for Incorrect Records | 3 | SEGID | Segment | nvarchar | 4 | 0 | | |
6 | RSDAARCHREQCREF | Assignment of Archiving Request to Source Request | 3 | SEGID | Segment ID in Archiving | nvarchar | 4 | 0 | | |
7 | RSDADAPIDX | BW Archiving: Archive Index | 3 | SEGID | Segment | nvarchar | 4 | 0 | | |
8 | RSDADAPIDXOBJ | BW Archiving: Further Index Characteristics | 3 | SEGID | Segment | nvarchar | 4 | 0 | | |
9 | RSDANLREQDPAKSEG | BW Archiving: Segment in Nearline Request Data Package | 3 | SEGID | Segment ID in Archiving | nvarchar | 4 | 0 | | |
10 | RSDANLSEG | BW Archiving: Segment of a Nearline Object | 2 | SEGID | Segment | nvarchar | 4 | 0 | | |
11 | RSDANLSEGI | BW Archiving: Fields of a Segment Index | 2 | SEGID | Segment | nvarchar | 4 | 0 | | |
12 | RSDANLSEGIF | BW Archiving: Segment Index of a Nearline Object | 2 | SEGID | Segment | nvarchar | 4 | 0 | | |
13 | RSDANLSEGV | BW Archiving: Errors for a Segment Version | 2 | SEGID | Segment | nvarchar | 4 | 0 | | |
14 | RSDANLSEGVF | BW Archiving: Segment Version of a Nearline Object | 2 | SEGID | Segment | nvarchar | 4 | 0 | | |
15 | RSDANLSEGVI | BW Archiving: Errors for a Segment Version | 2 | SEGID | Segment | nvarchar | 4 | 0 | | |
16 | RSDSRTSEGCOUNT | DataSource: Data Package ID Counter, Record | 3 | SEGID | Segment | nvarchar | 4 | 0 | | |
17 | RSDSSEG | DataSource - Segments | 4 | SEGID | Segment | nvarchar | 4 | 0 | | |
18 | RSDSSEGFD | DataSource - Segment Fields | 4 | SEGID | Segment | nvarchar | 4 | 0 | | |
19 | RSDSSEGFDSH | DataSource in BW - Shadow Table Fields | 4 | SEGID | Segment | nvarchar | 4 | 0 | | |
20 | RSDSSEGFDT | DataSource - Texts for Segment Fields | 5 | SEGID | Segment | nvarchar | 4 | 0 | | |
21 | RSDSSEGFDTSH | DataSource in BW - Shadow Table Field Texts | 5 | SEGID | Segment | nvarchar | 4 | 0 | | |
22 | RSDSSEGSH | DataSource in BW - Shadow Table Segments | 4 | SEGID | Segment | nvarchar | 4 | 0 | | |
23 | RSDSSEGT | DataSource - Segment Texts | 5 | SEGID | Segment | nvarchar | 4 | 0 | | |
24 | RSDSSEGTSH | DataSource in BW - Shadow Table Segment Texts | 5 | SEGID | Segment | nvarchar | 4 | 0 | | |
25 | RSDSTRANSTRU | DataSource: Transfer Structures | 3 | SEGID | Segment | nvarchar | 4 | 0 | | |
26 | RSKSFIELDNEW | Fields for New InfoSource | 3 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
27 | RSKSSEGTXT | Texts for Segments | 4 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
28 | RSOLTPSOURCESEG | Segments of a DataSource | 4 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
29 | RSOLTPSOURCESEGT | Segment Texts for DataSource | 5 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
30 | RSOLTPSOURCESFI | Segment Fields of a DataSource | 4 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
31 | RSOLTPSOURCESFIT | Texts for the Segment Fields of a DataSource | 5 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
32 | RSOSSEGFIEMAP | Mapping between DataSource and InfoSource Segments (Fields) | 4 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
33 | RSOSSEGFIEMAPSH | Mapping between DataSource and InfoSource Segments (Fields) | 3 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
34 | RSOSSEGMAP | Mapping between DataSource and InfoSource Segments | 4 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
35 | RSOSSEGMAPSH | Mapping between DataSource and InfoSource Segments | 3 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
36 | RSTRANFIELD | Mapping of Rule Parameters - Structure Fields | 3 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
37 | RSTRANFIELDPROP | Field Properties Within Transformation (obsolete?) | 3 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
38 | RSTRANGROUPFIELD | Selected Grouping Fields of Transformation (Source) | 3 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
39 | RSTRANROUTMAP | Rule Type: Routine | 7 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
40 | RSTRANSEG | Used segments | 3 | SEGID | Segment Number | nvarchar | 4 | 0 | | |
41 | RSTRFIELDSH | Shadow table: Transfer Structure Fields | 3 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
42 | RSTRRULESSH | Shadow table: Transfer Structure Transfer Rules | 3 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
43 | RSTRSH | Shadow table: Transfer Structure | 3 | SEGID | Segment ID | nvarchar | 1 | 0 | | |
TOPIncentive and Commission Management ICM |
44 | CACS_SEGAGR | Agreement for The Assignment of Segments | 6 | SEGID | Number of segment | nvarchar | 12 | 0 | | |
45 | CACS_SEGMNT | Segment | 4 | SEGID | Number of segment | nvarchar | 12 | 0 | | |
46 | CACS_SEGMNTT | Segment: Text | 5 | SEGID | Number of segment | nvarchar | 12 | 0 | | |
TOPInternationalization I18N |
47 | TCP00 | SAP code page catalog | 24 | SEGID | Start Segment of Code Page | nvarchar | 5 | 0 | | |
48 | TCPSATTR | Code Page Segment Attributes | 1 | SEGID | Name for Code Page Segment | nvarchar | 5 | 0 | | |
49 | TCPSBUILD | Iterative Structure of Code Page Segments | 1 | SEGID | Name for Code Page Segment | nvarchar | 5 | 0 | | |
50 | TCPSEG | List of Code Page Segments | 1 | SEGID | Name for Code Page Segment | nvarchar | 5 | 0 | | |
51 | TCPSPTL | Code Points (Up to 126 Bytes long) | 1 | SEGID | Name for Code Page Segment | nvarchar | 5 | 0 | | |
52 | TCPSPTS | Code Points (up to 4 Bytes Long) | 1 | SEGID | Name for Code Page Segment | nvarchar | 5 | 0 | | |
53 | TCPSRULE | Code Page Segment Special Rules | 1 | SEGID | Name for Code Page Segment | nvarchar | 5 | 0 | | |