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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J1I2 (Package) India, Phase II

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1IITMDTL	Table Relationship Diagram
Short Description	Item Details - for Capital goods and subcontracting

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	TRNTYP	☑	J_1ITRNTYP	J_1ITRNTYP	CHAR	4	0	Excise Transaction Type	J_1ITRAN
3	MJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
4	MBLNR	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
5	ZEILE	☑	DZEILE	ZEILE	NUMC	3	0	Line Number
6	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
10	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
11	RMENGE	☐	J_1IRMENGE	MENGE	QUAN	13	3	Quantity remaining to be sold/installed
12	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
13	CHAPID	☐	J_1ICHID	CHAR12	CHAR	12	0	Chapter ID
14	EXCUR	☐	J_1IEXCCUR	WAERS	CUKY	5	0	Currency	TCURC
15	EXBED	☐	J_1IEXCBED	WERT7	CURR	13	2	Basic Excise Duty
16	EXSED	☐	J_1IEXCSED	WERT7	CURR	13	2	Special Excise Duty
17	EXAED	☐	J_1IEXCAED	WERT7	CURR	13	2	Additional Excise Duty
18	STATUS	☐	J_1ICAPIND	J_1ICAPIND	CHAR	1	0	Material Type
19	RDOC1	☐	J_1IREFDOC	CHAR12	CHAR	12	0	Reference document
20	RYEAR1	☐	J_1IRYEAR1	CHAR4	CHAR	4	0	Reference year 1
21	RIND1	☐	J_1IRIND1	J_1IRIND	CHAR	1	0	Reference Document Type 1
22	RDOC2	☐	J_1IRDOC2	CHAR10	CHAR	10	0	Reference Document 2
23	RYEAR2	☐	J_1IRYEAR2	CHAR4	CHAR	4	0	Reference year 2
24	RIND2	☐	J_1IRIND2	J_1IRIND	CHAR	1	0	Reference Document Type 2
25	SERIAL1	☐	J_1ISRLNO1	NUMC10	NUMC	10	0	Register Entry Serial Number
26	SYEAR1	☐	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
27	SERIAL2	☐	J_1ISRLNO2	NUMC10	NUMC	10	0	Serial Number
28	SYEAR2	☐	J_1IYEAR	NUMC4	NUMC	4	0	Year of Register Entry
29	USNAM	☐	J_1IUSNAMC	CHAR12	CHAR	12	0	Changed by the user
30	CPUDT	☐	J_1ICPUDT	DATUM	DATS	8	0	Excise Document Entry Date
31	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1IITMDTL	CHARG	MCH1	CHARG
2	J_1IITMDTL	EXCUR	TCURC	WAERS
3	J_1IITMDTL	LIFNR	LFA1	LIFNR
4	J_1IITMDTL	MANDT	T000	MANDT
5	J_1IITMDTL	MATNR	MARA	MATNR
6	J_1IITMDTL	MEINS	T006	MSEHI
7	J_1IITMDTL	TRNTYP	J_1ITRAN	J_1ITRNTYP
8	J_1IITMDTL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in