Intrastat - Mode of Transport missing in purchase order header

[Former Member]

We have a problem where for a supplier there is missing import data for some materials - but not others. As far as I can tell the Info Records for those with missing data are identical to those where there is no data. For example, the Incoterms field and the Mode of Transport fields are blank. The Country of Origin field on the Info Record for both of these materials is DE. Does anyone have any ideas about what may be causing this?

[JL23]

Mode of transport has to be maintained in vendor master that it can default to the PO.

Alternative you can customize a default in VI95.

Incoterms can default from vendor master, info record, contract.

In any case a user can overwrite the values when creating the PO before saving (means that in this case you will not find any change documents)

[Former Member]

Thanks for the suggestions guys. I should have added that we are using IS-Retail 5.0 so don't use MM01/02/03 but rather MM41/42/43. I have checked the Foreign Trade settings for the materials concerned through MM03 and do not see any differences. What I can say is that if I create a PO for the vendor the Incoterms and Mode of Transport are displayed at that point in the Import tab. If I then enter a 'good' article (without plant) the values are retained but if I enter a 'bad' article then the values are taken out. So I can't think the vendor is a factor. Equally the Info records for 'good' articles appear to have the same settings in respect of commodity code as the 'bad' articles etc.

[JL23]

the info records can either be created at purchasing org level or at a purchasing org/plant level.

Did you check at table level (table EINE) whether you have 2 records with different information for the "bad" materials

[Former Member]

Yes I did, Jurgen, and I can see nothing wrong. It is very strange and I am sure it is article-related in some way.

[JL23]

CAn you confirm that the PO is not created in reference to a contract?

Can you check in SE38 program LXV50U01 and its include whether you have some coding to manipulate the mode of transport field (this is the user exit for foreign trade data)

[JL23]

one more thing to check:

The mode of transport is a well used in routes. Do you use routes?

As mode of transport is header information, I doupt that item (material or article) has impact on its determination.

Here a list of tables that hold this field (EXPVZ), the tables including TVRO are tables from where your PO can get the value, the rest are tables that finally get the value from the PO.

LFM1

LFM2

T161W

T617

T618

T618K

T618T

T618U

TVRO

VEIAV

VESED

VEXAV

EIKP

[Former Member]

Hi Jurgen

Once again thank you for your suggestions. Although I have yet to prove it fully our thinking now is that this is caused by the presence of 'vendor sub-range' purchasing data for some sub-ranges but not all. Within this data the import settings are missing. By adding them I can resolve the problem. Not sure if sub-ranges are an IS-Retail concept only. I will update this fully when I have completed my testing.

[JL23]

VSR is available in the standard ERP too, thats why I included the LFM2 table in the table list. Often forgotten, because it is not very user friendly to get to this screens.

[sjoginapally]

Hello, I have seen some of the above answers asking to maintain the Mode of Transport in Supplier Master but what if the mode of Transport needs to be changed at PO level based on business urgency? In such a case, how to add the Shipping mode field to the PO header?

Appreciate your support.

Thank You.

Sai Teja

[pankaj_singh9]

Hi,

Compare the "Foreign Trade : Import data" view of the materials for which it is working fine and for which it is giving error.

Also check vendor master for Mode of Transport and Inco terms details.