SAP ABAP Table DITSL (SDB: Dialog Table Solution Linked to an Item)

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	DITSL	Table Relationship Diagram
Short Description	SDB: Dialog Table Solution Linked to an Item

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 Short Text Table
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	ISOL
4	ISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
5	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
6	ISLTXT	☐	ISLTEXT	TEXT40	CHAR	40	0	Solution 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 Solution Table
18	ISLTP	☐	ISLTP	ISLTP	CHAR	2	0	Solution Type	T0KBB
19	RBNR	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
20	ISLART	☐	ISLART	CHAR2	CHAR	2	0	Solution Subtype	T0KBF
21	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
22	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
23	SL_VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
24	SL_VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
25	COPER	☐	COPER	USNAM	CHAR	12	0	Name of contact person
26	ISLST	☐	ISLST	ISLST	CHAR	1	0	Solution Status
27	TKCAT	☐	TKCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Task Code Groups and Task Codes	TQ15
28	ACTCAT	☐	IACTCAT	COM_CATALOG	CHAR	2	0	SDB: Catalog type - Activity	TQ15
29	ISOLICON	☐	ISOLICON	SYCHAR40	CHAR	40	0	SDB: Long Text Icon for Solution
30	LINKICON	☐	ISOLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change
31	ITEMNR	☐	ITEMNR	ITEMNR	NUMC	4	0	SDB: Trigger Number	*
32	STTXT	☐	SDBSTTXT	TEXT40	CHAR	40	0	Status
33	ISOLSEL	☐	ISSELECT	SELKZ	CHAR	1	0	Selection
34	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	DITSL	ACTCAT	TQ15	KATALOGART
2	DITSL	CLIENT	T000	MANDT	KEY	1	CN
3	DITSL	ISLART	T0KBF	ISLART		1	CN
4	DITSL	ISLNR	ISOL	ISLNR	KEY	1	CN
5	DITSL	ISLTP	T0KBB	ISLTP	REF	C	CN
6	DITSL	LANGU	T002	SPRAS		1	CN
7	DITSL	RBNR	CRMC_SUBJPROFILE	SUBJECT_PROFILE		C	CN
8	DITSL	TKCAT	TQ15	KATALOGART

History

Last changed by/on	SAP	20130604
SAP Release Created in