04-10-2014 6:52 AM
Dear All,
I have an issue in which i need to capture all the sales order in which change has taken place in a given day.
I have checked CDHDR & CDPOS but they arent helpful as they are not updated when there is change in status of sales order.
Could you please suggest a method by which i can track change in sales order status as well for a given date
Best Regards,
Ronak
04-10-2014 7:07 AM
Hi ronak,
Hi,
For Overall Header status and administrative data you can check in VBUK table.
For overall Item status and administrative data you can check in "VBUP" table.
In both these cases you have to pass the order number number only in SE11/SE16 T.Code.
For object status you have to check in "JCDS" table.
In this initially you have to pass the order number in "VBAK" table and then fetch the "OBJNR" for that order.
Pass this OBJNR into "JCDS" to get the header object status in SE11/SE16 T.Code.
Regards,
Sachin
04-10-2014 7:07 AM
Hi ronak,
Hi,
For Overall Header status and administrative data you can check in VBUK table.
For overall Item status and administrative data you can check in "VBUP" table.
In both these cases you have to pass the order number number only in SE11/SE16 T.Code.
For object status you have to check in "JCDS" table.
In this initially you have to pass the order number in "VBAK" table and then fetch the "OBJNR" for that order.
Pass this OBJNR into "JCDS" to get the header object status in SE11/SE16 T.Code.
Regards,
Sachin
04-10-2014 7:46 AM
Hi Sachin,
Your answer is very much relevant and my processing is exactly similar VBAK to VBAP to JCDS.
unfortunately i dont have order no which i have to fetch with some mechanism.
My requirement is to track any change in any sales order in a given day , capture them then pass to VBAP & JCDS and then do further processing.
I cannot go to JCDS without Objnr which i will only get if i know the orders which are changed.
If i directly go to JCDS without Objnr it will lead to optimisation issue.
Regards,
Ronak
04-10-2014 8:03 AM
Hi,
JCDS is fine. Search for OBJNR = VB* to get alle changes on sales document status.
To get only changes for sales document header status check for VB*000000.
OBJNR = 'VB' + sales document number + sales document item number.
Regards,
Klaus
04-10-2014 7:34 AM
Hi,
You can try with the table VBFA - Sales Document Flow.
Regards
Gangadhar
04-10-2014 8:02 AM
Did you look for solutions related to BW and/or LBWE LO Data Ext ?
Regards,
Raymond