SAP ABAP Table PIQMODULETAB_EXT_TEXT (Registered Modules (With Descriptions))

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	PIQMODULETAB_EXT_TEXT	Table Relationship Diagram
Short Description	Registered Modules (With Descriptions)

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	.INCLUDE	☐				0	0	Booked Modules
2	.INCLUDE	☐				0	0	Key Structure for Infotype Structures PNNNN
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
5	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
6	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
7	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T778T
8	SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype	T778U
9	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
10	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
11	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
12	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
13	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
14	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
15	.INCLUDE	☐				0	0	Additional Data for Relationship 506
16	SMSTATUS	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	T7PIQSMSTAT
17	STORREASON	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	T7PIQWITHDRAWN
18	STORDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
19	CPATTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
20	CPGAINED	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
21	CPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T006
22	NORM_VAL	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
23	BOOKDATE	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
24	BOOKTIME	☐	PIQWAITL_TIME	TIME	TIMS	6	0	Booking Time
25	SMRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
26	CHARGEFREE	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
27	TRANSFERFLAG	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
28	PACKNUMBER	☐	PIQSLNUM	HROBJID	NUMC	8	0	Event Package	*
29	VARID	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
30	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
31	PERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
32	ALT_SCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
33	ID	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
34	BOOKREASON	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	T7PIQBOOKREASON
35	ANNULMENT	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	T7PIQ_MR_ANNUL
36	LOCKFLAG	☐	PIQAWLOCKFLAG	FLAG	CHAR	1	0	Change Lock
37	COBOK	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
38	.INCLUDE	☐				0	0
39	MODULE_ID	☐	PIQSMOBJID	NUM08	NUMC	8	0	Module ID
40	.INCLUDE	☐				0	0	Descriptions for 506 Additional Data Fields
41	MODULE_SHORT	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
42	MODULE_STEXT	☐	STEXT	TEXT40	CHAR	40	0	Object Name
43	PERYT	☐	PIQPERYT	TEXT20	CHAR	20	0	Academic Year (Description)
44	PERIT	☐	PIQPERIT	TEXT20	CHAR	20	0	Academic Session (Description)
45	EVPACKAGET	☐	SHORT_D	TEXT12	CHAR	12	0	Object Abbreviation
46	SMSTATUST	☐	PIQSMSTATUST	TEXT25	CHAR	25	0	Module Booking Status (Description)
47	BOOKREASONT	☐	PIQBOOKREASONT	TEXT40	CHAR	40	0	Module Booking Reason (Description)
48	STORREASONT	☐	PIQSTORREASONT	PIQSTORREASONT	CHAR	40	0	Cancellation Reason (Description)
49	SMRATINGT	☐	PIQSMRATINGT	PIQSMRATINGT	CHAR	40	0	Alternative Assessment Method for Module (Description)
50	ANNULMENTT	☐	PIQMODREG_ANNULMENTT	TEXT40	CHAR	40	0	Exclusion Indicator for Module Bookings (Description)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQMODULETAB_EXT_TEXT	ALT_SCALEID	T7PIQSCALE	SCALEID
2	PIQMODULETAB_EXT_TEXT	ANNULMENT	T7PIQ_MR_ANNUL	ANNULMENT
3	PIQMODULETAB_EXT_TEXT	BOOKREASON	T7PIQBOOKREASON	BOOKREASON
4	PIQMODULETAB_EXT_TEXT	CPUNIT	T006	MSEHI
5	PIQMODULETAB_EXT_TEXT	INFTY	T778T	INFTY
6	PIQMODULETAB_EXT_TEXT	ISTAT	T778S	ISTAT
7	PIQMODULETAB_EXT_TEXT	MANDT	T000	MANDT
8	PIQMODULETAB_EXT_TEXT	OTYPE	T778O	OTYPE
9	PIQMODULETAB_EXT_TEXT	PERID	T7PIQPERIOD	PERID		1	CN
10	PIQMODULETAB_EXT_TEXT	PERYR	T7PIQYEAR	PERYR	KEY	1	CN
11	PIQMODULETAB_EXT_TEXT	PLVAR	T778P	PLVAR
12	PIQMODULETAB_EXT_TEXT	SMRATING	T7PIQSMRATING	SMRATING
13	PIQMODULETAB_EXT_TEXT	SMSTATUS	T7PIQSMSTAT	SMSTATUS
14	PIQMODULETAB_EXT_TEXT	STORREASON	T7PIQWITHDRAWN	STORREASON
15	PIQMODULETAB_EXT_TEXT	SUBTY	T778U	SUBTY
16	PIQMODULETAB_EXT_TEXT	VARID	T7PIQVARY	VARID	KEY	1	CN

History

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