SAP ABAP Table CRMT_DITSSL (Structure for Details and Long Texts for a Solution)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISE (Application Component) Internet Service
     ⤷ CRM_SERVICE_REQUEST_IAC1 (Package) CRM: Service Request Transaction for WEB (1), W/O DB Update

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_DITSSL	Table Relationship Diagram
Short Description	Structure for Details and Long Texts for a 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: Dialog Table Solution Linked to an Item
2	ISOLSEL	☐	SELECT	SELKZ	CHAR	1	0	Selection
3	.INCLUDE	☐				0	0	SDB: Solution Short Text Table
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	ISOL
6	ISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
7	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
8	ISLTXT	☐	ISLTEXT	TEXT40	CHAR	40	0	Solution Description
9	INDLTXT	☐	INDLTXT	CHAR1	CHAR	1	0	Long Text
10	TRSTAT	☐	TRSTAT	CHAR1	CHAR	1	0	Translation status for text fields
11	.INCLUDE	☐				0	0	SDB: Create and change
12	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
13	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
14	ERTIM	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AETIM	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
18	FLGDEL	☐	FLAGDEL	CHAR1	CHAR	1	0	Delete data record
19	.INCLUDE	☐				0	0	SDB: Structure for Solution Table
20	ISLTP	☐	ISLTP	ISLTP	CHAR	2	0	Solution Type	T0KBB
21	RBNR	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
22	ISLART	☐	ISLART	CHAR2	CHAR	2	0	Solution Subtype	T0KBF
23	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
24	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
25	SL_VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
26	SL_VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
27	COPER	☐	COPER	USNAM	CHAR	12	0	Name of contact person
28	ISLST	☐	ISLST	ISLST	CHAR	1	0	Solution Status
29	TKCAT	☐	TKCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Task Code Groups and Task Codes	TQ15
30	ACTCAT	☐	IACTCAT	COM_CATALOG	CHAR	2	0	SDB: Catalog type - Activity	TQ15
31	ISOLICON	☐	ISOLICON	SYCHAR40	CHAR	40	0	SDB: Long Text Icon for Solution
32	LINKCHANGE	☐	ISOLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change
33	LINKICON	☐	ISOLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change
34	ITEMNR	☐	ITEMNR	ITEMNR	NUMC	4	0	SDB: Trigger Number	*
35	SCORE	☐	ISMSCORE		DEC	7	3	SDB: Score (weight) returned form the search engine
36	FLGUPD	☐	FLAGUPD	CHAR1	CHAR	1	0	Update data record
37	LINKINX	☐	SYTABIX	SYST_LONG	INT4	10	0	Row Index of Internal Tables
38	STTXT	☐	SDBSTTXT	TEXT40	CHAR	40	0	Status
39	EXPTEXT	☐	EXPTEXT	TEXT40	CHAR	40	0	SDB: Explanation Text for Search Match
40	SOLTYTXT	☐	ISOLTX	TEXT40	CHAR	40	0	Solution Type Description
41	SOLCATXT	☐	TXTSLART	TEXT40	CHAR	40	0	Solution Subtype Description
42	SOLSTTXT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
43	ISOLTX	☐	ISOLTX	TEXT40	CHAR	40	0	Solution Type Description
44	TXTSLART	☐	TXTSLART	TEXT40	CHAR	40	0	Solution Subtype Description
45	TXTLONG	☐	CRMT_TXTLONG		CHAR	256	0	Excerpt from Long Text (356 Bytes)
46	ATT_TYPE	☐	ATTTP	ATTTP	CHAR	10	0	Attachment type
47	ATT_URL	☐	CHAR1024	CHARA1024	CHAR	1024	0	Character 1024
48	ATT_DESC	☐	ATTDESC	CHAR80	CHAR	80	0	Attachment Description
49	ATT_SIZE	☐	BDS_COMPSI	NUM12	NUMC	12	0	Business Document Service: Component size
50	ATT_EXT	☐	FILE_EXT	CHAR4	CHAR	4	0	File extensions for docu. elements in the Reuse Library

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_DITSSL	ACTCAT	TQ15	KATALOGART
2	CRMT_DITSSL	CLIENT	T000	MANDT	KEY	1	CN
3	CRMT_DITSSL	ISLART	T0KBF	ISLART		1	CN
4	CRMT_DITSSL	ISLNR	ISOL	ISLNR	KEY	1	CN
5	CRMT_DITSSL	ISLTP	T0KBB	ISLTP	REF	C	CN
6	CRMT_DITSSL	LANGU	T002	SPRAS		1	CN
7	CRMT_DITSSL	RBNR	CRMC_SUBJPROFILE	SUBJECT_PROFILE		C	CN
8	CRMT_DITSSL	TKCAT	TQ15	KATALOGART

History

Last changed by/on	SAP	20130604
SAP Release Created in	20B