SAP ABAP Table PIQGRADRECEXT (Graduation Data Record (Enhanced))

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	PIQGRADRECEXT	Table Relationship Diagram
Short Description	Graduation Data Record (Enhanced)

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	Graduation Data Record
2	ST_OBJID	☐	PIQSTUDENT	HROBJID	NUMC	8	0	Object ID of Student	*
3	CS_OBJID	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
4	SC_OBJID	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
5	GRADID	☐	PIQGRADID	SYSUUID_C	CHAR	32	0	Graduation Identification (ID)
6	STATUS	☐	PIQGRAD_STATUS	PIQGRAD_STATUS	CHAR	1	0	Graduation Status
7	.INCLUDE	☐				0	0	Graduation Data Record
8	REGDATE	☐	PIQGRAD_REGDATE	DATUM	DATS	8	0	Activity Key Date for Graduation Registration
9	GRAD_REASON	☐	PIQGRAD_REASON	PIQAPPREASON	NUMC	4	0	Activity Reason	T7PIQREASON
10	CRMNY_DATE	☐	PIQGRAD_CEREMONY_DATE	DATUM	DATS	8	0	Graduation Ceremony Date
11	CRMNY_LOCATION	☐	LOCID	HROBJID	NUMC	8	0	Business Event Location	*
12	CRMNY_BUILDING	☐	BUILD	BUILD	CHAR	8	0	Building	T777A
13	CRMNY_ROOM	☐	ROMID	HROBJID	NUMC	8	0	Room	PLOGI
14	CRMNY_BEGTIME	☐	BEGUZ	UZEIT	TIMS	6	0	Start Time
15	CRMNY_ENDTIME	☐	ENDUZ	UZEIT	TIMS	6	0	End Time
16	CRMNY_SEATNO	☐	PIQGRAD_CEREMONY_SEATNO	CHAR10	CHAR	10	0	Seat Number
17	CRMNY_CATEGORY	☐	PIQGRAD_CEREMONY_CATEGORY	PIQGRAD_CEREMONY_CATEGORY	CHAR	4	0	Graduation Ceremony Characteristic	T7PIQGRADCRMYCAT
18	CRMNY_PUBLISH	☐	PIQGRAD_CEREMONY_PUBLISH	FLAG	CHAR	1	0	Publication Permission
19	.INCLUDE	☐				0	0	Graduation Data Record (Texts)
20	REASON_TXT	☐	PIQREASONT	TEXT25	CHAR	25	0	Reason Description
21	STATUS_TXT	☐	PIQGRAD_STATUS_TXT	TEXT40	CHAR	40	0	Graduation Status (Description)
22	LOCATION_SHORT	☐	PIQLOCATION_SHORT	TEXT12	CHAR	12	0	Location (Abbreviation)
23	LOCATION_STEXT	☐	PIQLOCATION_STEXT	TEXT40	CHAR	40	0	Location Description (Personnel Planning Object)
24	BUILD_STEXT	☐	PIQBUILD_STEXT	TEXT40	CHAR	40	0	Building (Description)
25	ROOM_SHORT	☐	ROSHRT	TEXT12	CHAR	12	0	Short Name of Room
26	ROOM_STEXT	☐	ROSTEX	TEXT40	CHAR	40	0	Name of Room
27	CRMNY_CATEGORY_TXT	☐	PIQGRAD_CEREMONY_CATEGORYT	TEXT40	CHAR	40	0	Graduation Ceremony Characteristic (Description)
28	ST_NUMBER	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
29	ST_NAME	☐	PIQSTUDENTNAME	TEXT40	CHAR	40	0	Student Name
30	SC_SHORT	☐	PIQSCSHORT	TEXT12	CHAR	12	0	Program (Abbreviation)
31	SC_STEXT	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQGRADRECEXT	CRMNY_BUILDING	T777A	BUILD
2	PIQGRADRECEXT	CRMNY_CATEGORY	T7PIQGRADCRMYCAT	CATEGORY
3	PIQGRADRECEXT	CRMNY_ROOM	PLOGI	OBJID
4	PIQGRADRECEXT	GRAD_REASON	T7PIQREASON	REASON

History

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