SAP table ISMP (SDB: Symptom table)

SAP table ISMP has 3 primary key fields being CLIENT,ISMNR,ISMVR.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
ISMNR SDB: Symptom Number CHAR 12 0 ISMNR
ISMVR SDB: Version Number NUMC 3 0 IVERSION
COPER SDB: Name of the Contact Person CHAR 12 0 COPER
ISMTP SDB: Symptom Type CHAR 2 0 T0KBA ISMTP
APPLAR SDB: Application Area CHAR 20 0 T0KBD APPLAR
ISMART SDB: Symptom Category CHAR 2 0 T0KBC ISMART
VALDTFRM SDB: Validation Date From DATS 8 0 VALDATFRM
VALDTTO SDB: Validation Date To DATS 8 0 VALDATTO
ISMCAT SDB: Catalog Type - Symptom CHAR 1 0 TQ15 ISMCAT
ISMGRP SDB: Symptom Code Group - Coding CHAR 8 0 QPGR ISMGRP
ISMCOD SDB: Coding CHAR 4 0 QPCD ISMCOD
ARTPR Priority Type CHAR 2 0 T356A ARTPR
PRIOK Priority CHAR 1 0 T356 PRIOK
ISMST SDB: Symptom Status CHAR 1 0 ISMST
1 Created
2 Released
RBNR Catalog Profile CHAR 9 0 T352B RBNR
OPCAT SDB: Catalog type - Problem Location CHAR 1 0 TQ15 OPCAT
PRCAT SDB: Catalog Type - Problem Damage CHAR 1 0 TQ15 PRCAT
CACAT SDB: Catalog type - Causes CHAR 1 0 TQ15 CACAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERTIM Time at Which Record Was Added TIMS 6 0 ERZEIT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Time of Change TIMS 6 0 AEZEIT
FLGDEL Delete Data Record CHAR 1 0 KZLOESCH
OBJNR Object Number for Status Management CHAR 22 0 ONR00 QMOBJNR

ISMP foreign key relationships

Table Field Check Table Check Field
0 ISMP APPLAR T0KBD SDB: Customizing Application Area CLIENT
0 ISMP APPLAR T0KBD SDB: Customizing Application Area APPLAR
1 ISMP ARTPR T356A Priority type table MANDT
1 ISMP ARTPR T356A Priority type table ARTPR
0 ISMP CACAT TQ15 Inspection catalog type index KATALOGART
1 ISMP CLIENT T000 Clients MANDT
0 ISMP ISMART T0KBC SDB: Customizing Symptom Category CLIENT
1 ISMP ISMCAT TQ15 Inspection catalog type index KATALOGART
0 ISMP ISMCOD QPCD Inspection catalog codes MANDT
0 ISMP ISMCOD QPCD Inspection catalog codes KATALOGART
0 ISMP ISMCOD QPCD Inspection catalog codes CODEGRUPPE
0 ISMP ISMCOD QPCD Inspection catalog codes CODE
0 ISMP ISMCOD QPCD Inspection catalog codes VERSION
1 ISMP ISMGRP QPGR Inspection catalog code groups MANDT
1 ISMP ISMGRP QPGR Inspection catalog code groups KATALOGART
0 ISMP ISMTP T0KBA SDB: Customizing Symptom Type CLIENT
0 ISMP ISMTP T0KBA SDB: Customizing Symptom Type ISMTP
1 ISMP OBJNR ONR00 General Object Number MANDT
0 ISMP OPCAT TQ15 Inspection catalog type index KATALOGART
1 ISMP PRCAT TQ15 Inspection catalog type index KATALOGART
0 ISMP PRIOK T356 Priorities MANDT
0 ISMP PRIOK T356 Priorities ARTPR
1 ISMP RBNR T352B Technical report MANDT