SAP ABAP Table DIESL1 (Service packages per operation in the task list (1st level))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ IPRM (Package) Application Development R/3 Preventive Maintenance
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ IPRM (Package) Application Development R/3 Preventive Maintenance
Basic Data
Table Category | INTTAB | Structure |
Structure | DIESL1 | Table Relationship Diagram |
Short Description | Service packages per operation in the task list (1st level) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Service Packages per Operation in Task List | |||||
2 | FPACKNO | FPACKNO | PACKNO | NUMC | 10 | 0 | Parent package number | * | |
3 | HPACKNO | HPACKNO | PACKNO | NUMC | 10 | 0 | Highest package number | * | |
4 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
5 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
6 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
7 | BSTYP | BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
8 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
9 | .INCLUDE | 0 | 0 | Lines of Service Package | |||||
10 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
11 | PACKNO | PACKNO | PACKNO | NUMC | 10 | 0 | Package number | ESLH | |
12 | INTROW | NUMZEILE | INTROW | NUMC | 10 | 0 | Line Number | ||
13 | EXTROW | EXTROW | NUMC10 | NUMC | 10 | 0 | Line Number | ||
14 | .INCLUDE | 0 | 0 | Data Fields for Service Lines | |||||
15 | DEL | DEL | CHAR01 | CHAR | 1 | 0 | Deletion Indicator | ||
16 | SRVPOS | ASNUM | ASNUM | CHAR | 18 | 0 | Activity Number | ASMD | |
17 | RANG | RANG | INT1 | INT1 | 3 | 0 | Hierarchy level of group | ||
18 | EXTGROUP | EXTGROUP | CHAR8 | CHAR | 8 | 0 | Outline Level | ||
19 | PACKAGE | PACKAGE | CHAR1 | CHAR | 1 | 0 | Service Assignment | ||
20 | SUB_PACKNO | SUB_PACKNO | PACKNO | NUMC | 10 | 0 | Subpackage number | ESLH | |
21 | LBNUM | LBNUM | CHAR3 | CHAR | 3 | 0 | Short Description of Service Type | ||
22 | AUSGB | AUSGB | NUMC4 | NUMC | 4 | 0 | Edition of Service Type | ||
23 | STLVPOS | STLVPOS | CHAR18 | CHAR | 18 | 0 | Standard Service Catalog Item | ||
24 | EXTSRVNO | EXTSRVNO | CHAR18 | CHAR | 18 | 0 | Vendor's Service Number | ||
25 | MENGE | MENGEV | MENGV13 | QUAN | 13 | 3 | Quantity with Sign | ||
26 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
27 | UEBTO | SUEBTO | PRZ21 | DEC | 3 | 1 | Overfulfillment Tolerance | ||
28 | UEBTK | SUEBTK | XFELD | CHAR | 1 | 0 | Unlimited Overfulfillment | ||
29 | WITH_LIM | WITH_LIM | CHAR01 | CHAR | 1 | 0 | Also Search in Limits | ||
30 | SPINF | KUPDATE | XFELD | CHAR | 1 | 0 | Update Conditions | ||
31 | PEINH | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
32 | BRTWR | SBRTWR | WERT11V | CURR | 11 | 2 | Gross Price | ||
33 | NETWR | SNETWR | WERT11V | CURR | 11 | 2 | Net Value of Item | ||
34 | FROMPOS | FROMPOS | CHAR6 | CHAR | 6 | 0 | Lower Limit | ||
35 | TOPOS | TO_POS | CHAR6 | CHAR | 6 | 0 | Upper Limit | ||
36 | KTEXT1 | SH_TEXT1 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
37 | VRTKZ | VRTKZ | VRTKZ | CHAR | 1 | 0 | Distribution indicator for multiple account assignment | ||
38 | TWRKZ | TWRKZ | TWRKZ | CHAR | 1 | 0 | Partial invoice indicator | ||
39 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
40 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | * | |
41 | LGART | LGART | LGART | CHAR | 4 | 0 | Wage Type | * | |
42 | LGTXT | LGTXT | TEXT25 | CHAR | 25 | 0 | Wage Type Long Text | ||
43 | STELL | STELL | STELL | NUMC | 8 | 0 | Job | * | |
44 | IFTNR | IFTNR | IFTNR | NUMC | 10 | 0 | Sequence Number for CO/MM-SRV Interface Tables | ||
45 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
46 | INSDT | INSDT | DATUM | DATS | 8 | 0 | Date on Which This Record was Stored in the Table | ||
47 | PLN_PACKNO | PLN_PACKNO | PACKNO | NUMC | 10 | 0 | Source package number | ESLH | |
48 | PLN_INTROW | PLN_INTROW | PACKNO | NUMC | 10 | 0 | Entry: Planned package line | * | |
49 | KNT_PACKNO | KNT_PACKNO | PACKNO | NUMC | 10 | 0 | Entry: Unplanned from contract | ESLH | |
50 | KNT_INTROW | KNT_INTROW | INTROW | NUMC | 10 | 0 | Entry: Unplanned from contract | ||
51 | TMP_PACKNO | TMP_PACKNO | NUMC10 | NUMC | 10 | 0 | Entry: Unplanned service from model specifications | ||
52 | TMP_INTROW | TMP_INTROW | NUMC10 | NUMC | 10 | 0 | Entry: Unplanned service from model specifications | ||
53 | STLV_LIM | STLV_LIM | XFELD | CHAR | 1 | 0 | Service line refers to standard service catalog limits | ||
54 | LIMIT_ROW | LIMIT_ROW | PACKNO | NUMC | 10 | 0 | Entry: Unplanned, limit line | * | |
55 | ACT_MENGE | ACT_MENGE | MENG13V | QUAN | 13 | 3 | Purchase Order: Entered Quantity | ||
56 | ACT_WERT | ACT_WERT | WERT11V | CURR | 11 | 2 | Entered Value | ||
57 | KNT_WERT | KNT_WERT | WERT11V | CURR | 11 | 2 | Contract: Value Released (via Release Orders) | ||
58 | KNT_MENGE | KNT_MENGE | MENG13V | QUAN | 13 | 3 | Contract: Quantity Released (by Issue of Release Orders) | ||
59 | ZIELWERT | WERT_ZIEL | WERT11 | CURR | 11 | 2 | Target Value | ||
60 | UNG_WERT | UNG_WERT | WERT11V | CURR | 11 | 2 | Contract: Unplanned Released Value | ||
61 | UNG_MENGE | UNG_MENGE | MENG13V | QUAN | 13 | 3 | Contract: Unplanned Released Quantity | ||
62 | ALT_INTROW | ALT_INTROW | INTROW | NUMC | 10 | 0 | Alternatives: Reference to basic item | ||
63 | BASIC | GROUND | CHAR01 | CHAR | 1 | 0 | Basic Line | ||
64 | ALTERNAT | ALTERNAT | CHAR01 | CHAR | 1 | 0 | Alternative Line | ||
65 | BIDDER | BIDDER | CHAR01 | CHAR | 1 | 0 | Bidder's Line | ||
66 | SUPPLE | SUPPLE | CHAR01 | CHAR | 1 | 0 | Supplementary Line | ||
67 | FREEQTY | FREEQTY | CHAR01 | CHAR | 1 | 0 | Line with Open Quantity | ||
68 | INFORM | INFORM | CHAR01 | CHAR | 1 | 0 | Informatory Line | ||
69 | PAUSCH | PAUSCHPOS | CHAR01 | CHAR | 1 | 0 | Blanket Line | ||
70 | EVENTUAL | EVENTUAL | CHAR01 | CHAR | 1 | 0 | Contingency Line | ||
71 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | T007A | |
72 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
73 | PRS_CHG | PRS_CHG | XFELD | CHAR | 1 | 0 | Price Change in Entry Sheet | ||
74 | MATKL | MATKL_SRV | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
75 | TBTWR | SBRTWR | WERT11V | CURR | 11 | 2 | Gross Price | ||
76 | NAVNW | NAVNW_SRV | WERT11V | CURR | 11 | 2 | Non-deductible input tax | ||
77 | BASWR | BASWR | WERT11 | CURR | 11 | 2 | Tax base amount | ||
78 | KKNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
79 | IWEIN | IWEIN | MEINS | UNIT | 3 | 0 | Unit for Work | T006 | |
80 | INT_WORK | INT_WORK | INT_WORK | QUAN | 8 | 2 | Internal Work | ||
81 | EXTERNALID | SRMID | CHAR | 40 | 0 | SRM Reference Key | |||
82 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | * | |
83 | ACT_WORK | INT_WORK | INT_WORK | QUAN | 8 | 2 | Internal Work | ||
84 | MAPNO | MAPNO | NUMC4 | NUMC | 4 | 0 | Mapping Field f. PACKNO, INTROW at Item Level for Commitment | ||
85 | SRVMAPKEY | SRVMAPKEY | NUMC | 10 | 0 | Item Key for eSOA Messages | |||
86 | .INCLU--AP | 0 | 0 | Country-specific enhancement of structure SRV_DATA | |||||
87 | .INCLUDE | 0 | 0 | Country-specific fields of service-line items | |||||
88 | TAXTARIFFCODE | J_1B_TAX_TARIFF_CODE | STEUC | CHAR | 16 | 0 | Tax Tariff Code | T604F | |
89 | .INCLUDE | 0 | 0 | Additional Fields: Service Line | |||||
90 | SDATE | SIDATE | DATUM | DATS | 8 | 0 | Date | ||
91 | BEGTIME | BEGINUZ | UZEIT | TIMS | 6 | 0 | Start Time | ||
92 | ENDTIME | ENDEUZ | UZEIT | TIMS | 6 | 0 | End Time | ||
93 | PERSEXT | PERSEXT | TEXT40 | CHAR | 40 | 0 | External Personnel Number | ||
94 | CATSCOUNTE | CATSCOUNTE | CHAR12 | CHAR | 12 | 0 | Counter for Records in Time Recording | ||
95 | STOKZ | CO_STOKZ | FLAG | CHAR | 1 | 0 | Indicator: Document Has Been Reversed | ||
96 | BELNR | CATSBELNR | BELNR | CHAR | 10 | 0 | Document number | ||
97 | FORMELNR | FORMELNR | CHAR10 | CHAR | 10 | 0 | Formula Number | T167F | |
98 | FRMVAL1 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
99 | FRMVAL2 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
100 | FRMVAL3 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
101 | FRMVAL4 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
102 | FRMVAL5 | FRMVAL | MENGE | QUAN | 13 | 3 | Formula Value | ||
103 | USERF1_NUM | USERF1_NUM | NUMC10 | NUMC | 10 | 0 | User-Defined Field | ||
104 | USERF2_NUM | USERF2_NUM | MENGE | QUAN | 13 | 3 | User-Defined Field | ||
105 | USERF1_TXT | USERF1_TXT | TEXT40 | CHAR | 40 | 0 | User-Defined Field | ||
106 | USERF2_TXT | USERF2_TXT | TEXT10 | CHAR | 10 | 0 | User-Defined Field | ||
107 | KNOBJ | KNOBJ | KNOBJ | NUMC | 18 | 0 | Number of Object with Assigned Dependencies | ||
108 | CHGTEXT | CHGTEXT | XFELD | CHAR | 1 | 0 | Short Text Change Allowed | ||
109 | .INCLUDE | 0 | 0 | ||||||
110 | .INCLUDE | 0 | 0 | Fields for Unit Costing | |||||
111 | KALNR | CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure | * | |
112 | KLVAR | CK_KLVAR | KLVAR | CHAR | 4 | 0 | Costing Variant | * | |
113 | EXTREFKEY | EXTREFKEY | CHAR_40 | CHAR | 40 | 0 | External Reference Key for Service | ||
114 | INV_MENGE | INV_MENGE | MENG13V | QUAN | 13 | 3 | Purchase Order: Quantity Entered from the Invoice | ||
115 | .INCLU--AP | 0 | 0 | ESLL Period of Performance | |||||
116 | PER_SDATE | MMSRV_PEROP_SDATE | DATS | DATS | 8 | 0 | Period of Performance Start Date | ||
117 | PER_EDATE | MMSRV_PEROP_EDATE | DATS | DATS | 8 | 0 | Period of Performance End Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | DIESL1 | FORMELNR | T167F | FORMELNR | KEY | 1 | CN |
2 | DIESL1 | IWEIN | T006 | MSEHI | |||
3 | DIESL1 | KNT_PACKNO | ESLH | PACKNO | |||
4 | DIESL1 | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | DIESL1 | MATKL | T023 | MATKL | 1 | CN | |
6 | DIESL1 | MEINS | T006 | MSEHI | |||
7 | DIESL1 | MWSKZ | T007A | MWSKZ | KEY | 1 | CN |
8 | DIESL1 | PACKNO | ESLH | PACKNO | KEY | 1 | CN |
9 | DIESL1 | PLN_PACKNO | ESLH | PACKNO | |||
10 | DIESL1 | SRVPOS | ASMD | ASNUM | KEY | 1 | CN |
11 | DIESL1 | SUB_PACKNO | ESLH | PACKNO | |||
12 | DIESL1 | TAXTARIFFCODE | T604F | STEUC | KEY | 1 | CN |
13 | DIESL1 | TXJCD | TTXJ | TXJCD | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |