SAP ABAP Table PA0397 (Infotype 0021 Family)

Hierarchy

☛ SAP_HRCBR (Software Component) Sub component SAP_HRCBR of SAP_HR
   ⤷ PA-PA-BR (Application Component) Brazil
     ⤷ PB37 (Package) HR master data: Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0397	Table Relationship Diagram
Short Description	Infotype 0021 Family

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	T000
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	Infotype 0021 (Relatives/Dependents)
27	UFBOT	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
28	STINV	☐	PBR_STINV	CHAR1	CHAR	1	0	Challenged dependent indicator
29	ESCOL	☐	PBR_FASAR	PBR_FASAR	CHAR	2	0	Education level	T7BR7C
30	SALFA	☐	PBR_SALFA	CHAR1	CHAR	1	0	Eligibility indicator for child allowance
31	IRFLG	☐	PBR_IRFLG	CHAR1	CHAR	1	0	Eligibility indicator for income tax discount
32	SERIE	☐	PBR_SERIE	CHAR2	CHAR	2	0	Grade	T7BR7B
33	MODEN	☐	PBR_MODEN	PBR_MODEN	CHAR	1	0	Educational specification
34	ESCOA	☐	PBR_ESCOA	PBR_ESCOA	CHAR	4	0	School	T7BRES
35	DTCVC	☐	PBR_DTCVC	DATS	DATS	8	0	Vaccination card expiration
36	SALED	☐	PBR_SALED	CHAR1	CHAR	1	0	Eligibility indicator for education allowance
37	ESTUD	☐	PBR_STUDE	XFELD	CHAR	1	0	Dependent student indicator
38	FUMAN	☐	PBR_FUMAN	XFELD	CHAR	1	0	Smoker dependent indicator
39	CARTO	☐	PBR_CARTO	TEXT40	CHAR	40	0	Name of public notary
40	NOREG	☐	PBR_NOREG	TEXT10	CHAR	10	0	Record number
41	NOLIV	☐	PBR_NOLIV	TEXT10	CHAR	10	0	Entry ledger number
42	NOFOL	☐	PBR_NOFOL	TEXT5	CHAR	5	0	Entry sheet number
43	DTENT	☐	PBR_DTENT	DATS	DATS	8	0	Certificate date of delivery
44	DTBAI	☐	PBR_DTBAI	DATS	DATS	8	0	Sick leave date
45	ICTYP	☐	PBR_ICTYP	ICTYP	CHAR	2	0	Type of ID document	T5R05
46	ICNUM	☐	PBR_IDNUM	CHAR30	CHAR	30	0	CPF no.
47	PENSI	☐	PBR_PENSI	XFLAG	CHAR	1	0	Pensioner indicator
48	MOVOR	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
49	MONAM	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
50	MONA2	☐	PAD_NACH2	PAD_NACHN	CHAR	40	0	Second Name
51	MINIT	☐	INITS	TEXT10	CHAR	10	0	Initials
52	MOTHE	☐	PBR_MOTHE	TEXT80	CHAR	80	0	Mother full name
53	EXCEP	☐	PBR_EXCEP	XFELD	CHAR	1	0	Dependent physical challenged person
54	SBART	☐	SBART	SBART	CHAR	2	0	Type of Challenge	*
55	NOREU	☐	PBR_NOREU	PBR_NOREU	CHAR	32	0	Birth certificate register
56	LBCNR	☐	PBR_LBCNR	CHAR015	CHAR	15	0	Live Birth Certificate
57	NHCNR	☐	PBR_NHCNR	PBR_IDNR	CHAR	16	0	Health National Card
58	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0397	ESCOA	T7BRES	ESCOA	KEY	1	CN
2	PA0397	ESCOL	T7BR7C	ESCOL	KEY	1	CN
3	PA0397	ICTYP	T5R05	ICTYP	KEY	1	CN
4	PA0397	MANDT	T000	MANDT	KEY	1	CN
5	PA0397	PERNR	PA0003	PERNR
6	PA0397	PREAS	T530E	PREAS
7	PA0397	SERIE	T7BR7B	SERIE	KEY	1	CN
8	PA0397	UFBOT	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in