Skip to Content

Uploading data to Additional Identifier (SWW field) in sap B1 8.82 PL12

I am trying to upload item data using import from excel option under Administration->Data Import/Export->Data Import->Import from Excel.

I would like to ask, what fields should i use in the Import from excel form(attached picture)? Im sure for itemcode but i dont know what to use to target SWW field.

capture.jpg (42.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    Dec 07, 2016 at 08:37 AM

    SWW field only with data transfer workbench

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2016 at 08:56 AM

    Hi,

    The additional Identifier field not added import function. Use DTW to add SWW field.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 09, 2016 at 03:56 AM
    ,

    Hi Nagaranjan and Gonzalo,

    Thank you both for quick help.

    I would like to ask if you can show me how to add data to sww field using the DTW?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 09, 2016 at 10:03 AM

    What do you know about Data Transfer Worbench?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 17, 2016 at 04:06 AM

    hi,

    I already tried DTW but i always stuck with the error "select a valid business object" in step 3.

    here's what i chose:

    Step 1: Master Data

    Step 2: Update Existing Data

    Step 3: Inventory then Item Master Data.\

    I also tried to mix the options from Step 1 - 3 but got the same error.

    thank you for help.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2016 at 10:35 AM

    Step1-master data, step2-update existing data, step3-Inventory

    Select item master data, click on next an then you see this. Select the first items and locate your file

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 03:52 AM

    Good Day Gonzalo,

    Sorry for the late reply. i followed step 1 and 2 and when i got in step 3 interface, i cant surpass the error (attached). Your help is highly appreciated.

    I am stuck in this field.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 29, 2016 at 09:23 AM

    I don´t know... what´s happen....

    Try to reinstall DTW

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03, 2017 at 03:34 AM

    hi Gonzalo, I already fixed the issue by reinstalling DTW as what you have said. THANK YOU FOR YOUR Help. now my next issue is what should i choose to update SWW field i only have few fields available shown in the picture attached?

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 03, 2017 at 09:25 AM

    What you see are tables, no fields.

    Select only the first option Items and then the file.

    Add comment
    10|10000 characters needed characters exceeded