i have a requirement to process two internal tables in which i should update these two internal tables based on the conditions and for your convenience i'm describing the scenario in detail below.
my requirment is that for orderqty-goodsiss.date < batchqty-shelfexpdate,
i need to distribute the orderqty in orderqty table to orderqty in batchquantity table
based on plant, material, storage loc... and the orderqty in batchqty table should not exceed batchqty in the same table
the result would be as follows in batchqty table( orderqty increased since the date condition matched and cannot go beyond the batchqty)
and orderqty would be ( the orderqty reduced since it got into batchqty tab)
There might be several thousand records in both the tables, how to update the batchqty table
with minimum loops.