SAP ABAP Table PIQACADOFFERDETAIL_EV (Fields for Business Event)

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	PIQACADOFFERDETAIL_EV	Table Relationship Diagram
Short Description	Fields for Business Event

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	OTYPE_EV	☐	HREVTYP	OTYPE	CHAR	2	0	Object type of business event	*
2	OTEXT_EV	☐	PIQEVOTEXT	TEXT25	CHAR	25	0	Object Type Text of Business Event
3	OBJID_EV	☐	EVTID	HROBJID	NUMC	8	0	Business event	*
4	SHORT_EV	☐	EVSHT	TEXT12	CHAR	12	0	Business event abbreviation
5	STEXT_EV	☐	EVSTEXT	TEXT40	CHAR	40	0	Name of the business event
6	BEGDA_EV	☐	EBEGD	DATUM	DATS	8	0	Start date of business event
7	ENDDA_EV	☐	EENDA	DATUM	DATS	8	0	End date of business event
8	ISTAT_EV	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	*
9	ISTATTXT_EV	☐	PSTEXT	TEXT25	CHAR	25	0	Planning Status Name
10	ISTAT_FIX	☐	EVFIX	CHAR1	CHAR	1	0	Indicator: Firmly booked business event
11	ISTAT_PLAN	☐	EVPLAN	CHAR1	CHAR	1	0	Indicator: planned business event
12	KAPZ1_EV	☐	KAPZ1	DEC5	DEC	5	0	Minimum capacity
13	KAPZ2_EV	☐	KAPZ2	DEC5	DEC	5	0	Optimum capacity
14	KAPZ3_EV	☐	KAPZ3	DEC5	DEC	5	0	Maximum capacity
15	.INCLU-_EV	☐				0	0	Infotype 1026 fields
16	LANGU_EV	☐	KLANGU	SPRAS	LANG	1	0	Business event language	T002
17	LOCKM_EV	☐	LOCKM	CHAR1_X	CHAR	1	0	Lock flag
18	DELET_EV	☐	LOESCH	CHAR1_X	CHAR	1	0	Delete flag
19	EXTRN_EV	☐	EXTERN	CHAR1_X	CHAR	1	0	Display external business event
20	TEILX_EV	☐	TEILX	CHAR1_X	CHAR	1	0	Session indicator
21	CANCR_EV	☐	CANCR	CANCR	NUMC	4	0	Key: reason for cancellation of business event	T77CR
22	BCONT_EV	☐	BCONT_PE	NUMC5	NUMC	5	0	Number of Attendances Booked
23	WCONT_EV	☐	WCONT	NUMC5	NUMC	5	0	Number of waiting-list bookings
24	NCONT_EV	☐	NCONT	NUMC5	NUMC	5	0	Number of normal bookings
25	UPDAX_EV	☐	UPDAX	CHAR1_X	CHAR	1	0	Indicator: reservation values are current
26	FLUPX_EV	☐	FLUPX	CHAR1_X	CHAR	1	0	Indicator: business event follow-up processing completed
27	COND1_EV	☐	COND1	CHAR1_X	CHAR	1	0	Date contains no days off
28	COND2_EV	☐	COND2	CHAR1_X	CHAR	1	0	Start day as in schedule
29	CUBOE_EV	☐	CUBOE	CUBOE	CHAR	1	0	TEM-LSO: Flag - Can Only Be Booked As Part of Curriculum
30	TZONE_EV	☐	TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	*
31	.INCLUDE	☐				0	0
32	LANGUTXT_EV	☐	PIQEVLANGUT	TEXT16	CHAR	16	0	Business Event Language (Description)
33	AVAIL_PLACES_EV	☐	FCONT	NUMC5	NUMC	5	0	Number of places available
34	.INCLU-_EV	☐				0	0	Fields for Infotype 1716: Schedule Description
35	SCHEDCATEG_EV	☐	PIQSCHEDCATEG	PIQSCHEDCATEG	CHAR	1	0	Schedule Category of Business Event
36	PLPERLIMBEG_EV	☐	PIQPLPERLIMBEG	PIQNUMB	DEC	5	2	Relative Start of Planning Period
37	PLPERLIMBEGU_EV	☐	PIQPLPERBEGUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Relative Start of Planning Period
38	PLPERLIMEND_EV	☐	PIQPLPERLIMEND	PIQNUMB	DEC	5	2	Relative End of Planning Period
39	PLPERLIMENDU_EV	☐	PIQPLPERENDUNIT	PIQTEMPLUNIT	CHAR	2	0	Unit for Relative End of Planning Period
40	SCHEDBGDAY_EV	☐	PIQSCHEDBGDAY	DAYS17	NUMC	1	0	Start Day of Business Event Schedule
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0
43	.INCLU-_EV	☐				0	0	Text Fields for Intotype 1716
44	SCHEDCATEGTXT_EV	☐	PIQSCHEDCATEGT	DDTEXT	CHAR	60	0	Business Event Schedule Category (Description)
45	PLPERLIMBEGUTXT_EV	☐	PIQPLPERBEGUNITT	DDTEXT	CHAR	60	0	Unit for Relative Start of Planning Period (Description)
46	PLPERLIMENDUTXT_EV	☐	PIQPLPERENDUNITT	DDTEXT	CHAR	60	0	Unit for Relative End of Planning Period (Description)
47	SCHEDBGDAYTXT_EV	☐	PIQSCHEDBGDAYT	DDTEXT	CHAR	60	0	Start Day of Business Event Schedule (Description)
48	.INCLU-_EV	☐				0	0	Fields for Infotype 1722: Academic Event Info
49	.INCLUDE	☐				0	0
50	EVPROCSTAT_EV	☐	PIQEVPROCSTAT	PIQEVPROCSTAT	CHAR	3	0	Processing Status for Academic Event Planning	T7PIQEVPROCSTAT
51	.INCLUDE	☐				0	0
52	.INCLU-_EV	☐				0	0	Text Fields for Infotype 1722
53	EVPROCSTATTXT_EV	☐	PIQEVPROCSTATT	TEXT30	CHAR	30	0	Processing Status for Academic Event Planning (Description)
54	.INCLU-_EV	☐				0	0	Contact Hours
55	CHOURUNIT_EV	☐	PIQCHOURUNIT	PIQCHOURUNIT	CHAR	4	0	Unit for Teaching Effort or Contact Hours	T7PIQCHOURUNIT
56	CONTACTHOURS_EV	☐	PIQCONTACTHOURS	PIQNUMB	DEC	5	2	Contact Hours
57	ACTIVCHNGABL_EV	☐	PIQACTIVCHNGABL	FLAG	CHAR	1	0	Default Not Changeable in Academic Event
58	.INCLUDE	☐				0	0
59	.INCLUDE	☐				0	0
60	.INCLU-_EV	☐				0	0	Text Table Fields for Infotype 1753
61	CHOURUNIT_TEXT_EV	☐	PIQCHOURUNITT	TEXT40	CHAR	40	0	Unit for Teaching Effort or Contact Hours (Description)
62	OBJID_F_EV	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
63	SHORT_F_EV	☐	EVLOC	TEXT12	CHAR	12	0	Business event location name
64	STEXT_F_EV	☐	LOCTX	TEXT40	CHAR	40	0	Name of the business event location
65	KAPZ1CLC_EV	☐	PIQCAPACITY_MIN	DEC5	DEC	5	0	Calculated Minimum Capacity
66	KAPZ2CLC_EV	☐	PIQCAPACITY_OPT	DEC5	DEC	5	0	Calculated Optimum Capacity
67	KAPZ3CLC_EV	☐	PIQCAPACITY_MAX	DEC5	DEC	5	0	Calculated Maximum Capacity
68	RECDAYSFREE	☐	PIQRECDAYSFREE	XFELD	CHAR	1	0	Include Only Non-Working Days (Acc. to Factory Calendar)
69	RECDAYSOFF	☐	PIQRECDAYSOFF	XFELD	CHAR	1	0	Include Days w/o Classes
70	.INCLU-_EV	☐				0	0	Schedule Element Resources
71	ROOM_OBJID_EV	☐	ROOMID	NUM08	NUMC	8	0	Business event room: Key
72	ROOM_RETID_EV	☐	PIQROOM_RETID	HROBJID	NUMC	8	0	Identification (ID) of Room Resource Type	*
73	INSTR_OTYPE_EV	☐	PIQINSTRUCTOROTYPE	OTYPE	CHAR	2	0	Instructor Object Type	*
74	INSTR_OBJID_EV	☐	PIQINSTRUCTOROBJID	NUM08	NUMC	8	0	Instructor Identification (ID)
75	INSTR_RETID_EV	☐	PIQINSTR_RETID	HROBJID	NUMC	8	0	Instructor Resource Type Identification (ID)	*
76	INSTR_PROZT_EV	☐	PROZT	DEC3_2	DEC	5	2	Weighting Percentage
77	.INCLU-_EV	☐				0	0	Schedule Element Resources (Texts)
78	ROOM_SHORT_EV	☐	PIQROOM_SHORT	TEXT12	CHAR	12	0	Room (Abbreviation)
79	ROOM_STEXT_EV	☐	PIQROOM_STEXT	TEXT40	CHAR	40	0	Room (Description)
80	ROOM_RETSH_EV	☐	PIQROOM_RETSH	TEXT12	CHAR	12	0	Room Resource Type (Abbreviation)
81	ROOM_RETTX_EV	☐	PIQROOM_RETTX	TEXT40	CHAR	40	0	Room Resource Type (Description)
82	INSTR_OTEXT_EV	☐	PIQINSTRUCTOROTEXT	TEXT25	CHAR	25	0	Instructor Object Type (Text)
83	INSTR_SHORT_EV	☐	PIQINSTRUCTORSHORT	TEXT12	CHAR	12	0	Business Event Instructor (Abbreviation)
84	INSTR_STEXT_EV	☐	PIQINSTRUCTORSTEXT	TEXT40	CHAR	40	0	Business Event Instructor (Description)
85	INSTR_RETSH_EV	☐	PIQINSTR_RETSH	TEXT12	CHAR	12	0	Instructor Resource Type (Abbreviation)
86	INSTR_RETTX_EV	☐	PIQINSTR_RETTX	TEXT40	CHAR	40	0	Instructor Resource Type (Description)
87	MULTI_SE_ASGMT	☐	PIQSEMULTIREF	FLAG	CHAR	1	0	Multiple Assignment of Business Event to Event Packages
88	COHORTUSE_EV	☐	PIQCOHUSE	CHAR1_X	CHAR	1	0	Object Used as Context Object in Cohorts
89	DELMODEOT_EV	☐	PIQEVENTOTYPE	PIQEVENTOTYPE	CHAR	2	0	Academic Event Object Type
90	OPERA_EV	☐	PIQUPDATEFLAG	PIQUPDATEFLAG	CHAR	1	0	Update Indicator (Insert: I, Change: U, Delete: D)
91	FRAME1_EV	☐	PIQEVFRAME1	CHAR01	CHAR	1	0	Business Event Data (Frame)
92	FRAME2_EV	☐	PIQEVFRAME2	CHAR01	CHAR	1	0	Schedule Description (Frame)
93	FRAME3_EV	☐	PIQEVFRAME3	CHAR01	CHAR	1	0	Schedule and Resources (Frame)
94	FRAME4_EV	☐	PIQEVFRAME5	CHAR01	CHAR	1	0	Resources (Frame)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQACADOFFERDETAIL_EV	CANCR_EV	T77CR	CANCR		1	CN
2	PIQACADOFFERDETAIL_EV	CHOURUNIT_EV	T7PIQCHOURUNIT	CHOURUNIT
3	PIQACADOFFERDETAIL_EV	EVPROCSTAT_EV	T7PIQEVPROCSTAT	EVPROCSTAT
4	PIQACADOFFERDETAIL_EV	LANGU_EV	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in	600