SAP ABAP Table PIQEDSM506 (Structure for CS/SM Relationship)

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	PIQEDSM506	Table Relationship Diagram
Short Description	Structure for CS/SM Relationship

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	MODULEID	☐	PIQMODULE	HROBJID	NUMC	8	0	Module ID (Object Type SM)	*
2	NORM_VAL_SM	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
3	CPATTEMP	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
4	CPGAINED_SM	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
5	CPUNIT_SM	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
6	CHARGEFREE	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
7	ALT_SCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	*
8	SMRATING	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
9	VARID	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
10	PERID	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
11	PERYR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQEDSM506	PERID	T7PIQPERIOD	PERID		1	CN
2	PIQEDSM506	PERYR	T7PIQYEAR	PERYR	KEY	1	CN
3	PIQEDSM506	SMRATING	T7PIQSMRATING	SMRATING
4	PIQEDSM506	VARID	T7PIQVARY	VARID	KEY	1	CN

History

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