| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000281000 | PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee | 19 | ABKRS | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000283000 | PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee | 22 | ABKRS | | nvarchar | 2 | 0 | | |
3 | /GSINS/INH_CPHRR | Claim Payee and HCM Person Relation | 7 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
4 | /GSINS/INH_RIDH | HCM-FSCD: List of HCM Posting runs to be processed | 6 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
5 | CNVLTHCM_APLNO | Application Number Organisational data (Before Conversion) | 14 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
6 | CNVLTHCM_PERNR | Personnel Number Organisational data (Before Conversion) | 14 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
7 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 32 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
8 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 6 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
9 | P01BN_STAT | Status Table for Contribution Statements | 18 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
10 | P01PF_REBUILD | Garnishment Principle of Origin: Results of Rebuild | 17 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
11 | P01PF_REB_HIST | Garnishment Principle of Origin: Results of Rebuild History | 17 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
12 | P08RTI_XMLD | RTI | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
13 | P2CO_COAVA | PC2CO_AVA | 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
14 | P2RG_WEARN | NI: payment history of affected wagetype | 7 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
15 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
16 | P2RU_CLM | Overpayments Processing structure | 13 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
17 | P2RU_CLM_PERSON | Overpayments Processing structure | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
18 | P2RU_DFRT | Payroll Results: Retroaccounting Differences -DFRT- (USA) | 11 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
19 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
20 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
21 | P2RX_EVAL_PERIOD | Index for Payroll Results Periods | 10 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
22 | P2RX_VERSC | Payroll Status Information | 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
23 | PA3340 | Infotype 3340 | 28 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
24 | PA9220 | HR Master Record: Infotype 9220 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
25 | PA9390 | Personal-Stammsatz Infotyp 9390 | 26 | ABKRS | Abrechnungskreis | nvarchar | 2 | 0 | | |
26 | PA9429 | Registro maestro de personal Infotipo 9429 | 26 | ABKRS | Área de nómina | nvarchar | 2 | 0 | | |
27 | PA9640 | Personal-Stammsatz Infotyp 9640 | 26 | ABKRS | Abrechnungskreis | nvarchar | 2 | 0 | | |
28 | PA9701 | Personal-Stammsatz Infotyp 9701 | 26 | ABKRS | Abrechnungskreis | nvarchar | 2 | 0 | | |
29 | PA9725 | HR Master Record: Infotype 9725 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
30 | PA9741 | HR Master Record: Infotype 9741 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
31 | PA9742 | HR Master Record: Infotype 9742 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
32 | PA9825 | HR Master Record: Infotype 9825 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
33 | PA9990 | HR Master Record: Infotype 9990 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
34 | PA9991 | HR Master Record: Infotype 9991 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
35 | PA9992 | HR Master Record: Infotype 9992 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
36 | PA9993 | HR Master Record: Infotype 9993 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
37 | PA9995 | HR Master Record: Infotype 9995 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
38 | PA9996 | HR Master Record: Infotype 9996 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
39 | PA9997 | HR Master Record: Infotype 9997 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
40 | PA9998 | HR Master Record: Infotype 9998 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
41 | PYC_D_EE_MDCK | Employee Master Data Change Key Information | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
42 | PYC_D_PY_MSG | PYC: payroll message | 11 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
43 | T350W | Maintenance control parameters: Order type plant | 6 | ABKRS | Processing group | nvarchar | 2 | 0 | | |
44 | T5FPBST5 | Tranche de décompte / Code correspondant | 2 | ABKRS | Tranche de décompte | nvarchar | 2 | 0 | | |
45 | T5G_RTIDC | RTI Declaration Data | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
46 | T5REG | Employee Information Log for Destruction of Data | 16 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
47 | T5RPD | Personnel Data Deletion Log | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
48 | T704O | Batch Requests for Statements | 9 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
49 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 11 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
50 | T7CNREW_APRPARS | Payroll result master table | 8 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
51 | T7CNREW_USRFPA | User favorate control record | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
52 | T7ROA8 | Contr. G - Deducted Amount | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPArgentina |
53 | T7AR20 | Date for final settlement of income for financial year | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
54 | T7AR28 | Assignment of SIJP periods to settled payrolls | 13 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPBelgium |
55 | T5BVP | Definition of SI periods | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPBenefit Integration |
56 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
57 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
58 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
59 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
60 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
61 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPChile |
62 | T7CL16 | Period identifier | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPChina |
63 | HRPAYCN_GA | Wage Type Assignment (Golden Audit) | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
64 | T7CN3F | Reported Tax Data | 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
65 | AAUUFK | Order master data | 43 | ABKRS | Processing group | nvarchar | 2 | 0 | | |
TOPCross-Application Objects in HR |
66 | HRP5581 | DB Table for Infotype 5581 | 31 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPDenmark |
67 | T5M7D | Status Line for Payroll Run | 4 | ABKRS | Lower limit of payroll area interval | nvarchar | 2 | 0 | | |
68 | T5M7U | Retrieval of DA-DS Statistics | 2 | ABKRS | Lower limit of payroll area interval | nvarchar | 2 | 0 | | |
69 | T5M7W | File Entries Assignment from T5M7V | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
70 | T5M7X | Entries for Form X1 - Special Payment Days | 2 | ABKRS | Lower limit of payroll area interval | nvarchar | 2 | 0 | | |
71 | T5M8S | Employer assignment in original period | 9 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
72 | T5M8Z | Employer Assignment in Original Period | 12 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPFrance |
73 | T5F67 | Interface: Link PAC Payroll Area | 1 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
74 | T5F6F | M-1 management of presence incidents (SAP/ADP interface) | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
75 | T5F6U | Interface: Link PAC Processing Type | 1 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPGermany |
76 | PD3DSAP | HR-DDU: Administration Record for Notifications | 19 | ABKRS | HR-DDU: Payroll Area | nvarchar | 2 | 0 | | |
77 | T5D10 | Procedure for Expected Due Contributions | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
78 | T5D16 | Advanced Payment - Statement of Contributions Paid | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPGreat Britain |
79 | T5BUKT | Personnel numbers for AHP process model | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
80 | T5G51 | Payroll Area PAYE Reference | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
81 | T5G55 | HR-GB: Default Tax Code | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
82 | T5G56 | HR-GB: Offshore employer details | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
83 | T5GEF01 | HR-GB: filing - Store parsed recording coming in from GG | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPItaly |
84 | T5ITPOS_A | Header table for traceability | 7 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPJapan |
85 | PA3239 | HR Master Record: Infotype 3239 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
86 | T5J69 | HR Attributes to SYOYO payroll run JP | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
87 | T5JKG | Kijungai period setting per payroll area | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPKorea |
88 | T7KRTM | Tax calculation method | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPMaintenance Processing |
89 | /MRSS/C_PREMK | Dummy table for creating Org. Assgnmnt Search Help (No Data) | 6 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPOff-Cycle |
90 | T52OCG | Off-Cycle: Indicators for Batch: Payroll, Subsequent Program | 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
91 | T52OCMP | Off-Cycle Flag for Mass Processing | 7 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPOverhead Cost Orders |
92 | AUFK | Order master data | 43 | ABKRS | Processing group | nvarchar | 2 | 0 | | |
93 | TKO08 | Processing groups for orders | 3 | ABKRS | Processing group | nvarchar | 2 | 0 | | |
94 | TKO09 | Allocation Group Descriptions | 4 | ABKRS | Processing group | nvarchar | 2 | 0 | | |
TOPPayroll |
95 | T5H84 | Payroll log | 16 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
96 | T5TA1 | External transfers | 9 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
97 | T5TA2 | Medium for health insurance | 20 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
98 | T7ROA6 | Contr. H - received/deducted amount from the authorities | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
99 | T7ROER | HR Cluster 2 - ER Insurances | 7 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
100 | T7SKA1 | External transfers | 9 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
101 | T7TRP03 | Bordroda kullanilacak yabanci kurun gün belirleme tablosu | 2 | ABKRS | Bordro alt birimi | nvarchar | 2 | 0 | | |
TOPPayroll General Parts |
102 | HRPY_RGDIR | Directory for Payroll Results | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
103 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
104 | PYORGSCREEN | PNP900 Selection Screen: Fields for Organizational Selection | 7 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
105 | T506S | HR Loans: Value Date for Each Payroll Area | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
106 | T51G1 | Off-Cycle Batch Table | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
107 | T549AGA | Assign Payroll Area Group to Payroll Areas | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
108 | T569U | Logs for Control Records | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
109 | T569V | Control Records | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
110 | PA0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 32 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
111 | PA0402 | HR Master Data Infotype 0402 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
112 | PA0403 | HR Master Record for Infotype 0403 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
113 | PA0832 | HR master record for infotypes 0832 | 24 | ABKRS | Payroll area for authorized self-assessed values | nvarchar | 2 | 0 | | |
114 | T549A | Payroll areas | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
115 | T549T | Payroll areas | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
116 | T7COT8 | Payroll external results transfer: COAVA | 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPPersonnel Management |
117 | T7HR1S | R-Sm ID | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPProcess Controls -Automated Controls |
118 | GRPCRTA_HRDA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
119 | GRPCRTA_HRDA0045 | PC HR control data for infotype 0045 - Loan | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
120 | GRPCRTA_HRDA0078 | PC HR control data for infotype 0078 - Loan Payments | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
121 | GRPCRTA_HRDA0267 | PC HR control data for infotype 0267 | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
122 | GRPCRTA_HRDAT1 | PC HR control data for infotype 0014 and 0015 | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
123 | GRPCRTA_HRDAT2 | PC HR control data for infotype 0014 and 0015 | 15 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPRecruitment |
124 | PB0001 | HR Master Record: Infotype 0001 (Org. Assignment) | 32 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPReuse Services for Country Development |
125 | PA0262 | HR Master Record: Infotype 0262 | 25 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPSimulation |
126 | VSAUFK_CN | Version: Order master data | 44 | ABKRS | Processing group | nvarchar | 2 | 0 | | |
TOPTax Reporter |
127 | T51T4 | Evaluated tax form reporting periods | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
128 | T51T6 | Evaluated payroll time units | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
129 | T51T9 | Tax pay dates | 4 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPTools |
130 | HRPYO_D_CYCL | Cycles | 5 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
131 | HRPYO_D_SCHDL | Schedule | 6 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
TOPUSA |
132 | PA0446 | | 26 | ABKRS | | nvarchar | 2 | 0 | | |
133 | PA0447 | US Federal Tax MTD | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
134 | PA0448 | US Federal Tax QTD | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
135 | PA0449 | HR Master Record: Infotype 0449 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
136 | PA0450 | HR Master Record: Infotype 0450 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
137 | PA0451 | HR Master Record: Infotype 0451 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
138 | PA0452 | HR Master Record: Infotype 0452 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
139 | PA0453 | HR Master Record: Infotype 0453 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
140 | PA0454 | HR Master Record: Infotype 0454 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
141 | PA0455 | HR Master Record: Infotype 0455 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
142 | PA0456 | HR Master Record: Infotype 0456 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
143 | PA0457 | HR Master Record: Infotype 0457 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
144 | PA0458 | HR Master Record for Infotype 0458 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
145 | PA0459 | HR Master Record for Infotype 0459 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
146 | PA0460 | HR Master Record for Infotype 0460 | 26 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
147 | T51G2 | Off-Cycle Batch Table | 3 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |
148 | T5UFF | Personnel area to ADP company code mapping (US ADP only) | 2 | ABKRS | Payroll Area | nvarchar | 2 | 0 | | |