SAP ABAP Table PIQAUDIT_REQ_SUBREQ_INDEX (Structure for Reqmt, Subreqmt, Key Figure, Condition Display)

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	PIQAUDIT_REQ_SUBREQ_INDEX	Table Relationship Diagram
Short Description	Structure for Reqmt, Subreqmt, Key Figure, Condition Display

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	NODEID	☐	PIQAUDF_POS	NUMC4	NUMC	4	0	Item Within a Requirement Profile
2	REF_NODEID	☐	PIQAUDF_REFPOS	NUMC4	NUMC	4	0	Reference Item in Requirement Profile
3	ELEMENT	☐	PIQREQELEMENT	PIQREQELEMENT	NUMC	4	0	Requirement	*
4	ELEMENT_TXT	☐	PIQREQELEMENTT	TEXT40	CHAR	40	0	Requirement (Description)
5	ELEMENT_CALCMODE	☐	PIQREQELEM_CALCMODE	PIQREQELEM_CALCMODE	CHAR	1	0	Requirement Category
6	ELEMENT_DEPTH	☐	INT4	INT4	INT4	10	0	Natural number
7	TREECOMP	☐			STRG	0	0
8	SEQNR	☐	PIQSEQNR	NUMC3	NUMC	3	0	Sequence Number
9	SUBREQ_ID	☐	PIQRULEMODULE	PIQRULEMODULE	NUMC	8	0	Rule Module	*
10	SUBREQ_TXT	☐	PIQRULEMODULET	TEXT25	CHAR	25	0	Rule Module (Description)
11	SUBREQ_TYPE	☐	PIQRMTYPE	PIQRMTYPE	CHAR	4	0	Subrequirement Category
12	SUBREQ_REF	☐	CL_HRPIQ00AUDIT_SUBREQUIREMENT		REF	0	0
13	.INCLUDE	☐				0	0	Standard Value and Exception (Incl. Description)
14	.INCLUDE	☐				0	0	Standard Values for Indices (Incl. Descriptions)
15	.INCLUDE	☐				0	0	Structure: Definition of Indices and Standard Values
16	PINDEX	☐	PIQSI2S_ACADPI_ID	PIQSI2S_ACADPI_ID	CHAR	16	0	Performance Index	T7PIQ_SI2_PINDX
17	.INCLUDE	☐				0	0	Requirement Key Figures and Target Values
18	OPERAND	☐	PIQREQOPERAND	PIQREQOPERAND	CHAR	2	0	Relational Operand for a Subrequirement
19	VALUE	☐	PIQREQVALUE		QUAN	10	0	Comparison Value for a Subrequirement
20	UNIT	☐	PIQREQUNIT	MEINS	UNIT	3	0	Unit for Comparison Value of a Subrequirement	T006
21	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
22	SCALEID	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
23	PINDEX_TXT	☐	PIQSI2S_ACADPI_TXT	TEXT40	CHAR	40	0	Academic Performance Index (Description)
24	SCALE_TXT	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
25	GRADESYM_TXT	☐	PIQSCALE_GRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Scale Value (Description)
26	.INCLU-KEY	☐				0	0	Structure: Defined Key Figures and Std Vals (With Texts)
27	.INCLUDE	☐				0	0	Structure: Defined Key Figures and Standard Values
28	KEYFIGURE_IDKEY	☐	PIQKEYF_ID	PIQKEYFID	CHAR	4	0	Key Figure (Abbreviation)	T7PIQKEYFIGURES
29	.INCLUDE	☐				0	0	Requirement Key Figures and Target Values
30	OPERANDKEY	☐	PIQREQOPERAND	PIQREQOPERAND	CHAR	2	0	Relational Operand for a Subrequirement
31	VALUEKEY	☐	PIQREQVALUE		QUAN	10	0	Comparison Value for a Subrequirement
32	UNITKEY	☐	PIQREQUNIT	MEINS	UNIT	3	0	Unit for Comparison Value of a Subrequirement	T006
33	GRADESYMKEY	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
34	SCALEIDKEY	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
35	KEYFIGURE_TXTKEY	☐	PIQKEYF_TXT	TEXT40	CHAR	40	0	Key Figure (Description)
36	SCALE_TXTKEY	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
37	GRADESYM_TXTKEY	☐	PIQSCALE_GRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Scale Value (Description)
38	GRADESYM_EX	☐	PIQGRADESYMIND	PIQGRADESYM	CHAR	10	0	Personal Grade for Subrequirement
39	GRADESYM_EX_TXT	☐	PIQSCALE_GRADETEXT	PIQSCALE_GRADETEXT	CHAR	20	0	Scale Value (Description)
40	GRADE_EX	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
41	VALUE_EX	☐	PIQREQVALUEIND		QUAN	10	0	Personal Target Value for Subrequirement
42	REASON	☐	PIQAUDFREAS	PIQAUDFREAS	CHAR	4	0	Exception Reason	T7PIQAUDFEXREAS
43	REASON_TXT	☐	PIQAUDFREAST	TEXT30	CHAR	30	0	Exception Reason (Description)
44	IMG	☐			STRG	0	0
45	UPDATEFLAG	☐	PIQUPDATEFLAG	PIQUPDATEFLAG	CHAR	1	0	Update Indicator (Insert: I, Change: U, Delete: D)
46	COND_ID	☐	PIQRLCOND	PIQRLCOND	CHAR	4	0	Condition	*
47	COND_RESULT	☐	PIQRLCHECKRESULT	PIQREQRES	CHAR	1	0	Check Result of Condition
48	COND_TXT	☐	PIQRLCONDT	TEXT25	CHAR	25	0	Condition (Description)
49	ALL_RESULT	☐	PIQREQRES	PIQREQRES	CHAR	1	0	Result
50	VALGRADE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
51	CALCULATED_VALGRADE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
52	UNITSCALE_TXT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
53	OPERAND_TXT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
54	IMG_RESULT	☐			STRG	0	0
55	VALGRADE_TOOLTIP	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
56	PERSONAL_VALGRADE_TOOLTIP	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
57	MODULE_PREVIEW	☐			STRG	0	0
58	NORMINAL_VALGRADE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
59	PERSONAL_VALGRADE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
60	RLCATT	☐	PIQRLCATT	TEXT30	CHAR	30	0	Requirement Catalog (Description)
61	RLCATVERST	☐	PIQRLCATVERST	TEXT20	CHAR	20	0	Requirement Catalog Version (Description)
62	RLCAT	☐	PIQRLCAT	PIQRLCAT	CHAR	4	0	Requirement Catalog	*
63	RLCATVERS	☐	PIQRLCATVERS	PIQRLCATVERS	CHAR	4	0	Requirement Catalog Version	*
64	SUBREQ_TYPE_TXT	☐			STRG	0	0
65	SUBREQ_TYPE_IMG	☐			STRG	0	0
66	KEYF_COND_TXT	☐			STRG	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAUDIT_REQ_SUBREQ_INDEX	KEYFIGURE_IDKEY	T7PIQKEYFIGURES	KEYFIGURE_ID
2	PIQAUDIT_REQ_SUBREQ_INDEX	PINDEX	T7PIQ_SI2_PINDX	PINDEX	REF	1	CN
3	PIQAUDIT_REQ_SUBREQ_INDEX	REASON	T7PIQAUDFEXREAS	AUDF_EXCREAS
4	PIQAUDIT_REQ_SUBREQ_INDEX	SCALEID	T7PIQSCALE	SCALEID	REF	1	CN
5	PIQAUDIT_REQ_SUBREQ_INDEX	SCALEIDKEY	T7PIQSCALE	SCALEID	REF	1	CN
6	PIQAUDIT_REQ_SUBREQ_INDEX	UNIT	T006	MSEHI	REF	1	CN
7	PIQAUDIT_REQ_SUBREQ_INDEX	UNITKEY	T006	MSEHI	REF	1	CN

History

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