SAP ABAP Table PA0707 (HR Master Record: Infotype 0707)

Hierarchy

☛ EA-HRRXX (Software Component) Sub component EA-HRRXX of EA-HR
   ⤷ PA-GE (Application Component) Management of Global Employees
     ⤷ PAOC_PAD_MGE (Package) Management Of Global Employees

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0707	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0707

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	HR Master Record: Infotype 0707 (Activation Details)
27	CURR_FLUC	☐	PMGE_CURFL	PMGE_CURFL	CHAR	1	0	Currency Fluctuation Protection
28	CURR_PRCNT	☐	PMGE_SCPERC	PMGE_PRCNT	DEC	6	3	Percentage in Stable Currency
29	STABLE_CUR	☐	PMGE_STCUR	WAERS	CUKY	5	0	Stable Currency	TCURC
30	ACTIVATION_DATE	☐	PMGE_ACTDT	DATUM	DATS	8	0	Date of Assignment Activation
31	CATTYP01	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
32	DD_HOM01	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
33	DD_HOT01	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
34	CATTYP02	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
35	DD_HOM02	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
36	DD_HOT02	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
37	CATTYP03	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
38	DD_HOM03	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
39	DD_HOT03	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
40	CATTYP04	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
41	DD_HOM04	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
42	DD_HOT04	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
43	CATTYP05	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
44	DD_HOM05	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
45	DD_HOT05	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
46	CATTYP06	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
47	DD_HOM06	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
48	DD_HOT06	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
49	CATTYP07	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
50	DD_HOM07	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
51	DD_HOT07	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
52	CATTYP08	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
53	DD_HOM08	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
54	DD_HOT08	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
55	CATTYP09	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
56	DD_HOM09	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
57	DD_HOT09	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
58	CATTYP10	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
59	DD_HOM10	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
60	DD_HOT10	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
61	CATTYP11	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
62	DD_HOM11	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
63	DD_HOT11	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
64	CATTYP12	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
65	DD_HOM12	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
66	DD_HOT12	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
67	CATTYP13	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
68	DD_HOM13	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
69	DD_HOT13	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
70	CATTYP14	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
71	DD_HOM14	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
72	DD_HOT14	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
73	CATTYP15	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
74	DD_HOM15	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
75	DD_HOT15	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
76	CATTYP16	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
77	DD_HOM16	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
78	DD_HOT16	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
79	CATTYP17	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
80	DD_HOM17	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
81	DD_HOT17	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
82	CATTYP18	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
83	DD_HOM18	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
84	DD_HOT18	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
85	CATTYP19	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
86	DD_HOM19	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
87	DD_HOT19	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
88	CATTYP20	☐	PMGE_CTTYP	PMGE_CTTYP	CHAR	2	0	Category Types for Activation	T76MGE_CAG
89	DD_HOM20	☐	PMGE_HOMEX	CHAR1_X	CHAR	1	0	Indicator for Home Country
90	DD_HOT20	☐	PMGE_HOSTX	CHAR1_X	CHAR	1	0	Indicator for Host country
91	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0707	CATTYP01	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
2	PA0707	CATTYP02	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
3	PA0707	CATTYP03	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
4	PA0707	CATTYP04	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
5	PA0707	CATTYP05	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
6	PA0707	CATTYP06	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
7	PA0707	CATTYP07	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
8	PA0707	CATTYP08	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
9	PA0707	CATTYP09	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
10	PA0707	CATTYP10	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
11	PA0707	CATTYP11	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
12	PA0707	CATTYP12	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
13	PA0707	CATTYP13	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
14	PA0707	CATTYP14	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
15	PA0707	CATTYP15	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
16	PA0707	CATTYP16	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
17	PA0707	CATTYP17	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
18	PA0707	CATTYP18	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
19	PA0707	CATTYP19	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
20	PA0707	CATTYP20	T76MGE_CAG	CATEGORY_TYPE	KEY	1	CN
21	PA0707	MANDT	T000	MANDT	KEY	1	CN
22	PA0707	PERNR	PA0003	PERNR
23	PA0707	PREAS	T530E	PREAS
24	PA0707	STABLE_CUR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20041209
SAP Release Created in	110