SAP ABAP Table P0217 (Infotype 0217 (INSEE Code))

Hierarchy

☛ SAP_HRCFR (Software Component) Sub component SAP_HRCFR of SAP_HR
   ⤷ PA-PA-FR (Application Component) France
     ⤷ PB06 (Package) HR master data: France

Basic Data

Table Category	INTTAB	Structure
Structure	P0217	Table Relationship Diagram
Short Description	Infotype 0217 (INSEE Code)

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	Infotype 0217 (qualification & elections)
28	INSEE	☐	CINSE	CINSE	CHAR	4	0	Socio-professional category INSEE code	T5F4A
29	QUALIF	☐	P06_QUALIF	P06_QUALIF	CHAR	8	0	Qualification	T5F4C
30	COLDP	☐	P06_COLDP	P06_COLGE	CHAR	1	0	College for the PD elections	T5F4G
31	COLCE	☐	P06_COLCE	P06_COLGE	CHAR	1	0	College for the WC elections	T5F4G
32	COLPH	☐	P06_COLPH	P06_COLGE	CHAR	1	0	College for labor court elections	T5F4G
33	SECTN	☐	P06_SECTN	P06_SECTN	CHAR	1	0	Section (labor court elections)
34	ACTIV	☐	P06_SECACT	XFELD	CHAR	1	0	Section according to business area (labor court elections)
35	DOMIC	☐	P06_DOMIC	XFELD	CHAR	1	0	Voter of residential parish
36	PCS	☐	P06_PCS	P06_PCS	CHAR	4	0	Socio-professional category INSEE code	T5F4J
37	WERKS	☐	P06_PERSA	PERSA	CHAR	4	0	Personnel area	T500P
38	BTRTL	☐	P06_BTRTL	BTRTL	CHAR	4	0	Personnel subarea	T001P
39	INSEEC	☐	P06_COMKY	P06_COMKY	CHAR	5	0	Code commune INSEE	T5FPBS3B
40	REST_EE_ADDR	☐	P06_REST_EE_ADDR	XFELD	CHAR	1	0	Restaurant voucher distribution point: Employee's home
41	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0217	BTRTL	T001P	BTRTL
2	P0217	COLCE	T5F4G	COLGE	REF
3	P0217	COLDP	T5F4G	COLGE	REF
4	P0217	COLPH	T5F4G	COLGE	REF
5	P0217	INFTY	T582A	INFTY
6	P0217	INSEE	T5F4A	CINSE
7	P0217	INSEEC	T5FPBS3B	COMKY	KEY	1	CN
8	P0217	PCS	T5F4J	CINSE
9	P0217	PREAS	T530E	PREAS
10	P0217	QUALIF	T5F4C	QUALIF	KEY	1	CN
11	P0217	WERKS	T500P	PERSA

History

Last changed by/on	SAP	20110809
SAP Release Created in	470