SAP ABAP Table BAPIP0021SG (HR Master Record: Infotype 0021 (Family/Rel.Person) SG)

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	BAPIP0021SG	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0021 (Family/Rel.Person) SG

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	Key for HR Master Data
2	EMPLOYEENO	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
3	SUBTYPE	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
4	OBJECTID	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
5	LOCKINDIC	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
6	VALIDEND	☐	ENDDA	DATUM	DATS	8	0	End Date
7	VALIDBEGIN	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	RECORDNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
9	MEMBERTYPE	☐	FAMSA	SUBTY	CHAR	4	0	Type of Family Record
10	LASTNAME	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
11	FIRSTNAME	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
12	MAIDENNAME	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
13	GENDER	☐	GESCH	GESCH	CHAR	1	0	Gender Key
14	DATEOFBIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
15	NATIONALITY	☐	NATSL	LAND1	CHAR	3	0	Nationality	*
16	NAMEOFSUBTYPE	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
17	NAMEOFGENDER	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
18	NAMEOFNATIO	☐	NATIO	TEXT15	CHAR	15	0	Nationality
19	IDNUMBER	☐	PRDNI	CHAR20	CHAR	20	0	Personnel ID Number
20	RESIDENCY_TYPE	☐	PMRES	PMRES	CHAR	2	0	Residency type	*
21	TAXID	☐	P25_TAXID	CHAR15	CHAR	15	0	Tax ID
22	ETHNIC_ORIGIN	☐	RACKY	RACKY	CHAR	2	0	Ethnic origin	*
23	EMP_STATUS	☐	SPEMS	XFELD	CHAR	1	0	Spouse employment status
24	MEM_ER_STRT	☐	STRAS	TEXT30	CHAR	30	0	House number and street
25	MEM_ER_2NDSTRT	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
26	MEM_ER_CITY	☐	ORT01	TEXT25	CHAR	25	0	City
27	MEM_ER_PSTCD	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
28	MEM_STRT	☐	STRAS	TEXT30	CHAR	30	0	House number and street
29	MEM_2NDSTRT	☐	STRAS	TEXT30	CHAR	30	0	House number and street
30	MEM_CITY	☐	ORT01	TEXT25	CHAR	25	0	City
31	MEM_PSTCD	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
32	MEM_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
33	MEM_NAMEOFCNTY	☐	LANDX	TEXT15	CHAR	15	0	Country Name
34	MEM_PHONENUM	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
35	EMPLOYERNAME	☐	P25_ERNAM	TEXT100	CHAR	100	0	Name of employer
36	DESIGNATION	☐	P25_DESGN	TEXT15	CHAR	15	0	Designation
37	SCHOOLNAME	☐	P25_SNAME	TEXT100	CHAR	100	0	Name of school
38	CONFINEMENT_NO	☐	P25M_CONFN	NUMC01	NUMC	1	0	Confinement Number
39	CERTIFICATE_NO	☐	P25M_CLCNO	CHAR15	CHAR	15	0	Child Birth Certificate Number
40	CHILD_TYPE	☐	P25M_CLDTY	AUSPR	CHAR	2	0	Child Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIP0021SG	MEM_COUNTRY	T005	LAND1

History

Last changed by/on	SAP	20130529
SAP Release Created in