SAP ABAP Table CRMXIF_1_SYMPTOM (Interface SDB: One Problem)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-SDB (Application Component) Solution Database
     ⤷ CSKN (Package) Customer Service: Knowledge Base Development

Basic Data

Table Category	INTTAB	Structure
Structure	CRMXIF_1_SYMPTOM	Table Relationship Diagram
Short Description	Interface SDB: One Problem

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	.INCLUDE	☐				0	0	SDB: Problem
2	SYMP_GUID	☐	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	SYMP_NO	☐	ISMNR	ISMNR	CHAR	12	0	Number of Problem Record	*
4	VER_NO	☐	IVERSION	IVERSION	NUMC	3	0	Version Number	*
5	LEGACY_SYM_ID	☐	CRMT_SDB_LEGACY_SOLUTION	CHAR32	CHAR	32	0	ID of Solution/Problem in Legacy System
6	SUBJECT_PROFILE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	*
7	SUBJECT_PRF_DESCR	☐	RBNRTX	TEXT30	CHAR	30	0	Subject Profile Description
8	APPL_AREA	☐	APPLAR	CHAR20	CHAR	20	0	Application Area
9	APPL_AREA_DESCR	☐	TXTAPPLAR	TEXT40	CHAR	40	0	Application Area Description
10	SYMP_CAT_TYPE	☐	ISMCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Problem Code Groups and Problem Codes	*
11	SYMP_CAT_TP_DESCR	☐	QTXTCATALG	QKURZTEXT	CHAR	40	0	Short Text for the Catalog
12	SYMP_CODEGRP	☐	ISMGRP	QCODEGRP	CHAR	8	0	Problem Code Group	*
13	SYMP_CODEGRP_DESCR	☐	SDBTXTGR	CHAR40	CHAR	40	0	Code group description
14	SYMP_CODE	☐	ISMCOD	QCODE	CHAR	4	0	Problem Code	*
15	SYMP_CODE_DESCR	☐	SDBTXTCD	CHAR80	CHAR	80	0	Code Short Text
16	OBJECT_NO	☐	SDBOBJNR	J_OBJNR	CHAR	22	0	Object number for status management	*
17	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
18	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
19	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
20	CREATED_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
21	CREATED_TIME	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
22	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
23	CHANGED_DATE	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
24	CHANGED_TIME	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
25	STAT_PROF	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
26	STAT_PROF_DESCR	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
27	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
28	STATUS_DESCR	☐	SDBASTTX	CHAR40	CHAR	40	0	User Status
29	SYSTEM_STATUS	☐	ISMST	ISMST	CHAR	1	0	Solution Database: Problem Status
30	SYSTEM_ST_DESCR	☐	SDBSTTXT	TEXT40	CHAR	40	0	Status
31	DATAX_HEADER	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
32	TASK	☐	SMW3EXDTL1	SMW3EXDOM1	CHAR	1	0	Flow Example: Task for one row in an mBDoc segment
33	TYPE	☐	CRMXIF_SYMPTOM_TYPE_DATA		STRU	0	0
34	DATA	☐	CRMXIF_SYMPTOM_TYPE		STRU	0	0
35	SYMP_TYPE	☐	ISMTP	ISMPT	CHAR	2	0	Problem Type
36	SYMP_TYPE_DESCR	☐	ISMPTX	CHAR40	CHAR	40	0	Problem Type Description
37	SYMP_CATEG	☐	ISMART	ISMART	CHAR	2	0	Problem Subtype
38	SYMP_CATEG_DESCR	☐	TXTSMART	TEXT40	CHAR	40	0	Problem Subtype Description
39	SYMP_CAT_TYPE	☐	ISMCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Problem Code Groups and Problem Codes
40	SYMP_CAT_TP_DESCR	☐	QTXTCATALG	QKURZTEXT	CHAR	40	0	Short Text for the Catalog
41	LOCATION_CAT_TYPE	☐	OPCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Location Code Groups and Location Codes
42	LOCATION_CAT_DESCR	☐	QTXTCATALG	QKURZTEXT	CHAR	40	0	Short Text for the Catalog
43	DAMAGE_CAT_TYPE	☐	PRCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Damage Code Groups and Damage Codes
44	DAMAGE_CAT_DESCR	☐	QTXTCATALG	QKURZTEXT	CHAR	40	0	Short Text for the Catalog
45	CAUSE_CAT_TYPE	☐	CACAT	COM_CATALOG	CHAR	2	0	Catalog Containing Cause Code Groups and Cause Codes
46	CAUSE_CAT_DESCR	☐	QTXTCATALG	QKURZTEXT	CHAR	40	0	Short Text for the Catalog
47	STAT_PROF	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile
48	STAT_PROF_DESCR	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
49	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
50	PRIORITY	☐	CRMXIF_SYMPTOM_PRIORITY_DATA		STRU	0	0
51	DATA	☐	CRMXIF_SYMPTOM_PRIORITY		STRU	0	0
52	PRIOTYPE	☐	TYPPR	TYPPR	CHAR	2	0	Priority Type
53	PRIOTYPE_DESCR	☐	TYPPRTX	TEXT20	CHAR	20	0	Description of Priority Type
54	PRIORITY	☐	SDB_PRIOR	SDB_PRIOR	CHAR	1	0	Priority Level
55	PRIORITY_DESCR	☐	PRIORITYTX	TEXT20	CHAR	20	0	Priority Text
56	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
57	DAMAGES	☐	CRMXIF_SYMPTOM_DAMAGE_TAB_DATA		STRU	0	0
58	DATA	☐	CRMXIF_SYMPTOM_DAMAGE_TAB		TTYP	0	0
59	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
60	LOCATIONS	☐	CRMXIF_SYMPTOM_LOCAT_TAB_DATA		STRU	0	0
61	DATA	☐	CRMXIF_SYMPTOM_LOCATIONS_TAB		TTYP	0	0
62	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
63	CAUSES	☐	CRMXIF_SYMPTOM_CAUSE_TAB_DATA		STRU	0	0
64	DATA	☐	CRMXIF_SYMPTOM_CAUSE_TAB		TTYP	0	0
65	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
66	VALIDATION_CATEG	☐	CRMXIF_SDB_VALCAT_TAB_DATA		STRU	0	0
67	DATA	☐	CRMXIF_SDB_VALCAT_TAB		TTYP	0	0
68	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
69	BUSINESS_OBJS	☐	CRMXIF_SDB_OBJECTS_TAB_DATA		STRU	0	0
70	DATA	☐	CRMXIF_SDB_OBJECTS_TAB		TTYP	0	0
71	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
72	SOLUTION_LINKS	☐	CRMXIF_SYMPTOM_SOLSYM_TAB_DATA		STRU	0	0
73	DATA	☐	CRMXIF_SYMPTOM_SOLUSLINK_TAB		TTYP	0	0
74	DATAX	☐	CRMXIF_BT_UPDATE	BAPIUPDATE	CHAR	1	0	Information on Changes to Transaction Data Structure/Table
75	SHORTTEXTS	☐	CRMXIF_SYMPTOM_SHORTTXT_TAB		TTYP	0	0
76	LONGTEXT	☐	CRMXIF_SDB_TEXT_TAB		TTYP	0	0

History

Last changed by/on	SAP	20140117
SAP Release Created in	300