SAP ABAP Table PA0651 (HR Master Record Infotype 0651)
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷ PY-XX-RS (Application Component) Reuse Services for Country Development
⤷ P01W (Package) HR Germany: Statements
⤷ PY-XX-RS (Application Component) Reuse Services for Country Development
⤷ P01W (Package) HR Germany: Statements
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | PA0651 | Table Relationship Diagram |
Short Description | HR Master Record Infotype 0651 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | .INCLUDE | 0 | 0 | Key for HR Master Data | |||||
3 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | PA0003 | |
4 | SUBTY | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
5 | OBJPS | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
6 | SPRPS | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
7 | ENDDA | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
8 | BEGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
9 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
10 | .INCLUDE | 0 | 0 | HR Master Record: Control Field | |||||
11 | AEDTM | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
12 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
13 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
14 | ITXEX | ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
15 | REFEX | PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
16 | ORDEX | ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
17 | ITBLD | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
18 | PREAS | PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
19 | FLAG1 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
20 | FLAG2 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
21 | FLAG3 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
22 | FLAG4 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
23 | RESE1 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
24 | RESE2 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
25 | GRPVL | PCCE_GPVAL | PCCE_GPVAL | CHAR | 4 | 0 | Grouping Value for Personnel Assignments | ||
26 | .INCLUDE | 0 | 0 | Statements: Social Insurance Agency | |||||
27 | KVNAM | P01W_KVNAM | TEXT40 | CHAR | 40 | 0 | First Name of Sick Child | ||
28 | KNNAM | P01W_KNNAM | TEXT40 | CHAR | 40 | 0 | Last Name of Sick Child | ||
29 | KGDAT | P01W_KGDAT | DATUM | DATS | 8 | 0 | Child's Date of Birth | ||
30 | WVLDT | P01W_WVLDT | DATUM | DATS | 8 | 0 | Start of Advance Winter Compensation Benefit | ||
31 | WALAZ | P01W_WALAZ | XFELD | CHAR | 1 | 0 | Advance Winter Compensation Benefit in Last Payroll Period | ||
32 | STWAG | P01W_STWAG | STDAZ | DEC | 5 | 2 | Advance Winter Compensation Benefit: Number of Hours | ||
33 | EFZGD | P01W_EFZGD | TEXT30 | CHAR | 30 | 0 | Continued Pay <= 6 Weeks: Reasons | ||
34 | AEZUS | P01W_AEZUS | P01W_AEZUS | NUMC | 1 | 0 | Additional Remuneration | ||
35 | AEBIS | P01W_AEBIS | DATUM | DATS | 8 | 0 | Additional Remuneration: To | ||
36 | ZLRHT | P01W_ZLRHT | P01W_ZLRHT | CHAR | 1 | 0 | Payment Frequency | ||
37 | ZABRT | P01W_ZABRT | P_AMT07V | CURR | 13 | 2 | Additional Remuneration: Gross | ||
38 | ZANTO | P01W_ZANTO | P_AMT07V | CURR | 13 | 2 | Additional Remuneration: Net | ||
39 | KDGAM | P01W_KDGAM | DATUM | DATS | 8 | 0 | Termination On | ||
40 | KDGRD | P01W_KDGRD | TEXT30 | CHAR | 30 | 0 | Termination Reason | ||
41 | KDZUM | P01W_KDZUM | DATUM | DATS | 8 | 0 | Termination On | ||
42 | VWBET | P01W_VWBET | P_AMT07V | CURR | 13 | 2 | Capital Formation Savings Payment of Employer: Amount | ||
43 | VWBIS | P01W_VWBIS | DATUM | DATS | 8 | 0 | CFS Limited To | ||
44 | VWRHT | P01W_VWRHT | P01W_VWRHT | CHAR | 1 | 0 | CFS - Payment Frequency | ||
45 | ZUSAR | P01W_ZUSAR | TEXT30 | CHAR | 30 | 0 | Additional Payments in Kind: Type | ||
46 | ZSBTG | P01W_ZSBTG | P_AMT07V | CURR | 13 | 2 | Additional Payments in Kind: Amount | ||
47 | LABEG | P01W_LABEG | DATUM | DATS | 8 | 0 | Building Sector: Wage Compensation From | ||
48 | LAEND | P01W_LAEND | DATUM | DATS | 8 | 0 | Building Sector: Wage Compensation To | ||
49 | LABE1 | P01W_LABEG | DATUM | DATS | 8 | 0 | Building Sector: Wage Compensation From | ||
50 | LAEN1 | P01W_LAEND | DATUM | DATS | 8 | 0 | Building Sector: Wage Compensation To | ||
51 | FRNTO | P01W_FRNTO | P_AMT07V | CURR | 13 | 2 | Net Remuneration on First Day of Release from Work | ||
52 | FRGKI | P01W_FRGKI | XFELD | CHAR | 1 | 0 | Release from Work Due to Same Child | ||
53 | KIBE1 | P01W_KINBG | DATS | DATS | 8 | 0 | Release from Work Due to Illness of Same Child: Start Date | ||
54 | KIEN1 | P01W_KINED | DATS | DATS | 8 | 0 | Release from Work Due to Illness of Same Child: End Date | ||
55 | KIBE2 | P01W_KINBG | DATS | DATS | 8 | 0 | Release from Work Due to Illness of Same Child: Start Date | ||
56 | KIEN2 | P01W_KINED | DATS | DATS | 8 | 0 | Release from Work Due to Illness of Same Child: End Date | ||
57 | KITA1 | P01W_KINTG | NUMC02 | NUMC | 2 | 0 | Release from Work Due to Illness of Same Child: No. of Days | ||
58 | KITA2 | P01W_KINTG | NUMC02 | NUMC | 2 | 0 | Release from Work Due to Illness of Same Child: No. of Days | ||
59 | BRTAE | P01W_BRTAE | P01W_BRTAE | CHAR | 1 | 0 | Working Time | ||
60 | ANGRD | P01W_ANGRD | P01W_ANGRD | CHAR | 1 | 0 | Entitlement to Paid Release from Work | ||
61 | ANFRT | P01W_ANFRT | NUMC02 | NUMC | 2 | 0 | Temporary Entitlement to | ||
62 | FALNR | P01W_FALNR | CHAR12 | CHAR | 12 | 0 | Case Number | ||
63 | FRABL | P01W_FRABL | XFELD | CHAR | 1 | 0 | Work Relationship/Period Expiration | ||
64 | FADAT | P01W_FADAT | DATUM | DATS | 8 | 0 | Date of Period Expiration | ||
65 | ENTS1 | P01W_ENTSC | STDAZ | DEC | 5 | 2 | Excused Unpaid Working Hours | ||
66 | UNTS1 | P01W_UNTSC | STDAZ | DEC | 5 | 2 | Unexcused Unpaid Working Hours | ||
67 | ENTS2 | P01W_ENTSC | STDAZ | DEC | 5 | 2 | Excused Unpaid Working Hours | ||
68 | UNTS2 | P01W_UNTSC | STDAZ | DEC | 5 | 2 | Unexcused Unpaid Working Hours | ||
69 | ENTS3 | P01W_ENTSC | STDAZ | DEC | 5 | 2 | Excused Unpaid Working Hours | ||
70 | UNTS3 | P01W_UNTSC | STDAZ | DEC | 5 | 2 | Unexcused Unpaid Working Hours | ||
71 | MON01 | P01W_MONXX | P01W_MONXX | CHAR | 2 | 0 | Date - Month | ||
72 | MON02 | P01W_MONXX | P01W_MONXX | CHAR | 2 | 0 | Date - Month | ||
73 | MON03 | P01W_MONXX | P01W_MONXX | CHAR | 2 | 0 | Date - Month | ||
74 | YEA01 | P01W_YEAXX | CHAR4 | CHAR | 4 | 0 | Date - Year | ||
75 | YEA02 | P01W_YEAXX | CHAR4 | CHAR | 4 | 0 | Date - Year | ||
76 | YEA03 | P01W_YEAXX | CHAR4 | CHAR | 4 | 0 | Date - Year | ||
77 | WAERS | P01W_WAERS | WAERS | CUKY | 5 | 0 | Currency Key | T500W | |
78 | UFTAG | P01W_UFTAG | NUMC08 | NUMC | 8 | 0 | Accident Date | ||
79 | KDGSL | P01W_KDGSL | P01W_KDGSL | CHAR | 1 | 0 | Termination Reason | ||
80 | AEUEB | P01W_AEUEB | XFELD | CHAR | 1 | 0 | Remuneration Exceeds Comparison Net by More Than EUR 50 | ||
81 | FRBTO | P01W_FRBTO | P_AMT07V | CURR | 13 | 2 | Gross Remuneration on First Day of Release from Work | ||
82 | UVTRG | P01W_UVTRG | TEXT30 | CHAR | 30 | 0 | Name of Accident Insurance Institution | ||
83 | SBRHT | P01W_SBRHT | P01W_SBRHT | CHAR | 1 | 0 | HR-DBS: Payments in Kind - Payment Frequency | ||
84 | ADRS1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
85 | ADRS2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
86 | ADRS3 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
87 | KNDNR | P01_KNDNR | OBJPS | CHAR | 2 | 0 | Child Number | ||
88 | ABMSN | P01_ABMSN | XFELD | CHAR | 1 | 0 | Job-Creating Measure | ||
89 | VORER | P01_SV_EE_VORER | P01_SV_EE_KNZJN | CHAR | 1 | 0 | Continued Pay for Less Than 6 Weeks | ||
90 | BEGVE1 | P01_SV_EE_BEGVE1 | P01_SV_EE_DATUM | DATS | 8 | 0 | Start of Imputable Periods of Preexisting Conditions 1 | ||
91 | ENDVE1 | P01_SV_EE_ENDVE1 | P01_SV_EE_DATUM | DATS | 8 | 0 | Imputable Periods of Preexisting Conditions End 1 | ||
92 | BEGVE2 | P01_SV_EE_BEGVE2 | P01_SV_EE_DATUM | DATS | 8 | 0 | Start of Imputable Periods of Preexisting Conditions 2 | ||
93 | ENDVE2 | P01_SV_EE_ENDVE2 | P01_SV_EE_DATUM | DATS | 8 | 0 | Imputable Periods of Preexisting Conditions End 2 | ||
94 | AEVZMON | P01_SV_EE_AEVZMON2 | CURR | 8 | 2 | Monthly Full-Time Remuneration in Cal. Month Before Start | |||
95 | AEVZSTD | P01_SV_EE_AEVZSTD2 | CURR | 8 | 2 | Hourly Full-Time Remuneration in Cal. Month Before Start | |||
96 | WAZTRF | P01_SV_EE_WAZTRF2 | DEC | 5 | 2 | Weekly Working Time Agreed by Collective Agreement | |||
97 | BEGTRF | P01_SV_EE_BEGTRF | P01_SV_EE_DATUM | DATS | 8 | 0 | Currently Valid Collective Agreement Of | ||
98 | TRFGEM | P01_SV_EE_TRFGEM | P01_SV_EE_KZ20 | CHAR | 20 | 0 | Defining Pay Scale Group/Collective Agreement | ||
99 | MMTRF | P01_SV_EE_MMTRF | P01_SV_EE_MMTRF | CHAR | 1 | 0 | Defining Pay Scale Group/Collective Agreement | ||
100 | VRGTGR | P01_SV_EE_VRGTGR | P01_SV_EE_KZ20 | CHAR | 20 | 0 | Remuneration/Wage Group | ||
101 | VWLMON | P01_SV_EE_VWLMON2 | CURR | 8 | 2 | Monthly Coll. Agr. Capital Form. Savings Payment of Employer | |||
102 | EZTRF | P01_SV_EE_EZTRF2 | CURR | 8 | 2 | Non-Recurring Annual Payment Regulated by Collective Agr. | |||
103 | AEENTTRF | P01_SV_EE_AEENTTRF | P01_SV_EE_KZJNU | CHAR | 1 | 0 | Remuneration Corresponds to Collective Agreement Conditions | ||
104 | VWL | P01_SV_EE_VWL2 | CURR | 6 | 2 | Capital Formation Savings Payment During Bens for Particptn | |||
105 | BRUSB | P01_SV_EE_BRUSB2 | CURR | 8 | 2 | Gross Cont. Paymts in Kind/Rem. for PT Work in Mnth d. BfP | |||
106 | NETSB | P01_SV_EE_NETSB2 | CURR | 8 | 2 | Net Cont. Payments in Kind/Rem. PT Wrk d. BfP in Month | |||
107 | UNFAZ | P01_SV_EE_UNFAZ | P01_SV_EE_UNFAZ | CHAR | 20 | 0 | Accident Case Number of Relevant Accident Insurance Carrier | ||
108 | UNFTR | P01_SV_EE_UNFTR | P01_SV_EE_UNFTR | CHAR | 15 | 0 | Institute Indicator of Accident Insurance Carrier | ||
109 | BVALS | P01_SV_EE_BVALS | P01_SV_EE_BVALS | CHAR | 30 | 0 | Employed as | ||
110 | ABWGRD | P01_SV_EE_ABWGRD | P01_SV_EE_ABGRD | NUMC | 2 | 0 | Different Submission Reason | ||
111 | ABWBEG | P01_SV_EE_ABWBEG | P01_SV_EE_DATUM | DATS | 8 | 0 | Linked Absence | ||
112 | EAZEND | P01_SV_EE_EAZEND1 | P01_SV_EE_DATUM | DATS | 8 | 0 | Last Settled Payroll Period 1 End | ||
113 | LBTAG | P01_SV_EE_LBTAG | P01_SV_EE_DATUM | DATS | 8 | 0 | Last Paid Day | ||
114 | UMGEWAE | P01_SV_EE_UMGEWAE2 | CURR | 8 | 2 | Remuneration Conversion | |||
115 | VEBBRU | P01_SV_EE_VEBBRU2 | CURR | 8 | 2 | Agreed Gross Remuneration | |||
116 | VEBNET | P01_SV_EE_VEBNET2 | CURR | 8 | 2 | Net Remuneration | |||
117 | EZKV | P01_SV_EE_EZKV2 | CURR | 8 | 2 | Part of Non-Recurring Payments Liable for Contr. in HI | |||
118 | EZRV | P01_SV_EE_EZRV2 | CURR | 8 | 2 | Part of Non-Recurring Payments Liable for Contr. in PI | |||
119 | EZAV | P01_SV_EE_EZAV2 | CURR | 8 | 2 | Part of Non-Recurring Payments Liable for Contr. in UI | |||
120 | ANZTG | P01_SV_EE_ANZTG | P01_SV_EE_ANZTG | NUMC | 2 | 0 | Number of Workdays for Payment of Gross Remuneration | ||
121 | ANZAT | P01_SV_EE_ANZAT | P01_SV_EE_ATANZ | NUMC | 2 | 0 | Number of Workdays in Release from Work Period | ||
122 | FRTAG01 | P01_SV_EE_FRTAGZ | P01_SV_EE_DATUM | DATS | 8 | 0 | Additional Release from Work | ||
123 | FRTAG02 | P01_SV_EE_FRTAGZ | P01_SV_EE_DATUM | DATS | 8 | 0 | Additional Release from Work | ||
124 | ABWAUS | P01_SV_EE_ABWAUS | XFELD | CHAR | 1 | 0 | Termination During Illness | ||
125 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PA0651 | PERNR | PA0003 | PERNR | |||
2 | PA0651 | PREAS | T530E | PREAS | |||
3 | PA0651 | WAERS | T500W | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 46C |