PA0021

HR Master Record: Infotype 0021 (Family) | #masterdata | Component: Personnel Administration

🔑 Keys (8)
💰 Amounts (1)
∑ Quantities
📅 Dates (5)
☰ Categorical (4)
Other (26)
🔗 Relations (22)

Column Name	Description
MANDT FK	Client
PERNR FK	Personnel Number
SUBTY	Subtype
OBJPS	Object Identification
SPRPS	Lock Indicator for HR Master Data Record
ENDDA	End Date
BEGDA	Start Date
SEQNR	Number of Infotype Record With Same Key

Column Name	Description
💲 Currency Key (T500C.WAERS):
BETRG	Amount

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date
AEDTM	Last Changed On
FGBDT	Date of Birth
FASDT	End of Family Member's Education/Training

Column Name	Description
ITXEX	Text Exists for Infotype	Show values
REFEX	Reference Fields Exist (Primary/Secondary Costs)	Show values
ORDEX	Confirmation Fields Exist	Show values
EMRGN	Emergency Contact	Show values

Column Name	Description	Domain name
UNAME	Name of Person Who Changed Object	USNAM
HISTO	Historical Record Flag	CHAR1
ITBLD	Infotype Screen Control	CHAR2
FLAG1	Reserved Field/Unused Field	NUSED
FLAG2	Reserved Field/Unused Field	NUSED
FLAG3	Reserved Field/Unused Field	NUSED
FLAG4	Reserved Field/Unused Field	NUSED
RESE1	Reserved Field/Unused Field of Length 2	NUSED2
RESE2	Reserved Field/Unused Field of Length 2	NUSED2
GRPVL	Grouping Value for Personnel Assignments	PCCE_GPVAL
FAMSA	Type of Family Record	SUBTY
FAVOR	First Name	PAD_VORNM
FANAM	Last Name	PAD_NACHN
FGBOT	Birthplace	PAD_ORT01
ERBNR	Reference Personnel Number for Family Member	CHAR12
FGBNA	Name at Birth	PAD_NACHN
FNAC2	Second Name	PAD_NACHN
FCNAM	Complete Name	TEXT80
FKNZN	Name Format Indicator for Employee in a List	KNZN2
FINIT	Initials	TEXT10
AHVNR	AHV Number	P02_AHVNR
ERMNR	Authority Number	CHAR8
AUSVL	1st Part of SI Number (Sequential Number)	NUM4
AUSVG	2nd Part of SI Number (Birth Date)	NUM8
FASIN	Educational Institute	TEXT20
EGAGA	Employer of Family Member	VARGA

Master Data Relations \| to Other Relations ↓	Join Conditions
Second Nationality Second Nationality Client	`PA0021.FANA2 == T005.LAND1` `PA0021.MANDT == T005.MANDT`
Third Nationality Third Nationality Client	`PA0021.FANA3 == T005.LAND1` `PA0021.MANDT == T005.MANDT`
Nationality Nationality Client	`PA0021.FANAT == T005.LAND1` `PA0021.MANDT == T005.MANDT`
T77PAD_GENDER Gender ?	`PA0021.FASEX == T77PAD_GENDER.GENDER` `PA0021.[column in domain "MOLGA"] == T77PAD_GENDER.MOLGA`
Country/Region of Birth Country/Region of Birth Client	`PA0021.FGBLD == T005.LAND1` `PA0021.MANDT == T005.MANDT`
State Country/Region of Birth State	`PA0021.MANDT == T005S.MANDT` `PA0021.FGBLD == T005S.LAND1` `PA0021.FGDEP == T005S.BLAND`
Child Type ? Child Type ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDART == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Allowance Authorization ? Allowance Authorization ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDBSL == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Child Allowance Entitlement ? Child Allowance Entitlement ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDGBR == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Relationship to Child ? Relationship to Child ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDSVH == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Address of Child ? Address of Child ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDUTB == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Sickness Certificate Authorization ? Sickness Certificate Authorization ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDVBE == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Child Bonuses ? Child Bonuses ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDZUG == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Child Allowances ? Child Allowances ?	`PA0021.MANDT == T577.MANDT` `PA0021.[column in domain "EIGSH"] == T577.EIGSH` `PA0021.KDZUL == T577.AUSPR` `PA0021.[column in domain "MOLGA"] == T577.MOLGA`
Client	`PA0021.MANDT == T000.MANDT`
Personnel Number Personnel Number Client	`PA0021.PERNR == PA0003.PERNR` `PA0021.MANDT == PA0003.MANDT`
Reason for Changing Master Data ? Reason for Changing Master Data	`PA0021.MANDT == T530E.MANDT` `PA0021.[column in domain "INFTY"] == T530E.INFTY` `PA0021.PREAS == T530E.PREAS`

Other Relations \| to Master Data Relations ↑	Join Conditions
School Type of Family Member School Type of Family Member Client ?	`PA0021.FASAR == T517T.SLART` `PA0021.MANDT == T517T.MANDT` `PA0021.[column in domain "SPRAS"] == T517T.SPRSL`
Other Title ? Client Other Title	`PA0021.[column in domain "DZSART"] == T535N.ART` `PA0021.MANDT == T535N.MANDT` `PA0021.FNMZU == T535N.TITEL`
Name Prefix ? Client Name Prefix	`PA0021.[column in domain "DZSART"] == T535N.ART` `PA0021.MANDT == T535N.MANDT` `PA0021.FVRS2 == T535N.TITEL`
Name Prefix ? Client Name Prefix	`PA0021.[column in domain "DZSART"] == T535N.ART` `PA0021.MANDT == T535N.MANDT` `PA0021.FVRSW == T535N.TITEL`
Title ? Client Title	`PA0021.[column in domain "DZSART"] == T535N.ART` `PA0021.MANDT == T535N.MANDT` `PA0021.TITEL == T535N.TITEL`