| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTEI/OCR_TSTG | Staging table for HDCC download data | 6 | VORNA | First Name | nvarchar | 40 | 0 | | |
2 | P2RB_NAME | Payroll Results: Name of Employee | 6 | VORNA | First Name | nvarchar | 40 | 0 | | |
3 | P2RD_NAME | Payroll Results: Name of Employee | 6 | VORNA | First Name | nvarchar | 40 | 0 | | |
4 | P2RK_NAME | Name of Employee | 5 | VORNA | First Name | nvarchar | 40 | 0 | | |
5 | P2RN_NNAM | Personal Data | 7 | VORNA | First Name | nvarchar | 40 | 0 | | |
6 | P2RU_NAME | Name of Employee | 6 | VORNA | First Name | nvarchar | 40 | 0 | | |
7 | PAPBSGB_SWF_STAF | SWF: Staff Details | 12 | VORNA | First Name | nvarchar | 40 | 0 | | |
8 | PB0290 | HR Master Record: Infotype 0290 - Identity card CIS | 58 | VORNA | First Name | nvarchar | 40 | 0 | | |
9 | PDPBSZVNAM_R | SPI Confirmation: Name (Record Type 80) | 7 | VORNA | First Name | nvarchar | 30 | 0 | | |
10 | HRP1702 | DB Table for Infotype 1702 | 19 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPAustria |
11 | T5A9A | Created Statement of Employment (A) | 11 | VORNA | First Name | nvarchar | 40 | 0 | | |
12 | T5AB1 | Sick Leave Certificate: ELDA Record KB | 6 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPBelgium |
13 | T5BS3 | Employee information except reductions ( level 3 ) | 17 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPBenefit Integration |
14 | T7USBENH1 | For saving records of issued HIPAA certificates | 8 | VORNA | First Name | nvarchar | 40 | 0 | | |
15 | T7USBENH2 | For savings records of on-demand printing of HIPAA certs. | 8 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPCapacity and Resource Planning |
16 | /MRSS/SADRPX | IS-Zusatzstruktur zu den SADR*-Strukturen | 6 | VORNA | First Name | nvarchar | 25 | 0 | | |
TOPCompany Pension Scheme Germany |
17 | P01CVH | Actuarial CPS Header Records | 14 | VORNA | First Name | nvarchar | 40 | 0 | | |
18 | PA0746 | HR Master Record for Infotype 0746 | 30 | VORNA | First Name of Investor | nvarchar | 35 | 0 | | |
TOPConstruction Industry |
19 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 22 | VORNA | First Name | nvarchar | 30 | 0 | | |
20 | PDBKAU | Construction Industry Social Fund Proced: AUMEL Data Records | 29 | VORNA | First Name | nvarchar | 30 | 0 | | |
21 | PDBKLO | Construction Industry Social Fund Proced: LOMEL Data Records | 29 | VORNA | First Name | nvarchar | 30 | 0 | | |
22 | PDBKNE | Construction Industry Social Fund Proced: NEMEL Data Records | 30 | VORNA | First Name | nvarchar | 30 | 0 | | |
23 | PDBKRA | Construction Industry Social Fund Proced: RAMEL Data Records | 23 | VORNA | First Name | nvarchar | 30 | 0 | | |
24 | PDBKUR | Construction Industry Social Fund Proced: URMEL Data Records | 37 | VORNA | First Name | nvarchar | 30 | 0 | | |
TOPCross-Application Objects in HR |
25 | HRP5582 | DB Table for Infotype 5582 | 21 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPPayroll |
26 | T5TA1 | External transfers | 8 | VORNA | First Name | nvarchar | 25 | 0 | | |
27 | T5TA2 | Medium for health insurance | 10 | VORNA | First Name | nvarchar | 25 | 0 | | |
28 | T5TELDP2004TRANS | Records ELDP for transfer from external system to SAP | 18 | VORNA | First Name | nvarchar | 40 | 0 | | |
29 | T5TREGTRANS | HRCZ - table for transfer items of Insured Register to SAP | 21 | VORNA | First Name | nvarchar | 40 | 0 | | |
30 | T7ROG1 | EE register - ER history | 19 | VORNA | First Name | nvarchar | 40 | 0 | | |
31 | T7ROG2 | EE register - EE history | 11 | VORNA | First Name | nvarchar | 40 | 0 | | |
32 | T7ROG5 | EE register - ER history | 23 | VORNA | First Name | nvarchar | 25 | 0 | | |
33 | T7ROG6 | EE register - EE history | 13 | VORNA | First Name | nvarchar | 40 | 0 | | |
34 | T7SIA8 | Data for VIRVDC | 8 | VORNA | First Name | nvarchar | 40 | 0 | | |
35 | T7SKA1 | External transfers | 8 | VORNA | First Name | nvarchar | 25 | 0 | | |
TOPPersonnel Administration |
36 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 28 | VORNA | First Name | nvarchar | 40 | 0 | | |
37 | T7GR4APD | IKA - A.P.D. | 17 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPPersonnel Management |
38 | /BKC/S21_ANON | Sol21: Anonymisierungsfelder für Report /BKC/SOL21_KLON | 2 | VORNA | Vorname | nvarchar | 25 | 0 | | |
TOPPublic Sector |
39 | P01ZFA_NN_DATA | ZfA: Notifications Not Assigned | 18 | VORNA | First Name of Investor | nvarchar | 40 | 0 | | |
40 | PDPBSZVNAM | Name (Record Type 80), ZVE-PBS | 15 | VORNA | First Name | nvarchar | 30 | 0 | | |
TOPPublic sector Sweden |
41 | T5SA0_CE | Alecta | 14 | VORNA | First Name | nvarchar | 40 | 0 | | |
42 | T5SK0_CE | KPA events | 10 | VORNA | First Name | nvarchar | 40 | 0 | | |
43 | T5SS3_CE | PA03 pernr | 5 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPRecruitment |
44 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 28 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPRussia |
45 | PA0290 | HR Master Record: Infotype 0290 - Identity card CIS | 58 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPSweden |
46 | T5SPP | HR-SE: Information needed to be reported to Alecta | 12 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPTaiwan |
47 | T7TW2I | Reported data of Tax withdrawal report | 19 | VORNA | First Name | nvarchar | 40 | 0 | | |
TOPTax |
48 | P01T_LST | ETStmt: General Employment Tax Data | 17 | VORNA | ETStmt: First Name | nvarchar | 30 | 0 | | |
TOPVenezuela |
49 | T7VE02 | Additional Data on Company (Time-dependent) | 9 | VORNA | Surname of Legal Person of the Company | nvarchar | 40 | 0 | | |