/SPE/DELTA_OBDLV_OUTPUT SAP (Delta Tool: Output of Outbound deliveries) Structure details
Description: Delta Tool: Output of Outbound deliveries
Related tables to /SPE/DELTA_OBDLV_OUTPUT
Access table /SPE/DELTA_OBDLV_OUTPUT
Structure field list including key, data, relationships and ABAP select examples
/SPE/DELTA_OBDLV_OUTPUT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Delta Tool: Output of Outbound deliveries" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_/SPE/DELTA_OBDLV_OUTPUT TYPE /SPE/DELTA_OBDLV_OUTPUT.
The /SPE/DELTA_OBDLV_OUTPUT table consists of various fields, each holding specific information or linking keys about Delta Tool: Output of Outbound deliveries data available in SAP. These include VLSTK (Distribution Status (Decentralized Warehouse Processing)), BESTK (Confirmation status), LGNUM (Warehouse Number / Warehouse Complex), KUNNR (Ship-to party).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP /SPE/DELTA_OBDLV_OUTPUT structure 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 |
| VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
| VLSTK | Distribution Status (Decentralized Warehouse Processing) | VLSTK | CHAR | 1 | VLSTK | ||||
| BESTK | Confirmation status | BESTK | CHAR | 1 | STATV | ||||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
| KUNNR | Ship-to party | KUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
| LFART | Delivery Type | LFART | CHAR | 4 | Assigned to domain | LFART | ALT | ||
| LFDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
| VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
| WBSTK | Total goods movement status | WBSTK | CHAR | 1 | STATV | ||||
| LIFEX | External Identification of Delivery Note | LIFEX | CHAR | 35 | TEXT35 | ||||
| POSNR | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| WERKS_D | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| LGMNG | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
| WBSTP | Goods movement status | WBSTA | CHAR | 1 | STATV | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| DELIV_NUMB | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
| DOCNO | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
| DOCID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
| ITEM_NUMBER | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
| ITEMNO | Data Element Type CHAR Length 35 | CHAR35 | CHAR | 35 | CHAR35 | ||||
| ITEMID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
| SHIP_TO_PARTY | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
| SO_NUMBER | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
| SO_ITEM | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
| GM_STATUSK | Total goods movement status | WBSTK | CHAR | 1 | STATV | ||||
| CHECKED_STATUS | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| STGE_LOC | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| DLV_QTY_STOCK | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
| BASE_UOM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| LGNUM_EWM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
| LOCNO | Location | /SPE/CIF_LOCNO | CHAR | 20 | /SPE/CIF_LOCNO | ||||
| GM_STATUSP | Goods movement status | WBSTA | CHAR | 1 | STATV |
| Key field | Non-key field |
How do I retrieve data from SAP structure /SPE/DELTA_OBDLV_OUTPUT using ABAP code?
As /SPE/DELTA_OBDLV_OUTPUT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SPE/DELTA_OBDLV_OUTPUT as there is no data to select.How to access SAP table /SPE/DELTA_OBDLV_OUTPUT
Within an ECC or HANA version of SAP you can also view further information about /SPE/DELTA_OBDLV_OUTPUT 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