Open quantity for scheduling lines

[Former Member]

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,

Z

[Former Member]

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

[Former Member]

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