SAP ABAP Table P0412 (HR Master Record : Additional family related information)

Hierarchy

☛ SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   ⤷ PA-PA-SG (Application Component) Singapore
     ⤷ PB25 (Package) HR Singapore: Master data

Basic Data

Table Category	INTTAB	Structure
Structure	P0412	Table Relationship Diagram
Short Description	HR Master Record : Additional family related information

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	Additional family data
28	ENAME	☐	P25_ERNAM	TEXT100	CHAR	100	0	Name of employer
29	DESGN	☐	P25_DESGN	TEXT15	CHAR	15	0	Designation
30	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
31	LOCAT	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
32	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
33	STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
34	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
35	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
36	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
37	SNAME	☐	P25_SNAME	TEXT100	CHAR	100	0	Name of school
38	STRT	☐	STRAS	TEXT30	CHAR	30	0	House number and street
39	LOCT	☐	STRAS	TEXT30	CHAR	30	0	House number and street
40	TELPH	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
41	CITY	☐	ORT01	TEXT25	CHAR	25	0	City
42	PSTCD	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
43	LAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
44	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
45	STAT1	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
46	PERID	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
47	TAXNB	☐	P25_TAXID	CHAR15	CHAR	15	0	Tax ID
48	PMRES	☐	PMRES	PMRES	CHAR	2	0	Residency type	T5R03
49	RACKY	☐	RACKY	RACKY	CHAR	2	0	Ethnic origin	T505R
50	SPEMS	☐	SPEMS	XFELD	CHAR	1	0	Spouse employment status
51	PERMO	☐	PIDMO	CHAR2	CHAR	2	0	Modifier for Personnel Identifier
52	SPUEM	☐	SPEMS	XFELD	CHAR	1	0	Spouse employment status
53	CONFN	☐	P25M_CONFN	NUMC01	NUMC	1	0	Confinement Number
54	CLCNO	☐	P25M_CLCNO	CHAR15	CHAR	15	0	Child Birth Certificate Number
55	CLDTY	☐	P25M_CLDTY	AUSPR	CHAR	2	0	Child Type	T577
56	FCCSL	☐	P25_FCCSL	XFELD	CHAR	1	0	CCSL validity for last valid year
57	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0412	CLDTY	T577	AUSPR
2	P0412	INFTY	T582A	INFTY
3	P0412	LAND	T005	LAND1
4	P0412	PMRES	T5R03	PMRES	KEY
5	P0412	PREAS	T530E	PREAS
6	P0412	RACKY	T505R	RACKY
7	P0412	STAT1	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in