Logic for Open Sales order qty

[Former Member]

What should be the logic given to determine "open sales order qty" during designing a report.

Note the criterias are as under:

1) Open sales order qty is the confirmed qty less the delivery qty.

2) The delivery qty should be delivery order qty (The delivery should not necessarily be pick, packed & PGI)

[rmazzali]

I suggest you to directly find the open quantity in field VBBE-OMENG.

You can access this table by order number (VBELN), item (POSNR) and schedule line (ETENR).

it works fine and avoids lots of calculations.

Roberto

[Former Member]

Hi Roberto,

Thanks for the reply. I think it should help me. However, let me check if it works for service order too.

Thanks & Regards

Nayan Shah

[rmazzali]

sorry it doesn't work for services, since they do not create requirements.

in this case you can use VBFA table, subracting all the delivered quantities VBFA-RFMNG with VBFA-VBTYP_N = J and VBFA-VBELV/VBFA-POSNV = to your order/item from the ordered quantities

hope this help you.

Roberto

[Former Member]

Hi

I thought so your earlier logic would not work for service order but i tested it and surprisingly it works...............!!!!!!!!

The second logic provided by you is what I was working on.

Thanks & Reagrds