SAP ABAP Table PIQACADOFFERLIST (Fields for Event Offering (ALV))

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	PIQACADOFFERLIST	Table Relationship Diagram
Short Description	Fields for Event Offering (ALV)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Event Offering
2	SM_OBJID	PIQ_SM_OBJID	HROBJID	NUMC	8	0	Module Object ID	*
3	SM_SHORT	PIQSMSHORT	TEXT12	CHAR	12	0	Module (Abbreviation)
4	SM_STEXT	PIQSMSTEXT	TEXT40	CHAR	40	0	Module (Description)
5	SE_OBJID	PIQSEOBJID	HROBJID	NUMC	8	0	Object ID of Event Package	*
6	SE_SHORT	PIQSESHORT	TEXT12	CHAR	12	0	Event Package (Abbreviation)
7	SE_STEXT	PIQSESTEXT	TEXT40	CHAR	40	0	Event Package (Description)
8	D_OBJID	VTEID	NUM08	NUMC	8	0	Business event type
9	D_SHORT	ETSHT	TEXT12	CHAR	12	0	Business event type short name
10	D_STEXT	VTSTX	TEXT40	CHAR	40	0	Name of business event type
11	E_OBJID	EVTID	HROBJID	NUMC	8	0	Business event	*
12	E_OTYPE	HREVTYP	OTYPE	CHAR	2	0	Object type of business event	*
13	E_SHORT	EVSHT	TEXT12	CHAR	12	0	Business event abbreviation
14	E_STEXT	EVSTEXT	TEXT40	CHAR	40	0	Name of the business event
15	E_OTEXT	PIQEVOTEXT	TEXT25	CHAR	25	0	Object Type Text of Business Event
16	SM_CATEGORY	PIQSMCATEGORY	PIQCATEGORY	CHAR	4	0	Module Category	T7PIQCATEGORY
17	SM_CATEGORYTXT	PIQSMCATEGORYT	TEXT40	CHAR	40	0	Module Category (Description)
18	SM_CAP_MIN	PIQSMCAPMIN	DEC5	DEC	5	0	Minimum Capacity of Module
19	SM_CAP_OPT	PIQSMCAPOPT	DEC5	DEC	5	0	Optimum Capacity of Module
20	SM_CAP_MAX	PIQSMCAPMAX	DEC5	DEC	5	0	Maximum Capacity of Module
21	SM_OFFERED	PIQSM_OFFERED	PIQMPSWITCH	CHAR	1	0	Module Is Offered
22	SM_OBJIDREF	PIQREFSM_OBJID	HROBJID	NUMC	8	0	Referenced Module Identification (ID)	*
23	SM_SHORTREF	PIQREFSM_SHORT	TEXT12	CHAR	12	0	Referenced Module (Abbreviation)
24	SM_STEXTREF	PIQREFSM_STEXT	TEXT40	CHAR	40	0	Referenced Module (Description)
25	D_CATEGORY	PIQDCATEGORY	PIQCATEGORY	CHAR	4	0	Business Event Type Category	T7PIQCATEGORY
26	D_CATEGORYTXT	PIQDCATEGORYT	TEXT40	CHAR	40	0	Business Event Type Category (Description)
27	D_TEACHMETHOD	PIQMETHOD	PIQMETHOD	CHAR	4	0	Teaching Method	*
28	D_TEACHMETHODTXT	PIQMETHODT	TEXT40	CHAR	40	0	Teaching Method (Description)
29	D_DELMODE	PIQDELMODE	PIQDELMODE	CHAR	4	0	Delivery Mode	*
30	D_DELMODETXT	PIQDELMODET	TEXT40	CHAR	40	0	Delivery Mode (Description)
31	SE_CAP_MIN	PIQSECAPMIN	DEC5	DEC	5	0	Minimum Capacity of Event Package
32	SE_CAP_OPT	PIQSECAPOPT	DEC5	DEC	5	0	Optimum Capacity of Event Package
33	SE_CAP_MAX	PIQSECAPMAX	DEC5	DEC	5	0	Maximum Capacity of Event Package
34	SE_OFFERED	PIQSE_OFFERED	PIQMPSWITCH	CHAR	1	0	Event Package Is Offered
35	SE_F_OBJID	PIQSE_F_OBJID	HROBJID	NUMC	8	0	Campus Identification (ID)	*
36	SE_F_SHORT	PIQSE_F_SHORT2	TEXT12	CHAR	12	0	Campus (Abbreviation)
37	SE_F_STEXT	PIQSE_F_STEXT	TEXT40	CHAR	40	0	Campus (Description)
38	SE_OPERA	PIQACADOFFERUPDFLG	PIQACADOFFERUPDFLG	CHAR	1	0	Change Indicator
39	BEGDA	EBEGD	DATUM	DATS	8	0	Start date of business event
40	ENDDA	EENDA	DATUM	DATS	8	0	End date of business event
41	ISTAT	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
42	ISTATTXT	PSTEXT	TEXT25	CHAR	25	0	Planning Status Name
43	LANGU	KLANGU	SPRAS	LANG	1	0	Business event language	*
44	LANGUTXT	PIQEVLANGUT	TEXT16	CHAR	16	0	Business Event Language (Description)
45	E_CAP_MIN	PIQEVCAPMIN	DEC5	DEC	5	0	Minimum Capacity of Business Event
46	E_CAP_OPT	PIQEVCAPOPT	DEC5	DEC	5	0	Optimum Capacity of Business Event
47	E_CAP_MAX	PIQEVCAPMAX	DEC5	DEC	5	0	Maximum Capacity of Business Event
48	EVPROCSTAT	PIQEVPROCSTAT	PIQEVPROCSTAT	CHAR	3	0	Processing Status for Academic Event Planning	T7PIQEVPROCSTAT
49	EVPROCSTATTXT	PIQEVPROCSTATT	TEXT30	CHAR	30	0	Processing Status for Academic Event Planning (Description)
50	SCHEDCATEG	PIQSCHEDCATEG	PIQSCHEDCATEG	CHAR	1	0	Schedule Category of Business Event
51	SCHEDCATEGTXT	PIQSCHEDCATEGT	DDTEXT	CHAR	60	0	Business Event Schedule Category (Description)
52	PLPERLIMBEG	PIQPLPERLIMBEG	PIQNUMB	DEC	5	2	Relative Start of Planning Period
53	PLPERLIMBEGU	PIQPLPERBEGUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Relative Start of Planning Period
54	PLPERLIMBEGUTXT	PIQPLPERBEGUNITT	DDTEXT	CHAR	60	0	Unit for Relative Start of Planning Period (Description)
55	PLPERLIMEND	PIQPLPERLIMEND	PIQNUMB	DEC	5	2	Relative End of Planning Period
56	PLPERLIMENDU	PIQPLPERENDUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Relative End of Planning Period
57	PLPERLIMENDUTXT	PIQPLPERENDUNITT	DDTEXT	CHAR	60	0	Unit for Relative End of Planning Period (Description)
58	SCHEDBGDAY	PIQSCHEDBGDAY	DAYS17	NUMC	1	0	Start Day of Business Event Schedule
59	SCHEDBGDAYTXT	PIQSCHEDBGDAYT	DDTEXT	CHAR	60	0	Start Day of Business Event Schedule (Description)
60	.INCLUDE				0	0	Time and Dates of Business Event
61	BEGUZ	BEGUZ	UZEIT	TIMS	6	0	Start Time
62	ENDUZ	ENDUZ	UZEIT	TIMS	6	0	End Time
63	MONDAY	PIQXFELDMONDAY	CHAR1	CHAR	1	0	Monday
64	TUESDAY	PIQXFELDTUESDAY	CHAR1	CHAR	1	0	Tuesday
65	WEDNESDAY	PIQXFELDWEDNESDAY	CHAR1	CHAR	1	0	Wednesday
66	THURSDAY	PIQXFELDTHURSDAY	CHAR1	CHAR	1	0	Thursday
67	FRIDAY	PIQXFELDFRIDAY	CHAR1	CHAR	1	0	Friday
68	SATURDAY	PIQXFELDSATURDAY	CHAR1	CHAR	1	0	Saturday
69	SUNDAY	PIQXFELDSUNDAY	CHAR1	CHAR	1	0	Sunday
70	SCHEDELE_SAWEEKS	PIQFIRSTDATEAFTER	DEC2	DEC	2	0	First Date After Start of Classes
71	SCHEDELE_EAWEEKS	PIQLASTDATEAFTER	DEC2	DEC	2	0	Last Date After Start of Classes
72	SCHEDELE_BEGDA	PIQSCHEDELE_BEGDA	DATUM	DATS	8	0	Start Date of Planning Period for Schedule Element
73	SCHEDELE_ENDDA	PIQSCHEDELE_ENDDA	DATUM	DATS	8	0	End Date of Planning Period for Schedule Element
74	SCHEDELE_XDATES	PIQNUMBEROFDATES	DEC2	DEC	2	0	Number of Dates on Which Event Is Held
75	SCHEDELE_RECFRQ	PIQFREQUENCY	DEC2	DEC	2	0	Number of Recurrences
76	SCHEDELE_RECINT	PIQINTERVAL	DEC2	DEC	2	0	Recurrence Interval
77	SCHEDELE_WEEKS	WOCHE	CHAR1	CHAR	1	0	Selection field for time interval unit: 'Week'
78	SCHEDELE_MONTHS	QMONAT	CHAR1	CHAR	1	0	Selection field for time interval unit: 'Month'
79	SCHEDELE_OIMONTH	PIQOIMONTH	PIQOIMONTH	NUMC	1	0	Occurrence(s) per Month
80	E_F_OBJID	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
81	E_F_SHORT	EVLOC	TEXT12	CHAR	12	0	Business event location name
82	E_F_STEXT	LOCTX	TEXT40	CHAR	40	0	Name of the business event location
83	ROOM_OBJID	ROOMID	NUM08	NUMC	8	0	Business event room: Key
84	ROOM_SHORT	PIQROOM_SHORT	TEXT12	CHAR	12	0	Room (Abbreviation)
85	ROOM_STEXT	PIQROOM_STEXT	TEXT40	CHAR	40	0	Room (Description)
86	ROOM_CAP_MIN	PIQROOMCAPMIN	DEC5	DEC	5	0	Minimum Capacity of Room for Business Event
87	ROOM_CAP_OPT	PIQROOMCAPOPT	DEC5	DEC	5	0	Optimum Capacity of Room for Business Event
88	ROOM_CAP_MAX	PIQROOMCAPMAX	DEC5	DEC	5	0	Maximum Capacity of Room for Business Event
89	ROOM_BUILD	BUILD	BUILD	CHAR	8	0	Building	*
90	ROOM_BUILD_TXT	PIQBUILD_STEXT	TEXT40	CHAR	40	0	Building (Description)
91	ROOM_RETID	PIQROOM_RETID	HROBJID	NUMC	8	0	Identification (ID) of Room Resource Type	*
92	ROOM_RETSH	PIQROOM_RETSH	TEXT12	CHAR	12	0	Room Resource Type (Abbreviation)
93	ROOM_RETYT	PIQROOM_RETTX	TEXT40	CHAR	40	0	Room Resource Type (Description)
94	INSTR_OTYPE	PIQINSTRUCTOROTYPE	OTYPE	CHAR	2	0	Instructor Object Type	*
95	INSTR_OTEXT	PIQINSTRUCTOROTEXT	TEXT25	CHAR	25	0	Instructor Object Type (Text)
96	INSTR_OBJID	PIQINSTRUCTOROBJID	NUM08	NUMC	8	0	Instructor Identification (ID)
97	INSTR_SHORT	PIQINSTRUCTORSHORT	TEXT12	CHAR	12	0	Business Event Instructor (Abbreviation)
98	INSTR_STEXT	PIQINSTRUCTORSTEXT	TEXT40	CHAR	40	0	Business Event Instructor (Description)
99	INSTR_RETID	PIQINSTR_RETID	HROBJID	NUMC	8	0	Instructor Resource Type Identification (ID)	*
100	INSTR_RETSH	PIQINSTR_RETSH	TEXT12	CHAR	12	0	Instructor Resource Type (Abbreviation)
101	INSTR_RETYT	PIQINSTR_RETTX	TEXT40	CHAR	40	0	Instructor Resource Type (Description)
102	INSTR_MULTI	PIQINSTRMULTIASGMT	CHAR01	CHAR	1	0	Multiple Assignment of Instructors to a Schedule Element
103	EV_OPERA	PIQACADOFFERUPDFLG	PIQACADOFFERUPDFLG	CHAR	1	0	Change Indicator
104	CAPACITY_MIN	PIQCAPACITY_MIN	DEC5	DEC	5	0	Calculated Minimum Capacity
105	CAPACITY_OPT	PIQCAPACITY_OPT	DEC5	DEC	5	0	Calculated Optimum Capacity
106	CAPACITY_MAX	PIQCAPACITY_MAX	DEC5	DEC	5	0	Calculated Maximum Capacity
107	AVAIL_PLACES	FCONT	NUMC5	NUMC	5	0	Number of places available
108	TOTAL_BOOKINGS	BCONT_PE	NUMC5	NUMC	5	0	Number of Attendances Booked
109	NORMAL_BOOKINGS	NCONT	NUMC5	NUMC	5	0	Number of normal bookings
110	WAITLIST	WCONT	NUMC5	NUMC	5	0	Number of waiting-list bookings