Skip to Content
0

DTW Error: Enter Valid code [OITW WhsCode] Application-defined or object-defined error

Feb 07, 2017 at 10:35 PM

403

avatar image
Former Member

Hi

I've been trying to the the DTW workbench app to import some data to SAP OITM table but keep getting the following error:

Enter valid code [OITW.WHSCODE] Application-defined or object-defined error.

The whole DTW import template will fail to process with nothing importing at all.

I have tried this firstly trying to update 3x pricelists per item on around 600 items.

I then got the same error when trying to update the codebars field on OITM.

On both occasions I created the import template using the original SAP import template excel doc and saved to .txt format for the actual import, examples of the files attached.

I am a bit confused why this error should be happening as I have used DTW many times over the years of being on SAP and this is the first time ever I have had a problem with it.

Any advice or guidance on how to resolve this to allow me to DTW would be gratefully received.

Thanks

tuk-ean.txt - codebars import

pricing.txt - pricing import

tuk-ean.txt (54.5 kB)
pricing.txt (146.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Nagarajan K Feb 08, 2017 at 01:05 AM
0

Hi,

Please make sure all items are added with valid warehouse code in template. Also check warehouse code exist in SAP.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 08, 2017 at 10:20 AM
0

Hi Nagarajan

Thanks for your reply.

We have some 53x warehouses, so presumably to do what you recommend is basically a line per part per warehouse in the import template?

Regards

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 08, 2017 at 11:35 AM
0

Yes correct. If possible share your template here.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 08, 2017 at 11:58 AM
0

OK, thanks.

Here is an example of the import template here in .TXT format.. I can't add the .XLT template itself on this post, but its the standard one named "OITM - Items.xlt" that is provided with B1, there is also a screen shot of how it looks in excel prior to saving as a .TXT.. please note I added the key section to help me remember when bringing values in for different pricelists via vlookup.data-import.txtimp-temp-pre-save.jpg


data-import.txt (30.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 08, 2017 at 01:02 PM
0

Are you importing price list or item master data? Attached template is for price list not for item master data.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 08, 2017 at 01:18 PM
0

Sorry, my bad... the template I use is named "ITM1 - Items_Prices.xlt" and I import to Items_Prices in the DTW app..

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 08, 2017 at 02:16 PM
0

Please follow SAP note 903392 - DTW_How to set PriceList field for the Items_Price object

Share
10 |10000 characters needed characters left characters exceeded