| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2CN_BI | Payroll result: Social Insurances and PHF (CN) | 10 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
2 | P2CN_II | Payroll result: Social Insurances and PHF (CN) | 10 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
3 | P2CN_MI | Payroll result: Social Insurances and PHF (CN) | 10 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
4 | P2CN_PHF | Payroll result: Social Insurances and PHF (CN) | 10 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
5 | P2CN_PI | Payroll result: Social Insurances and PHF (CN) | 10 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
6 | P2CN_SUI | Payroll result: Supplementary Insurance (CN) | 11 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
7 | P2CN_UI | Payroll result: Social Insurances and PHF (CN) | 10 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
TOPBasic Functions |
8 | T852 | Subgroups | 7 | CONGR | Consolidation activity group | nvarchar | 2 | 0 | | |
9 | T852V | Version-dependent subgroup characteristics | 7 | CONGR | Consolidation activity group | nvarchar | 2 | 0 | | |
10 | T863B | Report groups | 2 | CONGR | Report group | nvarchar | 2 | 0 | | |
11 | T877 | Consolidation activity groups | 2 | CONGR | Consolidation activity group | nvarchar | 2 | 0 | | |
12 | T877K | Consolidation activity groups: Names | 2 | CONGR | Consolidation activity group | nvarchar | 2 | 0 | | |
13 | T877L | Consolidation activity groups: Texts | 3 | CONGR | Consolidation activity group | nvarchar | 2 | 0 | | |
TOPChina |
14 | PA0530 | HR Master Record: Infotype 0530 (Public Housing Fund) | 28 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
15 | PA0532 | HR Master Record: Infotype 0532 (Insurance) | 28 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
16 | PA3532 | HR Master Record: Infotype 3532 | 28 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
17 | T7CN20 | Contribution base | 6 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
18 | T7CN21 | Contribution Group | 2 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
19 | T7CN21T | Contribution Group Text | 3 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
20 | T7CN23 | Contribution Level | 2 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
21 | T7CN23T | Contribution Level Text | 3 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
22 | T7CNTX | Tax Rate or Amount Paid by Employer | 3 | CONGR | Contribution group | nvarchar | 8 | 0 | | |
TOPConsolidation |
23 | ECMCO | SAP Cons.: Object Table Assignment Fields (Object/Partner) | 13 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
24 | TF180 | Consolidation Groups | 3 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
25 | TF181 | Consolidation Groups: Texts | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
26 | TF182 | Consolidation Groups, Version-Dependent | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
27 | TF183 | Consolidation Groups, Version- and Period Categ.-Dependent | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
28 | TF183A | Consolidation Groups - Restricted Task Groups | 6 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
29 | TF184 | Consolidation Groups, Version- and Year-Dependent | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
30 | TF187 | Consolidation Group Set Assignments | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
31 | TF188 | Consolidation Group Assignment of Task Group | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
32 | TF189 | Assignment of CG/CU, Version- and Period-Dependent | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
33 | TF189A | Inactive Consolidation Units per Consolidation Group | 4 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
34 | TF291 | Cons Groups to be Copied | 3 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
35 | TF292 | Cons Units to be Copied | 6 | CONGR | Cons Group of Source Ledger | nvarchar | 18 | 0 | | |
36 | TF350 | Download: Assign CG PC Path | 3 | CONGR | Consolidation unit receiving downloaded data | nvarchar | 18 | 0 | | |
37 | TF360 | Download: Selection Parameters for Special Download | 3 | CONGR | Consolidation unit receiving downloaded data | nvarchar | 18 | 0 | | |
38 | TF361 | Download: Selection Parameters for General Download | 3 | CONGR | Consolidation unit receiving downloaded data | nvarchar | 18 | 0 | | |
39 | TF362 | Download: Selection Parameters for Downloading Fin. Data | 3 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
40 | TF560 | Methods for Reclassification | 6 | CONGR | Limit to a specific consolidation group | nvarchar | 18 | 0 | | |
41 | TF605 | C/I Methods: Assignments | 6 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
42 | TF625 | Group Shares | 6 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
43 | TF635 | Goodwill/Neg.Goodwill | 6 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
44 | TF635A | Goodwill/Neg.Goodwill | 5 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
45 | TF646 | Recorded Fair Value Adjustments | 5 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
46 | TF810 | Top Groups, Organizational Changes | 6 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
47 | TFMIG03 | Allocation: Subgroup -> Consolidation Group | 3 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
TOPData Collection |
48 | CF709 | Consolidation Basic | 10 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
49 | CF710 | IDES FPI | 7 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
50 | CF711 | KPI | 7 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
51 | CF712 | EC Integration: EVA | 9 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
52 | CF714 | Strategic Planning | 9 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
53 | KCK710 | Comments for FPI | 11 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |
TOPGlobal Trade Services |
54 | /SAPSLL/CCGR | Control Groupings for Products | 3 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
55 | /SAPSLL/CCGRT | Legal Control: Control Groupings for Products - Relation. | 4 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
56 | /SAPSLL/CD01 | Country/Control Grouping (Legal Control Determination Level) | 4 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
57 | /SAPSLL/CD03 | Country Grp/Control Grpg (Legal Control Determination Level) | 4 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
58 | /SAPSLL/CD07 | Control Grouping (Legal Control Determination Level) | 3 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
59 | /SAPSLL/CD13 | Country/Control Class/Grouping (Determ. Level Legal Control) | 5 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
60 | /SAPSLL/CD14 | Country Group/Control Class/Grouping (Determ. Legal Regul.) | 5 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
61 | /SAPSLL/CD15 | Control Class/Grouping (Determ. Level: Legal Regulation) | 4 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
62 | /SAPSLL/LEGCON | Legal Control - Document | 12 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
63 | /SAPSLL/PRCON | Legal Control - Product Master | 12 | CONGR | Grouping for Legal Control | nvarchar | 30 | 0 | | |
TOPInvestment Programs |
64 | TAI11 | Group shares in Inv. Program Info System | 3 | CONGR | Consolidation group | nvarchar | 18 | 0 | | |