1. Home
  2. Resources
  3. SAP Tables
  4. ISMP - SDB: Symptom table

SAP Table ISMP

SDB: Symptom table

ISMP (SDB: Symptom table) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ISMP to other SAP tables.

ISMP table fields

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

ISMP foreign key relationships

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