| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVHCM_COMPARLOG | TDMS4HCM: Protocoll information for payroll compare | 5 | FPPER | TDMS4HCM: For-period for payroll | nvarchar | 6 | 0 | | |
2 | HRBW_REC_DT | PY-XX-RECON : Country specific reports detailed results | 7 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
3 | HRBW_REC_DT_NEW | PY-XX-RECON : Country specific reports detailed results | 8 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
4 | HRDCT_TPY_RGDIR | Declustering - Directory for Test Payroll Results | 7 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
5 | HRPADDE_D_DN_CI | Dest. Rep. Data: Const. "Business Complete" Information | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
6 | P01PF_PFBB_DIR | PO Rebuild: Transfer Garnishable Amount Directly | 5 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
7 | P2CN_CNREI | Payroll result: structure for retro difference details | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
8 | P2CN_CNREO | Payroll result: structure for retro difference details | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
9 | P2CO_COAVA | PC2CO_AVA | 10 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
10 | P2CO_COBTR | PC2CO_BTR | 20 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
11 | P2CO_COGAR | PC2CO_GAR | 18 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
12 | P2CO_COSSA | PC2CO_SSA | 11 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
13 | P2NZ_EMS | Payroll Result: Employer Monthly Schedule - NZ | 9 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
14 | P2PL_ZLABASE | Results of PLZLA operation | 6 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
15 | P2RA_DFRT | Payroll Result for Other Payroll Periods | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
16 | P2RG_NIPAY | Niable Pay | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
17 | P2RG_WEARN | NI: payment history of affected wagetype | 6 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
18 | P2RH_HU_NRBE | Irregular incomes from infotype 3234 | 6 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
19 | P2RN_NARG | Payroll Results: Add. Terms of Employment | 15 | FPPER | Future Payment Period | nvarchar | 6 | 0 | | |
20 | P2RU_BAL | Payroll Results: Tax Retro Differences -(USA) | 12 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
21 | P2RU_CLM | Overpayments Processing structure | 7 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
22 | P2RU_CLM_PERSON | Overpayments Processing structure | 9 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
23 | P2RU_DFRT | Payroll Results: Retroaccounting Differences -DFRT- (USA) | 6 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
24 | P2RU_DNRCT | Payroll Results: Retro Differences 1042S -DNRCT- (USA) | 8 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
25 | P2RU_UNB | Payroll Results: Tax Retro Differences -(USA) | 12 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
26 | P2RU_XDFRT | Payroll Results: Tax Retro Differences -(USA) | 12 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
27 | P2RX_EVAL_PERIOD | Index for Payroll Results Periods | 11 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
28 | P2RX_VERSC | Payroll Status Information | 24 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
29 | PA9220 | HR Master Record: Infotype 9220 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
30 | PA9390 | Personal-Stammsatz Infotyp 9390 | 28 | FPPER | Fürperiode der Abrechnung | nvarchar | 6 | 0 | | |
31 | PA9429 | Registro maestro de personal Infotipo 9429 | 28 | FPPER | Período para de la nómina | nvarchar | 6 | 0 | | |
32 | PA9640 | Personal-Stammsatz Infotyp 9640 | 28 | FPPER | Fürperiode der Abrechnung | nvarchar | 6 | 0 | | |
33 | PA9701 | Personal-Stammsatz Infotyp 9701 | 28 | FPPER | Fürperiode der Abrechnung | nvarchar | 6 | 0 | | |
34 | PA9725 | HR Master Record: Infotype 9725 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
35 | PA9741 | HR Master Record: Infotype 9741 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
36 | PA9742 | HR Master Record: Infotype 9742 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
37 | PA9825 | HR Master Record: Infotype 9825 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
38 | PA9990 | HR Master Record: Infotype 9990 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
39 | PA9991 | HR Master Record: Infotype 9991 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
40 | PA9992 | HR Master Record: Infotype 9992 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
41 | PA9993 | HR Master Record: Infotype 9993 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
42 | PA9995 | HR Master Record: Infotype 9995 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
43 | PA9996 | HR Master Record: Infotype 9996 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
44 | PA9997 | HR Master Record: Infotype 9997 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
45 | PA9998 | HR Master Record: Infotype 9998 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
46 | T5FDSNAB_FR | Temp table for PAYFR_RESULT-AB_FR | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
47 | T5FDSNACTI | Temp table for PAYFR_RESULT-ACTI | 3 | FPPER | Période recalculée de la paie | nvarchar | 6 | 0 | | |
48 | T5FDSNCT | Temp table for PAYFR_RESULT-CT | 3 | FPPER | Période recalculée de la paie | nvarchar | 6 | 0 | | |
49 | T5FDSNFPERS | Temp table for PAYFR_RESULT-FPERS | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
50 | T5FDSNPAYM | Temp table for PAYFR_RESULT-PAYM | 3 | FPPER | Période recalculée de la paie | nvarchar | 6 | 0 | | |
51 | T5FDSNREM | Temp table for PAYFR_RESULT-REM | 3 | FPPER | Période recalculée de la paie | nvarchar | 6 | 0 | | |
52 | T5FDSNSUSPENSION | Temp table for PAYFR_RESULT-SUSPENSION | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
53 | T5Q_SUPERSTREAM | Super Stream Master Table | 9 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
54 | T5TPENSAV | Data for pension savings | 4 | FPPER | Reported for period | nvarchar | 6 | 0 | | |
55 | T5TPENSAV_YS | Pension savings - annual reporting | 4 | FPPER | Reported for period | nvarchar | 6 | 0 | | |
56 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 9 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
57 | T7CNREW_APRPARS | Payroll result master table | 4 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
58 | T7ROA8 | Contr. G - Deducted Amount | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPArgentina |
59 | T7AR28 | Assignment of SIJP periods to settled payrolls | 10 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPAustria |
60 | HRPAYAT_PAYRSRES | Saves Wage Types from Simulated Payroll Results | 6 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
61 | PA3233 | HR Master Record: Infotype 3233 | 50 | FPPER | For-Period for Lists (PP.YYYY) | nvarchar | 7 | 0 | | |
TOPBenefit Integration |
62 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
63 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
64 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
65 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
66 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
67 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPChina |
68 | T7CN3F | Reported Tax Data | 6 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPConstruction Industry |
69 | PDBKAD | CI: Social Fund Procedure: Records Management | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
70 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
71 | PDBKAU | Construction Industry Social Fund Proced: AUMEL Data Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
72 | PDBKBE | Constr. Ind. Social Fund Procedure: BEMEL (PerNo) Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
73 | PDBKBESUM | Constr. Ind. Social Fund Procedure: BEMEL Records (Total) | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
74 | PDBKLO | Construction Industry Social Fund Proced: LOMEL Data Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
75 | PDBKNE | Construction Industry Social Fund Proced: NEMEL Data Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
76 | PDBKNW | Construction Industry Social Fund Proced: Employee Statement | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
77 | PDBKRA | Construction Industry Social Fund Proced: RAMEL Data Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
78 | PDBKUR | Construction Industry Social Fund Proced: URMEL Data Records | 4 | FPPER | For-Period for Evaluation for Social Fund Procedure | nvarchar | 6 | 0 | | |
TOPGarnishmentCession |
79 | P01PF_RT_EP | Garnishment Pr. of Origin: Results of Garnishment Calc. | 4 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
TOPGreat Britain |
80 | T5BUKT | Personnel numbers for AHP process model | 4 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPIndia |
81 | T7INTE | Form 24Q - TAN number lock | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPItaly |
82 | T5ITPOS_A | Header table for traceability | 4 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPJapan |
83 | PA3239 | HR Master Record: Infotype 3239 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPNew Zealand |
84 | HNZLVPAY | Table for modified LVPAY cluster table records | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPNorway |
85 | T5V3A | Vacation allowance calculation | 7 | FPPER | Period for payment of holiday allowance | nvarchar | 2 | 0 | | |
86 | T5V3E | Holiday allowance: Payment | 5 | FPPER | Period for payment of holiday allowance | nvarchar | 2 | 0 | | |
TOPPayroll |
87 | T5HNR | HU_NREN payroll table data of the "current month" | 4 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
88 | T5HS1 | HR-H: Havi bevallás - bevallási adatok | 5 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
89 | T5HS4 | HR-H: Havi bevallás - Élesben futtatott hónapok (bárkód) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
90 | T5HS7 | HR-H: Havi bevallás - bevallási adatok - adózónként | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
91 | T5HS8 | HR-H: Havi bevallás - adózót terhelo egyéb kötelezettségek | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
92 | T5HSE | 12. lap Önellenorzés | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
93 | T5HSH | HR-H: Havi bevallás - Kijelölés helyesbítésre | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
94 | T5HSJ | Havi bevallás - bevallási adatok - munkavállalónként | 5 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
95 | T5HSK | Havi bevallás - külso bevallási adatok - adózónként | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
96 | T5HSM | Havi bevallás - külso bevallási adatok magánszemély (I.né) | 5 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
97 | T5HSN | Havi bevallás - külso bevallási adatok - adózó (I.né) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
98 | T5HSR | HR-H: Havi bevallás - nemnegatív járulékbérelemek | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
99 | T5HSS | Havi bevallás - külso-belso adatok összesítve - adózó | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
100 | T5HST | Havi bevallás- külso-belso adatok összesítve - személy | 5 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
101 | T5HSV | HR-H: Havi bevallás - bevallási adatok (negyedéves) | 5 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
102 | T5HSW | HR-H: Havi bevallás - bevallási adatok - adózó (n.éves) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
103 | T5HSX | Havi bevallás - külso-belso adatok összesítve adózó I. né | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
104 | T5HSY | Havi bevallás- külso-belso adatok összesítve személy I.né | 5 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
105 | T5HV4 | Élesben futtatott hónapok (BAR-kód) (havi adóbevallás) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
106 | T5HV7 | Bevallási adatok adózónként (havi adóbevallás) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
107 | T5HV8 | Vállalati összesíto egyéb adatok (havi bevallás) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
108 | T5HVH | Kijelölés helyesbítésre (havi bevallás) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
109 | T5HVK | Külso bevallási adatok adózónként (havi bevallás) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
110 | T5HVR | Nemnegatív járulékbérelemek (havi bevallás) | 4 | FPPER | Bérszámfejtés vonatkoztatási periódusa | nvarchar | 6 | 0 | | |
111 | T7ROA3 | Insurance result table - Person 1:1 with RGDIR | 9 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
112 | T7ROA6 | Contr. H - received/deducted amount from the authorities | 2 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
113 | T7SIREK11A | State for REK field 011a | 3 | FPPER | Za obdobje - za placo | nvarchar | 6 | 0 | | |
TOPPayroll General Parts |
114 | HRPY_RGDIR | Directory for Payroll Results | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
115 | HRPY_RGDIR_TEMP | Internal TEMPORARY Directory for Payroll Results | 5 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
116 | PYNOSCREEN | Selection Screen Fields (Only as Interface) | 3 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
TOPPersonnel Administration |
117 | PA0402 | HR Master Data Infotype 0402 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
118 | PA0403 | HR Master Record for Infotype 0403 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
119 | T7COT2 | Payroll external results transfer: COSSA | 11 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
120 | T7COT5 | Payroll external results transfer: COBTR | 20 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
121 | T7COT6 | Payroll external results transfer: COGAR | 18 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | | |
122 | T7COT8 | Payroll external results transfer: COAVA | 10 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPPersonnel Management |
123 | /BKC/S21_EV | Sol21: Vergleich von Abrechnungsergebnissen | 3 | FPPER | Fürperiode der Abrechnung | nvarchar | 6 | 0 | | |
124 | /BKC/S21_EV1 | Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR. | 2 | FPPER | Fürperiode der Abrechnung | nvarchar | 6 | 0 | | |
125 | /BKC/S21_RT | C&T! - Table RT for the payroll comparison programs | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
126 | /BKC/S21_RT_NEU | C&T! - Table RT for the payroll comparison programs | 3 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
127 | /BKC/S21_RT_NOPN | C&T! - Table RT for the payroll comparison programs | 2 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPPublic Sector |
128 | PDPBSZVADM | Administration Table for ZVE-PBS Notification Procedure | 10 | FPPER | For-Period for Payroll | nvarchar | 6 | 0 | | |
TOPSweden |
129 | T5SVT | Payroll Account Transfer for Capacity utilization level | 8 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
TOPUSA |
130 | PA0446 | | 28 | FPPER | | nvarchar | 6 | 0 | | |
131 | PA0447 | US Federal Tax MTD | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
132 | PA0448 | US Federal Tax QTD | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
133 | PA0449 | HR Master Record: Infotype 0449 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
134 | PA0450 | HR Master Record: Infotype 0450 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
135 | PA0451 | HR Master Record: Infotype 0451 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
136 | PA0452 | HR Master Record: Infotype 0452 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
137 | PA0453 | HR Master Record: Infotype 0453 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
138 | PA0454 | HR Master Record: Infotype 0454 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
139 | PA0455 | HR Master Record: Infotype 0455 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
140 | PA0456 | HR Master Record: Infotype 0456 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
141 | PA0457 | HR Master Record: Infotype 0457 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
142 | PA0458 | HR Master Record for Infotype 0458 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
143 | PA0459 | HR Master Record for Infotype 0459 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
144 | PA0460 | HR Master Record for Infotype 0460 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |
145 | PA0909 | HR Master Record: Infotype 0909 | 28 | FPPER | For-period for payroll | nvarchar | 6 | 0 | | |