SAP ABAP View V_PIQSTATUSCSF4 (Database View (Status Search for Student))

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_PIQSTATUSCSF4
Short Description	Database View (Status Search for Student)
Root table	HRP1702	DB Table for Infotype 1702

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HRP1702	HRP1702
2	HRP1001
3	HRP1728
4	CMACBPST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRP1702	MANDT	JL	EQ				0	0
2	HRP1001	MANDT	JR	EQ			AND	0	0
3	HRP1702	PLVAR	JL	EQ				0	0
4	HRP1001	PLVAR	JR	EQ			AND	0	0
5	HRP1702	OTYPE	JL	EQ				0	0
6	HRP1001	OTYPE	JR	EQ			AND	0	0
7	HRP1702	OBJID	JL	EQ				0	0
8	HRP1001	OBJID	JR	EQ			AND	0	0
9	HRP1702	ISTAT	JL	EQ				0	0
10	HRP1001	ISTAT	JR	EQ			AND	0	0
11	HRP1728	MANDT	JL	EQ				0	0
12	HRP1001	MANDT	JR	EQ			AND	0	0
13	HRP1728	PLVAR	JL	EQ				0	0
14	HRP1001	PLVAR	JR	EQ			AND	0	0
15	HRP1728	OTYPE	JL	EQ				0	0
16	HRP1001	SCLAS	JR	EQ			AND	0	0
17	HRP1728	OBJID	JL	EQ				0	0
18	HRP1001	SOBID	JR	EQ			AND	0	0
19	HRP1728	ISTAT	JL	EQ				0	0
20	HRP1001	ISTAT	JR	EQ			AND	0	0
21	HRP1702	MANDT	JL	EQ				0	0
22	CMACBPST	CLIENT	JR	EQ			AND	0	0
23	HRP1702	OBJID	JL	EQ				0	0
24	CMACBPST	STOBJID	JR	EQ			AND	0	0
25	HRP1702	MANDT	JL	EQ				0	0
26	HRP1728	MANDT	JR	EQ			AND	0	0
27	HRP1001	MANDT	JL	EQ				0	0
28	CMACBPST	CLIENT	JR	EQ			AND	0	0
29	HRP1728	MANDT	JL	EQ				0	0
30	CMACBPST	CLIENT	JR	EQ			AND	0	0
31	HRP1001	RSIGN		EQ	'A'		AND	0	0
32	HRP1001	RELAT		EQ	'517'		AND	0	0
33	HRP1001	SCLAS		EQ	'CS'		AND	0	0
34	HRP1728	HS_STATE		EQ	'A'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HRP1702	MANDT		☐	MANDT	☐	Client
2	PLVAR	HRP1702	PLVAR		☐	PLVAR	☐	Plan Version
3	OTYPE	HRP1702	OTYPE		☐	OTYPE	☐	Object Type
4	OBJID	HRP1702	OBJID		☐	HROBJID	☐	Object ID
5	ISTAT	HRP1702	ISTAT		☐	ISTAT_D	☐	Planning Status
6	BEGDA	HRP1702	BEGDA		☐	BEGDATUM	☐	Start Date
7	ENDDA	HRP1702	ENDDA		☐	ENDDATUM	☐	End Date
8	NACHN	HRP1702	NACHN		☐	PAD_NACHN	☐	Last Name
9	VORNA	HRP1702	VORNA		☐	PAD_VORNA	☐	First Name
10	MIDNM	HRP1702	MIDNM		☐	PAD_MIDNM	☐	Middle Name
11	BIRTHNAME	HRP1702	BIRTHNAME		☐	PAD_NAME2	☐	Name at Birth
12	NACHN_MC	HRP1702	NACHN_MC		☐	PIQ_NACHN_MC	☐	Last Name (Field for Search Help)
13	VORNA_MC	HRP1702	VORNA_MC		☐	PIQ_VORNA_MC	☐	First Name (Search Help Field)
14	MIDNM_MC	HRP1702	MIDNM_MC		☐	PIQ_MIDNM_MC	☐	Middle Name (Field for Search Help)
15	BIRTHNAME_MC	HRP1702	BIRTHNAME_MC		☐	PIQ_BIRTHNAME_MC	☐	Name at Birth (Field for Search Help)
16	GBDAT	HRP1702	GBDAT		☐	PIQ_GBDAT	☐	Date of Birth
17	GBLND	HRP1702	GBLND		☐	GBLND	☐	Country of Birth
18	PRDNI	HRP1702	PRDNI		☐	PIQ_PRDNI	☐	Identification Number
19	GESCH	HRP1702	GESCH		☐	GESCH	☐	Gender Key
20	FAMST	HRP1702	FAMST		☐	FAMST	☐	Marital Status Key
21	STATUS	HRP1728	SUBTY		☐	SUBTYP	☐	Subtype
22	RSIGN	HRP1001	RSIGN		☐	RSIGN	☐	Relationship Specification
23	RELAT	HRP1001	RELAT		☐	RELAT	☐	Relationship Between Objects
24	SCLAS	HRP1001	SCLAS		☐	SCLAS	☐	Type of Related Object
25	P1728_BEGDA	HRP1728	BEGDA		☐	BEGDATUM	☐	Start Date
26	P1728_ENDDA	HRP1728	ENDDA		☐	ENDDATUM	☐	End Date
27	STATE	HRP1728	HS_STATE		☐	PIQHS_STATE	☐	Status Specification
28	MATNR	CMACBPST	STUDENT12		☐	PIQSTUDENT12	☐	Student Number

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