Skip to Content

SAP B1 - Existing Stock Items - How to import Commodity Codes?

SAP B1 9.2 SQL

I have the valid commodity codes already setup in SAP. (Intrastat configuration)

I have marked the Items with the 'Intrastat relevent' switch.

How can I bulk import the commodity code against existing stock items in SAP without having to manually assign them?

Customer has a spreadsheet list like this:

Stock item Commodity Code

0008106,40081100

I need the commodity code field updated on the stock item.

Does anyone know if this can be done using a DTW template?

comm-code-list.jpg

olw5i.png (17.8 kB)
comm-code-list.jpg (125.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 18, 2018 at 12:56 PM

    The ‘ABS entry’ from the commodity code(ODCI) table has to go into the ‘commodity code’ field on the import template instead of the actual commodity code.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 16, 2018 at 01:03 PM

    Hi Eoin,

    You can import bulk commodity in Item master through DTW. You can login to DTW and create Customize template for ItemIntrastatExtention.

    Let me know if you need more help on this.

    Thanks,

    Harshal Makwana

    Add comment
    10|10000 characters needed characters exceeded

    • I found the template - Many Thanks.

      I have filled in the file like this

      ParentKey,LineNum,CommodityCode,SupplementaryUnit,FactorOfSupplementaryUnit,ImportRegionState,ExportRegionState,ImportNatureOfTransaction,ExportNatureOfTransaction,ImportStatisticalProcedure,ExportStatisticalProcedure,CountryOfOrigin,ServiceCode,Type,ServiceSupplyMethod,ServicePaymentMethod,ImportRegionCountry,ExportRegionCountry,UseWeightInCalculation,IntrastatRelevant
      ItemCode,LineNum,ISCommCode,ISSubMasUn,ISFactor,ISOrCSTImp,ISOrCSTExp,ISNaTraImp,ISNaTraExp,ISStProImp,ISStProExp,ISOriCntry,ISSerCode,ISItemType,ISSerSupMt,ISSerPayMt,ISOrCRYImp,ISOrCRYExp,ISUseWeigh,ISRelevant
      0010846,0,83022000,,,,,,,,,,,,,,,,,
      0008106,0,40081100,,,,,,,,,,,,,,,,,

      But when I import it says 'No matching records found' even though the items do exist. Do I need to fill more information in? Thanks

  • Jul 17, 2018 at 03:19 PM

    I have filled in the DTW template file like this

    ParentKey,LineNum,CommodityCode,SupplementaryUnit,FactorOfSupplementaryUnit,ImportRegionState,ExportRegionState,ImportNatureOfTransaction,ExportNatureOfTransaction,ImportStatisticalProcedure,ExportStatisticalProcedure,CountryOfOrigin,ServiceCode,Type,ServiceSupplyMethod,ServicePaymentMethod,ImportRegionCountry,ExportRegionCountry,UseWeightInCalculation,IntrastatRelevant
    ItemCode,LineNum,ISCommCode,ISSubMasUn,ISFactor,ISOrCSTImp,ISOrCSTExp,ISNaTraImp,ISNaTraExp,ISStProImp,ISStProExp,ISOriCntry,ISSerCode,ISItemType,ISSerSupMt,ISSerPayMt,ISOrCRYImp,ISOrCRYExp,ISUseWeigh,ISRelevant
    0010846,0,83022000,,,,,,,,,,,,,,,,,
    0008106,0,40081100,,,,,,,,,,,,,,,,,

    But when I import it says 'No matching records found' even though the items & commodity codes do exist. Do I need to fill more information in? Thanks

    Add comment
    10|10000 characters needed characters exceeded