| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000285000 | PSA for 0PERSON_ATTR T90CLNT090 Person | 10 | NATIO | | nvarchar | 3 | 0 | | |
2 | P2AA_PS_SA | Payroll Result: Pension Data for KSA | 8 | NATIO | Nationality | nvarchar | 3 | 0 | | |
3 | P2AA_SV_SA | Payroll Result: SI Data for KSA | 11 | NATIO | Nationality | nvarchar | 3 | 0 | | |
4 | P2KZ_KZGRP | Groupings and statuses of PERNR | 9 | NATIO | Nationality Status | nvarchar | 1 | 0 | | |
5 | P2QA_PS_QA | Payroll Result: Pension Data for QA | 8 | NATIO | Nationality | nvarchar | 3 | 0 | | |
6 | P2RB_PERM | Personal Features | 5 | NATIO | Nationality | nvarchar | 3 | 0 | | |
7 | P2RD_PERM | Payroll Results: Personal Features | 5 | NATIO | Nationality | nvarchar | 3 | 0 | | |
8 | P2RN_NNAM | Personal Data | 17 | NATIO | Nationality | nvarchar | 3 | 0 | | |
9 | T001E | Company Code-Dependent Address Data | 7 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
10 | T5PPBS9D | Portugal Public Sector - BDAP - Country Codes | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
11 | T5T2I | Tax calculation configuration - non-residents | 4 | NATIO | Nationality | nvarchar | 3 | 0 | | |
12 | T7AE28 | Emiratization National | 3 | NATIO | Nationality | nvarchar | 3 | 0 | | |
13 | T7AEPBS66 | Absence Type Limit Condition | 14 | NATIO | Nationality | nvarchar | 3 | 0 | | |
14 | T7KW08 | Absence Type Limit Condition | 8 | NATIO | Nationality | nvarchar | 3 | 0 | | |
15 | T7OM11 | Visa Approval Information | 7 | NATIO | Nationality | nvarchar | 3 | 0 | | |
16 | T7OM17 | Labor Approval Amendment Track | 4 | NATIO | Nationality | nvarchar | 3 | 0 | | |
17 | T7OM33 | Absence Type Limit Condition | 8 | NATIO | Nationality | nvarchar | 3 | 0 | | |
18 | T7QA62 | Visa Approval Information | 7 | NATIO | Nationality | nvarchar | 3 | 0 | | |
19 | T7QA68 | Labor Approval Amendment Track | 4 | NATIO | Nationality | nvarchar | 3 | 0 | | |
20 | T7QAPBS25 | Absence Type Limit Condition | 8 | NATIO | Nationality | nvarchar | 3 | 0 | | |
21 | T7RUNATIO | OKIN: Nationality | 3 | NATIO | OKIN: Nationality Code | nvarchar | 1 | 0 | | |
22 | T7RUR2 | Meaning of statuses of IT 0048 (Residence status) | 3 | NATIO | Status of Social Insurance Residence | nvarchar | 1 | 0 | | |
23 | T7SA46 | Visa Approval Information | 7 | NATIO | Nationality | nvarchar | 3 | 0 | | |
24 | T7SA48 | Labor Approval Amendment Track | 4 | NATIO | Nationality | nvarchar | 3 | 0 | | |
25 | T7SAPBS66 | Absence Type Limit Condition | 8 | NATIO | Nationality | nvarchar | 3 | 0 | | |
26 | HRP1702 | DB Table for Infotype 1702 | 32 | NATIO | Nationality (Citizenship) | nvarchar | 3 | 0 | | |
TOPAddress ManagementBusiness Address |
27 | SADR | Address Management: Company Data | 3 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
28 | SADRP | Address Management: Personal Data | 3 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
29 | T005T | Country Names | 5 | NATIO | Nationality | nvarchar | 15 | 0 | | |
30 | TSAV | Address Versions (Business Address Services) (Obsolete) | 1 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
31 | TSAVT | Address Versions Text (obsolete) | 2 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
TOPAdvertising Management |
32 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 43 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
TOPArgentina |
33 | T7ARM6 | My Simplification: Nationality-country code relationship | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPAustria |
34 | T5A9A | Created Statement of Employment (A) | 13 | NATIO | Nationality | nvarchar | 15 | 0 | | |
TOPBrazil |
35 | T7BRNA | Nationality codes | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPCapacity and Resource Planning |
36 | /MRSS/SADRPX | IS-Zusatzstruktur zu den SADR*-Strukturen | 3 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
TOPClinical System |
37 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 32 | NATIO | IS-H: Uyruk | nvarchar | 3 | 0 | | |
38 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 33 | NATIO | IS-H: Uyruk | nvarchar | 3 | 0 | | |
39 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 33 | NATIO | IS-H: Uyruk | nvarchar | 3 | 0 | | |
TOPCompany Pension Scheme Germany |
40 | PA0746 | HR Master Record for Infotype 0746 | 52 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPConstruction Industry |
41 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 31 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPData Transfer |
42 | T52CODIST_RETRO | Retroactive Accounting-Specific Wage Types for Cost Distrib. | 9 | NATIO | General Flag | nvarchar | 1 | 0 | | |
TOPIndonesia |
43 | T7ID0I | Identity Types | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPInternational Functions for the Public Sector |
44 | T7PBSDEC_COSTS | XDEC: Cost Distribution Definition | 18 | NATIO | XDEC: The cost is subject to Country Specific rules | nvarchar | 1 | 0 | | |
TOPLogbook |
45 | ADFSH_APTMAS | Flight Scheduling: Airport Master | 4 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
TOPPatient Management |
46 | NPAT | IS-H: Patient Master Data (General) | 26 | NATIO | IS-H: Nationality | nvarchar | 3 | 0 | | |
47 | NWAN | IS-H: Bad Debt Parties | 11 | NATIO | IS-H: Nationality | nvarchar | 3 | 0 | | |
TOPPayroll |
48 | PA0775 | Personel ana verileri: Bilgi tipi 0775 | 24 | NATIO | Uyrugu | nvarchar | 3 | 0 | | |
49 | T5H8N | Codes of nationality | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
50 | T5TREGTRANS | HRCZ - table for transfer items of Insured Register to SAP | 28 | NATIO | Nationality | nvarchar | 3 | 0 | | |
51 | T7RO005 | RO Nationality Names for EE Register | 4 | NATIO | Nationality (Max. 50 Characters) | nvarchar | 50 | 0 | | |
52 | T7ROG1 | EE register - ER history | 7 | NATIO | Version Number Component | nvarchar | 2 | 0 | | |
53 | T7ROG2 | EE register - EE history | 13 | NATIO | Version Number Component | nvarchar | 2 | 0 | | |
54 | T7ROG5 | EE register - ER history | 7 | NATIO | Version Number Component | nvarchar | 2 | 0 | | |
55 | T7ROG6 | EE register - EE history | 15 | NATIO | Version Number Component | nvarchar | 2 | 0 | | |
56 | T7TRT04 | Yurtdisi hizmetinde anlasmali gün bilgileri | 2 | NATIO | Uyrugu | nvarchar | 3 | 0 | | |
TOPPersonnel Administration |
57 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 44 | NATIO | Nationality | nvarchar | 3 | 0 | | |
58 | PA0152 | Infotype 0152 - Tax data CZ | 43 | NATIO | Resident's state | nvarchar | 3 | 0 | | |
59 | T7PL82 | Tax rates for foreign workers | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPPublic Sector |
60 | P01ZFA_NN_DATA | ZfA: Notifications Not Assigned | 34 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
61 | DFMCA_BRF590 | BRF: Process Business Partner (General Information) | 30 | NATIO | BRF: Expression | nvarchar | 20 | 0 | | |
TOPRecruitment |
62 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 44 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPRecycling Administration Core Functions |
63 | J_7LSADR | Address Management: Company Data | 3 | NATIO | International address version ID | nvarchar | 1 | 0 | | |
TOPReporting |
64 | P05TPRNL_EE_PD | Pension Return: Personal Data - Pers Level | 17 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
65 | NAKR1 | IS-H AT: LKF - Grunddaten | 8 | NATIO | IS-H: Staatsangehörigkeit | nvarchar | 3 | 0 | | |
66 | NPNTCAS | IS-H: Patient Master Data at Case Level (CV IT) | 8 | NATIO | IS-H: Nationality | nvarchar | 3 | 0 | | |
67 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 15 | NATIO | IS-H: Nationality | nvarchar | 3 | 0 | | |
TOPStaffing |
68 | T777N | Name Format | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPTaiwan |
69 | T7TW2I | Reported data of Tax withdrawal report | 31 | NATIO | Nationality | nvarchar | 3 | 0 | | |
70 | T7TW2J | Tax agreement codes | 2 | NATIO | Nationality | nvarchar | 3 | 0 | | |
71 | T7TW2JT | Tax agreement codes description | 3 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPTraining and Event Management |
72 | HRP1034 | Infotype 1034 DB table | 23 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPUse AP-MD-BP Components |
73 | BUT000 | BP: General data I | 59 | NATIO | Nationality | nvarchar | 3 | 0 | | |
74 | BUT000_TD | BP: General Data I, Shadow Table Time Dependency | 60 | NATIO | Nationality | nvarchar | 3 | 0 | | |
75 | BUT000_TDS | BP: General Data I, Shadow Table Time Dependency | 61 | NATIO | Nationality | nvarchar | 3 | 0 | | |
TOPUse Subcomponents |
76 | SOPR | SAPoffice: System-wide profile | 51 | NATIO | SAPoffice: international code for character set | nvarchar | 1 | 0 | | |
77 | SOUD | SAPoffice: user definition | 72 | NATIO | SAPoffice: international code for character set | nvarchar | 1 | 0 | | |