on 2013 May 16 7:30 AM
Dear All Experts,
I want to update minimum Stock quantity in Item Master.
How to do that?
Please guide.
Regards,
AKM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Avijit...
You want to update by warehouse wise or on Item Level?
For Item Level you may use OITM template for DTW
and for Warehouse you may use OITW and OITM DTW template...
Rahul
I think i have to update by Item level wise. because for all warehouse miimum stock would be remain same.
In item Master i have the option checked "Manage Inventory by Warehouse".
I dont have the sample template please send me on my email id abhitkumar@gmail.com
because i m not able to found proper template from the sample folder.
Hi,
You can find the sample templates where DTW was installed.
Templates are marked with Table name and its description
For example:
OITM- Items
OQUT - Document (sales quotation)
QUT -Document lines
Hope helpful.
Please find OITM xlt Template under below path...
C:\Program Files (x86)\SAP\Data Transfer Workbench\Templates\Templates\Inventory\Item Master Data
If you set the "Manage Inventory by Warehouse" you should set the minimum values for all warehouses even they have equal values.
OK,
Can i update this by externally by using sql query? or it will create problems?
No. You will lose SAP support and there will be inconsistency the DB.
Thanks & Regards,
Nagarajan
I have used two file OITM and OITW template to upload but i am getting below error.
Violation of Primary key constraint OITW_PRIMARY. Cannot insert duplicate key in object dbo.OITW.Application-defined error65171.
I have checked the option of Update only in DTW.
OITM Sheet
OITW Sheet
Please check with below thread:
http://scn.sap.com/thread/2133218
I have checked but not worked.
It is enough to use the OITW with update mode, like this:
ParentKey
LineNum
MinimalStock
WarehouseCode
ItemCode
MinStock
WhsCode
ZÁK000000008
0
22
01
1
45
02
You may try only include OITW to update. There is no need for OITM.
Thanks,
Gordon
i have made the file and when i select the file in ItemWarehouseinfo option and click on next button then msg is coming "A source file must be provided".
In this case, you may include OITM with only ItemCode put in.
Are you sure you really selected the OITW file? I used only the OITW table I previously shown and it worked!
I am using b1 2007..is that reason its not supporting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.