SAP ABAP Table CRMT_BSP_SDB_NOTIF (Display Structure for Solution Database)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BSP_MODEL_IL_1O (Package) Model Implementation: Business Transaction

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_SDB_NOTIF	Table Relationship Diagram
Short Description	Display Structure for Solution Database

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

Foreign Keys

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

History

Last changed by/on	SAP	20130604
SAP Release Created in	500