SAP ABAP Table DIASTSOL (DIA: Statistical update structure for solution links)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-IIA (Application Component) Interactive Intelligent Agent
     ⤷ DIA (Package) IIA: Distributed Intelligent Agent

Basic Data

Table Category	INTTAB	Structure
Structure	DIASTSOL	Table Relationship Diagram
Short Description	DIA: Statistical update structure for solution links

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	ISLTXT	☐	ISLTEXT	TEXT40	CHAR	40	0	Solution Description
30	RISLNR	☐	RISLNR	ISLNR	CHAR	12	0	Reference Solution Number	*
31	RISLVR	☐	RISLVR	ISLVER	CHAR	3	0	Reference Solution Version Number
32	SISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
33	SISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
34	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
35	RBNRX	☐	RBNRTX	TEXT30	CHAR	30	0	Subject Profile Description
36	STTXT	☐	SDBSTTXT	TEXT40	CHAR	40	0	Status
37	USTAX	☐	SDBASTEX	KREUZ	CHAR	1	0	Active User Status
38	USTTXT	☐	SDBASTTX	CHAR40	CHAR	40	0	User Status
39	ISLSTX	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
40	ISOLTX	☐	ISOLTX	TEXT40	CHAR	40	0	Solution Type Description
41	TXTSLART	☐	TXTSLART	TEXT40	CHAR	40	0	Solution Subtype Description
42	ACTYP	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
43	ISOLICON	☐	ISOLICON	SYCHAR40	CHAR	40	0	SDB: Long Text Icon for Solution
44	ISOSICON	☐	ISSMICON	SYCHAR40	CHAR	40	0	SDB: Dynamic Icon for Status Management
45	LINKICON	☐	ISOLINK	SYCHAR40	CHAR	40	0	SDB: Icon Used in Initial Screen to Display/Change
46	ITEMNR	☐	ITEMNR	ITEMNR	NUMC	4	0	SDB: Trigger Number	*
47	FLGPOST	☐	FLAGUPD	CHAR1	CHAR	1	0	Update data record
48	FLGUPD	☐	FLAGUPD	CHAR1	CHAR	1	0	Update data record
49	TKCNT	☐	INT4	INT4	INT4	10	0	Natural number
50	ACTCNT	☐	INT4	INT4	INT4	10	0	Natural number
51	ICONEXP	☐	ICONEXP	SYCHAR40	CHAR	40	0	SDB: Icon to Toggle between Expanded and Collapsed Screens
52	LISLNR	☐	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record	*
53	LISLVR	☐	ISOVER	ISOVER	NUMC	3	0	Solution Version Number	*
54	FLGCAL	☐	FLGCAL	CHAR1	CHAR	1	0	SDB: Indicator to show from where it is called
55	IACOUNT	☐	IAFLTP	IAFLOAT	FLTP	16	16	DIA: Floating point format
56	IAFPCOUNT	☐	IAFLTP	IAFLOAT	FLTP	16	16	DIA: Floating point format
57	IAFNCOUNT	☐	IAFLTP	IAFLOAT	FLTP	16	16	DIA: Floating point format
58	IAERRSUM	☐	IAFLTP	IAFLOAT	FLTP	16	16	DIA: Floating point format

Foreign Keys

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

History

Last changed by/on	SAP	20100420
SAP Release Created in