SAP ABAP Table DSWP_SDREPORTSTR (Structure for Service Desk Reporting in the Solution Manager)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-OP (Application Component) Solution Directory
     ⤷ DSWP_CRM (Package) Link: SAP Solution Manager - CRM

Basic Data

Table Category	INTTAB	Structure
Structure	DSWP_SDREPORTSTR	Table Relationship Diagram
Short Description	Structure for Service Desk Reporting in the Solution Manager

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	TIMEFRAME	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
2	BUSPARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	BUSPARTNER_NAME	☐	DWSPCRMPERSONRESP	TEXT80	CHAR	80	0	Employee Responsible - Name
4	SYST_STAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
5	SYST_STAT_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
6	STATUS_USER	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
7	CONCATSTATUSER	☐	CRMT_REPORT_USERSTATUS	TEXT40	CHAR	40	0	User Status
8	SAP_COMPONENT	☐	BCOS_COMP	CHAR20	CHAR	20	0	R/3 component
9	POSTINGDATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
10	CHANGEDATE	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
11	CREATEDBY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
12	CHANGEDBY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
13	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
14	CATEGORY_TXT	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
15	PRIORITY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
16	PRIORITY_TXT	☐	CRMT_REPORT_PRIORITY_TXT	DDTEXT	CHAR	60	0	Text Description for Priority
17	SVERH	☐	DSWP_CRMT_CODE_TEXT	DSWP_CRMT_CODE_TEXT	CHAR	80	0	Short text for code
18	CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
19	CODEGROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
20	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
21	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
22	PROCESS_TYPE_TXT	☐	CRMT_REPORT_PROCESS_TYPE_TXT	DDTEXT	CHAR	60	0	Text Description for Transaction Category
23	STAT_PERCENTAGE	☐	DEC07	CO_ANZHL	DEC	7	2	Decimal field of length 7
24	TIME_AVER	☐	DEC07	CO_ANZHL	DEC	7	2	Decimal field of length 7
25	BIS_DATE	☐	DEC07	CO_ANZHL	DEC	7	2	Decimal field of length 7
26	SORT_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
27	SNOTE_COUNT	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
28	SNOTE_PERC	☐	DEC07	CO_ANZHL	DEC	7	2	Decimal field of length 7
29	CREQU_COUNT	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
30	CREQU_PERC	☐	DEC07	CO_ANZHL	DEC	7	2	Decimal field of length 7
31	LDB_COUNT	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
32	LDB_PERC	☐	DEC07	CO_ANZHL	DEC	7	2	Decimal field of length 7
33	IBASE	☐	DSWPDIBASENO	DSWPDIBASENO	NUMC	18	0	DSWP: IBase Component
34	INSTNR	☐	DNOT_INSTN	DNOE_INSTN	CHAR	10	0	SAP Installation Number
35	SYSID	☐	DNOT_SYSID	DNOE_SYSID	CHAR	8	0	SAP System, Name of SAP System
36	MANDT	☐	DNOT_MANDT	MANDT	CLNT	3	0	SAP Client	*
37	IBASEDESCR	☐	DSWPDTEXT40		CHAR	40	0	DSWP: 40-Char. Text
38	MESSCOUNT	☐	INT4	INT4	INT4	10	0	Natural number
39	CREATED_AT	☐	CRMT_CREATED_AT_USR	CRM_TSTMP	DEC	15	0	Created On (Output in User Time Zone)
40	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
41	CHANGED_AT_DATE	☐	CRMT_CHANGED_AT_DATE	SYDATS	DATS	8	0	Date on Which Transaction Was Last Changed
42	REACTIME	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
43	MESSNUM	☐	DSWP_MESSNUM	CHAR26	CHAR	26	0	SAP Message Number
44	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
45	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
46	TIMEFRAME_SORT	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters

History

Last changed by/on	SAP	20100705
SAP Release Created in	400