SAP ABAP Table P0001_AF (Additional Query Fields)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PA-PA (Application Component) Personnel Administration
     ⤷ PBAS (Package) SAP HR Master Data Application Development

Basic Data

Table Category	INTTAB	Structure
Structure	P0001_AF	Table Relationship Diagram
Short Description	Additional Query Fields

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	MANAGERN	☐	MANAGER	TEXT40	CHAR	40	0	Name of Supervisor (Organizational Assignment)
2	OMNGR_NR	☐	PERNR_SUPERVISOR_OM	PERNR	NUMC	8	0	Personnel number of superior (Org. Management)
3	OMNGR_NA	☐	ORGMANAGER	TEXT40	CHAR	40	0	Name of Manager (Using Org. Structure)
4	CC_RESPN	☐	VERAK	VERAK	CHAR	20	0	Person Responsible
5	SVSUB	☐	P_SCODE	SUBTYP	CHAR	4	0	Salary Survey	T778U
6	JCODE	☐	P_JCODE	CHAR8	CHAR	8	0	Job from survey	T710S
7	MABAS	☐	P_MABAS	P_AMT07V	CURR	13	2	Average Survey Salary
8	MAB_WS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
9	MAB_FR	☐	CMP_FREQU	CMP_FREQU	CHAR	1	0	Unit of Time for Compensation	T710F
10	OCCTM	☐	SJOBYEARS		NUMC	3	0	Staffing duration for current position (years)
11	OCCTM_YM	☐	SJOBTIME		CHAR	6	0	Staffing duration for current position (years/months)
12	EVSUB	☐	CMP_EVTYP	SUBTYP	CHAR	4	0	Evaluation method	T778U
13	EVPTS	☐	P_EVPTS	P_EVPTS	NUMC	5	0	Evaluation points
14	EVGRD	☐	P_EVGRD	CMP_EVGROUP	CHAR	8	0	Evaluation Group	T710G
15	BMARK	☐	P_BMARK	XFELD	CHAR	1	0	Benchmark job
16	PL_BUILD	☐	BUILD	BUILD	CHAR	8	0	Building	*
17	PL_PSTLZ	☐	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
18	PL_CITY	☐	KORT	TEXT40	CHAR	40	0	City
19	PL_CTRY	☐	KLAND	LAND1	CHAR	3	0	Country	*
20	OCCAT	☐	P16_OCCAT	P16_OCCAT	CHAR	4	0	Occupational Category Employment Equity
21	DTYSN	☐	P10_DTYSN	P10_DTYSN	CHAR	9	0	Duty Station
22	SOCCD	☐	NUSED4	CHAR4	CHAR	4	0	Reserved field/unused field of length 4
23	SOCCL	☐	P16_SOC7	P16_SOC7	CHAR	7	0	Standard Occupational Category Code (South Africa)	*
24	OPERNR	☐	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
25	PL_STRAS	☐	PD_STRAS	TEXT30	CHAR	30	0	House Number and Street
26	PL_ROOM1	☐	ROOM1	CHAR8	CHAR	8	0	Physical Room Number
27	OFOCD	☐	NUM6	NUM06	NUMC	6	0	Numerical Character Field of Length 6
28	SLEVEL	☐	NUM2	NUM2	NUMC	2	0	Numeric, 2-digit value
29	OCIDX	☐	NUM10	NUM10	NUMC	10	0	10 digit number
30	P_IS_MGR	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
31	HAUSN	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
32	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0001_AF	EVGRD	T710G	EVGRD
2	P0001_AF	EVSUB	T778U	SUBTY
3	P0001_AF	JCODE	T710S	JCODE
4	P0001_AF	MAB_FR	T710F	FREQU		1	CN
5	P0001_AF	MAB_WS	TCURC	WAERS		1	CN
6	P0001_AF	SVSUB	T778U	SUBTY

History

Last changed by/on	SAP	20130529
SAP Release Created in