SAP ABAP Table PIQOFFERTMPLOVW (Overview Structure for Business Event Templates)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	PIQOFFERTMPLOVW	Table Relationship Diagram
Short Description	Overview Structure for Business Event Templates

Delivery and Maintenance

Pool/cluster
Delivery Class
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	OFFERED	☐	PIQXFELDTMPLOFFERED	XFELD	CHAR	1	0	Template Is Offered for Business Event Offering
2	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
3	SM_OBJID	☐	PIQ_SM_OBJID	HROBJID	NUMC	8	0	Module Object ID	*
4	SM_SHORT	☐	PIQSMSHORT	TEXT12	CHAR	12	0	Module (Abbreviation)
5	SM_STEXT	☐	PIQSMSTEXT	TEXT40	CHAR	40	0	Module (Description)
6	SE_CONCATENATED	☐	PIQSECONCATENATED	CHAR100	CHAR	100	0	Event Packages
7	TEMPLID	☐	PIQTEMPLID	SYSUUID_C	CHAR	32	0	Template for Business Event Offering
8	SHORT	☐	EVSHT	TEXT12	CHAR	12	0	Business event abbreviation
9	STEXT	☐	EVSTEXT	TEXT40	CHAR	40	0	Name of the business event
10	D_OBJID	☐	ETYID	HROBJID	NUMC	8	0	Business event type: key	*
11	D_SHORT	☐	VTSHT	TEXT12	CHAR	12	0	Business event type abbreviation
12	D_STEXT	☐	VTSTX	TEXT40	CHAR	40	0	Name of business event type
13	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
14	OFFERPATTERN	☐	PIQOFFERPATTERN	PIQOFFERPATTERN	CHAR	4	0	Session Pattern	T7PIQOFFERPAT
15	LOCATION	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
16	LOCATION_SHORT	☐	LOCTX	TEXT40	CHAR	40	0	Name of the business event location
17	LOCATION_STEXT	☐	KUORT	CHAR12	CHAR	12	0	Business Event Location
18	CAPACITY_MIN	☐	KAPZ1	DEC5	DEC	5	0	Minimum capacity
19	CAPACITY_OPT	☐	KAPZ2	DEC5	DEC	5	0	Optimum capacity
20	CAPACITY_MAX	☐	KAPZ3	DEC5	DEC	5	0	Maximum capacity
21	UNITNUMBER	☐	PIQNUMB	PIQNUMB	DEC	5	2	Number
22	TEMPLUNIT	☐	PIQTEMPLUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Class Period
23	.INCLUDE	☐				0	0	Business Event Template - Resources
24	SEQNR	☐	NUM06	NUM06	NUMC	6	0	Numeric field: Length 6
25	MONDAY	☐	PIQXFELDMONDAY	CHAR1	CHAR	1	0	Monday
26	TUESDAY	☐	PIQXFELDTUESDAY	CHAR1	CHAR	1	0	Tuesday
27	WEDNESDAY	☐	PIQXFELDWEDNESDAY	CHAR1	CHAR	1	0	Wednesday
28	THURSDAY	☐	PIQXFELDTHURSDAY	CHAR1	CHAR	1	0	Thursday
29	FRIDAY	☐	PIQXFELDFRIDAY	CHAR1	CHAR	1	0	Friday
30	SATURDAY	☐	PIQXFELDSATURDAY	CHAR1	CHAR	1	0	Saturday
31	SUNDAY	☐	PIQXFELDSUNDAY	CHAR1	CHAR	1	0	Sunday
32	BEGUZ	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
33	ENDUZ	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
34	FREQUENCY	☐	PIQINTERVAL	DEC2	DEC	2	0	Recurrence Interval
35	FIRST_APPEARANCE	☐	PIQFIRSTDATEAFTER	DEC2	DEC	2	0	First Date After Start of Classes
36	LAST_APPEARANCE	☐	PIQLASTDATEAFTER	DEC2	DEC	2	0	Last Date After Start of Classes
37	NUMBER_OF_DATES	☐	PIQNUMBEROFDATES	DEC2	DEC	2	0	Number of Dates on Which Event Is Held
38	ROOM_OBJID	☐	ROMID	HROBJID	NUMC	8	0	Room	*
39	ROOM_SHORT	☐	ROSHRT	TEXT12	CHAR	12	0	Short Name of Room
40	ROOM_STEXT	☐	ROSTEX	TEXT40	CHAR	40	0	Name of Room
41	INSTR_OTYPE	☐	PIQINSTRUCTOROTYPE	OTYPE	CHAR	2	0	Instructor Object Type	*
42	INSTR_OBJID	☐	CHAR45	CHAR45	CHAR	45	0	Char45
43	INSTR_SHORT	☐	PIQINSTRUCTORSHORT	TEXT12	CHAR	12	0	Business Event Instructor (Abbreviation)
44	INSTR_STEXT	☐	PIQINSTRUCTORSTEXT	TEXT40	CHAR	40	0	Business Event Instructor (Description)
45	INSTR_PROZT	☐	PROZT	DEC3_2	DEC	5	2	Weighting Percentage
46	ROOM_RESTYP	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
47	ROOM_RESTYP_STEXT	☐	RETYT	TEXT40	CHAR	40	0	Resource type: Name
48	INSTR_RESTYP	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
49	INSTR_RESTYP_STEXT	☐	RETYT	TEXT40	CHAR	40	0	Resource type: Name
50	RECFRQ	☐	PIQFREQUENCY	DEC2	DEC	2	0	Number of Recurrences
51	X_WEEKS	☐	WOCHE	CHAR1	CHAR	1	0	Selection field for time interval unit: 'Week'
52	X_MONTHS	☐	QMONAT	CHAR1	CHAR	1	0	Selection field for time interval unit: 'Month'
53	OIMONTH	☐	PIQOIMONTH	PIQOIMONTH	NUMC	1	0	Occurrence(s) per Month
54	COLOR	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQOFFERTMPLOVW	ISTAT	T778S	ISTAT	REF	1	CN
2	PIQOFFERTMPLOVW	OFFERPATTERN	T7PIQOFFERPAT	OFFERPATTERN		1	CN
3	PIQOFFERTMPLOVW	PLVAR	T778P	PLVAR	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in	464