Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Feb 08, 2017 at 01:05 AM

    Hi,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2017 at 10:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 11:35 AM

    Yes correct. If possible share your template here.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2017 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 01:02 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2017 at 01:18 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 08, 2017 at 02:16 PM

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

    Add comment
    10|10000 characters needed characters exceeded