SAP Table PA0077
HR Master Record: Infotype 0077 (Additional Personal Data)
PA0077 (HR Master Record: Infotype 0077 (Additional Personal Data)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PA0077 to other SAP tables.
Source: PA0077 (HR Master Record: Infotype 0077 (Additional Personal Data))
PA0077 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
PERNR | Personnel number | PERSNO | PA0003 | NUMC | 8 | 0 | ||||||||
SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||||
OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||||
SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||||
ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||
BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||
SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||
AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||
ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||||
REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||
ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||
ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||||
PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||||
FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||
RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||
GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||||
RACKY | Ethnic origin | RACKY | T505R | CHAR | 2 | 0 | ||||||||
MILSA | Military status | MILSA | T505M | NUMC | 2 | 0 | ||||||||
RELGN | Religious Denomination Key | KONFE | T516T | CHAR | 2 | 0 | ||||||||
SURVY | Survey answered | SURVY | CHAR | 1 | 0 |
Possible values
|
||||||||
DISAB | Disability | DISABTY | CHAR | 1 | 0 |
Possible values
|
||||||||
VETST | Veteran status | VETST | CHAR | 1 | 0 | |||||||||
DISDT | Date of Determination of Disability Status | DISDT | DATS | 8 | 0 | |||||||||
DISLE | Date Employer Learned of Disability Status | DISLE | DATS | 8 | 0 | |||||||||
MEDIC | Benefit Indicator for Medicare | BEN_MEDIC | CHAR | 1 | 0 |
Possible values
|
||||||||
EEOEX | EEO Exempt Indicator | EEOEX | CHAR | 1 | 0 | |||||||||
ETHEN | Ethnicity | ETHEN | T505R | CHAR | 2 | 0 | ||||||||
RAC01 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC02 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC03 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC04 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC05 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC06 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC07 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC08 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC09 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RAC10 | Racial Category | RACES | T505R | CHAR | 2 | 0 | ||||||||
RIFST | Reduction in Force Veterans' Preference | P10_RIFST | CHAR | 2 | 0 |
Possible values
|
||||||||
RCITY | Designated CMA | PCA_RECTY | CHAR | 4 | 0 | |||||||||
SURPA | Survey Participation flag | PCA_SURPA | CHAR | 1 | 0 |
Possible values
|
||||||||
RELEA | Release of Data | PCA_RELEA | CHAR | 1 | 0 |
Possible values
|
||||||||
SURSC | Source of Survey Data | PCA_SURSC | T5KE2 | CHAR | 2 | 0 | ||||||||
ABOTY | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
DTY01 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
DTY02 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
DTY03 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
DTY04 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
DTY05 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
MTY01 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
MTY02 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
MTY03 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
MTY04 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
MTY05 | Designated groups for Group types | PCA_DESGR | T5KE2 | CHAR | 2 | 0 | ||||||||
VETS1 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS2 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS3 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS4 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS5 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS6 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS7 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS8 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS9 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS10 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS11 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
VETS12 | Veteran Status New | VETRST | CHAR | 2 | 0 | |||||||||
DCRDT | Date of Discharge | DISCHDT | DATS | 8 | 0 |
PA0077 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
PA0077 | ABOTY | PA0077 | ABOTY | T5KE2 | Designated Groups | DESGR |
PA0077 | ABOTY | T5KE1 | EEAGT | T5KE2 | Designated Groups | EEAGT |
PA0077 | ABOTY | T5KE1 | MOLGA | T5KE2 | Designated Groups | MOLGA |
PA0077 | ABOTY | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | DTY01 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | DTY01 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | DTY01 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | DTY01 | PA0077 | DTY01 | T5KE2 | Designated Groups | DESGR |
PA0077 | DTY02 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | DTY02 | PA0077 | DTY02 | T5KE2 | Designated Groups | DESGR |
PA0077 | DTY02 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | DTY02 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | DTY03 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | DTY03 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | DTY03 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | DTY03 | PA0077 | DTY03 | T5KE2 | Designated Groups | DESGR |
PA0077 | DTY04 | PA0077 | DTY04 | T5KE2 | Designated Groups | DESGR |
PA0077 | DTY04 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | DTY04 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | DTY04 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | DTY05 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | DTY05 | PA0077 | DTY05 | T5KE2 | Designated Groups | DESGR |
PA0077 | DTY05 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | DTY05 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | ETHEN | PA0077 | ETHEN | T505R | Ethnic Origin | RACKY |
PA0077 | ETHEN | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | ETHEN | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | MANDT | PA0077 | MANDT | T000 | Clients | MANDT |
PA0077 | MILSA | PA0077 | MANDT | T505M | Military status | MANDT |
PA0077 | MILSA | T001P | MOLGA | T505M | Military status | MOLGA |
PA0077 | MILSA | PA0077 | MILSA | T505M | Military status | MILSA |
PA0077 | MTY01 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | MTY01 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | MTY01 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | MTY01 | PA0077 | MTY01 | T5KE2 | Designated Groups | DESGR |
PA0077 | MTY02 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | MTY02 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | MTY02 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | MTY02 | PA0077 | MTY02 | T5KE2 | Designated Groups | DESGR |
PA0077 | MTY03 | PA0077 | MTY03 | T5KE2 | Designated Groups | DESGR |
PA0077 | MTY03 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | MTY03 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | MTY03 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | MTY04 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | MTY04 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | MTY04 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | MTY04 | PA0077 | MTY04 | T5KE2 | Designated Groups | DESGR |
PA0077 | MTY05 | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | MTY05 | * | T5KE2 | Designated Groups | MOLGA | |
PA0077 | MTY05 | * | T5KE2 | Designated Groups | EEAGT | |
PA0077 | MTY05 | PA0077 | MTY05 | T5KE2 | Designated Groups | DESGR |
PA0077 | PERNR | PA0077 | PERNR | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | PERNR |
PA0077 | PERNR | PA0077 | MANDT | PA0003 | HR Master Record: Infotype 0003 (Payroll Status) | MANDT |
PA0077 | PREAS | '0077' | T530E | Reasons for Changes | INFTY | |
PA0077 | PREAS | PA0077 | MANDT | T530E | Reasons for Changes | MANDT |
PA0077 | PREAS | PA0077 | PREAS | T530E | Reasons for Changes | PREAS |
PA0077 | RAC01 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC01 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC01 | PA0077 | RAC01 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC02 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC02 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC02 | PA0077 | RAC02 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC03 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC03 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC03 | PA0077 | RAC03 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC04 | PA0077 | RAC04 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC04 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC04 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC05 | PA0077 | RAC05 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC05 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC05 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC06 | PA0077 | RAC06 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC06 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC06 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC07 | PA0077 | RAC07 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC07 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC07 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC08 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC08 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC08 | PA0077 | RAC08 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC09 | PA0077 | RAC09 | T505R | Ethnic Origin | RACKY |
PA0077 | RAC09 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC09 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC10 | SYST | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RAC10 | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RAC10 | PA0077 | RAC10 | T505R | Ethnic Origin | RACKY |
PA0077 | RACKY | T001P | MOLGA | T505R | Ethnic Origin | MOLGA |
PA0077 | RACKY | PA0077 | MANDT | T505R | Ethnic Origin | MANDT |
PA0077 | RACKY | PA0077 | RACKY | T505R | Ethnic Origin | RACKY |
PA0077 | RELGN | PA0077 | RELGN | T516T | Religious Denomination Texts | KONFE |
PA0077 | RELGN | SYST | LANGU | T516T | Religious Denomination Texts | SPRSL |
PA0077 | RELGN | SYST | MANDT | T516T | Religious Denomination Texts | MANDT |
PA0077 | SURSC | SYST | MANDT | T5KE2 | Designated Groups | MANDT |
PA0077 | SURSC | T5KE1 | MOLGA | T5KE2 | Designated Groups | MOLGA |
PA0077 | SURSC | T5KE1 | EEAGT | T5KE2 | Designated Groups | EEAGT |
PA0077 | SURSC | PA0077 | SURSC | T5KE2 | Designated Groups | DESGR |