SAP ABAP Table ISMP (SDB: Problem 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	ISMP	Table Relationship Diagram
Short Description	SDB: Problem 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	ISMNR	☑	ISMNR	ISMNR	CHAR	12	0	Number of Problem Record
3	ISMVR	☑	IVERSION	IVERSION	NUMC	3	0	Version Number
4	.INCLUDE	☐				0	0	SDB: Structure for Problem Table
5	COPER	☐	COPER	USNAM	CHAR	12	0	Name of contact person
6	ISMTP	☐	ISMTP	ISMPT	CHAR	2	0	Problem Type	T0KBA
7	APPLAR	☐	APPLAR	CHAR20	CHAR	20	0	Application Area	T0KBD
8	ISMART	☐	ISMART	ISMART	CHAR	2	0	Problem Subtype	T0KBC
9	VALDTFRM	☐	VALDATFRM	SYDATS	DATS	8	0	Valid-From Date
10	VALDTTO	☐	VALDATTO	SYDATS	DATS	8	0	Valid-To Date
11	ISMCAT	☐	ISMCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Problem Code Groups and Problem Codes	TQ15
12	ISMGRP	☐	ISMGRP	QCODEGRP	CHAR	8	0	Problem Code Group	QPGR
13	ISMCOD	☐	ISMCOD	QCODE	CHAR	4	0	Problem Code	QPCD
14	ARTPR	☐	TYPPR	TYPPR	CHAR	2	0	Priority Type	T0KBH
15	PRIOK	☐	SDB_PRIOR	SDB_PRIOR	CHAR	1	0	Priority Level	T0KBG
16	ISMST	☐	ISMST	ISMST	CHAR	1	0	Solution Database: Problem Status
17	RBNR	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
18	OPCAT	☐	OPCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Location Code Groups and Location Codes	TQ15
19	PRCAT	☐	PRCAT	COM_CATALOG	CHAR	2	0	Catalog Containing Damage Code Groups and Damage Codes	TQ15
20	CACAT	☐	CACAT	COM_CATALOG	CHAR	2	0	Catalog Containing Cause Code Groups and Cause Codes	TQ15
21	.INCLUDE	☐				0	0	SDB: Create and change
22	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
23	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
24	ERTIM	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
25	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
26	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
27	AETIM	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
28	FLGDEL	☐	FLAGDEL	CHAR1	CHAR	1	0	Delete data record
29	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRM_ONR00
30	LEGACY_SYM_ID	☐	CRMT_SDB_LEGACY_SOLUTION	CHAR32	CHAR	32	0	ID of Solution/Problem in Legacy System
31	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISMP	APPLAR	T0KBD	APPLAR		1	CN
2	ISMP	ARTPR	T0KBH	ARTPR
3	ISMP	CACAT	TQ15	KATALOGART
4	ISMP	CLIENT	T000	MANDT	KEY	1	CN
5	ISMP	ISMART	T0KBC	ISMART		1	CN
6	ISMP	ISMCAT	TQ15	KATALOGART
7	ISMP	ISMCOD	QPCD	CODE
8	ISMP	ISMGRP	QPGR	CODEGRUPPE
9	ISMP	ISMTP	T0KBA	ISMTP	REF	C	CN
10	ISMP	OBJNR	CRM_ONR00	OBJNR	REF	C	CN
11	ISMP	OPCAT	TQ15	KATALOGART
12	ISMP	PRCAT	TQ15	KATALOGART
13	ISMP	PRIOK	T0KBG	PRIOK	REF	C	CN
14	ISMP	RBNR	CRMC_SUBJPROFILE	SUBJECT_PROFILE		C	CN

History

Last changed by/on	SAP	20030225
SAP Release Created in