SAP ABAP Table DITSSM (SDB: Dialog Table for Problem Linked from Solution)

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	DITSSM	Table Relationship Diagram
Short Description	SDB: Dialog Table for Problem Linked from Solution

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	ISYMSEL	☐	SELECT	SELKZ	CHAR	1	0	Selection
2	.INCLUDE	☐				0	0	SDB: Problem Short Text
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	ISMNR	☐	ISMNR	ISMNR	CHAR	12	0	Number of Problem Record	ISMP
5	ISMVR	☐	IVERSION	IVERSION	NUMC	3	0	Version Number	*
6	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
7	ISMTXT	☐	ISMTEXT	TEXT40	CHAR	40	0	Problem Description
8	INDLTXT	☐	INDLTXT	CHAR1	CHAR	1	0	Long Text
9	TRSTAT	☐	TRSTAT	CHAR1	CHAR	1	0	Translation status for text fields
10	.INCLUDE	☐				0	0	SDB: Create and change
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERTIM	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
14	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
15	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
16	AETIM	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
17	FLGDEL	☐	FLAGDEL	CHAR1	CHAR	1	0	Delete data record
18	.INCLUDE	☐				0	0	SDB: Structure for Problem Table
19	COPER	☐	COPER	USNAM	CHAR	12	0	Name of contact person
20	ISMTP	☐	ISMTP	ISMPT	CHAR	2	0	Problem Type	T0KBA
21	APPLAR	☐	APPLAR	CHAR20	CHAR	20	0	Application Area	T0KBD
22	ISMART	☐	ISMART	ISMART	CHAR	2	0	Problem Subtype	T0KBC
23	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
24	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
25	ISMCAT	☐	ISMCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Problem Code Groups and Problem Codes	TQ15
26	ISMGRP	☐	ISMGRP	QCODEGRP	CHAR	8	0	Problem Code Group	QPGR
27	ISMCOD	☐	ISMCOD	QCODE	CHAR	4	0	Problem Code	QPCD
28	ARTPR	☐	TYPPR	TYPPR	CHAR	2	0	Priority Type	T0KBH
29	PRIOK	☐	SDB_PRIOR	SDB_PRIOR	CHAR	1	0	Priority Level	T0KBG
30	ISMST	☐	ISMST	ISMST	CHAR	1	0	Solution Database: Problem Status
31	RBNR	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
32	OPCAT	☐	OPCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Location Code Groups and Location Codes	TQ15
33	PRCAT	☐	PRCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Damage Code Groups and Damage Codes	TQ15
34	CACAT	☐	CACAT	COM_CATALOG	CHAR	2	0	Catalog Containing Cause Code Groups and Cause Codes	TQ15
35	ITEMNR	☐	ITEMNR	ITEMNR	NUMC	4	0	SDB: Trigger Number	*
36	ISYMICON	☐	ISYMICON	SYCHAR40	CHAR	40	0	SDB: Long Text Icon for Problem
37	LINKCHANGE	☐	ISYMLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change a Problem
38	LINKICON	☐	ISYMLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change a Problem
39	SCORE	☐	ISMSCORE		DEC	7	3	SDB: Score (weight) returned form the search engine
40	EXPTEXT	☐	EXPTEXT	TEXT40	CHAR	40	0	SDB: Explanation Text for Search Match
41	FLGUPD	☐	FLAGUPD	CHAR1	CHAR	1	0	Update data record
42	LINKINX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
43	STTXT	☐	SDBSTTXT	TEXT40	CHAR	40	0	Status
44	SYMTYTXT	☐	ISMPTX	CHAR40	CHAR	40	0	Problem Type Description
45	SYMSTTXT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
46	SYMCATXT	☐	TXTSMART	TEXT40	CHAR	40	0	Problem Subtype Description
47	IIACLUSTER	☐	CRMT_EI_IIA_CLUSTER	INT2	INT2	5	0	Cluster for grouping of IIA results

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DITSSM	APPLAR	T0KBD	APPLAR		1	CN
2	DITSSM	ARTPR	T0KBH	ARTPR
3	DITSSM	CACAT	TQ15	KATALOGART
4	DITSSM	CLIENT	T000	MANDT	KEY	1	CN
5	DITSSM	ISMART	T0KBC	ISMART		1	CN
6	DITSSM	ISMCAT	TQ15	KATALOGART
7	DITSSM	ISMCOD	QPCD	CODE
8	DITSSM	ISMGRP	QPGR	CODEGRUPPE
9	DITSSM	ISMNR	ISMP	ISMNR	KEY	1	CN
10	DITSSM	ISMTP	T0KBA	ISMTP	REF	C	CN
11	DITSSM	LANGU	T002	SPRAS		1	CN
12	DITSSM	OPCAT	TQ15	KATALOGART
13	DITSSM	PRCAT	TQ15	KATALOGART
14	DITSSM	PRIOK	T0KBG	PRIOK	REF	C	CN
15	DITSSM	RBNR	CRMC_SUBJPROFILE	SUBJECT_PROFILE		C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in