SAP ABAP Table ISMTXT (SDB: Problem Short Text)

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	ISMTXT	Table Relationship Diagram
Short Description	SDB: Problem Short Text

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	ISMP
3	ISMVR	☑	IVERSION	IVERSION	NUMC	3	0	Version Number	ISMP
4	LANGU	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	ISMTXT	☐	ISMTEXT	TEXT40	CHAR	40	0	Problem Description
6	INDLTXT	☐	INDLTXT	CHAR1	CHAR	1	0	Long Text
7	TRSTAT	☐	TRSTAT	CHAR1	CHAR	1	0	Translation status for text fields
8	.INCLUDE	☐				0	0	SDB: Create and change
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	ERTIM	☐	ER_TIME	UHRZT	TIMS	6	0	Time at which record was created
12	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
14	AETIM	☐	AETIME	UHRZT	TIMS	6	0	Time at which record was changed
15	FLGDEL	☐	FLAGDEL	CHAR1	CHAR	1	0	Delete data record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISMTXT	CLIENT	T000	MANDT	KEY	1	CN
2	ISMTXT	ISMNR	ISMP	ISMNR	KEY	1	CN
3	ISMTXT	ISMVR	ISMP	ISMVR	TEXT	1	CN
4	ISMTXT	LANGU	T002	SPRAS		1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in