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

[former_member391531]

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

[former_member391531 · Accepted solution]

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.

[former_member329644]

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

[former_member391531]

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

[former_member391531]

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

[former_member329644]

Hi Eoin,

In DTW template you should not enter commodity code but instead you need to enter its Abs Entry.

Run this query and enter AbsEntry of commodity code in your template.

SELECT * FROM ODCI T0 WHERE T0."ConfType" = 'C'

Thanks,

Harshal

[former_member391531]

query-results.jpg

Thanks for the reply. I've attached the results of the query.

[former_member391531]

Thank you Harshal,

That has worked for me. Really appreciate the help on this as I would never have figured that out.