SAP ABAP Table ISOL (SDB: Solution table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-SDB (Application Component) Solution Database
     ⤷ CSKN (Package) Customer Service: Knowledge Base Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ISOL	Table Relationship Diagram
Short Description	SDB: Solution table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ISLNR	☑	ISLNR	ISLNR	CHAR	12	0	Number of Solution Record
3	ISLVR	☑	ISOVER	ISOVER	NUMC	3	0	Solution Version Number
4	.INCLUDE	☐				0	0	SDB: Structure for Solution Table
5	ISLTP	☐	ISLTP	ISLTP	CHAR	2	0	Solution Type	T0KBB
6	RBNR	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
7	ISLART	☐	ISLART	CHAR2	CHAR	2	0	Solution Subtype	T0KBF
8	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
9	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
10	SL_VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
11	SL_VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
12	COPER	☐	COPER	USNAM	CHAR	12	0	Name of contact person
13	ISLST	☐	ISLST	ISLST	CHAR	1	0	Solution Status
14	TKCAT	☐	TKCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Task Code Groups and Task Codes	TQ15
15	ACTCAT	☐	IACTCAT	COM_CATALOG	CHAR	2	0	SDB: Catalog type - Activity	TQ15
16	.INCLUDE	☐				0	0	SDB: Create and change
17	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
18	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
19	ERTIM	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
20	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
21	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
22	AETIM	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
23	FLGDEL	☐	FLAGDEL	CHAR1	CHAR	1	0	Delete data record
24	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRM_ONR00
25	LEGACY_SOL_ID	☐	CRMT_SDB_LEGACY_SOLUTION	CHAR32	CHAR	32	0	ID of Solution/Problem in Legacy System
26	.INCLUDE	☐				0	0

Foreign Keys

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

History

Last changed by/on	SAP	20080418
SAP Release Created in