SAP ABAP Table DISOL (SDB: Dialog Table 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	DISOL	Table Relationship Diagram
Short Description	SDB: Dialog Table 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: Solution table
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
4	ISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
5	.INCLUDE	☐				0	0	SDB: Structure for Solution Table
6	ISLTP	☐	ISLTP	ISLTP	CHAR	2	0	Solution Type	T0KBB
7	RBNR	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
8	ISLART	☐	ISLART	CHAR2	CHAR	2	0	Solution Subtype	T0KBF
9	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
10	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
11	SL_VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
12	SL_VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
13	COPER	☐	COPER	USNAM	CHAR	12	0	Name of contact person
14	ISLST	☐	ISLST	ISLST	CHAR	1	0	Solution Status
15	TKCAT	☐	TKCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Task Code Groups and Task Codes	TQ15
16	ACTCAT	☐	IACTCAT	COM_CATALOG	CHAR	2	0	SDB: Catalog type - Activity	TQ15
17	.INCLUDE	☐				0	0	SDB: Create and change
18	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
20	ERTIM	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
21	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
22	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
23	AETIM	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
24	FLGDEL	☐	FLAGDEL	CHAR1	CHAR	1	0	Delete data record
25	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRM_ONR00
26	LEGACY_SOL_ID	☐	CRMT_SDB_LEGACY_SOLUTION	CHAR32	CHAR	32	0	ID of Solution/Problem in Legacy System
27	.INCLUDE	☐				0	0
28	ISOLSEL	☐	SELECT	SELKZ	CHAR	1	0	Selection
29	SELEC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
30	ISLTXT	☐	ISLTEXT	TEXT40	CHAR	40	0	Solution Description
31	RISLNR	☐	RISLNR	ISLNR	CHAR	12	0	Reference Solution Number	*
32	RISLVR	☐	RISLVR	ISLVER	CHAR	3	0	Reference Solution Version Number
33	SISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
34	SISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
35	QMNUM	☐	CRMTQMNUM	CRMTQMNUM	CHAR	12	0	Notification Number
36	RBNRX	☐	RBNRTX	TEXT30	CHAR	30	0	Subject Profile Description
37	STTXT	☐	SDBSTTXT	TEXT40	CHAR	40	0	Status
38	USTAX	☐	SDBASTEX	KREUZ	CHAR	1	0	Active User Status
39	USTTXT	☐	SDBASTTX	CHAR40	CHAR	40	0	User Status
40	ISLSTX	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
41	ISOLTX	☐	ISOLTX	TEXT40	CHAR	40	0	Solution Type Description
42	TXTSLART	☐	TXTSLART	TEXT40	CHAR	40	0	Solution Subtype Description
43	ACTYP	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
44	ISOLICON	☐	ISOLICON	SYCHAR40	CHAR	40	0	SDB: Long Text Icon for Solution
45	ISOSICON	☐	ISSMICON	SYCHAR40	CHAR	40	0	SDB: Dynamic Icon for Status Management
46	LINKICON	☐	ISOLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change
47	ITEMNR	☐	ITEMNR	ITEMNR	NUMC	4	0	SDB: Trigger Number	*
48	FLGPOST	☐	FLAGUPD	CHAR1	CHAR	1	0	Update data record
49	FLGUPD	☐	FLAGUPD	CHAR1	CHAR	1	0	Update data record
50	TKCNT	☐	INT4	INT4	INT4	10	0	Natural number
51	ACTCNT	☐	INT4	INT4	INT4	10	0	Natural number
52	ICONEXP	☐	ICONEXP	SYCHAR40	CHAR	40	0	SDB: Icon to Toggle between Expanded and Collapsed Screens
53	LISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
54	LISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
55	CONFIG	☐	EWF_CONFIG	EWF_CONFIG	CHAR	8	0	Action Box Configuration	*
56	CALLID	☐	SDB_CALLID	EWF_CALLID	CHAR	4	0	Transaction Code	*
57	FLGCAL	☐	FLGCAL	CHAR1	CHAR	1	0	SDB: Indicator to show from where it is called

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DISOL	ACTCAT	TQ15	KATALOGART
2	DISOL	CLIENT	T000	MANDT	KEY	1	CN
3	DISOL	ISLART	T0KBF	ISLART		1	CN
4	DISOL	ISLTP	T0KBB	ISLTP	REF	C	CN
5	DISOL	OBJNR	CRM_ONR00	OBJNR	REF	C	CN
6	DISOL	RBNR	CRMC_SUBJPROFILE	SUBJECT_PROFILE		C	CN
7	DISOL	TKCAT	TQ15	KATALOGART

History

Last changed by/on	SAP	20100420
SAP Release Created in