| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPPSSRM/TEMD | Table for EMD Payment | 9 | PAY_DATE | Payment Date | nvarchar | 8 | 0 | | |
2 | PA9220 | HR Master Record: Infotype 9220 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
3 | PA9390 | Personal-Stammsatz Infotyp 9390 | 31 | PAY_DATE | Datum der Auszahlung eines Abrechnungsergebnisses | nvarchar | 8 | 0 | | |
4 | PA9429 | Registro maestro de personal Infotipo 9429 | 31 | PAY_DATE | Fecha de pago de un resultado de nómina | nvarchar | 8 | 0 | | |
5 | PA9640 | Personal-Stammsatz Infotyp 9640 | 31 | PAY_DATE | Datum der Auszahlung eines Abrechnungsergebnisses | nvarchar | 8 | 0 | | |
6 | PA9701 | Personal-Stammsatz Infotyp 9701 | 31 | PAY_DATE | Datum der Auszahlung eines Abrechnungsergebnisses | nvarchar | 8 | 0 | | |
7 | PA9725 | HR Master Record: Infotype 9725 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
8 | PA9741 | HR Master Record: Infotype 9741 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
9 | PA9742 | HR Master Record: Infotype 9742 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
10 | PA9825 | HR Master Record: Infotype 9825 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
11 | PA9990 | HR Master Record: Infotype 9990 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
12 | PA9991 | HR Master Record: Infotype 9991 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
13 | PA9992 | HR Master Record: Infotype 9992 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
14 | PA9993 | HR Master Record: Infotype 9993 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
15 | PA9995 | HR Master Record: Infotype 9995 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
16 | PA9996 | HR Master Record: Infotype 9996 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
17 | PA9997 | HR Master Record: Infotype 9997 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
18 | PA9998 | HR Master Record: Infotype 9998 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPBenefit Integration |
19 | PA0496 | Payroll Infotype: US Benefits Data - Per Pay Period | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
20 | PA0497 | Payroll Infotype: US Benefits Data - MTD | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
21 | PA0498 | Payroll Infotype: US Benefits Data - QTD | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
22 | PA0499 | Payroll Infotype: US Benefits Data - YTD | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
23 | PA0500 | Payroll Infotype: US Benefits Data in Arrears (ARRRS) | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
24 | PA0501 | Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK) | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPJapan |
25 | PA3239 | HR Master Record: Infotype 3239 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPPension fund Netherlands |
26 | PA0646 | HR Master Record: Infotype 0022 (Education) | 43 | PAY_DATE | | nvarchar | 8 | 0 | | |
TOPPersonnel Administration |
27 | PA0402 | HR Master Data Infotype 0402 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
28 | PA0403 | HR Master Record for Infotype 0403 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
TOPPosition Management |
29 | BKKA1 | Position Manangement: General Data | 23 | PAY_DATE | Cashing Date of Check | nvarchar | 8 | 0 | | |
TOPStakeholder Relationship Management |
30 | USS_SHARE_DIVID | Dividends per Security | 3 | PAY_DATE | Dividend Payment Date | nvarchar | 8 | 0 | | |
TOPUSA |
31 | PA0446 | | 31 | PAY_DATE | | nvarchar | 8 | 0 | | |
32 | PA0447 | US Federal Tax MTD | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
33 | PA0448 | US Federal Tax QTD | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
34 | PA0449 | HR Master Record: Infotype 0449 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
35 | PA0450 | HR Master Record: Infotype 0450 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
36 | PA0451 | HR Master Record: Infotype 0451 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
37 | PA0452 | HR Master Record: Infotype 0452 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
38 | PA0453 | HR Master Record: Infotype 0453 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
39 | PA0454 | HR Master Record: Infotype 0454 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
40 | PA0455 | HR Master Record: Infotype 0455 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
41 | PA0456 | HR Master Record: Infotype 0456 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
42 | PA0457 | HR Master Record: Infotype 0457 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
43 | PA0458 | HR Master Record for Infotype 0458 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
44 | PA0459 | HR Master Record for Infotype 0459 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
45 | PA0460 | HR Master Record for Infotype 0460 | 31 | PAY_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |