SAP table EDIDS (Status Record (IDoc))
SAP table EDIDS has 5 primary key fields being MANDT,DOCNUM,LOGDAT,LOGTIM,COUNTR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |||||||||||
| DOCNUM | IDoc number | NUMC | 16 | 0 | EDI_DOCNUM | ||||||||||||
| LOGDAT | Date of status information | DATS | 8 | 0 | EDI_LOGDAT | ||||||||||||
| LOGTIM | Time of status information | TIMS | 6 | 0 | EDI_LOGTIM | ||||||||||||
| COUNTR | IDoc status counter | NUMC | 16 | 0 | EDI_COUNTR | ||||||||||||
| CREDAT | Date status record was created | DATS | 8 | 0 | EDI_CREDAT | ||||||||||||
| CRETIM | Time status record was created | TIMS | 6 | 0 | EDI_CRETIM | ||||||||||||
| STATUS | Status of IDoc | CHAR | 2 | 0 | * | EDI_STATUS | |||||||||||
| UNAME | User Name | CHAR | 12 | 0 | EDI_UNAME | ||||||||||||
| REPID | Program Name | CHAR | 30 | 0 | EDI_REPID | ||||||||||||
| ROUTID | Name of subroutine (routine, function module) | CHAR | 30 | 0 | EDI_ROUTID | ||||||||||||
| STACOD | Status code | CHAR | 8 | 0 | EDI_STACOD | ||||||||||||
| STATXT | Text for status code | CHAR | 70 | 0 | EDI_STATX_ | ||||||||||||
| SEGNUM | Number of SAP segment | NUMC | 6 | 0 | IDOCSSGNUM | ||||||||||||
| SEGFLD | Field Name in SAP Segment | CHAR | 30 | 0 | EDI_SEGFLD | ||||||||||||
| STAPA1 | Parameter 1 | CHAR | 50 | 0 | EDI_STAPA1 | ||||||||||||
| STAPA2 | Parameter 2 | CHAR | 50 | 0 | EDI_STAPA2 | ||||||||||||
| STAPA3 | Parameter 3 | CHAR | 50 | 0 | EDI_STAPA3 | ||||||||||||
| STAPA4 | Parameter 4 | CHAR | 50 | 0 | EDI_STAPA4 | ||||||||||||
| STATYP | Type of system error message (A, W, E, S, I) | CHAR | 1 | 0 | EDI_SYMSTY |
|
|||||||||||
| STAMQU | Status message qualifier | CHAR | 3 | 0 | EDI_STAMQU | ||||||||||||
| STAMID | Status message ID | CHAR | 20 | 0 | EDI_STAMID | ||||||||||||
| STAMNO | Status message number | NUMC | 3 | 0 | EDI_STAMNO | ||||||||||||
| TID | Transaction ID | CHAR | 24 | 0 | EDI_TID | ||||||||||||
| APPL_LOG | Application Log | CHAR | 20 | 0 | EDI_ALOG | ||||||||||||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |