SAP ABAP View M_PREMP (View for Matchcode for Ext. Person ID)

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

View Type	D	Database View
Database View	M_PREMP
Short Description	View for Matchcode for Ext. Person ID
Root table	PA0709	HR Master Record: Infotype 0709 (Person ID)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	PA0709	PA0709
2	PA0002
3	PA0001
4	PA0003	PA0003

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	PA0003	MANDT	JL	EQ				0	8	ENDDA_0002
2	PA0001	MANDT	JR	EQ			AND	0	8	ENDDA_0002
3	PA0003	PERNR	JL	EQ				0	8	ENDDA_0002
4	PA0001	PERNR	JR	EQ			AND	0	8	ENDDA_0002
5	PA0003	MANDT	JL	EQ				0	8	ENDDA_0002
6	PA0002	MANDT	JR	EQ			AND	0	8	ENDDA_0002
7	PA0003	PERNR	JL	EQ				0	8	ENDDA_0002
8	PA0002	PERNR	JR	EQ			AND	0	8	ENDDA_0002
9	PA0003	MANDT	JL	EQ				0	8	ENDDA_0002
10	PA0709	MANDT	JR	EQ			AND	0	8	ENDDA_0002
11	PA0003	PERNR	JL	EQ				0	8	ENDDA_0002
12	PA0709	PERNR	JR	EQ			AND	0	8	ENDDA_0002
13	PA0001	ENDDA		EQ	'99991231'		AND	0	8	ENDDA_0002
14	PA0002	ENDDA		EQ	'99991231'		AND	0	8	ENDDA_0002
15	PA0709	PERSONID_EXT		NE	' '			0	8	ENDDA_0002

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	PA0709	MANDT		☐	MANDT	☐	Client
2	PERSONID_EXT	PA0709	PERSONID_EXT		☐	PERSONID_EXT	☐	External Person ID
3	NCHMC	PA0002	NCHMC		☐	NACHNMC	☐	Last Name (Field for Search Help)
4	VNAMC	PA0002	VNAMC		☐	VORNAMC	☐	First Name (Field for Search Help)
5	ENAME	PA0001	ENAME		☐	EMNAM	☐	Formatted Name of Employee or Applicant
6	WERKS	PA0001	WERKS		☐	PERSA	☐	Personnel Area
7	BTRTL	PA0001	BTRTL		☐	BTRTL	☐	Personnel Subarea
8	PERSG	PA0001	PERSG		☐	PERSG	☐	Employee Group
9	PERSK	PA0001	PERSK		☐	PERSK	☐	Employee Subgroup
10	ABKRS	PA0001	ABKRS		☐	ABKRS	☐	Payroll Area
11	BUKRS	PA0001	BUKRS		☐	BUKRS	☐	Company Code
12	KOSTL	PA0001	KOSTL		☐	KOSTL	☐	Cost Center
13	ORGEH	PA0001	ORGEH		☐	ORGEH	☐	Organizational Unit
14	VDSK1	PA0001	VDSK1		☐	VDSK1	☐	Organizational Key
15	PERNR	PA0003	PERNR		☐	PERSNO	☐	Personnel number
16	BEGDA_0001	PA0001	BEGDA		☐	BEGDA	☐	Start Date
17	ENDDA_0001	PA0001	ENDDA		☐	ENDDA	☐	End Date

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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