SAP ABAP View DSWP_NA_RPS_ADDR (View for reading recipients and commuication addresses-PF)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-ADM (Application Component) System Administration and Planning
     ⤷ DSWP_NOTIF_ADMIN (Package) Handling of notifications in Solution Manager

Basic Data

View Type	D	Database View
Database View	DSWP_NA_RPS_ADDR
Short Description	View for reading recipients and commuication addresses-PF
Root table	DSWP_NA_RPIENTS	Solman Notification Administration - Global Recipient Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DSWP_NA_RPIENTS	DSWP_NA_RPIENTS
2	DSWP_NA_COMMADDR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DSWP_NA_COMMADDR	RECIPIENT_GUID	JL	EQ				0	0
2	DSWP_NA_RPIENTS	RECIPIENT_GUID	JR	EQ			AND	0	0
3	DSWP_NA_COMMADDR	CLIENT	JL	EQ				0	0
4	DSWP_NA_RPIENTS	CLIENT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	DSWP_NA_RPIENTS	CLIENT		☐	MANDT	☐	Client
2	RECIPIENT_GUID	DSWP_NA_RPIENTS	RECIPIENT_GUID		☐	DSWPDNMGUID	☐	GUID in Notification Manager
3	RECIPIENT_ID	DSWP_NA_RPIENTS	RECIPIENT_ID		☐	DSWP_NA_USERBPID	☐	User or BP ID of a Recipient
4	SOURCE_TYPE	DSWP_NA_RPIENTS	SOURCE_TYPE		☐	DSWPDNMUSRTYPE	☐	User type - System User or Business partner or external user
5	SOURCE_ID	DSWP_NA_RPIENTS	SOURCE_ID		☐	DTSCOMPKEY	☐	DTS: Key of a Component in a System Landscape
6	ACTIVE	DSWP_NA_RPIENTS	ACTIVE		☐	DSWP_NA_RECIPACTIVE	☐	Recipient Active/ Inactive/ Forward to Substitute
7	GLOBAL_RECIPIENT	DSWP_NA_RPIENTS	GLOBAL_RECIPIENT		☐	DSWPDNM_BOOLEAN	☐	Boolean
8	FULLNAME	DSWP_NA_RPIENTS	FULLNAME		☐	AD_NAMTEXT	☐	Full Name of Person
9	CREATED_AT	DSWP_NA_RPIENTS	CREATED_AT		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	CREATED_BY	DSWP_NA_RPIENTS	CREATED_BY		☐	XUBNAME	☐	User Name in User Master Record
11	LAST_CHANGED_AT	DSWP_NA_RPIENTS	LAST_CHANGED_AT		☐	TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	LAST_CHANGED_BY	DSWP_NA_RPIENTS	LAST_CHANGED_BY		☐	XUBNAME	☐	User Name in User Master Record
13	DELETE_FLAG	DSWP_NA_RPIENTS	DELETE_FLAG		☐	LOEVM	☐	Deletion Indicator
14	SOURCE	DSWP_NA_RPIENTS	SOURCE		☐	GUID	☐	Globally Unique Identifier
15	SYSTEM_CLIENT	DSWP_NA_RPIENTS	SYSTEM_CLIENT		☐	MANDT	☐	Client
16	TIME_ZONE	DSWP_NA_RPIENTS	TIME_ZONE		☐	DSWP_NA_TIMEZONE	☐	Time Zone in Notification Management
17	COMM_MODE_GUID	DSWP_NA_COMMADDR	COMM_MODE_GUID		☐	DSWPDNMGUID	☐	GUID in Notification Manager
18	RPIENT_GUID	DSWP_NA_COMMADDR	RECIPIENT_GUID		☐	DSWPDNMGUID	☐	GUID in Notification Manager
19	COMM_MODE	DSWP_NA_COMMADDR	COMM_MODE		☐	DSWPDNMMODE	☐	DSWP_NM_MODE
20	ADDRESS	DSWP_NA_COMMADDR	ADDRESS		☐	DSWPDNM_ADDRESS	☐	Email / sms address
21	CONSUNUMBER	DSWP_NA_COMMADDR	CONSUNUMBER		☐	DSWP_NA_CONSNUMBER	☐	Data element for consnumber
22	STATUS	DSWP_NA_COMMADDR	STATUS		☐	WDY_BOOLEAN	☐	Replacement for Real Boolean Type: 'X' == True '' == False

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	20111123
SAP Release Created in	710