SAP ABAP Table SRM_PU_QUERY_SPS (Assignment of SPS ID to Query ID)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-RM (Application Component) SAP Records Management
     ⤷ SRM_PROPERTY (Package) Generic Property Handling

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SRM_PU_QUERY_SPS	Table Relationship Diagram
Short Description	Assignment of SPS ID to Query ID

Delivery and Maintenance

Pool/cluster
Delivery Class	E	Control table, SAP and customer have separate key areas
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	QUERY_ID	☑	SRMPUQID	SRMID	CHAR	32	0	ID of the Predefined Search	SRM_PU_QUERY_ID
3	SPS_ID	☑	SRMSPSID	SRMID	CHAR	32	0	Element Type ID	SRMSPSDE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SRM_PU_QUERY_SPS	QUERY_ID	SRM_PU_QUERY_ID	QUERY_ID		1	CN
2	SRM_PU_QUERY_SPS	SPS_ID	SRMSPSDE	SPSID		1	CN

History

Last changed by/on	SAP	20041223
SAP Release Created in	700