| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | HRP1789 | DB Table for Infotype 1789 | 19 | PERID | Academic Session | nvarchar | 3 | 0 | | |
2 | HRP1798 | DB Table for Infotype 1798 | 19 | PERID | Academic Session | nvarchar | 3 | 0 | | |
3 | P2RB_PERM | Personal Features | 11 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
4 | P2RB_SV | Social Insurance payroll Belgium | 16 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
5 | P2RD_PERM | Payroll Results: Personal Features | 11 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
6 | P2RK_PERM | Personal Characteristics | 6 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
7 | P2RM_MTAX | Payroll Result: Tax (DK) | 9 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
8 | P2RU_PERM | Personal Characteristics | 7 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
9 | PAPBSGB_SWF_STAF | SWF: Staff Details | 14 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
10 | PIQDB_DE_STATHDR | Header Table for Statistical Reporting Germany | 9 | PERID | Academic Session | nvarchar | 3 | 0 | | |
11 | T7PIQ_DE_MTPERID | Mapping table for Academic Periods | 2 | PERID | Academic Session | nvarchar | 3 | 0 | | |
12 | T868 | Elimination of IC profit and loss | 5 | PERID | Period | nvarchar | 3 | 0 | | |
13 | TSTGC | Consolidation test data | 6 | PERID | Period | nvarchar | 3 | 0 | | |
14 | HRP1707 | Database Table for Infotype 1707 | 23 | PERID | Note Reference to an Academic Session | nvarchar | 3 | 0 | | |
15 | HRP1739 | DB Table for Infotype 1739 | 19 | PERID | Academic Session | nvarchar | 3 | 0 | | |
16 | HRP1771 | DB Table for Infotype 1771 | 19 | PERID | Academic Session | nvarchar | 3 | 0 | | |
17 | HRP1772 | DB Table for Infotype 1772 | 54 | PERID | Academic Session | nvarchar | 3 | 0 | | |
18 | HRPAD503 | Additional Data for PAD503 | 4 | PERID | Academic Session | nvarchar | 3 | 0 | | |
19 | HRPAD506 | Additional Data for PAD506 | 17 | PERID | Academic Session | nvarchar | 3 | 0 | | |
20 | HRPAD512 | Additional Data for PAD512 | 4 | PERID | Academic Session | nvarchar | 3 | 0 | | |
21 | HRPAD532 | Additional Data for PAD508 | 13 | PERID | Academic Session | nvarchar | 3 | 0 | | |
22 | HRPAD547 | Additional Data PAD547 | 6 | PERID | Academic Session | nvarchar | 3 | 0 | | |
23 | HRT1737 | Table Section for Infotype 1737 | 17 | PERID | Academic Session for Progression Result | nvarchar | 3 | 0 | | |
24 | HRT1750 | Table Section for Infotype 1750 | 6 | PERID | Academic Session | nvarchar | 3 | 0 | | |
25 | HRT1764 | Table Section for Infotype 1764 | 11 | PERID | Academic Session | nvarchar | 3 | 0 | | |
26 | HRT1773 | Table Section for Infotype 1773 | 32 | PERID | Academic Session | nvarchar | 3 | 0 | | |
27 | PIQDBCMPRRECORDS | Assessment Process | 9 | PERID | Assessment Session | nvarchar | 3 | 0 | | |
28 | PIQDBEVOBOFFER | Scheduled Assessment | 6 | PERID | Academic Session | nvarchar | 3 | 0 | | |
29 | PIQDBEVOBOFFER2 | Scheduled Assessment: Functions | 6 | PERID | Academic Session | nvarchar | 3 | 0 | | |
30 | PIQDBEVOBOFFER3 | Scheduled Assessment: Location/Time | 6 | PERID | Academic Session | nvarchar | 3 | 0 | | |
31 | PIQDBLMSLPID | Learning Product UUID - LMS | 5 | PERID | Academic Session | nvarchar | 3 | 0 | | |
32 | PIQDBOFFERMP1 | Templates Copied for Academic Period | 4 | PERID | Academic Session | nvarchar | 3 | 0 | | |
33 | PIQDBOFFERMP2 | Business Events Copied for Academic Period | 5 | PERID | Academic Session | nvarchar | 3 | 0 | | |
34 | PIQPROC_ED_INT_W | ED Activity Document: Transferred Internal Academic Work | 19 | PERID | Assigned Academic Session of Internal Academic Work/Qualif. | nvarchar | 3 | 0 | | |
35 | PIQPROC_PG_DT | Activity Document: Progression Details | 18 | PERID | Academic Session for Progression Result | nvarchar | 3 | 0 | | |
36 | PIQPROC_PG_MB | Activity Document: Module Booking | 10 | PERID | Academic Session | nvarchar | 3 | 0 | | |
37 | T7PIQOFFERPATDEF | Session Pattern Definition | 3 | PERID | Academic Session | nvarchar | 3 | 0 | | |
38 | T7PIQPERASSIGN | Academic Session/Group Assignments | 3 | PERID | Academic Session | nvarchar | 3 | 0 | | |
39 | T7PIQPERIOD | Academic Sessions | 2 | PERID | Academic Session | nvarchar | 3 | 0 | | |
40 | T7PIQPERIODT | Academic Sessions (Text Table) | 3 | PERID | Academic Session | nvarchar | 3 | 0 | | |
41 | T7PIQSTDYEARPRD | Standard Academic Year/Session Assignments | 3 | PERID | Academic Session | nvarchar | 3 | 0 | | |
42 | T7PIQYEARPRD | Academic Year/Session Assignments | 3 | PERID | Academic Session | nvarchar | 3 | 0 | | |
43 | T7PIQ_NL_ENRNM | Mapping Table for Year/ Session and Enrollment Moment Code | 3 | PERID | Academic Session | nvarchar | 3 | 0 | | |
44 | T7PIQ_US_PTINDX | Customizing to map Program Full time and Performance Index | 6 | PERID | Academic Session | nvarchar | 3 | 0 | | |
45 | TCMACGRHD | Grants Document Header | 4 | PERID | Academic Session | nvarchar | 3 | 0 | | |
46 | TCMACGRIT | Grants Document Items | 5 | PERID | Academic Session | nvarchar | 3 | 0 | | |
47 | TCMACSUBTYPERID | CO-Integration: Map Acad. Session to Subtype of infty 1759 | 2 | PERID | Academic Session | nvarchar | 3 | 0 | | |
TOPBasic Data |
48 | TN01Z | IS-H: Table for Period Input Help | 3 | PERID | IS-H: Period for Time Interval Input Help | nvarchar | 8 | 0 | | |
TOPBasic Functions |
49 | T850D | Assignment of business segment | 4 | PERID | Period | nvarchar | 3 | 0 | | |
50 | T850S | Tax rates | 4 | PERID | Period | nvarchar | 3 | 0 | | |
51 | T851 | Changes in Investments | 7 | PERID | Period | nvarchar | 3 | 0 | | |
52 | T852P | Consolidation Periods | 3 | PERID | "To" period for the period interval | nvarchar | 3 | 0 | | |
53 | T852U | Subgroup companies | 6 | PERID | Period | nvarchar | 3 | 0 | | |
54 | T853 | Company status | 6 | PERID | Period | nvarchar | 3 | 0 | | |
55 | T853K | Subgroup status | 6 | PERID | Period | nvarchar | 3 | 0 | | |
56 | T864 | Reclassifications | 3 | PERID | Period | nvarchar | 3 | 0 | | |
57 | T865 | Intercompany Elimination | 3 | PERID | Period | nvarchar | 3 | 0 | | |
58 | T868B | Elimination of IC profit/loss: Inventory management co.s | 4 | PERID | Period | nvarchar | 3 | 0 | | |
59 | T869 | Consolidation methods | 6 | PERID | Goodwill amortization: Duration in months | nvarchar | 3 | 0 | | |
60 | T871 | Changes in investee equity | 6 | PERID | Period | nvarchar | 3 | 0 | | |
61 | T872 | Equity Holdings Adjustments | 7 | PERID | Period | nvarchar | 3 | 0 | | |
62 | T873 | Hidden reserves | 6 | PERID | Period | nvarchar | 3 | 0 | | |
63 | T875 | Asset transfers within the group | 9 | PERID | Period | nvarchar | 3 | 0 | | |
64 | T875C | Changes in depreciation | 6 | PERID | Period | nvarchar | 3 | 0 | | |
65 | T875D | Asset transfers | 33 | PERID | Period of asset transfer | nvarchar | 3 | 0 | | |
66 | T875E | Change in depreciation of asset transfers | 7 | PERID | Period | nvarchar | 3 | 0 | | |
TOPBelgium |
67 | PA0735 | HR Master Record: Infotype 0735 (Dimona B) | 47 | PERID | Dimona Period ID (00913) | nvarchar | 12 | 0 | | |
68 | T5BDI0 | HR-BE: Dimona Central Table | 4 | PERID | Dimona Period ID (00913) | nvarchar | 12 | 0 | | |
TOPBenefits |
69 | T74AB | COBRA dependent of qualified beneficiary | 11 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPCollectionsDisbursements |
70 | TVS010H | IS-IS Scheduling: Percentage Distribution in Paymt Plan | 3 | PERID | Period identification | nvarchar | 3 | 0 | | |
TOPConsolidation |
71 | TF080 | List Directory of MCDX | 7 | PERID | Period | nvarchar | 3 | 0 | | |
72 | TF154 | Dimensions year- and period-dependent | 4 | PERID | Effective from period | nvarchar | 3 | 0 | | |
73 | TF155 | Dimensions: Assign Task Groups | 5 | PERID | Effective from period | nvarchar | 3 | 0 | | |
74 | TF163 | Consolidation Units, Version/Period-Based Attributes | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
75 | TF167 | Consolidation Units Version- and Period-Dependent | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
76 | TF169 | Version/Period-Dependent Cons. Units: Tax Rates | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
77 | TF183A | Consolidation Groups - Restricted Task Groups | 5 | PERID | Effective from period | nvarchar | 3 | 0 | | |
78 | TF187 | Consolidation Group Set Assignments | 6 | PERID | Period | nvarchar | 3 | 0 | | |
79 | TF188 | Consolidation Group Assignment of Task Group | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
80 | TF189 | Assignment of CG/CU, Version- and Period-Dependent | 7 | PERID | Effective from period | nvarchar | 3 | 0 | | |
81 | TF192 | Hierarchies, Period-Dependent | 5 | PERID | Effective from period | nvarchar | 3 | 0 | | |
82 | TF242 | Consolidation Periods | 3 | PERID | To period | nvarchar | 3 | 0 | | |
83 | TF250 | Periods, Opened/Closed | 6 | PERID | Period | nvarchar | 3 | 0 | | |
84 | TF260 | Overall Status of CG/CU - Data Monitor | 6 | PERID | Period | nvarchar | 3 | 0 | | |
85 | TF261 | CG/CU: Detail Status of Tasks - Data Monitor | 6 | PERID | Period | nvarchar | 3 | 0 | | |
86 | TF262 | History of Data Entry Layouts | 5 | PERID | Period | nvarchar | 3 | 0 | | |
87 | TF270 | CG/CU Overall Status of Consolidation Monitor | 6 | PERID | Period | nvarchar | 3 | 0 | | |
88 | TF271 | CG/CU: Detail Status of Tasks - Consolidation Monitor | 6 | PERID | Period | nvarchar | 3 | 0 | | |
89 | TF280 | User-Defined Tasks | 5 | PERID | Effective from period | nvarchar | 3 | 0 | | |
90 | TF362 | Download: Selection Parameters for Downloading Fin. Data | 9 | PERID | Period | nvarchar | 3 | 0 | | |
91 | TF425 | Exchange Rate Indicators: ER Type Assignments | 5 | PERID | Effective from period | nvarchar | 3 | 0 | | |
92 | TF543 | Consolidation Tasks: Assignments of Methods and Doc.Types | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
93 | TF544 | Tasks: Task Group Exceptions | 7 | PERID | Effective from period | nvarchar | 3 | 0 | | |
94 | TF545 | Consolidation Tasks: Exceptions for Cons Units | 7 | PERID | Effective from period | nvarchar | 3 | 0 | | |
95 | TF562 | Assignment of Method/Doc. Type to Task in Reclassification | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
96 | TF570 | Tasks for Manual Posting - Document Type Assignments | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
97 | TF575 | Tasks for CG Changes: Document Type Assignments | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
98 | TF585 | Inventory Data | 6 | PERID | Period | nvarchar | 3 | 0 | | |
99 | TF586 | Supplier Data | 5 | PERID | Effective from period | nvarchar | 3 | 0 | | |
100 | TF595 | Elimination of IU Profit/Loss in Inventory: Tasks | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
101 | TF599 | Global Settings for Elim. of IU P/L in Inventory | 4 | PERID | Effective from period | nvarchar | 3 | 0 | | |
102 | TF615 | C/I Tasks: Assignment of Document Types | 6 | PERID | Effective from period | nvarchar | 3 | 0 | | |
103 | TF616 | C/I Activities/Acctg Techniques: Document Type Assignments | 7 | PERID | Effective from period | nvarchar | 3 | 0 | | |
104 | TF620 | Changes in Investments | 8 | PERID | Period | nvarchar | 3 | 0 | | |
105 | TF625 | Group Shares | 9 | PERID | Effective from period | nvarchar | 3 | 0 | | |
106 | TF630 | Changes in Investee Equity | 8 | PERID | Period | nvarchar | 3 | 0 | | |
107 | TF643 | Fair Value Adjustments: Version/Date-Sensitive | 8 | PERID | Effective from period | nvarchar | 3 | 0 | | |
108 | TF645 | Reporting Fair Value Adjustment Data | 8 | PERID | Period | nvarchar | 3 | 0 | | |
109 | TF650 | C/I Activity Numbers | 8 | PERID | Period | nvarchar | 3 | 0 | | |
110 | TF651 | Activity Numbers - Sequence | 8 | PERID | Period | nvarchar | 3 | 0 | | |
111 | TF652 | Activity Numbers - Sequence - Sort Status | 7 | PERID | Period | nvarchar | 3 | 0 | | |
112 | TF660 | Equity Holdings Adjustments | 8 | PERID | Period | nvarchar | 3 | 0 | | |
113 | TF661 | Equity Holdings Adjustments by Upper Unit | 8 | PERID | Period | nvarchar | 3 | 0 | | |
114 | TFMIG10 | Migration: Processing Options | 7 | PERID | Period | nvarchar | 3 | 0 | | |
TOPFinland |
115 | T7FILIS | Table for Low Income Support Statement | 6 | PERID | HR_FI: Finnish person ID | nvarchar | 11 | 0 | | |
116 | T7FITELME | TEL messages | 5 | PERID | Social insurance number | nvarchar | 11 | 0 | | |
TOPGermany |
117 | PA0521 | HR Master Record: Infotype 0521 (Semiretirement D) | 38 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPItaly |
118 | T5ITBS | Bonus Straordinario | 14 | PERID | Riferimento da | nvarchar | 6 | 0 | | |
TOPNorway |
119 | PA0173 | Tax card information | 41 | PERID | eTaxCard - Personnel ID Number | nvarchar | 11 | 0 | | |
TOPPayroll |
120 | T5TA1 | External transfers | 6 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
121 | T5TELDP2004TRANS | Records ELDP for transfer from external system to SAP | 24 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
122 | T5TREGTRANS | HRCZ - table for transfer items of Insured Register to SAP | 18 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
123 | T7ROG2 | EE register - EE history | 15 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
124 | T7ROG6 | EE register - EE history | 17 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
125 | T7SIA3 | M4 - Temporary data | 5 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
126 | T7SKA1 | External transfers | 6 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPPayroll General Parts |
127 | T51G1 | Off-Cycle Batch Table | 13 | PERID | Payroll period | nvarchar | 6 | 0 | | |
TOPPersonnel Administration |
128 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 54 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
129 | PA0152 | Infotype 0152 - Tax data CZ | 44 | PERID | Personal ID number | nvarchar | 20 | 0 | | |
130 | PA0153 | Infotype 0153 - SI CZ | 69 | PERID | Personal ID number | nvarchar | 20 | 0 | | |
131 | T7PL91 | Seniority codes relevance to technical dates | 5 | PERID | Period identifier | nvarchar | 1 | 0 | | |
132 | T7PL92 | Infotype record influence to seniority | 7 | PERID | Period identifier | nvarchar | 1 | 0 | | |
TOPPortfolio Management |
133 | RPM_FIDATA | Financial Information | 11 | PERID | Period | nvarchar | 3 | 0 | | |
134 | RPM_PROJECT_CO | Controlling Information about a project | 10 | PERID | Period | nvarchar | 3 | 0 | | |
135 | RPM_SCENARIO_FIN | RPM : Scenario financial data | 8 | PERID | Period | nvarchar | 3 | 0 | | |
TOPPublic sector Sweden |
136 | T5SA0_CE | Alecta | 8 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
137 | T5SK0_CE | KPA events | 11 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
138 | T5SP0_CE | PA91 periods | 4 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
139 | T5SP1_CE | PA91 absence | 4 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
140 | T5SP2_CE | PA91 income | 4 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
141 | T5SS0_CE | PA03 periods | 5 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
142 | T5SS1_CE | PA03 absences | 5 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
143 | T5SS2_CE | PA03 income | 5 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPRecruitment |
144 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 54 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPRecycling Administration Core Functions |
145 | J_7LV1K | REA Document: Header Data | 51 | PERID | REA Declaration Periodicity | nvarchar | 1 | 0 | | |
TOPSingapore |
146 | PA0412 | HR Master Record: Infotype 0412 [View to I0021] (SG) | 42 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPSouth Africa |
147 | T5WITA88 | ITA88 Transaction Table | 12 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPSpain |
148 | T5EL1 | Protected data access log | 6 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
149 | T5EL5 | Protected data access log | 5 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
150 | T5EL7 | Log for accessing protected data for XML files | 3 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPSweden |
151 | T5S0S | Messages for sickness administration (SE) | 9 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
152 | T5SPP | HR-SE: Information needed to be reported to Alecta | 13 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPTraining and Event Management |
153 | HRT1060 | Table Division for Infotype 1060 | 4 | PERID | Period for Training and Event Planning | nvarchar | 3 | 0 | | |
TOPUnited Kingdom |
154 | PAGB_ASHE | ASHE Return Data | 11 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPUSA |
155 | PA0106 | HR Master Record: Infotype 0106 (Related Persons NA) | 25 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
156 | T51G2 | Off-Cycle Batch Table | 7 | PERID | Payroll period | nvarchar | 6 | 0 | | |
TOPWorkbench Utilities |
157 | FLAPP | Internal flight applications | 2 | PERID | Personnel number | nvarchar | 10 | 0 | | |
158 | FLEMP | Employees | 1 | PERID | Personnel number | nvarchar | 10 | 0 | | |
159 | FLPAS | Passenger list | 2 | PERID | Personnel number | nvarchar | 10 | 0 | | |
TOPWorkforce Management Application |
160 | WFAEM_START_DATE | Start date of the employee | 6 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |
TOPWorkforce Management Core |
161 | WFMEM_START_DATE | Start date of the employee | 6 | PERID | Personnel ID Number | nvarchar | 20 | 0 | | |