DIESL2 SAP (Service packages per operation in the task list (2nd level)) Structure details
Description: Service packages per operation in the task list (2nd level)
Structure field list including key, data, relationships and ABAP select examples
DIESL2 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 "Service packages per operation in the task list (2nd level)" 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_DIESL2 TYPE DIESL2.
The DIESL2 table consists of various fields, each holding specific information or linking keys about Service packages per operation in the task list (2nd level) data available in SAP. These include FPACKNO (Parent package number), HPACKNO (Highest package number), KNUMV (Number of the document condition), EBELN (Purchasing Document Number).. 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 (character-type or numeric)
SAP DIESL2 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 |
FPACKNO | Parent package number | FPACKNO | NUMC | 10 | Assigned to domain | PACKNO | |||
HPACKNO | Highest package number | HPACKNO | NUMC | 10 | Assigned to domain | PACKNO | |||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | PACKNO | |||
INTROW | Line Number | NUMZEILE | NUMC | 10 | INTROW | ||||
EXTROW | Line Number | EXTROW | NUMC | 10 | NUMC10 | ||||
DEL | Deletion Indicator | DEL | CHAR | 1 | CHAR01 | ||||
SRVPOS | Activity Number | ASNUM | CHAR | 18 | ASMD | ALPHA | ASNUM | ASN | |
RANG | Hierarchy level of group | RANG | INT1 | 3 | INT1 | ||||
EXTGROUP | Outline Level | EXTGROUP | CHAR | 8 | CHAR8 | ||||
PACKAGE | Service Assignment | PACKAGE | CHAR | 1 | CHAR1 | ||||
SUB_PACKNO | Subpackage number | SUB_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
LBNUM | Short Description of Service Type | LBNUM | CHAR | 3 | CHAR3 | LBR | |||
AUSGB | Edition of Service Type | AUSGB | NUMC | 4 | NUMC4 | AGB | |||
STLVPOS | Standard Service Catalog Item | STLVPOS | CHAR | 18 | CHAR18 | ||||
EXTSRVNO | Vendor's Service Number | EXTSRVNO | CHAR | 18 | CHAR18 | ||||
MENGE | Quantity with Sign | MENGEV | QUAN | 13(3) | MENGV13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
UEBTO | Overfulfillment Tolerance | SUEBTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Unlimited Overfulfillment | SUEBTK | CHAR | 1 | XFELD | ||||
WITH_LIM | Also Search in Limits | WITH_LIM | CHAR | 1 | CHAR01 | ||||
SPINF | Update Conditions | KUPDATE | CHAR | 1 | XFELD | ||||
PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
BRTWR | Gross Price | SBRTWR | CURR | 11(2) | WERT11V | ||||
NETWR | Net Value of Item | SNETWR | CURR | 11(2) | WERT11V | ||||
FROMPOS | Lower Limit | FROMPOS | CHAR | 6 | CHAR6 | ||||
TOPOS | Upper Limit | TO_POS | CHAR | 6 | CHAR6 | ||||
KTEXT1 | Short Text | SH_TEXT1 | CHAR | 40 | TEXT40 | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
MOLGA | Country Grouping | MOLGA | CHAR | 2 | Assigned to domain | MOLGA | MOL | ||
LGART | Wage Type | LGART | CHAR | 4 | Assigned to domain | LGART | |||
LGTXT | Wage Type Long Text | LGTXT | CHAR | 25 | TEXT25 | ||||
STELL | Job | STELL | NUMC | 8 | Assigned to domain | STELL | |||
IFTNR | Sequence Number for CO/MM-SRV Interface Tables | IFTNR | NUMC | 10 | IFTNR | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
INSDT | Date on Which This Record was Stored in the Table | INSDT | DATS | 8 | DATUM | ||||
PLN_PACKNO | Source package number | PLN_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
PLN_INTROW | Entry: Planned package line | PLN_INTROW | NUMC | 10 | Assigned to domain | PACKNO | |||
KNT_PACKNO | Entry: Unplanned from contract | KNT_PACKNO | NUMC | 10 | ESLH | PACKNO | |||
KNT_INTROW | Entry: Unplanned from contract | KNT_INTROW | NUMC | 10 | INTROW | ||||
TMP_PACKNO | Entry: Unplanned service from model specifications | TMP_PACKNO | NUMC | 10 | NUMC10 | ||||
TMP_INTROW | Entry: Unplanned service from model specifications | TMP_INTROW | NUMC | 10 | NUMC10 | ||||
STLV_LIM | Service line refers to standard service catalog limits | STLV_LIM | CHAR | 1 | XFELD | ||||
LIMIT_ROW | Entry: Unplanned, limit line | LIMIT_ROW | NUMC | 10 | Assigned to domain | PACKNO | |||
ACT_MENGE | Purchase Order: Entered Quantity | ACT_MENGE | QUAN | 13(3) | MENG13V | ||||
ACT_WERT | Entered Value | ACT_WERT | CURR | 11(2) | WERT11V | ||||
KNT_WERT | Contract: Value Released (via Release Orders) | KNT_WERT | CURR | 11(2) | WERT11V | ||||
KNT_MENGE | Contract: Quantity Released (by Issue of Release Orders) | KNT_MENGE | QUAN | 13(3) | MENG13V | ||||
ZIELWERT | Target Value | WERT_ZIEL | CURR | 11(2) | WERT11 | ||||
UNG_WERT | Contract: Unplanned Released Value | UNG_WERT | CURR | 11(2) | WERT11V | ||||
UNG_MENGE | Contract: Unplanned Released Quantity | UNG_MENGE | QUAN | 13(3) | MENG13V | ||||
ALT_INTROW | Alternatives: Reference to basic item | ALT_INTROW | NUMC | 10 | INTROW | ||||
BASIC | Basic Line | GROUND | CHAR | 1 | CHAR01 | ||||
ALTERNAT | Alternative Line | ALTERNAT | CHAR | 1 | CHAR01 | ||||
BIDDER | Bidder's Line | BIDDER | CHAR | 1 | CHAR01 | ||||
SUPPLE | Supplementary Line | SUPPLE | CHAR | 1 | CHAR01 | ||||
FREEQTY | Line with Open Quantity | FREEQTY | CHAR | 1 | CHAR01 | ||||
INFORM | Informatory Line | INFORM | CHAR | 1 | CHAR01 | ||||
PAUSCH | Blanket Line | PAUSCHPOS | CHAR | 1 | CHAR01 | ||||
EVENTUAL | Contingency Line | EVENTUAL | CHAR | 1 | CHAR01 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
PRS_CHG | Price Change in Entry Sheet | PRS_CHG | CHAR | 1 | XFELD | ||||
MATKL | Material Group | MATKL_SRV | CHAR | 9 | T023 | MATKL | MKL | WBWG | |
TBTWR | Gross Price | SBRTWR | CURR | 11(2) | WERT11V | ||||
NAVNW | Non-deductible input tax | NAVNW_SRV | CURR | 11(2) | WERT11V | ||||
BASWR | Tax base amount | BASWR | CURR | 11(2) | WERT11 | ||||
KKNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
IWEIN | Unit for Work | IWEIN | UNIT | 3 | T006 | CUNIT | MEINS | ||
INT_WORK | Internal Work | INT_WORK | QUAN | 8(2) | INT_WORK | ||||
EXTERNALID | SRM Reference Key | SRMID | CHAR | 40 | |||||
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
ACT_WORK | Internal Work | INT_WORK | QUAN | 8(2) | INT_WORK | ||||
MAPNO | Mapping Field f. PACKNO, INTROW at Item Level for Commitment | MAPNO | NUMC | 4 | NUMC4 | ||||
SRVMAPKEY | Item Key for eSOA Messages | SRVMAPKEY | NUMC | 10 | |||||
.INCLU--AP | 0 | ||||||||
TAXTARIFFCODE | Tax Tariff Code | J_1B_TAX_TARIFF_CODE | CHAR | 16 | T604F | STEUC | |||
SDATE | Date | SIDATE | DATS | 8 | DATUM | ||||
BEGTIME | Start Time | BEGINUZ | TIMS | 6 | UZEIT | ||||
ENDTIME | End Time | ENDEUZ | TIMS | 6 | UZEIT | ||||
PERSEXT | External Personnel Number | PERSEXT | CHAR | 40 | TEXT40 | ||||
CATSCOUNTE | Counter for Records in Time Recording | CATSCOUNTE | CHAR | 12 | CHAR12 | ||||
STOKZ | Indicator: Document Has Been Reversed | CO_STOKZ | CHAR | 1 | FLAG | ||||
BELNR | Document Number | CATSBELNR | CHAR | 10 | ALPHA | BELNR | |||
FORMELNR | Formula Number | FORMELNR | CHAR | 10 | T167F | CHAR10 | |||
FRMVAL1 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL2 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL3 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL4 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
FRMVAL5 | Formula Value | FRMVAL | QUAN | 13(3) | MENGE | ||||
USERF1_NUM | User-Defined Field | USERF1_NUM | NUMC | 10 | NUMC10 | ||||
USERF2_NUM | User-Defined Field | USERF2_NUM | QUAN | 13(3) | MENGE | ||||
USERF1_TXT | User-Defined Field | USERF1_TXT | CHAR | 40 | TEXT40 | ||||
USERF2_TXT | User-Defined Field | USERF2_TXT | CHAR | 10 | TEXT10 | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
CHGTEXT | Short Text Change Allowed | CHGTEXT | CHAR | 1 | XFELD | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
KLVAR | Costing Variant | CK_KLVAR | CHAR | 4 | Assigned to domain | KLVAR | KRT | ||
.INCLU--AP | 0 | ||||||||
EXTDES | Line ID | EXTDES | CHAR | 10 | CHAR10 | ||||
BOSINTER | Internal line | BOSINTER | CHAR | 1 | CHAR01 | ||||
BOSGRP | Subcontractor group | BOSGRP | CHAR | 4 | TBOSGRP | BOSGRP | |||
BOS_RISK | Risk Line | BOS_RISK | CHAR | 1 | CHAR01 | ||||
BOS_ECP | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
CHGLTEXT | Change to Long Text Allowed | CHGLTEXT | CHAR | 1 | XFELD | ||||
BOSGRUPPENR | Group Number of Assignemnt Number for Execution Model | BOSGRUPPENR | NUMC | 3 | NUM3 | ||||
BOSLFDNR | Sequence Number of Assignemnt Number for Execution Model | BOSLFDNR | NUMC | 1 | BOSLFDNR | ||||
BOSDRUKZ | Print ID | BOSDRUKZ | CHAR | 1 | BOSDRUKZ | ||||
BOSSUPPLENO | Supplementary Number | BOSSUPPLENO | NUMC | 3 | NUM3 | ||||
BOSSUPPLESTATUS | Supplemetary Status | BOSSUPPLESTATUS | NUMC | 1 | TBOSSUPPLE | NUM1 | |||
/SAPBOQ/OBJTYPE | Object Category of Line in BOS | /SAPBOQ/OBJTYPE | CHAR | 1 | /SAPBOQ/OBJTYPE | ||||
/SAPBOQ/SPOSNR | Subitem Number | /SAPBOQ/SPOSNR | NUMC | 4 | /SAPBOQ/SPOSNR | ||||
/SAPBOQ/MINTROW | Line Number | NUMZEILE | NUMC | 10 | INTROW | ||||
/SAPBOQ/QT_REL | Service Entry Allowed for Subitem | /SAPBOQ/QT_REL | CHAR | 1 | CHAR01 | ||||
/SAPBOQ/CK_QTY | Lot Size for Costing | /SAPBOQ/CK_QTY | CHAR | 1 | XFELD | ||||
/SAPBOQ/M_FRATE | Flat Rate for the Main Item Defined | /SAPBOQ/MFLT_RATE | CHAR | 1 | XFELD | ||||
EXTREFKEY | External Reference Key for Service | EXTREFKEY | CHAR | 40 | CHAR_40 | ||||
INV_MENGE | Purchase Order: Quantity Entered from the Invoice | INV_MENGE | QUAN | 13(3) | MENG13V | ||||
.INCLU--AP | 0 | ||||||||
PER_SDATE | Period of Performance Start Date | MMSRV_PEROP_SDATE | DATS | 8 | DATS | ||||
PER_EDATE | Period of Performance End Date | MMSRV_PEROP_EDATE | DATS | 8 | DATS |
Key field | Non-key field |
How do I retrieve data from SAP structure DIESL2 using ABAP code?
As DIESL2 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 DIESL2 as there is no data to select.How to access SAP table DIESL2
Within an ECC or HANA version of SAP you can also view further information about DIESL2 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