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

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in