SAP ABAP View V_PIQMODNORMAL (Number of Normal and Mandatory Bookings)

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_PIQMODNORMAL
Short Description	Number of Normal and Mandatory Bookings
Root table	HRP1001	Infotype 1001 DB Table

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRP1001	MANDT	JL	EQ				0	0
2	HRPAD506	MANDT	JR	EQ			AND	0	0
3	HRP1001	ADATANR	JL	EQ				0	0
4	HRPAD506	ADATANR	JR	EQ			AND	0	0
5	HRP1001	SUBTY		EQ	'B506'		AND	0	0
6	HRPAD506	SMSTATUS		EQ	'01'		OR	0	0
7	HRPAD506	SMSTATUS		EQ	'02'		OR	0	0
8	HRPAD506	SMSTATUS		EQ	'03'		OR	0	0
9	HRPAD506	SMSTATUS		EQ	'08'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HRP1001	MANDT		☐	MANDT	☐	Client
2	PLVAR	HRP1001	PLVAR		☐	PLVAR	☐	Plan Version
3	OTJID	HRP1001	OTJID		☐	OTJID	☐	Concatenation of Object Type and Object ID
4	BEGDA	HRP1001	BEGDA		☐	BEGDATUM	☐	Start Date
5	ENDDA	HRP1001	ENDDA		☐	ENDDATUM	☐	End Date
6	SCLAS	HRP1001	SCLAS		☐	SCLAS	☐	Type of Related Object
7	SOBID	HRP1001	SOBID		☐	SOBID	☐	ID of Related Object
8	PRIOX	HRP1001	PRIOX		☐	PRIOX	☐	Priority
9	PERID	HRPAD506	PERID		☐	PIQPERID	☐	Academic Session
10	PERYR	HRPAD506	PERYR		☐	PIQPERYR	☐	Academic Year
11	SMSTATUS	HRPAD506	SMSTATUS		☐	PIQSMSTATUS	☐	Module Booking Status
12	PACKNUMBER	HRPAD506	PACKNUMBER		☐	PIQSLNUM	☐	Event Package

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	600