SAP ABAP Table PA0187 (Additional family data)

Hierarchy

☛ SAP_HRCTH (Software Component) Sub component SAP_HRCTH of SAP_HR
   ⤷ PA-PA-TH (Application Component) Thailand
     ⤷ PB26 (Package) HR Master Data: Thailand

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0187	Table Relationship Diagram
Short Description	Additional family data

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	Additional family Data (Thailand)
27	ANRED	☐	ANRDE	ANRDE	CHAR	1	0	Form-of-Address Key	T522G
28	STRAS	☐	PTH_STRAS	TEXT60	CHAR	60	0	Address Number, Soi Trok (TH)
29	ORT01	☐	PTH_TORT1	TEXT40	CHAR	40	0	Province
30	ORT02	☐	PTH_TORT2	TEXT40	CHAR	40	0	District (TH)
31	PSTLZ	☐	PSTLZ_HR	PSTLZ	CHAR	10	0	Postal Code
32	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
33	TELNR	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
34	LOCAT	☐	PTH_LOCAT	TEXT60	CHAR	60	0	Street/Road, Tambol
35	COM01	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
36	NUM01	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
37	COM02	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
38	NUM02	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
39	COM03	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
40	NUM03	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
41	COM04	☐	COMKY	COMKY	CHAR	4	0	Communication Type	T536B
42	NUM04	☐	COMNR	CHAR20	CHAR	20	0	Communication Number
43	ALDEC	☐	PTH_ALDEC	XFELD	CHAR	1	0	Deceased Indicator
44	JOBTL	☐	STLTX	TEXT25	CHAR	25	0	Job Title
45	EFAML	☐	PTH_EFAML	TEXT40	CHAR	40	0	Employer of Family Member (TH)
46	FTXID	☐	PTH_FTXID	CHAR13	CHAR	13	0	Identity Number for Father
47	MTXID	☐	PTH_MTXID	CHAR13	CHAR	13	0	Identity Number for Mother
48	STXID	☐	PTH_STXID	CHAR13	CHAR	13	0	Identity Number for Spouse
49	SFXID	☐	PTH_SFXID	CHAR13	CHAR	13	0	Identity Number for Spouse's Father
50	SMXID	☐	PTH_SMXID	CHAR13	CHAR	13	0	Identity Number for Spouse's Mother
51	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0187	ANRED	T522G	ANRED
2	PA0187	COM01	T536B	COMKY
3	PA0187	COM02	T536B	COMKY
4	PA0187	COM03	T536B	COMKY
5	PA0187	COM04	T536B	COMKY
6	PA0187	LAND1	T005	LAND1
7	PA0187	MANDT	T000	MANDT	KEY	1	CN
8	PA0187	PERNR	PA0003	PERNR
9	PA0187	PREAS	T530E	PREAS

History

Last changed by/on	SAP	20130529
SAP Release Created in