SAP ABAP Table P0799 (AFI message data)

Hierarchy

☛ SAP_HRCES (Software Component) Sub component SAP_HRCES of SAP_HR
   ⤷ PA-PA-ES (Application Component) Spain
     ⤷ PB04 (Package) HR Master Data: Spain

Basic Data

Table Category	INTTAB	Structure
Structure	P0799	Table Relationship Diagram
Short Description	AFI message data

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	AFI message data
28	ACCAF	☐	PES_ACCAFI	PES_ACCAFI	CHAR	3	0	Action at employee level
29	MOTAF	☐	PES_MOTAFI	PES_MOTAFI	NUMC	2	0	Employee status	*
30	STAFI	☐	PES_STAFI	PES_STAFI	NUMC	1	0	.AFI message status
31	FPAFI	☐	PES_FPAFI	DATS	DATS	8	0	.AFI message processing date
32	FEINI	☐	PES_FECH_I	DATUM	DATS	8	0	Contracts start date
33	INDSU	☐	PES_INDSUB	CHAR1	CHAR	1	0	Partial subrogation indicator
34	RELAB	☐	PES_RELLAB	PES_RELLAB	CHAR	4	0	Special work relationship
35	NUSST	☐	PES_NUSS	NUM12	NUMC	12	0	Replaced employee Social Insurance number
36	CAUSU	☐	PES_CAUSAS	PES_CAUSAS	CHAR	2	0	Reason for substitution
37	RELEV	☐	PES_RELEV	CAT_FLAG	CHAR	1	0	Relief contract
38	CODES	☐	PES_CODES	PES_CODES	CHAR	1	0	Unemployed
39	MUJSR	☐	PES_MUJSR	XFELD	CHAR	1	0	Under-represented woman
40	COLTR	☐	PES_COLTR	PES_COLTR	NUMC	3	0	Worker group
41	INACT	☐	PES_INACTI	PES_INACT	CHAR	1	0	Inactivity type
42	COEF_HUEL	☐	PES_HUEL	NUM3	NUMC	3	0	Activity percentage in the event of a partial strike
43	MREIN	☐	PES_MREIN	PES_MREIN	CHAR	1	0	Rehired female employee
44	INCRE	☐	PES_INCRE	XFELD	CHAR	1	0	Readmitted person with occupational disability
45	PTRAU	☐	PES_PTRAU	XFELD	CHAR	1	0	Self-employed worker
46	EXCVD	☐	PES_EXCVD	PES_EXCVD	NUMC	1	0	Social disadvantage / domestic violance
47	RACIN	☐	PES_RACIN	XFELD	CHAR	1	0	Active Insertion Income
48	ALUMB	☐	PES_ALUMB	XFELD	CHAR	1	0	Contract after giving birth
49	REDJB	☐	PES_REDJB	NUMC2	NUMC	2	0	Retirement age reduction coefficient
50	AUTTR	☐	PES_AUTTR1	CHAR3	CHAR	3	0	Authorization to work (foreigners)
51	AUTVI	☐	PES_AUTVI	DATS	DATS	8	0	Validity of authorization to work (foreigners)
52	HPAFI	☐	PES_HPAFI		TIMS	6	0	.AFI message processing time
53	CODER	☐	PES_CODER	CHAR4	CHAR	4	0	Error code
54	TXTAD	☐	PES_TXTAD	CHAR1	CHAR	1	0	Additional text indicator
55	TXTOT	☐	PES_TXTOT	CHAR1	CHAR	1	0	Other text indicator
56	GLBID	☐	PC_B2A_GLBID	CHAR32	CHAR	32	0	HR B2A: Global Object ID
57	DTRTP	☐	PES_DTRTP	NUMC2	NUMC	2	0	Days worked part-time
58	CPTRA	☐	PES_CPTRA	PES_CPTRA	NUMC	2	0	Change of work center
59	PERDB	☐	PES_PERDB	PES_PERDB	NUMC	2	0	Lost of profits indicator
60	INDAU	☐	PES_INDAU	XFELD	CHAR	1	0	Automatism indicator
61	INDPB	☐	PES_INDPB	PES_INDPB	CHAR	2	0	Lost of profits indicator
62	SAAFI	☐	PES_SAAFI	PES_SAAFI	CHAR	3	0	Type of additional situation
63	NEWBE	☐	PES_NEWBE	DATUM	DATS	8	0	New start date
64	NEWEN	☐	PES_NEWEN	DATUM	DATS	8	0	New end date
65	VIFAM	☐	PES_VIFAM	PES_VIFAM	CHAR	1	0	Family tie indicator
66	INDIMP	☐	PES_INDIMP	PES_INDIMP	CHAR	1	0	RED system: printout indicator
67	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0799	INFTY	T582A	INFTY
2	P0799	PREAS	T530E	PREAS

History

Last changed by/on	SAP	20130529
SAP Release Created in