SAP ABAP View V_HRP1771_1001 (Database View for Selection of Registrations)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

View Type	D	Database View
Database View	V_HRP1771_1001
Short Description	Database View for Selection of Registrations
Root table	HRP1771	DB Table for Infotype 1771

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HRP1771	HRP1771
2	HRP1001

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRP1771	MANDT	JL	EQ				0	0
2	HRP1001	MANDT	JR	EQ			AND	0	0
3	HRP1771	PLVAR	JL	EQ				0	0
4	HRP1001	PLVAR	JR	EQ			AND	0	0
5	HRP1771	OTYPE	JL	EQ				0	0
6	HRP1001	OTYPE	JR	EQ			AND	0	0
7	HRP1771	OBJID	JL	EQ				0	0
8	HRP1001	OBJID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	HRP1771	*		☐		☐
2	MANDT	HRP1771	MANDT		☐	MANDT	☐	Client
3	PLVAR	HRP1771	PLVAR		☐	PLVAR	☐	Plan Version
4	OTYPE	HRP1771	OTYPE		☐	OTYPE	☐	Object Type
5	OBJID	HRP1771	OBJID		☐	HROBJID	☐	Object ID
6	SUBTY	HRP1771	SUBTY		☐	SUBTYP	☐	Subtype
7	ISTAT	HRP1771	ISTAT		☐	ISTAT_D	☐	Planning Status
8	BEGDA	HRP1771	BEGDA		☐	BEGDATUM	☐	Start Date
9	ENDDA	HRP1771	ENDDA		☐	ENDDATUM	☐	End Date
10	VARYF	HRP1771	VARYF		☐	VARYF	☐	Variation Field for File PLOG
11	SEQNR	HRP1771	SEQNR		☐	SEQNR	☐	Number of Infotype Record With Same Key
12	INFTY	HRP1771	INFTY		☐	INFOTYP	☐	Infotype
13	OTJID	HRP1771	OTJID		☐	OTJID	☐	Concatenation of Object Type and Object ID
14	AEDTM	HRP1771	AEDTM		☐	AEDTM	☐	Changed on
15	UNAME	HRP1771	UNAME		☐	USRNAME	☐	User Name
16	REASN	HRP1771	REASN		☐	REASN	☐	Reason
17	HISTO	HRP1771	HISTO		☐	HISTO	☐	Historical Record Flag
18	ITXNR	HRP1771	ITXNR		☐	ITXNR	☐	Text Module for Infotype
19	AYEAR	HRP1771	AYEAR		☐	PIQPERYR	☐	Academic Year
20	PERID	HRP1771	PERID		☐	PIQPERID	☐	Academic Session
21	PR_STATUS	HRP1771	PR_STATUS		☐	PIQREG_PERIODSTATUS	☐	Sessional Registration Status
22	PRS_STATE	HRP1771	PRS_STATE		☐	PIQREG_PRS_STATE	☐	Sessional Registration Status Specification
23	APPTYPE	HRP1771	APPTYPE		☐	PIQAPPTYPE_503	☐	Activity for Sessional Registration (OBSOLETE)
24	REASON	HRP1771	REASON		☐	PIQLEAREASON	☐	Leave of Absence Reason
25	ACLEVEL	HRP1771	ACLEVEL		☐	PIQLEVEL	☐	Stage
26	REGDATE	HRP1771	REGDATE		☐	PIQREGPERDATE	☐	Activity Key Date for Sessional Registration
27	FEEFL	HRP1771	FEEFL		☐	NUSED	☐	Reserved Field/Unused Field
28	REG_CERT_DATE	HRP1771	REG_CERT_DATE		☐	PIQCERTDATE	☐	Date of Registration Certificate (Obsolete)
29	PERCT	HRP1771	PERCT		☐	PIQPERCT	☐	Completed Length of Study
30	REGCLASS	HRP1771	REGCLASS		☐	PIQREGCLASS	☐	Registration Classification
31	CANCPROCESS	HRP1771	CANCPROCESS		☐	PIQREGCANCPROCESS	☐	Cancellation Activity (For Registration)
32	CANCREASON	HRP1771	CANCREASON		☐	PIQREGCANCREASON	☐	Cancellation Reason (For Registration)
33	CANCDATE	HRP1771	CANCDATE		☐	PIQREGCANCDATE	☐	Cancellation Date (Registration)
34	P1001_RSIGN	HRP1001	RSIGN		☐	RSIGN	☐	Relationship Specification
35	P1001_RELAT	HRP1001	RELAT		☐	RELAT	☐	Relationship Between Objects
36	P1001_ISTAT	HRP1001	ISTAT		☐	ISTAT_D	☐	Planning Status
37	P1001_PRIOX	HRP1001	PRIOX		☐	PRIOX	☐	Priority
38	P1001_BEGDA	HRP1001	BEGDA		☐	BEGDATUM	☐	Start Date
39	P1001_ENDDA	HRP1001	ENDDA		☐	ENDDATUM	☐	End Date
40	P1001_SCLAS	HRP1001	SCLAS		☐	SCLAS	☐	Type of Related Object
41	P1001_SOBID	HRP1001	SOBID		☐	SOBID	☐	ID of Related Object

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	20050224
SAP Release Created in	464