Hi
I have a temp-table defined in my program. I am populating this using data from various tables.
But i have come across a problem which causes the record to be overwritten.
I have data such as below
qty vardesc order kdelref
144,000 20001111 Shower gel 456785e 712499
13,000 20001111 Shower gel 456785e 712499
we have data in our system which is similar to the above. As you can see the record is identical apart from the quantity. So when i run my program it only shows 13,000 quantity record.
How can i get around this so that both fields are in my temp table?
here is my temp table
define temp-table tt-Deln
field tt-iCount as int
field tt-qtymoved like ostkmove.qty-moved
field tt-custitem like ovar.kcust-item
field tt-vardesc like ovar.vardesc
field tt-order like ostkmove.korder
field tt-delref like odelnote.kdnref
field tt-calloff like jpcalloff.kcallref
index tt-delref as primary tt-order tt-vardesc.
cheers
tj
I have a temp-table defined in my program. I am populating this using data from various tables.
But i have come across a problem which causes the record to be overwritten.
I have data such as below
qty vardesc order kdelref
144,000 20001111 Shower gel 456785e 712499
13,000 20001111 Shower gel 456785e 712499
we have data in our system which is similar to the above. As you can see the record is identical apart from the quantity. So when i run my program it only shows 13,000 quantity record.
How can i get around this so that both fields are in my temp table?
here is my temp table
define temp-table tt-Deln
field tt-iCount as int
field tt-qtymoved like ostkmove.qty-moved
field tt-custitem like ovar.kcust-item
field tt-vardesc like ovar.vardesc
field tt-order like ostkmove.korder
field tt-delref like odelnote.kdnref
field tt-calloff like jpcalloff.kcallref
index tt-delref as primary tt-order tt-vardesc.
cheers
tj