SAP ABAP Table PIQBW_PCP (BW Extraction Structure: Program Completions)

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_PCP	Table Relationship Diagram
Short Description	BW Extraction Structure: Program Completions

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	CQGUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
2	CQ_OBJECTID	☐	PIQCQOBJID	HROBJID	NUMC	8	0	Internal Qualification Identification (ID)	*
3	BPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	STUDNR	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
5	PROGRAM_OBJECTID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
6	STUDY_OBJECTID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
7	ACAD_YEARPERID	☐	PIQBW_YRSES	PIQBW_YRSES	NUMC	7	0	Academic Period (Year and Session)
8	STATUS	☐	PIQGRAD_STATUS	PIQGRAD_STATUS	CHAR	1	0	Graduation Status
9	REGDATE	☐	PIQGRAD_REGDATE	DATUM	DATS	8	0	Activity Key Date for Graduation Registration
10	REASON	☐	PIQGRAD_REASON	PIQAPPREASON	NUMC	4	0	Activity Reason	*
11	CRMNY_DATE	☐	PIQGRAD_CEREMONY_DATE	DATUM	DATS	8	0	Graduation Ceremony Date
12	CRMNY_LOCATION	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
13	CRMNY_BUILDING	☐	BUILD	BUILD	CHAR	8	0	Building	*
14	CRMNY_ROOM	☐	ROMID	HROBJID	NUMC	8	0	Room	*
15	CRMNY_BEGTIME	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
16	CRMNY_ENDTIME	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
17	CRMNY_SEATNO	☐	PIQGRAD_CEREMONY_SEATNO	CHAR10	CHAR	10	0	Seat Number
18	CRMNY_CATEGORY	☐	PIQGRAD_CEREMONY_CATEGORY	PIQGRAD_CEREMONY_CATEGORY	CHAR	4	0	Graduation Ceremony Characteristic	*
19	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
20	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
21	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
22	CONF_COMMENT	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
23	CONFER_DATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
24	VALID_FROM	☐	BEGDA	DATUM	DATS	8	0	Start Date
25	VALID_TO	☐	ENDDA	DATUM	DATS	8	0	End Date
26	TRANSFERFLAG	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
27	PERIDFORCQ	☐	PIQCONFERQ_PERIDFORCQ	PIQPERCT	NUMC	3	0	Duration of Study Required to Achieve Qualification
28	PERIDFORCQUNIT	☐	PIQCONFERQ_PERIDFORCQUNIT	PIQCONFERQ_PERIDFORCQUNIT	CHAR	1	0	Unit for Number of Periods
29	ACADHONOR_SYM	☐	PIQCONFERQ_ACADHONOR_GRADESYM	PIQGRADESYM	CHAR	10	0	Academic Honors
30	ACADHONOR_GRADE	☐	PIQCONFERQ_ACADHONOR_GRADE	PIQSCALE_NORM_VAL	DEC	8	2	Academic Honors: Standard Value
31	ACADHONOR_SCALE	☐	PIQCONFERQ_ACADHONOR_SCALE	PIQSCALE_ID	CHAR	4	0	Academic Honors Scale	*
32	DIPLOMANAME	☐	PIQCONFERQ_DIPLOMANAME	TEXT80	CHAR	80	0	Diploma Name
33	FINALW_TITLE	☐	PIQCONFERQ_FINALWTITLE	TEXT100	CHAR	100	0	Title of Qualifying Work
34	FINALW_LANGU	☐	PIQCONFERQ_FINALWLANGU	SPRAS	LANG	1	0	Original Language	*
35	FINALW_TITLEALT	☐	PIQCONFERQ_FINALWTITLEALT	TEXT100	CHAR	100	0	Title of Qualifying Work in Other Language
36	FINALW_LANGUALT	☐	PIQCONFERQ_FINALWLANGUALT	SPRAS	LANG	1	0	Other Language	*
37	RECORDMODE	☐	PIQBW_UPDMOD	PIQBW_UPDMOD	CHAR	1	0	BW Delta Procedure: Update Mode

History

Last changed by/on	SAP	20130529
SAP Release Created in