Skip to Content
0

Source file is not picking in VI94

Feb 09, 2017 at 06:55 AM

75

avatar image

Dear Experts,

I am trying to upload a list of commodity codes having near about 23000 for German country. When i execute the button in VI94 source file is not picking from the path that we maintained in under source file. As soon as i execute(F8), System should open the path specified in the source file. This is not happening, Attached is the screen shot FYR.

Related to this i have checked OSS Notes 1807839, but it is in status cannot be implemented.

And 1 more thing is this tcode will help us to upload this huge 23000 at a time? If yes what i need to maintain under the fields Data record structure in VI94.

If any one is having step by step process screen shot, kindly share with me.

Thanks & Regards

Raghuram.P

+91 9159541853

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jürgen L
Feb 09, 2017 at 07:06 AM
0

23000 records will take some time.

create a copy of your source file and and reduce its content to 1 to 10 lines only - just for test purpose to see if it can be opened and something can be read. I would also reduce the length to less than 300 as the T604T table has no endless capacitiy, it has 7 fields á 40 characters.

I ma not a 100% certain without my system but looking at your file name it has the drive included, while there is also a separate field for the drive.This could also be an issue in case the file cannot be opened or found

EDIT: I just checked in my system. Please remove the D:\ from your file name.

then execute and click the green check mark in the pop-up

SAP will then open another pop-up and shows your D: drive

here select your file again.

Share
10 |10000 characters needed characters left characters exceeded
Raghuram Peram Feb 13, 2017 at 06:26 AM
0

Hello Jurgen,

First of all, Thanks for your prompt response.

I have tried lot of times to upload the import codes in to the table T604 on the same day . Finally i could able to upload this with 5 import codes(For testing) and all the codes are now visible in T604 and in Material master as well.

While uploading i found that, what are all the codes that i have uploaded, system is picking default 1 for additional info field in T604. Then i have opened relevant oss notes 1034696, Here i found the valid reason as below.

The question arises how the 'Additional information' field is set in Customizing (field T604-NIHON) during the import.

The logic is as follows:

Commodity codes are imported (VE94): NIHON = 2 (Dispatch / Export)

Import code numbers are imported (VI94): NIHON = 1 (Arrival / Import)

I believe as per the above logic system is picking 1, Please let me know if my understanding is wrong.

I have raised few questions to client requesting detail explanation

1. To decrease the length of the descriptions

2. Asking confirmation for some other fields(Like start date, end date etc.) which will not able to upload in SAP Table T604. If they yes we can ignore we can easily ignore. If not we need to make them to understand this is not possible in SAP.

3. And asking why we need this much huge codes at a time? why cant we segregate the list of codes as per Business and import the relevant codes.

Kindly let me know if i am not stick to SCN Rules, And once again many thanks for spending your valuable time on this.

Regards

Raghu. P

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Feb 13, 2017 at 10:18 AM
0

Your understanding of the default logic is correct. This way it is possible to control more tight what materials can be imported and exported. Not sure if anyone does it all on this level. We are a chemical company, with plants and distribution centers around the globe, so all our finished materials would need commodity codes that serve both ways, while all spare parts would only need NIHON = 1. But spare parts do actually not have a sales view, so they will not be sold anyway, hence no double control via NIHON needed. I load everything with NIHON = 0.

to 1) not sure if the business can help you here - these are official descriptions. You may eventually ask them what they do with the description, eg. if it is printed anywhere.

In the F4 help for the commodity code field in material master you see anyway just the first 40 characters, so this does - from my experience with chemicals - not really help anybody to classify a new material master with the right commodity code. They usually determine the right code outside SAP and this 40 characters are just a small help to verify that you have not mistyped the number in the material master.

to 3) this is a standard discussion, for convenience some people tend to get all commodity codes loaded since they know about internal processes in large companies where it can take weeks or months to get a new customizing request through to production. And honestly these entries in T604 table take probably less space than a single picture added as GOS attachment to a material master.

Share
10 |10000 characters needed characters left characters exceeded