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
|
|
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 |