ISMP

SDB: Symptom table | #masterdata | Component: Knowledge Base

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (6)
☰ Categorical (1)
Other (4)
🔗 Relations (14)

Column Name	Description
CLIENT FK	Client
ISMNR	SDB: Symptom Number
ISMVR	SDB: Version Number

Column Name	Description

Column Name	Description

Column Name	Description
VALDTFRM	SDB: Validation Date From
VALDTTO	SDB: Validation Date To
ERDAT	Date on which the record was created
ERTIM	Time at Which Record Was Added
AEDAT	Last Changed On
AETIM	Time of Change

Column Name	Description
ISMST	SDB: Symptom Status	Show values

Column Name	Description	Domain name
COPER	SDB: Name of the Contact Person	USNAM
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
FLGDEL	Delete Data Record	CHAR1

Master Data Relations	Join Conditions
SDB: Application Area SDB: Application Area Client	`ISMP.APPLAR == T0KBD.APPLAR` `ISMP.CLIENT == T0KBD.CLIENT`
Priority Type	`ISMP.CLIENT == T356A.MANDT` `ISMP.ARTPR == T356A.ARTPR`
SDB: Catalog type - Causes ? SDB: Catalog type - Causes	`ISMP.[column in domain "MANDT"] == TQ15.MANDT` `ISMP.CACAT == TQ15.KATALOGART`
Client	`ISMP.CLIENT == T000.MANDT`
SDB: Symptom Category SDB: Symptom Type SDB: Symptom Category	`ISMP.CLIENT == T0KBC.CLIENT` `ISMP.ISMTP == T0KBC.ISMTP` `ISMP.ISMART == T0KBC.ISMART`
SDB: Catalog Type - Symptom	`ISMP.CLIENT == TQ15.MANDT` `ISMP.ISMCAT == TQ15.KATALOGART`
SDB: Coding SDB: Catalog Type - Symptom SDB: Coding SDB: Symptom Code Group - Coding ?	`ISMP.CLIENT == QPCD.MANDT` `ISMP.ISMCAT == QPCD.KATALOGART` `ISMP.ISMCOD == QPCD.CODE` `ISMP.ISMGRP == QPCD.CODEGRUPPE` `ISMP.[column in domain "QVERSNR"] == QPCD.VERSION`
SDB: Symptom Code Group - Coding SDB: Catalog Type - Symptom Client SDB: Symptom Code Group - Coding	`ISMP.ISMCAT == QPGR.KATALOGART` `ISMP.CLIENT == QPGR.MANDT` `ISMP.ISMGRP == QPGR.CODEGRUPPE`
SDB: Symptom Type SDB: Symptom Type Client	`ISMP.ISMTP == T0KBA.ISMTP` `ISMP.CLIENT == T0KBA.CLIENT`
SDB: Catalog type - Problem Location ? SDB: Catalog type - Problem Location	`ISMP.[column in domain "MANDT"] == TQ15.MANDT` `ISMP.OPCAT == TQ15.KATALOGART`
SDB: Catalog Type - Problem Damage ? SDB: Catalog Type - Problem Damage	`ISMP.[column in domain "MANDT"] == TQ15.MANDT` `ISMP.PRCAT == TQ15.KATALOGART`
Priority Priority Type Client Priority	`ISMP.ARTPR == T356.ARTPR` `ISMP.CLIENT == T356.MANDT` `ISMP.PRIOK == T356.PRIOK`
Catalog Profile	`ISMP.CLIENT == T352B.MANDT` `ISMP.RBNR == T352B.RBNR`