Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
im facing a problem and i dont know how to solve it.
After somebody creates an order, its possible to change some details in that order like amount or price.
Lets say an order is created at day 1 with an amount of 1000 pieces. So thats means an order inflow of 1000 pieces on that day.
Now, on day 2 the order is changed from 1000 to 2000 pieces (maybe the customer needs more pieces than he originally thought). That means its an order inflow of 1000 pieces on day 2.
Now VBAP contains only one order with 2000 pieces but the field AEDAT (change date) is now filled with the day where a change happened. The details on those changes are stored in the tables CDHDR and CDPOS. So far so good.
But I dont know how to get a table like this:
Date | Order | Amount |
---|---|---|
Day 1 | 1234 | 1000 |
Day 2 | 1234 | 1000 |
How can I achieve this?
Before answering, i have to ask, what will be stored in CDHDR and CDPOS tables when there are two or more changes done in the order?