SAP Table J_1IITMDTL
Item Details - for Capital goods and subcontracting
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table J_1IITMDTL (Item Details - for Capital goods and subcontracting) is a standard table in SAP ERP. It belongs to the package J1I2.
Technical Information
| Table | J_1IITMDTL |
| Short Text | Item Details - for Capital goods and subcontracting |
| Package | J1I2 |
| Table Type | Transparent Table |
Fields for Table J_1IITMDTL
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| TRNTYP | ✔ | Excise Transaction Type | J_1ITRNTYP | CHAR | 4 | J_1ITRAN |
| MJAHR | ✔ | Material Document Year | MJAHR | NUMC | 4 | |
| MBLNR | ✔ | Number of Material Document | MBLNR | CHAR | 10 | |
| ZEILE | ✔ | Line Number | DZEILE | NUMC | 3 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | |
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | |
| WERKS | Plant | WERKS_D | CHAR | 4 | T001W | |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | |
| MENGE | Quantity | MENGE_D | QUAN | 13 | ||
| RMENGE | Quantity remaining to be sold/installed | J_1IRMENGE | QUAN | 13 | ||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| CHAPID | Chapter ID | J_1ICHID | CHAR | 12 | ||
| EXCUR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | |
| EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 13 | ||
| EXSED | Special Excise Duty | J_1IEXCSED | CURR | 13 | ||
| EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 13 | ||
| STATUS | Material Type | J_1ICAPIND | CHAR | 1 | ||
| RDOC1 | Reference document | J_1IREFDOC | CHAR | 12 | ||
| RYEAR1 | Reference year 1 | J_1IRYEAR1 | CHAR | 4 | ||
| RIND1 | Reference Document Type 1 | J_1IRIND1 | CHAR | 1 | ||
| RDOC2 | Reference Document 2 | J_1IRDOC2 | CHAR | 10 | ||
| RYEAR2 | Reference year 2 | J_1IRYEAR2 | CHAR | 4 | ||
| RIND2 | Reference Document Type 2 | J_1IRIND2 | CHAR | 1 | ||
| SERIAL1 | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 10 | ||
| SYEAR1 | Year of Register Entry | J_1IYEAR | NUMC | 4 | ||
| SERIAL2 | Serial Number | J_1ISRLNO2 | NUMC | 10 | ||
| SYEAR2 | Year of Register Entry | J_1IYEAR | NUMC | 4 | ||
| USNAM | Changed by the user | J_1IUSNAMC | CHAR | 12 | ||
| CPUDT | Excise Document Entry Date | J_1ICPUDT | DATS | 8 | ||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 |