SAP Table DITCA
SDB: Dialog Table Item cause
DITCA (SDB: Dialog Table Item cause) 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 DITCA to other SAP tables.
Source: DITCA (SDB: Dialog Table Item cause)
DITCA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| ISMNR | SDB: Symptom Number | ISMNR | ISMIT | CHAR | 12 | 0 | ||||||||
| ISMVR | SDB: Version Number | IVERSION | ISMIT | NUMC | 3 | 0 | ||||||||
| CACNT | SDB: Cause number in cause record | CACNT | NUMC | 4 | 0 | |||||||||
| ITEMNR | SDB: Trigger Number | ITEMNR | ISMIT | NUMC | 4 | 0 | ||||||||
| CACAT | SDB: Catalog type - Causes | CACAT | TQ15 | CHAR | 1 | 0 | ||||||||
| CAGRP | SDB: Code Group - Causes | CAGRP | QPGR | CHAR | 8 | 0 | ||||||||
| CACOD | SDB: Cause code | CACOD | QPCD | CHAR | 4 | 0 | ||||||||
| PRCNT | SDB: Problem damage number in problem damage record | IPRCNT | NUMC | 4 | 0 | |||||||||
| OPCNT | SDB: Problem location number in Problem record | IOPCNT | NUMC | 4 | 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 | |||||||||
| ITCASEL | Selection | SELECT | CHAR | 1 | 0 |
Possible values
|
||||||||
| TXTCAGRP | SDB: Descriptions (40 characters) | KBTXT40 | CHAR | 40 | 0 | |||||||||
| TXTCACOD | SDB: Descriptions (40 characters) | KBTXT40 | CHAR | 40 | 0 | |||||||||
| FLGUPD | SDB: Indicator to update the record | FLAGUPD | CHAR | 1 | 0 | |||||||||
DITCA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| DITCA | CACAT | DITCA | CACAT | TQ15 | Inspection catalog type index | KATALOGART |
| DITCA | CACAT | DITCA | CLIENT | TQ15 | Inspection catalog type index | MANDT |
| DITCA | CACOD | * | QPCD | Inspection catalog codes | VERSION | |
| DITCA | CACOD | DITCA | CACOD | QPCD | Inspection catalog codes | CODE |
| DITCA | CACOD | DITCA | CAGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
| DITCA | CACOD | DITCA | CACAT | QPCD | Inspection catalog codes | KATALOGART |
| DITCA | CACOD | DITCA | CLIENT | QPCD | Inspection catalog codes | MANDT |
| DITCA | CAGRP | DITCA | CAGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| DITCA | CAGRP | DITCA | CACAT | QPGR | Inspection catalog code groups | KATALOGART |
| DITCA | CAGRP | DITCA | CLIENT | QPGR | Inspection catalog code groups | MANDT |
| DITCA | CLIENT | DITCA | CLIENT | T000 | Clients | MANDT |
| DITCA | ISMNR | DITCA | ISMNR | ISMIT | SDB: Symptom Trigger | ISMNR |
| DITCA | ISMNR | DITCA | ITEMNR | ISMIT | SDB: Symptom Trigger | ITEMNR |
| DITCA | ISMNR | DITCA | ISMVR | ISMIT | SDB: Symptom Trigger | ISMVR |
| DITCA | ISMNR | DITCA | CLIENT | ISMIT | SDB: Symptom Trigger | CLIENT |
| DITCA | ISMVR | DITCA | ITEMNR | ISMIT | SDB: Symptom Trigger | ITEMNR |
| DITCA | ISMVR | DITCA | ISMVR | ISMIT | SDB: Symptom Trigger | ISMVR |
| DITCA | ISMVR | DITCA | ISMNR | ISMIT | SDB: Symptom Trigger | ISMNR |
| DITCA | ISMVR | DITCA | CLIENT | ISMIT | SDB: Symptom Trigger | CLIENT |
| DITCA | ITEMNR | DITCA | ITEMNR | ISMIT | SDB: Symptom Trigger | ITEMNR |
| DITCA | ITEMNR | DITCA | ISMVR | ISMIT | SDB: Symptom Trigger | ISMVR |
| DITCA | ITEMNR | DITCA | ISMNR | ISMIT | SDB: Symptom Trigger | ISMNR |
| DITCA | ITEMNR | DITCA | CLIENT | ISMIT | SDB: Symptom Trigger | CLIENT |
