Upload minimum stock

[Former Member]

Dear all,

I create a template to upload minimum stock using 8.81 PL 6.

OITM

ItemCode

A0001

B0001

OITW

ItemCode ~ MinStock ~ WhsCode

A0001 ~ 70 ~ WHS01

A0001 ~ 50 ~ WHS02

B0001 ~ 100 ~ WHS01

B0001 ~ 135 ~ WHS02

No error during upload. However, when I check into the system and the database, the minimum inventory was not updated despite successful upload. Anyone here knew the solution?

Thanks in advance!

Best Regards,

Hendry Wijaya

[former_member541807 · Accepted solution]

hi,

please check this SAP Note: [1621095|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3030303136323130393526]

regards,

Fidel

[Former Member · Accepted solution]

Hi Fidel,

I'm not quite get your intention here, no error message displayed when I finish the import. While your document seems cover the case when user want to update evaluation method of certain item. I'm not trying to update any information pertaining to OITM / Item master, I only want to update the minimum inventory stock for particular item at particular warehouse. OITW is the correct template isn't it? Thanks in advance.

Best Regards,

Hendry Wijaya

[Former Member · Accepted solution]

Hi Hendry Wijaya,

In you OITM DTW sheet find column "ManageStockByWarehouse" & then wright "tYES" in this column & then add your stock in "MinInventory" column of OITM DTW sheet.

then import it to SAP through DTW.

Thanks,

Vishal Dabhi

[Former Member · Accepted solution]

Hi Vishal,

I do aware that we have to manage item by warehouse first. As a matter of fact, I already set all item to manage item by warehouse beforehand.

[Former Member · Accepted solution]

Hi Hendry,

The issue at times might also be due to mismatch of record key and line num.

Have you checked that possibility?

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Joseph,

So far, I never tried to upload minimum stock. This is my first attempt. Thus, maybe you're right, maybe I miss some specific rule to fill the template. My template goes like this:

OITM

ItemCode

A0001

B0001

OITW

ItemCode ~ MinStock ~ WhsCode

A0001 ~ 70 ~ WHS01

A0001 ~ 50 ~ WHS02

B0001 ~ 100 ~ WHS01

B0001 ~ 135 ~ WHS02

As for Record Key, I believe I can't find this field from SAP template, neither in OITM nor OITW.

As for Line Num, I intentionally leave it empty. However, I look at the example provided by SAP, and fill this field with zero, as exactly as SAP filled it. Still, the result is same, no error during upload, but none of the data updated also.

Could you rectify my template based on your experience? Do I have to fill certain field with certain ways? I desperately need some help here. Thanks.

Best Regards,

Hendry Wijaya

[Former Member · Accepted solution]

Hi Hendry,

In the OITW template, there's a field linenum, with reference to the OITM code, update the OITW template as well. For your reference i'm sending a sample file to your email.

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Hendry,

Try run this simple query:

SELECT T0.ItemCode, WhsCode

FROM OITW T0

WHERE T0.ItemCode IN ('A001','B001')

ORDER BY T0.ItemCode

How many lines do you have?

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Joseph,

Thank you very much for your concern and assistance, much appreciate it. I already got your email.

However, unfortunately, it still didn't work as expected.

First of all, in your OITM.csv file, you put RecordKey field. I presume you use template for version prior to 8.81? In 8.81 version, this field doesn't exist, either in Template or Samples folder in DTW working folder. I have a virtual machine with 2005 version, and yes, the RecordKey field is there on 2005 version, but definitely not exist in 8.81.

Even if I manually insert a column / field in OITM template, I name it with RecordKey, when I try to upload it using DTW, in step 5 of DTW (Map Object Fields), I couldn't map that RecordKey field with respective Target Fields of RecordKey. Quite logical, since it doesn't contain this field in first place.

In my desperation, I tried to fill the LineNum field in OITW with the sequence of the item in OITM template.

OITM

Item Code

A0001

B0001

OITW

Item Code ~ Line Num ~ Min Stock ~ Warehouse

A0001 ~ 1 ~ 330 ~ WHS01

B0001 ~ 2 ~ 410 ~ WHS01

And tried this also

OITM

Item Code

A0001

B0001

OITW

Item Code ~ Line Num ~ Min Stock ~ Warehouse

A0001 ~ 0 ~ 330 ~ WHS01

B0001 ~ 1 ~ 410 ~ WHS01

And, as I already posted in my previous post, I also tried this

OITM

Item Code

A0001

B0001

OITW

Item Code ~ Line Num ~ Min Stock ~ Warehouse

A0001 ~ 0 ~ 330 ~ WHS01

B0001 ~ 0 ~ 410 ~ WHS01

And definitely, I also tried this

OITM

Item Code

A0001

B0001

OITW

Item Code ~ Line Num ~ Min Stock ~ Warehouse

A0001 ~ (blank) ~ 330 ~ WHS01

B0001 ~ (blank) ~ 410 ~ WHS01

Every combination I tried resulting in pure vain. And the most curious thing was, as I already state beforehand, DTW mark all of my effort as successful attempt to update the data, no error data at all.

[Former Member · Accepted solution]

Hi Gordon,

Frankly, "A001" and "B001" aren't the actual item code. I only use it for explaining my template. Anyway, I did your query, and the result there are 54 lines. There are 27 warehouses, so it is obvious, 2 multiply 27 warehouses = 54.

[Former Member · Accepted solution]

Hi all,

No one ever experience this? Or at least have an experience upload minimum stock in 8.81? Thanks.

[Former Member · Accepted solution]

In you case, try the following to update.:

OITW

Item Code ~ Line Num ~ Min Stock ~ Warehouse

ItemCode ~ LineNum ~ MinStock ~ Warehouse

A0001 ~ 1 ~ 330 ~ WHS01

B0001 ~ 1 ~ 410 ~ WHS01

A0001 ~ 26 ~ 330 ~ WHS26

B0001 ~ 26 ~ 410 ~ WHS26

[Former Member · Accepted solution]

Hi Hendry,

I just tried and found something strange. If you want to upload the minimum/max inventory, you can create only 1 template for OITW and select this template at ItemWareHouseInfo on step 4. There is no need to select items template. The mode I selected was Add new and update existing and it works fine in my case.

Hope this helps.

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Hendry Wijaya ,

Try this

OITW Tamplet

ParentKey	LineNum	MinimalStock	MaximalStock   WarehouseCode
ItemCode	LineNum	MinStock	MaxStock	   WhsCode
A	          0	    10	              300	          WH01
B	          0	    10	              100	          WH02

Thanks,

Srujal Patel

[Former Member · Accepted solution]

OH MY GOSH, YOU'RE RIGHT JOSEPH!!! Okay, I realize that I may infringe certain net-etiquette regarding all caps, but seriously, you're right! I mean, how on earth you even knew that you had to use OITW only and leave the OITM file selection blank? Usually people will try different combination in both file, since OITM is the parent tree of the OITW. Amazing that you found this solution to be honest!

Well, as a matter of fact, I already solve this problem myself earlier this morning. But, I didn't use DTW, I build a simple program using SDK to upload the minimum stock. The end result still achieved, but still, I'm very curious why all of my efforts filling the DTW template went out of the window.

Once again, many thanks, you're awesome dude!

Best Regards,

Hendry Wijaya

[Former Member · Accepted solution]

That is what I showed you only need OITW to DTW. Joseph tried by my suggestion and it is worked.

[Former Member · Accepted solution]

Hi Gordon,

Sorry, just now reply, I've just finished my leave and did my best to stay away from any job related task these last few days, fiuh...

Yay! Terribly sorry, I didn't know when you wrote this:

In you case, try the following to update.:

OITW

Item Code ~ Line Num ~ Min Stock ~ Warehouse

ItemCode ~ LineNum ~ MinStock ~ Warehouse

A0001 ~ 1 ~ 330 ~ WHS01

B0001 ~ 1 ~ 410 ~ WHS01

A0001 ~ 26 ~ 330 ~ WHS26

B0001 ~ 26 ~ 410 ~ WHS26

You actually mean to tell me to use OITW only. Nonetheless, you gave the solution and Joseph gave further confirmation to me. You're both great, thank you for the time you spend to give me the solution!

Best Regards,

Hendry Wijaya