SAP ABAP Table PIQBW_MBK (BW Extraction Structure: Module Booking)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM (Application Component) Campus Management
     ⤷ PMIQBW_E (Package) Campus Management BW Extraction

Basic Data

Table Category	INTTAB	Structure
Structure	PIQBW_MBK	Table Relationship Diagram
Short Description	BW Extraction Structure: Module Booking

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	BPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	STUDNR	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
3	MODULE_OBJECTID	☐	PIQSMOBJID	NUM08	NUMC	8	0	Module ID
4	SMSTATUS	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	*
5	EVPACK_OBJECTID	☐	PIQSEOBJID	HROBJID	NUMC	8	0	Object ID of Event Package	*
6	ACAD_YEARPERID	☐	PIQBW_YRSES	PIQBW_YRSES	NUMC	7	0	Academic Period (Year and Session)
7	EVENT_OBJECTID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
8	EVENT_OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
9	BOOKDATE	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
10	BOOKREASON	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	*
11	CANCELDATE	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
12	CANCELREASON	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	*
13	CPATTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
14	CPEARNED	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
15	CPGRADED	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
16	CPUNIT	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
17	GRADESYMBOL	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
18	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
19	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
20	AWRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	*
21	CHARGEFREE	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
22	TRANSFERFLAG	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
23	ANNULMENT	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	*
24	COBOK	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
25	AGRTYPE	☐	PIQAGRTYPE	PIQAGRTYPE	NUMC	4	0	Appraisal Type	*
26	AGRSTAT	☐	PIQAGRSTAT	PIQAGRSTAT	CHAR	5	0	Appraisal Status	*
27	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
28	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
29	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
30	AGRREMARK	☐	PIQAGRREMARK	PIQAGRREMARK	CHAR	2	0	Appraisal Remark	*
31	AGRBEGDA	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
32	AGRENDDA	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
33	WAITL_BOOKING	☐	PIQFLAG	FLAG	CHAR	1	0	General Indicator
34	PROGRAM_OBJECTID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
35	PROGRAM_TYPE	☐	PIQPROGC_VAR	PIQPROGC_VAR	CHAR	4	0	Program Type	*
36	RECORDMODE	☐	PIQBW_UPDMOD	PIQBW_UPDMOD	CHAR	1	0	BW Delta Procedure: Update Mode
37	MODREG_ID	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
38	ST_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*

History

Last changed by/on	SAP	20130529
SAP Release Created in