SAP table T604 (Foreign Trade: Commodity Code / Import Code Number)

SAP table T604 has 3 primary key fields being MANDT,LAND1,STAWN.

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
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
STAWN Commodity Code CHAR 17 0 STAWN
BEMEH Supplementary Unit UNIT 3 0 T006 BEMEH
NIHON Add. information: Usage of code no. (excl.) f. Foreign Trade NUMC 1 0 NIHON
0 Receipt / Import and Dispatch / Export
1 Receipt / Import
2 Dispatch / Export
IMPMA Second Supplementary Unit UNIT 3 0 T006 IMPMA
MINOL Indicator: Mineral Oil Products CHAR 1 0 MINOL

T604 foreign key relationships

Table Field Check Table Check Field
0 T604 BEMEH T006 Units of Measurement MANDT
0 T604 BEMEH T006 Units of Measurement MSEHI
1 T604 IMPMA T006 Units of Measurement MANDT
0 T604 LAND1 T005 Countries MANDT
0 T604 LAND1 T005 Countries LAND1