/SPE/DELTA_DELV SAP (Delta Tool: Results of delivery comparison) Table details
Dictionary Type: Table
Description: Delta Tool: Results of delivery comparison
Description: Delta Tool: Results of delivery comparison
ABAP Code to SELECT data from /SPE/DELTA_DELV
Related tables to /SPE/DELTA_DELV
Access table /SPE/DELTA_DELV
Related tables to /SPE/DELTA_DELV
Access table /SPE/DELTA_DELV
Table field list including key, data, relationships and ABAP select examples
/SPE/DELTA_DELV is a standard SAP Table which is used to store Delta Tool: Results of delivery comparison data and is available within R/3 SAP systems depending on the version and release level.
The /SPE/DELTA_DELV table consists of various fields, each holding specific information or linking keys about Delta Tool: Results of delivery comparison data available in SAP. These include RELID (Region in IMPORT/EXPORT Data Table), SRTFD (30 Characters), SRTF2 (Next record counter in EXPORT/IMPORT data tables), UNAME (User Name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP /SPE/DELTA_DELV table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| RELID | Region in IMPORT/EXPORT Data Table | INDX_RELID | CHAR | 2 | SYCHAR02 | ||||
| SRTFD | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INDX_SRTF2 | INT4 | 10 | SYBIN4 | ||||
| UNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
| ERDAT | Delta Tool: Date when results were saved | /SPE/DELTA_ERDAT | DATS | 8 | SYDATS | ||||
| ERZEIT | Delat Tool: Time when results were saved | /SPE/DELTA_ERZEIT | TIMS | 6 | SYTIME | ||||
| SELDAT | Delta Tool : Date of Selection | /SPE/DELTA_SELDAT | DATS | 8 | SYDATS | ||||
| SELZEIT | Delta Tool: Time of selection | /SPE/DELTA_SELZEIT | TIMS | 6 | SYTIME | ||||
| USER_COMMENT | Delta Tool: User comment entered | /SPE/DELTA_USERCMNT | CHAR | 50 | CHAR50 | ||||
| RESULTS_INB | Delta Tool: Number of incons. inbound deliveries | /SPE/DELTA_INB_WRONG | INT4 | 10 | INT4 | ||||
| RESULTS_OUTB | Delta Tool: Number of errors found | /SPE/DELTA_OUTB_WRONG | INT4 | 10 | INT4 | ||||
| CLUSTR | Length field for user data in EXPORT/IMPORT tables | INDX_CLSTR | INT2 | 5 | SYBIN2 | ||||
| CLUSTD | Data field for IMPORT/EXPORT database tables | INDX_CLUST | LRAW | 2886 | INDX_CLUST |
| Key field | Non-key field |
How do I retrieve data from SAP table /SPE/DELTA_DELV using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SPE/DELTA_DELV to SELECT all data from the tableDATA: WA_/SPE/DELTA_DELV TYPE /SPE/DELTA_DELV.
SELECT SINGLE *
FROM /SPE/DELTA_DELV
INTO CORRESPONDING FIELDS OF WA_/SPE/DELTA_DELV
WHERE...
How to access SAP table /SPE/DELTA_DELV
Within an ECC or HANA version of SAP you can also view further information about /SPE/DELTA_DELV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects