SAP table J_1IMTCHID (Combination of Material Number and Chapter ID)

SAP table J_1IMTCHID has 3 primary key fields being MANDT,MATNR,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
J_1ICHID Chapter ID CHAR 12 0 J_1ICHPTER J_1ICHID
J_1ISUBIND Material Can Be Sent to Subcontractors CHAR 1 0 J_1ISUBIND
J_1ICAPIND Material Type CHAR 1 0 J_1ICAPIND
Raw materials
A Assets
C Consumables
F RG1
N Noncenvatable
T Tools
J_1IGRXREF Number of Goods Receipts per Excise Invoice CHAR 1 0 J_1IGREX
J_1IDECFLAG Indicator whether the material is declared to Excise CHAR 1 0 J_1IDECLAG
J_1IDECDATE Declaration date of the material to Excise DATS 8 0 J_1IDECDATE
AEDAT Last Changed On DATS 8 0 AEDAT
USNAM Changed by the user CHAR 12 0 J_1IUSNAMC

J_1IMTCHID foreign key relationships

Table Field Check Table Check Field
0 J_1IMTCHID J_1ICHID J_1ICHPTER Chapter ID Master MANDT
0 J_1IMTCHID J_1ICHID J_1ICHPTER Chapter ID Master J_1ICHID
1 J_1IMTCHID MANDT T000 Clients MANDT
0 J_1IMTCHID MATNR MARA General Material Data MANDT
0 J_1IMTCHID MATNR MARA General Material Data MATNR
1 J_1IMTCHID WERKS T001W Plants/Branches MANDT
1 J_1IMTCHID WERKS T001W Plants/Branches WERKS