on 09-05-2012 4:32 PM
Hi Experts,
This is the scenario:
Company JDE (external vendor)
Warehouse DSP: 30 PC
Warehouse DDT: 10 PC (blocked stock)
Warehouse DDK: 0 PC
Total Stock 40 PC
Company SAP (my client):
Warehouse 100: 0 PC
Warehouse 200: 20 PC (unrestricted stock)
Warehouse 300: 5 PC
Total Stock 25 PC
SAP warehouse 100 is the equivalent of JDE warehouse DSP.
SAP warehouse 200 is the equivalent of JDE warehouse DDT.
SAP warehouse 300 is the equivalent of JDE warehouse DDK.
The Stock is owned by SAP but JDE is the company who manage that stock. So SAP do not have any idea regarding what is happening with his own stock. This means that every day a lot of stocks movements will take place from JDE to customers or from blocked to unrestricted or vice versa inside JDE warehouses.
The requirement are: SAP want to have in his own SAP WM system the same stock that JDE has. For that SAP wants to have a interface running in real time (or at least update the stocks ones a day so both stock at the end of the day are the same).
Note: SAP WM have Storage Unit (HU) management active. And SAP do not allow to have negative stocks.
Please advice on how I can build this interface.
Thaks a lot in advance for you help!
Fred.-
Hi fred , is this issue resolved,
Thanks
Jinoy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is how is currently working:
First Step: File sent from JDE and PI mapping take place. Interface Run and 3 idocs are generated (1 for each bin). Custom program check and compare quantity between JDE bin and SAP bin. Example; if JDE DSP warehouse is 0 and in SAP 100 warehouse is 30, then a transfer order Idoc WMTORD for 30 quantity is created in SAP to move the stock from Virtual Bin (allows negatives stock) and place them in SAP 100. With that way stock in both warehouses will be the same.
Virtual bin is a fictitious warehouse where we can remove or put stock from or to the reals bins (100, 200 & 300) in order to have same stocks level in SAP and JDE.
Second Step: Posting Changes. This posting changes are created to allocate the stock in IM in same status as in WM through LQ02 job.
So far so good..what is the problem with all that? We will implemented Storage Unit Managment (HU) and that SAP functionality do not allow negative stocks at warehouse level "Negative stock not possible for storage unit management". So our Virtual bin will not be helpfull anymore.
Any suggestion friends? How we can sorted this out?
Very thanks in advance for your help on this.
Fred.-
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fred .
In this case you will have to set up interface which could perform SAP relevant transactions.
Will take example of physical inventory.
WM - DSP has stock of 10 EA
WM - 100 - has stock of 8 EA
You interface runs and finds that WM -100 , SAP warehouse has 2 EA less , so to adjust stock in SAP and make both warehouse in sync . Interface triggered to sync stock should perform 712 movement type to increase difference ( 711 movement type to decrease difference )
Interim storage type 999 can be used in this case .interface should take care WM and IM posting.
Thanks
Jinoy
Hi,
How IDOCS posting is happening ? is it routed through middleware PI ?
If yes please check with PI guys if anything has missed out & you could process it.
If its not through PI then you must built custom program which will take out dump of MSEG everyday & send excel as posting as on ........... to third party.
Also the erronous IDOCS on that day. You can check for error & put validations in that case & if posting wont happen in SAP , mail should go to relevant user mentioning error.
Kind of regular monitoring issue.
thanks,
mahesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are managing third party warehouse .You said every day lot of movements happen at your warelevel.What happened at invenetory level .If you issue some qty at wlevel then some inbound message should come into sap to update the stock.
If it is happeneiin your case then if it is mismatch the qty then you need to check any idocs failed in system ?or any inbound messages stuck in interface.
To match the stobetween sap and your third party warehouse you need to develop a program and should compare the sap stock image and warehouse stock image every night then it should post the idocs accordingly in SAP to match warehouse stocks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is how is currently working:
First Step: File sent from JDE and PI mapping take place. Interface Run and 3 idocs are generated (1 for each bin). Custom program check and compare quantity between JDE bin and SAP bin. Example; if JDE DSP warehouse is 0 and in SAP 100 warehouse is 30, then a transfer order Idoc WMTORD for 30 quantity is created in SAP to move the stock from Virtual Bin (allows negatives stock) and place them in SAP 100. With that way stock in both warehouses will be the same.
Virtual bin is a fictitious warehouse where we can remove or put stock from or to the reals bins (100, 200 & 300) in order to have same stocks level in SAP and JDE.
Second Step: Posting Changes. This posting changes are created to allocate the stock in IM in same status as in WM through LQ02 job.
So far so good..what is the problem with all that? We will implemented Storage Unit Managment (HU) and that SAP functionality do not allow negative stocks at warehouse level "Negative stock not possible for storage unit management". So our Virtual bin will not be helpfull anymore.
Any suggestion friends? How we can sorted this out?
Very thanks in advance for your help on this.
Fred.-
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.