SAP ABAP Table HRP1711 (DB Table for Infotype 1711)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ_E (Package) Campus Management, original language EN

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	HRP1711	Table Relationship Diagram
Short Description	DB Table for Infotype 1711

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	Extended Key Definition of PD Infotypes
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	PLVAR	☑	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
4	OTYPE	☑	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
5	OBJID	☑	HROBJID	HROBJID	NUMC	8	0	Object ID	PLOGI
6	SUBTY	☑	SUBTYP	SUBTYP	CHAR	4	0	Subtype	*
7	ISTAT	☑	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
8	BEGDA	☑	BEGDATUM	DATUM	DATS	8	0	Start Date
9	ENDDA	☑	ENDDATUM	DATUM	DATS	8	0	End Date
10	VARYF	☑	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
11	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
12	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
13	OTJID	☐	OTJID	CHAR10	CHAR	10	0	Concatenation of Object Type and Object ID
14	.INCLUDE	☐				0	0	Infotype Administration Data
15	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
16	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
17	REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
18	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
19	ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
20	.INCLUDE	☐				0	0	Residency Information
21	RESID_STATUS	☐	PIQRESIDSTATUS	RESIS	CHAR	1	0	Resident Status	T505U
22	RESID_COUNTRY	☐	PIQRESIDCOUNTRY	LAND1	CHAR	3	0	Resident Country	T005
23	RESID_REGIO	☐	PIQRESIDREGIO	REGIO	CHAR	3	0	Resident State	T005S
24	RESID_COUNC	☐	PIQRESIDCOUNC	COUNC	CHAR	3	0	Resident County	T005E
25	PASSN	☐	PIQPASSN	PIQPASSN	CHAR	20	0	Passport Number
26	ORIGIN	☐	PIQORIGIN	PIQORIGIN	CHAR	4	0	Origin	T7PIQORIGIN
27	PASS_ISSUEDATE	☐	PIQ_GB_UCAS_PASSPORTISDATE	DATS	DATS	8	0	UCAS: Passport Issue Date
28	PASS_EXPIRYDATE	☐	PIQ_GB_UCAS_PASSPORTEXDATE	DATS	DATS	8	0	UCAS: Passport Expiry Date
29	PASS_ISSUEPLACE	☐	PIQ_GB_UCAS_PASSPORTISPLACE	CHAR30	CHAR	30	0	UCAS: Passport Place of Issue
30	DATE_ENTERED_UK	☐	PIQ_GB_UCAS_DATEENTERUK	DATS	DATS	8	0	Date of Admission to United Kingdom
31	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HRP1711	INFTY	T778T	INFTY	KEY	1	CN
2	HRP1711	ISTAT	T778S	ISTAT	KEY	1	CN
3	HRP1711	MANDT	T000	MANDT	KEY	1	CN
4	HRP1711	OBJID	PLOGI	OBJID	KEY	1	CN
5	HRP1711	ORIGIN	T7PIQORIGIN	ORIGIN
6	HRP1711	OTYPE	T778O	OTYPE	KEY	1	CN
7	HRP1711	PLVAR	T778P	PLVAR	KEY	1	CN
8	HRP1711	RESID_COUNC	T005E	COUNC
9	HRP1711	RESID_COUNTRY	T005	LAND1
10	HRP1711	RESID_REGIO	T005S	BLAND
11	HRP1711	RESID_STATUS	T505U	RESIS

History

Last changed by/on	SAP	20130529
SAP Release Created in	463