PA0043

HR Master Record: Infotype 0043 (Family Allowance - A) | #masterdata | Component: Public Sector

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (4)
☰ Categorical (4)
Other (33)
🔗 Relations (44)

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

Column Name	Description

Column Name	Description
ENDDA	End Date
BEGDA	Start Date
AEDTM	Last Changed On
STAAG	Family Allowance Card Issued on

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
FBBEE	Child Type for Orphans	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
STAKN	FA Card Number	CHAR15
STANR	Tax number at tax office	CHAR15
AUSAN	Family Allowance Card Issued To	CHAR1
FNR01	Number of Children on Family Allowance Card	CHAR2
FNR02	Number of Children on Family Allowance Card	CHAR2
FNR03	Number of Children on Family Allowance Card	CHAR2
FNR04	Number of Children on Family Allowance Card	CHAR2
FNR05	Number of Children on Family Allowance Card	CHAR2
FNR06	Number of Children on Family Allowance Card	CHAR2
FNR07	Number of Children on Family Allowance Card	CHAR2
FNR08	Number of Children on Family Allowance Card	CHAR2
FNR09	Number of Children on Family Allowance Card	CHAR2
FNR10	Number of Children on Family Allowance Card	CHAR2
FNR11	Number of Children on Family Allowance Card	CHAR2
FNR12	Number of Children on Family Allowance Card	CHAR2
FNR13	Number of Children on Family Allowance Card	CHAR2
FNR14	Number of Children on Family Allowance Card	CHAR2
FNR15	Number of Children on Family Allowance Card	CHAR2
FNR16	Number of Children on Family Allowance Card	CHAR2
FNR17	Number of Children on Family Allowance Card	CHAR2
FNR18	Number of Children on Family Allowance Card	CHAR2
FNR19	Number of Children on Family Allowance Card	CHAR2
FNR20	Number of Children on Family Allowance Card	CHAR2

Master Data Relations \| to Other Relations ↓	Join Conditions
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR01 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR02 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR03 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR04 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR05 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR06 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR07 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR08 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR09 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR10 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR11 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR12 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR13 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR14 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR15 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR16 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR17 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR18 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR19 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Child number ? ? ? ? Child number ?	`PA0043.MANDT == PA0021.MANDT` `PA0043.[column in domain "OBJPS"] == PA0021.OBJPS` `PA0043.[column in domain "PERSNO"] == PA0021.PERNR` `PA0043.[column in domain "SPRPS"] == PA0021.SPRPS` `PA0043.[column in domain "BEGDA"] == PA0021.BEGDA` `PA0043.KNR20 == PA0021.SUBTY` `PA0043.[column in domain "ENDDA"] == PA0021.ENDDA`
Client	`PA0043.MANDT == T000.MANDT`
Personnel Number Personnel Number Client	`PA0043.PERNR == PA0003.PERNR` `PA0043.MANDT == PA0003.MANDT`
Reason for Changing Master Data ? Reason for Changing Master Data	`PA0043.MANDT == T530E.MANDT` `PA0043.[column in domain "INFTY"] == T530E.INFTY` `PA0043.PREAS == T530E.PREAS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB01 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB02 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB03 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB04 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB05 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB06 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB07 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB08 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB09 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB10 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB11 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB12 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB13 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB14 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB15 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB16 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB17 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB18 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB19 == T5A3T.FBKDA`
Family Allowance Child Type ? Family Allowance Child Type	`PA0043.MANDT == T5A3T.MANDT` `PA0043.[column in domain "SPRAS"] == T5A3T.SPRSL` `PA0043.FBB20 == T5A3T.FBKDA`
Tax Office Number	`PA0043.MANDT == T5A2F.MANDT` `PA0043.STAFZ == T5A2F.FZAMT`