SAP ABAP View RSPMXREFTGTVIEW (Source view)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-WHM-DST (Application Component) Data Staging
     ⤷ RSPM (Package) BW Request Status Management

Basic Data

View Type	D	Database View
Database View	RSPMXREFTGTVIEW
Short Description	Source view
Root table	RSPMXREF	RSPM Request Cross Reference

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	RSPMXREF	RSPMXREF
2	RSPMPROCESS
3	RSPMVARIANT
4	RSPMREQUEST
5	RSPMDATATARGET

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	RSPMXREF	PROCESS_TSN	JL	EQ				0	0
2	RSPMPROCESS	PROCESS_TSN	JR	EQ			AND	0	0
3	RSPMPROCESS	PROCESS_TYPE	JL	EQ				0	0
4	RSPMVARIANT	PROCESS_TYPE	JR	EQ			AND	0	0
5	RSPMPROCESS	PROCESS_ID	JL	EQ				0	0
6	RSPMVARIANT	PROCESS_ID	JR	EQ			AND	0	0
7	RSPMPROCESS	PROCESS_VERSION	JL	EQ				0	0
8	RSPMVARIANT	PROCESS_VERSION	JR	EQ			AND	0	0
9	RSPMXREF	REQUEST_TSN	JL	EQ				0	0
10	RSPMREQUEST	REQUEST_TSN	JR	EQ			AND	0	0
11	RSPMVARIANT	PROCESS_TYPE	JL	EQ				0	0
12	RSPMDATATARGET	PROCESS_TYPE	JR	EQ			AND	0	0
13	RSPMVARIANT	PROCESS_ID	JL	EQ				0	0
14	RSPMDATATARGET	PROCESS_ID	JR	EQ			AND	0	0
15	RSPMVARIANT	PROCESS_VERSION	JL	EQ				0	0
16	RSPMDATATARGET	PROCESS_VERSION	JR	EQ			AND	0	0
17	RSPMDATATARGET	ROLE		EQ	'S'		AND	0	0
18	RSPMXREF	SOURCE_IS_EXTERNAL		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	PROCESS_TSN	RSPMXREF	PROCESS_TSN		☐	RSPM_PROCESS_TSN	☐	Process Transaction Sequence Number
2	PROCESS_TYPE	RSPMPROCESS	PROCESS_TYPE		☐	RSPM_PROCESS_TYPE	☐	RSPM Process Type
3	PROCESS_ID	RSPMPROCESS	PROCESS_ID		☐	RSPM_PROCESS_ID	☐	RSPM Process ID
4	PROCESS_VERSION	RSPMPROCESS	PROCESS_VERSION		☐	RSPM_PROCESS_VERSION	☐	RSPM Process Version
5	PROCESS_STATUS	RSPMPROCESS	PROCESS_STATUS		☐	RSPM_PROCESS_STATUS	☐	RSPM Process Status
6	PREDECESSOR_PROCESS_TSN	RSPMPROCESS	PREDECESSOR_PROCESS_TSN		☐	RSPM_PREDECESSOR_PROCESS_TSN	☐	Predecessor Process TSN
7	EXTERNAL_ID	RSPMPROCESS	EXTERNAL_ID		☐	RSPM_EXTERNAL_ID	☐	External ID
8	UNAME	RSPMPROCESS	UNAME		☐	SYUNAME	☐	User Name
9	UPDATE_MODE	RSPMVARIANT	UPDATE_MODE		☐	RSPM_UPDATE_MODE	☐	RSPM Update Mode
10	ALLOWS_GAPS	RSPMVARIANT	ALLOWS_GAPS		☐	RS_BOOL	☐	Boolean
11	TGT_REQUEST_TSN	RSPMXREF	REQUEST_TSN		☐	RSPM_REQUEST_TSN	☐	Request Transaction Sequence Number
12	TGT_TLOGO	RSPMREQUEST	TLOGO		☐	RSTLOGO	☐	BW: Object Type (TLOGO)
13	TGT_DATATARGET	RSPMREQUEST	DATATARGET		☐	RSPM_DATATARGET	☐	RSPM: Data Target
14	TGT_STORAGE	RSPMREQUEST	STORAGE		☐	RSPM_DTA_STORAGE	☐	Storage of a data target
15	TGT_LAST_OPERATION_TYPE	RSPMREQUEST	LAST_OPERATION_TYPE		☐	RSPM_OPERATION_TYPE	☐	RSPM Operation Type (CRUD)
16	TGT_LAST_PROCESS_TSN	RSPMREQUEST	LAST_PROCESS_TSN		☐	RSPM_PROCESS_TSN	☐	Process Transaction Sequence Number
17	TGT_LAST_TIME_STAMP	RSPMREQUEST	LAST_TIME_STAMP		☐	RSPM_TSN	☐	BW Request Status Management: Transaction Sequence Number
18	TGT_RECORDS	RSPMREQUEST	RECORDS		☐		☐
19	TGT_REQUEST_STATUS	RSPMREQUEST	REQUEST_STATUS		☐	RSPM_REQUEST_STATUS	☐	RSPM Request Status
20	TGT_REQUEST_STATUS_BEFORE_DEL	RSPMREQUEST	REQUEST_STATUS_BEFORE_DELETION		☐	RSPM_REQUEST_STATUS	☐	RSPM Request Status
21	TGT_OPERATION_TYPE	RSPMXREF	OPERATION_TYPE		☐	RSPM_OPERATION_TYPE	☐	RSPM Operation Type (CRUD)
22	SRC_REQUEST_TSN	RSPMXREF	SOURCE_REQUEST_TSN		☐	RSPM_SOURCE_REQUEST_TSN	☐	Source Request Transaction Sequence Number
23	SRC_TLOGO	RSPMDATATARGET	TLOGO		☐	RSTLOGO	☐	BW: Object Type (TLOGO)
24	SRC_DATATARGET	RSPMDATATARGET	DATATARGET		☐	RSPM_DATATARGET	☐	RSPM: Data Target
25	SRC_STORAGE	RSPMDATATARGET	STORAGE		☐	RSPM_DTA_STORAGE	☐	Storage of a data target
26	SRC_OPERATION_TYPE	RSPMDATATARGET	OPERATION_TYPE		☐	RSPM_OPERATION_TYPE	☐	RSPM Operation Type (CRUD)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20141013
SAP Release Created in	740