SAP ABAP Table P0051 (HR Master Record Infotype 0051 (VBL/SPI Data))
Hierarchy
☛
SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
⤷ PY-DE-PS (Application Component) Public Sector
⤷ P01O_ZV (Package) SP Notification Program for Public Sector Germany
⤷ PY-DE-PS (Application Component) Public Sector
⤷ P01O_ZV (Package) SP Notification Program for Public Sector Germany
Basic Data
Table Category | INTTAB | Structure |
Structure | P0051 | Table Relationship Diagram |
Short Description | HR Master Record Infotype 0051 (VBL/SPI Data) |
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 0051 (VBL/SPI Data) | |||||
28 | VBLPF | VBLPF | P01P_VBLPF | CHAR | 1 | 0 | Employee's Insurance Liability | ||
29 | PFBIS | PFBIS | CHAR3 | CHAR | 3 | 0 | Maximum Age for Insurance | ||
30 | BEINB | BEINB | KMONAT | NUMC | 2 | 0 | Period for higher assessment threshold | ||
31 | PAUST | PAUST | PAUST | CHAR | 1 | 0 | Tax Indicator | ||
32 | VBLNR | VBLNO | CHAR10 | CHAR | 10 | 0 | Insurance Number (Public Sector) (Obsolete with ZVMP) | ||
33 | TTART | TTART | VBLAK | CHAR | 2 | 0 | Job in Special Case (Obsolete with ZVMP) | T535V | |
34 | VVZVE | VVZVE | XFELD | CHAR | 1 | 0 | Previous insurance at another SPI | ||
35 | ARGZU | ARGZU | XFELD | CHAR | 1 | 0 | Previous Employer's Contribution (Obsolete with ZVMP) | ||
36 | BEZVE | BEZVE | XFELD | CHAR | 1 | 0 | Previous exemption from ZVE | ||
37 | ZWVER | DZWVER | XFELD | CHAR | 1 | 0 | Second Insurance Contract | ||
38 | AGRND | AGRND | VBLAK | CHAR | 2 | 0 | Deregistration Reason (Obsolete with ZVMP) | T535V | |
39 | SWTBE | SWTBE | SWTBE | CHAR | 1 | 0 | Employment Type (Obsolete with ZVMP) | ||
40 | WIEDE | WIEDE | XFELD | CHAR | 1 | 0 | Rehiring of Seasonal/Forestry Workers (Obsolete with ZVMP) | ||
41 | ZVSOD | DZVSOD | CHAR1 | CHAR | 1 | 0 | Supplementary Pension (Civil Service) (Obsolete with ZVMP) | ||
42 | ZVEID | VWOID | VZVID | CHAR | 2 | 0 | Different ID for SPI (Obsolete with ZVMP) | T5D5Z | |
43 | UMLAN | UMLAN | XFELD | CHAR | 1 | 0 | Indicator: Is contribution amount to be paid to employee? | ||
44 | FAMST | FAMSTZV | FAMSTZV | CHAR | 1 | 0 | Material Status (for SP Notifications) (Obsolete with ZVMP) | ||
45 | ANSKG | ANSKGZV | ANSKGZV | CHAR | 1 | 0 | Entitlm. to Child Allowance (SP Notifs) (Obsolete with ZVMP) | ||
46 | ZSUML | VZSUML | XFELD | CHAR | 1 | 0 | Additional Contribution Amount/Contribution from 2002 | ||
47 | VTMOD | P01_VTMOD | P01_VTMOD | CHAR | 4 | 0 | AVmG: Contract Model | T5DR3 | |
48 | KZ_ALTBESTAND | P01P_KZ_ALTBESTAND | XFELD | CHAR | 1 | 0 | Key Fig., Prior-Year Acquisitions (Due to Retro. Financing) | ||
49 | ANZKE | P01P_ZV_ANZ_KIND_ELTERNZEIT_N | P01P_ZV_ANZ_KIND_ELTERNZEIT | NUMC | 2 | 0 | Suppl. Pension: No. of Children Entitled to Parental Leave | ||
50 | .INCLUDE | 0 | 0 | Employer Identification | |||||
51 | WERKS_SUM | PERSA_SUM | PERSA | CHAR | 4 | 0 | Personnel Area Reporting | T5DPBSZVAGE | |
52 | BTRTL_SUM | BTRTL_SUM | BTRTL | CHAR | 4 | 0 | Personnel Subarea Reporting | T5DPBSZVAGE | |
53 | VAKEY | P01P_VARKEY | CHAR08 | CHAR | 8 | 0 | Variable Key for Employer Table | T5DPBSZVAGE | |
54 | VERNR | P01P_VERNR | P01P_VERNR | CHAR | 12 | 0 | Supp. Insurance Number | ||
55 | ABMGR | P01P_ABMGR | P01P_ABMGR | CHAR | 2 | 0 | Deregistration Reason of DATUEV-ZVE | ||
56 | NONOT | P01P_NONOT | XFELD | CHAR | 1 | 0 | Switch: Do Not Transfer Notifications | ||
57 | STMOD | P01P_ZVSTEU | P01P_ZVSTEU | CHAR | 2 | 0 | Supplementary Pension: Tax Model | T5D5H | |
58 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P0051 | AGRND | T535V | IDENT | |||
2 | P0051 | BTRTL_SUM | T5DPBSZVAGE | WERKS_SUM | KEY | 1 | CN |
3 | P0051 | INFTY | T582A | INFTY | |||
4 | P0051 | PREAS | T530E | PREAS | |||
5 | P0051 | STMOD | T5D5H | STMOD | KEY | 1 | CN |
6 | P0051 | TTART | T535V | IDENT | |||
7 | P0051 | VAKEY | T5DPBSZVAGE | BTRTL_SUM | KEY | 1 | CN |
8 | P0051 | VTMOD | T5DR3 | VTMOD | |||
9 | P0051 | ZVEID | T5D5Z | ZVEID |
History
Last changed by/on | SAP | 20060703 |
SAP Release Created in |