J_1IITMDTL SAP (Item Details - for Capital goods and subcontracting) Table details

Dictionary Type: Table
Description: Item Details - for Capital goods and subcontracting




ABAP Code to SELECT data from J_1IITMDTL
Related tables to J_1IITMDTL
Access table J_1IITMDTL




Table field list including key, data, relationships and ABAP select examples

J_1IITMDTL is a standard SAP Table which is used to store Item Details - for Capital goods and subcontracting data and is available within R/3 SAP systems depending on the version and release level.

The J_1IITMDTL table consists of various fields, each holding specific information or linking keys about Item Details - for Capital goods and subcontracting data available in SAP. These include TRNTYP (Excise Transaction Type), MJAHR (Material Document Year), MBLNR (Number of Material Document), ZEILE (Line 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1IITMDTL 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
MANDTClient MANDTCLNT3T000MANDT
TRNTYPExcise Transaction Type J_1ITRNTYPCHAR4J_1ITRANJ_1ITRNTYP
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
ZEILELine Number DZEILENUMC3ZEILEPOS
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
MENGEQuantity MENGE_DQUAN13(3) MENG13
RMENGEQuantity remaining to be sold/installed J_1IRMENGEQUAN13(3) MENGE
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
CHAPIDChapter ID J_1ICHIDCHAR12CHAR12
EXCURCurrency J_1IEXCCURCUKY5TCURCWAERS
EXBEDBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
EXSEDSpecial Excise Duty J_1IEXCSEDCURR13(2) WERT7
EXAEDAdditional Excise Duty J_1IEXCAEDCURR13(2) WERT7
STATUSMaterial Type J_1ICAPINDCHAR1J_1ICAPIND
RDOC1Reference document J_1IREFDOCCHAR12CHAR12
RYEAR1Reference year 1 J_1IRYEAR1CHAR4CHAR4
RIND1Reference Document Type 1 J_1IRIND1CHAR1J_1IRIND
RDOC2Reference Document 2 J_1IRDOC2CHAR10CHAR10
RYEAR2Reference year 2 J_1IRYEAR2CHAR4CHAR4
RIND2Reference Document Type 2 J_1IRIND2CHAR1J_1IRIND
SERIAL1Register Entry Serial Number J_1ISRLNO1NUMC10NUMC10
SYEAR1Year of Register Entry J_1IYEARNUMC4NUMC4
SERIAL2Serial Number J_1ISRLNO2NUMC10NUMC10
SYEAR2Year of Register Entry J_1IYEARNUMC4NUMC4
USNAMChanged by the user J_1IUSNAMCCHAR12CHAR12
CPUDTExcise Document Entry Date J_1ICPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT

Key field Non-key field



How do I retrieve data from SAP table J_1IITMDTL using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1IITMDTL to SELECT all data from the table
DATA: WA_J_1IITMDTL TYPE J_1IITMDTL.

SELECT SINGLE *
FROM J_1IITMDTL
INTO CORRESPONDING FIELDS OF WA_J_1IITMDTL
WHERE...

How to access SAP table J_1IITMDTL

Within an ECC or HANA version of SAP you can also view further information about J_1IITMDTL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!