SAP ABAP Table P0059 (HR Master Record: Infotype 0059 (Social Insurance - NL))
Hierarchy
☛
SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
⤷ PA-PA-NL (Application Component) Netherlands
⤷ PB05 (Package) HR Master Data: Netherlands
⤷ PA-PA-NL (Application Component) Netherlands
⤷ PB05 (Package) HR Master Data: Netherlands
Basic Data
Table Category | INTTAB | Structure |
Structure | P0059 | Table Relationship Diagram |
Short Description | HR Master Record: Infotype 0059 (Social Insurance - NL) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Headers for Infotype Records | |||||
2 | .INCLUDE | 0 | 0 | Keys for HR Master Data | |||||
3 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
4 | INFTY | INFTY | INFOTYP | CHAR | 4 | 0 | Infotype | T582A | |
5 | SUBTY | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
6 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
7 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
8 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
9 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
10 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
11 | .INCLUDE | 0 | 0 | HR Master Record: Control Field | |||||
12 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
13 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
14 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
15 | ITXEX | ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
16 | REFEX | PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
17 | ORDEX | ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
18 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
19 | PREAS | PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
20 | FLAG1 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
21 | FLAG2 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
22 | FLAG3 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
23 | FLAG4 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
24 | RESE1 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
25 | RESE2 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
26 | GRPVL | PCCE_GPVAL | PCCE_GPVAL | CHAR | 4 | 0 | Grouping Value for Personnel Assignments | ||
27 | .INCLUDE | 0 | 0 | HR Master Record: Infotype 0059 (Social Insurance - NL) | |||||
28 | KDZW1 | KDZW1 | KDSV1 | CHAR | 1 | 0 | Contribution Ind. for the Sicknes Benefits Act [ZW] Scheme | T5N1A | |
29 | KDWW1 | KDWW1 | KDSV1 | CHAR | 1 | 0 | Contribution Indicator for the Unemployment Act Scheme [WW] | T5N1A | |
30 | KDWAO | KDWAO | KDSV1 | CHAR | 1 | 0 | Contrib. cd. for the Act on Work and Income by Labour Capac. | T5N1A | |
31 | KDZKS | KDZKS | KDSV1 | CHAR | 1 | 0 | Contribution code for the Health Insurance Act | T5N1A | |
32 | NVERZ | NVERZ | NVERZ | CHAR | 5 | 0 | Name of Private Health Insurance Company | T5N1C | |
33 | BDRPR | BDRPR | P05_WERT7 | CURR | 7 | 2 | Private Health Insurance Premium | ||
34 | INHPR | INHPR | INHPR | CHAR | 1 | 0 | Deduction Indicator for EE Contribution to Private HI | ||
35 | BDRWG | BDRWG | P05_WERT7 | CURR | 7 | 2 | Employer's Contribution to Private Health Insurance | ||
36 | INHBS | INHBS | KDSV1 | CHAR | 1 | 0 | Indicator SI (Equalization) Deduction [VB] (Civil Servants) | T5N1A | |
37 | DATSF | DATSF | DATUM | DATS | 8 | 0 | Start Date for Social Fund Membership | ||
38 | BMETH | BMETH | BMETH | CHAR | 2 | 0 | Calculation Method for Employer's Contribution to HI | T5N1D | |
39 | EXSV1 | EXSV1 | KDSV1 | CHAR | 1 | 0 | Contribution Indicator for Additional SI Scheme 1 | T5N1A | |
40 | EXSV2 | EXSV2 | KDSV1 | CHAR | 1 | 0 | Contribution Indicator for Additional SI Scheme 2 | T5N1A | |
41 | EXSV3 | EXSV3 | KDSV1 | CHAR | 1 | 0 | Contribution Indicator for Additional SI Scheme 3 | T5N1A | |
42 | EXSV4 | EXSV4 | KDSV1 | CHAR | 1 | 0 | Contribution Indicator for Additional SI Scheme 4 | T5N1A | |
43 | EXSV5 | EXSV5 | KDSV1 | CHAR | 1 | 0 | Contribution Indicator for Additional SI Scheme 5 | T5N1A | |
44 | SVGRP | SVGRP | P05_SPGRP | CHAR | 3 | 0 | Social Insurance Group Indicator | T5N12 | |
45 | SVDAY | P05_SVDAY | P05_SVDAY | CHAR | 1 | 0 | Indicator for Calculation of SI Days | ||
46 | SVMET | P05_SVMET | P05_SVMET | CHAR | 1 | 0 | Calculation Method for Social Insurance | ||
47 | ZKVGP | P05_ZKVGP | P05_ZKVGP | CHAR | 2 | 0 | Private Health Insurance Group | ||
48 | PKLAS | P05_PKLAS | P05_PKLAS | CHAR | 2 | 0 | Contribution Scale for Health Insurance | T5N1E | |
49 | ZKVNR | P05_ZKVNR | CHAR20 | CHAR | 20 | 0 | Health Insurance [Ziekenfonds] Registration Number | ||
50 | MBVCD | P05_MBVCD | P05_CDMDG | CHAR | 2 | 0 | Special Code | T5N9D | |
51 | UPKOW | P05_UPKOW | CHAR1 | CHAR | 1 | 0 | Excluded from Premium Exemption for Elderly Employees | ||
52 | ARBGK | P05_ARBGK | P05_ARBGK | CHAR | 1 | 0 | Disabled Person's SI Reduction | ||
53 | DATAG | P05_DATAG | DATUM | DATS | 8 | 0 | Start Date for Disabled Person's SI Reduction | ||
54 | JGKRT | P05_JGKRT | CHAR1 | CHAR | 1 | 0 | Young Disabled Person's SI Reduction | ||
55 | NOMPR | P05_NOMPR | P05_WERT7 | CURR | 7 | 2 | Nominal contribution Health Insurance Act (ZVW) | ||
56 | WGBNP | P05_WGBNP | P05_WERT7 | CURR | 7 | 2 | Employer contribution nominal contribution ZVW | ||
57 | INCVZ | P05_INDCVZ | P05_INDCVZ | CHAR | 1 | 0 | CVZ indication | ||
58 | IDCVZ | P05_IDCVZ | CHAR25 | CHAR | 25 | 0 | Identification at CVZ | ||
59 | FACVZ | P05_FACTOR_CVZ | P05T_CVZ_FACTOR | DEC | 8 | 7 | Country of residence factor | ||
60 | SIRHE | P05_SIRHE | P05_SIRHE | CHAR | 1 | 0 | SI Reduction Hiring Elderly Employee | ||
61 | SIBEG | P05_SIRHE_BEGDA | DATUM | DATS | 8 | 0 | Start Date SI Reduction Hiring Elderly Employee | ||
62 | SIEND | P05_SIRHE_ENDDA | DATUM | DATS | 8 | 0 | End Date SI Reduction Hiring Elderly Employee | ||
63 | EXREE | P05_EXREE | P05_EXREE | CHAR | 1 | 0 | Excluded from SI Reduction Employing Elderly Employee | ||
64 | SIEMA | P05_SIEMA | XFELD | CHAR | 1 | 0 | Premium Exemption Ex-Social Benefits Recipient (PMA) | ||
65 | REPOR | P05_REPOR | XFELD | CHAR | 1 | 0 | Subject to Reduced Pay (Old Regulation) | ||
66 | EXSJR | P05_EXSJR | XFELD | CHAR | 1 | 0 | Excluded from Small Jobs Regulation | ||
67 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P0059 | BMETH | T5N1D | BMETH | REF | ||
2 | P0059 | EXSV1 | T5N1A | KDSV1 | REF | 1 | CN |
3 | P0059 | EXSV2 | T5N1A | KDSV1 | REF | 1 | CN |
4 | P0059 | EXSV3 | T5N1A | KDSV1 | REF | 1 | CN |
5 | P0059 | EXSV4 | T5N1A | KDSV1 | REF | 1 | CN |
6 | P0059 | EXSV5 | T5N1A | KDSV1 | REF | 1 | CN |
7 | P0059 | INFTY | T582A | INFTY | |||
8 | P0059 | INHBS | T5N1A | KDSV1 | REF | 1 | CN |
9 | P0059 | KDWAO | T5N1A | KDSV1 | REF | 1 | CN |
10 | P0059 | KDWW1 | T5N1A | KDSV1 | REF | 1 | CN |
11 | P0059 | KDZKS | T5N1A | KDSV1 | REF | 1 | CN |
12 | P0059 | KDZW1 | T5N1A | KDSV1 | REF | 1 | CN |
13 | P0059 | MBVCD | T5N9D | CDMDG | 1 | CN | |
14 | P0059 | NVERZ | T5N1C | NVERZ | |||
15 | P0059 | PKLAS | T5N1E | PKLAS | REF | 1 | CN |
16 | P0059 | PREAS | T530E | PREAS | |||
17 | P0059 | SVGRP | T5N12 | SPGRP | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |