Skip to Content
0
Jun 03, 2013 at 11:45 AM

BEX Query Calcultaion

54 Views

Dear Experts,

We are having a problem in calculating in To be delivered column.If any material is issuing 2 or more times for any PO then to be delivered column is being populated as a wrong value. (To be delivered is a simple formula in BEX).

Suppose in the below Table for PO 45000100, Material 10001 is issued in 2 times.First time they issued 50 Qty and second time they issued 200 Qty.Total they issued 250 Qty (They ordered 250 Qty).Here In 3rd row To be delivered column should be populated as a "zero" but it is showing as a "50".

Can some one please guide me how can we achieve this requirement in BEX Query designer.

Awaiting for your valuable reply.

PO Number PO Line item Material No Order QTY Issued QTY To be delivered To be delivered we need 45000100 1 10000 100 100 0 0 45000100 2 10001 250 50 200 200 45000100 2 10001 250 200 50 0 45000100 3 10002 300 300 0 0 45000100 4 10003 450 150 300 300 45000100 4 10003 450 300 150 0

Regards

Shankar.