topic Open quantity for scheduling lines in Application Development and Automation Discussions

Open quantity for scheduling lines

Former Member — Sat, 22 Aug 2009 10:48:06 GMT

Hi,

I need calculate open quantity from scheduling lines(based on date) for Scheduling Agreement (similar like VL10I works). I noticed that open quantity is not maintain in VBEP. So could you help me?

BR,

Re: Open quantity for scheduling lines

Former Member — Mon, 24 Aug 2009 04:47:15 GMT

Hi,

You'll get all the data related to a schedule line in table EKET

You need to query the sales order number in table VBUK and check the field GBSTK ne C then it will be an open order.

You can look in table VBAKUK for this.

This is nothing but a Join of VBAK and VBUK entries. you can eliminate a join if u fetch it from VbakUk

Now once it is confirmed that it is open then fetch the entries from VBAP.

Regards,

Shamma

Re: Open quantity for scheduling lines

Former Member — Mon, 24 Aug 2009 07:01:58 GMT

Hi,

For calculating open quantity for scheduling lines ,u need to query the sales order number in table VBUK and check the field GBSTK , it will be an open order .

You can look in table VBAKUK for this .

This is Join of VBAK and VBUK entries. You can eliminate a join if you fetch it from VbakUk

Now once it is confirmed that it is open then fetch the entries from VBAP.

Hope it helps you.

Thanks,

Sarita Singh