| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CF002 | Human Resources | 12 | VALTY | Value type | nvarchar | 1 | 0 | | |
2 | CF004 | Stock Prices | 8 | VALTY | Value type | nvarchar | 1 | 0 | | |
3 | P2RB_PK | Pension Fund, Payroll Belgium | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
4 | P2RC_PK | HR-CH: Pension fund payroll values | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
5 | P2RN_PK | Payroll Result: Pension Module | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
6 | P2UN_PK | Pension Fund, Payroll United Nations | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
7 | T5C1E | Transaction Types | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
8 | T5PPBS3V | Check values for PD infotype fields | 2 | VALTY | Value type | nvarchar | 2 | 0 | | |
9 | T5PPBS3VT | Text of values for PD infotype fields | 3 | VALTY | Value type | nvarchar | 2 | 0 | | |
TOPData Collection |
10 | CF001 | Profitability Analysis | 15 | VALTY | Value type | nvarchar | 1 | 0 | | |
11 | CF003 | Projects | 15 | VALTY | Value type | nvarchar | 1 | 0 | | |
12 | CF005 | Personnel Information | 13 | VALTY | Value type | nvarchar | 1 | 0 | | |
13 | CF006 | Balance Sheet | 10 | VALTY | Value type | nvarchar | 1 | 0 | | |
14 | CF050 | Balance sheet/P&L (FI/FILC) | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
15 | CF500 | IDES Investment | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
16 | CF701 | IDES Marketing | 13 | VALTY | Value type | nvarchar | 1 | 0 | | |
17 | CF703 | IDES Profitability | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
18 | CF704 | IDES Sales Info Sys. | 12 | VALTY | Value type | nvarchar | 1 | 0 | | |
19 | CF705 | IDES Personnel Info | 14 | VALTY | Value type | nvarchar | 1 | 0 | | |
20 | CF706 | IDES Legal Cons. | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
21 | CF707 | IDES Insight | 11 | VALTY | Value type | nvarchar | 1 | 0 | | |
22 | CF708 | IDES: Setup Example | 10 | VALTY | Value type | nvarchar | 1 | 0 | | |
23 | CF720 | Top EIS Aspect | 19 | VALTY | Value type | nvarchar | 1 | 0 | | |
24 | CF750 | MCRED | 9 | VALTY | Value type | nvarchar | 1 | 0 | | |
25 | CF751 | MCBLUE | 9 | VALTY | Value type | nvarchar | 1 | 0 | | |
26 | CF752 | MCBlack | 10 | VALTY | Value type | nvarchar | 1 | 0 | | |
27 | T241W | Description of value type | 3 | VALTY | Value type | nvarchar | 1 | 0 | | |
28 | T242W | Value types | 2 | VALTY | Value type | nvarchar | 1 | 0 | | |
29 | TKCUM | EIS: Conversion table of new fixed fields 4.0 | 3 | VALTY | Value type | nvarchar | 1 | 0 | | |
TOPFunds Management |
30 | FMLGD_H_CUST | Note to Payee Control | 7 | VALTY | Processing variant | nvarchar | 4 | 0 | | |
31 | FMLGD_H_VALTYP | Processing variant | 2 | VALTY | Processing variant | nvarchar | 4 | 0 | | |
32 | FMLGD_H_VALTYPT | Text Table for FMLGD_H_VALTYP | 2 | VALTY | Processing variant | nvarchar | 4 | 0 | | |
TOPGlobal Trade Services |
33 | /SAPSLL/LEGCULC | SLL: Customs Document: Customs Processing: Duties | 8 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
34 | /SAPSLL/LEGCULCR | Customs Document (Backup): Customs Processing: Duties | 6 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
35 | /SAPSLL/PRVAL | Legal and Logistics Services: Product Master - Prices | 5 | VALTY | Valuation Type | nvarchar | 10 | 0 | | |
36 | /SAPSLL/SECADJWL | Worklist for Automatic Adjustment of Securities | 10 | VALTY | Value Type | nvarchar | 2 | 0 | | |
37 | /SAPSLL/TLC_ASC | GTS: Customs Management: Toll Procedure | 5 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
38 | /SAPSLL/TLC_ASE | GTS: Customs Processing: Duty Structure for Exports | 5 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
39 | /SAPSLL/TLC_AST | GTS: Customs Processing: Duty Structure for Proc. Transit. | 5 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | | |
TOPHR Information Systems |
40 | T72B1_BW | HR-PF-BW: Permitted Value Type per PC Activities for BW | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
TOPPension fund General Parts |
41 | T5CA2 | PC Value Types | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
42 | T5CA3 | HR-CH: Value type descriptions | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
43 | T5CA8 | PC Method Determination | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
44 | T5CA9 | PC Method Variant Determination | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
45 | T5CAC | Parameter Range Determination | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
46 | T5CAD | PC Parameter Values | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
47 | T5CAG | PC Method Definitions | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
48 | T5CAH | Schedule Value Types | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
49 | T5CAO | Line Selection of Processing Schedules | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
50 | T5CAV | Value Type Attribute Assignment | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
51 | T5CB3 | PC Parameter Attributes | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
52 | T5CBE | Value Type Field Assignment | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
53 | T5CBO | Additional Selection Parameters for Reports | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
54 | T5CBU | Field Selection for PC Online Evaluation View | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
55 | T5CC0 | PC Method Steps Add-Ons | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
56 | T5CC4 | HR-PF: Value Type Grouping | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
57 | T5CP3 | HR-CH: Field assignment for infotype 279 | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
58 | T5CP4 | HR-CH: Value assignment for fields (BI) | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
59 | T5CPA | HR-CH: Determination of Wage Types for PF Value Types | 2 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
60 | T5CPB | HR-CH: Pension fund postings | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
61 | T5CPQ | Input Parameter Quantity Value Types for PF Calulation | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
62 | T5CPS | Additional Infotype Field Values for PF Calculation | 8 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
63 | T5CPW | Ad Hoc Query Field Assignment | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
64 | T5CQ1 | Account View Posting Value Types | 4 | VALTY | Account View Posting Value Type | nvarchar | 4 | 0 | | |
65 | T5CQ3 | Account View Result Value Types | 5 | VALTY | Result value type | nvarchar | 4 | 0 | | |
66 | T5NF3 | PA-PF-NL: Feldzuordnung für Infotyp 279 | 6 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
67 | T5NP3 | HR-Gran: Mapping table VALTY - LGART for Simulation | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
68 | T72A2 | HR-PF: Totals Value Types | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
69 | T72A6 | HR-IB: Parameters for a PF recalculation | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
70 | T72A9 | HR-PF: Total Compensation Statement Integration | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
71 | T72AD | Value types of a variant for the Wage Maintenance Debugger | 3 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
72 | T72F0 | HR-PF: FI Posting Characteristics of Value Types | 6 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
73 | T72FA | HR-PF: FI Index Table | 10 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
74 | T72P0 | HR-PF: Determination of Payroll Values for PF Value Types | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
75 | T72T5 | HR-PF: TS Account Data | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
76 | T72T6 | HR-PF: TS Account Data Totals Formation | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
77 | T72TB | HR-PF: TS Parameter Values | 7 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
TOPPension fund Netherlands |
78 | T5NBG | Berekeningsmethode (FAS/ALM interface) | 6 | VALTY | VS-waardesoort | nvarchar | 4 | 0 | | |
79 | T5ND1 | HR-CH: Pension fund postings | 5 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
80 | T5NDA | Log tabel voor euroconversie van IT0279 waardecomponenten | 3 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
81 | T5NDB | Log tabel voor euroconversie van tabel T5CPB | 6 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
82 | T5NE1 | Groepsdefinitie (VK-rapport) | 6 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
83 | T5NE6 | Berekeningsmethode (VK-rapport) | 11 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
84 | T5NK2 | Pensioen producten - VB-Waardesoorten | 3 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
85 | T5NL3 | Toewijzing VB-waardesoort aan actuarieel bestandstype kolom | 4 | VALTY | VB-waardesoort | nvarchar | 4 | 0 | | |
TOPPension Fund Switzerland |
86 | PA3230 | Personnel Master Record for Infotype 3230 | 29 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |
87 | T5CD3 | House Bank Pension Fund for Non-Recurring Payments | 3 | VALTY | Value Type of DME Posting | nvarchar | 4 | 0 | | |
TOPSwitzerland |
88 | T5CEL | HR-CH: Values from Infotype 0279 for Master Data Sheet | 4 | VALTY | PC Value Type | nvarchar | 4 | 0 | | |