on 10-13-2011 7:48 AM
Hi Gurus,
I need the list of sales order which are open on the given date.
I have copied the Standard Transaction VA05 to ZVA05N and added a custom field 'Open at key date' to enter the date.
Now my requirement is : I need the list of sales order which are open on the given date.
I am not able to find the logic/data flow for this case.
How to fetch the data ? how will be the data flow ? Which tables should I use ?
please help me out.
Thanks,
-Naren
Edited by: narenovernet on Oct 13, 2011 12:19 PM
Edited by: Csaba Szommer on Oct 13, 2011 8:53 AM
Dear ,
You can use the tables VBAK & VBUK
VBUK has field for completion status.
In the selection of your Zreport, select DATE / SALES ORDER TYPE
based on the above selection system will fetch the values from VBAK and input the same in VBUK with COMPLETION STATUS = OPEN.
The same list displayed will give you the list of open orders on the key date.
Thanks & Regards,
Hegal K Charles
Edited by: Hegal . K . Charles on Oct 13, 2011 1:39 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Naren,
You are saying that you all ready copied VA05N to ZVA05N,there you can add one more filed like Status ,for this status fetch the data from VBAKUK table LFSTK,where the LFSTK is "A" you can get all records with that status.
At the initial screen ZVA05N in status you will give "A" then system will pick all the records matches with A.
Take ABAPer help.
Regards
Ram
Hi,
I doubt if you could have open orders on a given date?
You can check CDHDR/CDPOS tables if they capture a change when the delivery is created.
But even these tables do not capture such delivery creation.
The best you can do is check the delivery date creation and before that would be the date of change in status or something like that..?
Regards,
Raghu.
Naren,
what are open orders..? they're open until all items are delivered? or not yet billed?
So if you want to find all open orders on 10th Oct: 1) you'll have to first pick up all orders from VBAK created on or before 10th oct. 2) See in VBFA if corresponding deliveries or billing is not yet created and filter those for which billing is already done on or before10th oct etc..
However, you're trying to build what VA05 does.. so see if you could copy VA05 and modify the logic based on the above logic.
I hope this helps.
Regards,
Raghu.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
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.