Open Sales Order table with multiple schedule line....

[Former Member]

YUSUF BHORI wrote:

Hi Experts,

In Sales Order there are multiple schedule line for single item.

Where and in which table i can find open qty for order ,material, item and schedule line items.

I Want open items for each schedule line. For One vbeln, posnr there multiple etenr.

Urgent,

Yusuf.

[Former Member]

Hai,

Join VBAK & VBAP and store data in an internal table GT_VBAP to get Sales order numbers, items, materials.

Get Open Sales order items from VBUP into GT_VBUP where VBUP-GBSTA NE 'C'.

LOOP at GT_VBAP.

Read table GT_VBUP with key vbeln & posnr.

If sy-subrc <> 0.

delete GT_VBAP.

endif.

****Fill your Final Report Internal table with required field values **Append into that internal table

ENDLOOP.

Now Select WMENG BMENG from VBEP into GT_VBEP for all entries in GT_VBAP.

LOOP AT GT_VBEP.

*******Again Modify your Final Report internal table with these values

***VBEP-WMENG is Ordered Qty

***VBEP-BMENG is Confirmed Qty

************Open Qty = Ordered Qty = Confirmed Qty***

************Open Qty = VBEP-WMENG = VBEP-BMENG.***

ENDLOOP.

Edited by: Eswara Rao Aakula on Dec 24, 2007 9:56 AM

Edited by: Eswara Rao Aakula on Dec 24, 2007 9:57 AM

[Former Member]

Hi Eswara,

U could ot understood my problem. As per your suggetio u r right but i want open qty for the schedule line item. For vbeln and posnr again there is etenr. I want open qty. for etenr wise.

Yusuf

[Former Member]

Hi Yusuf,

I'm making you sure, that there is no ways other than calculating it yourself.

suppose u've a SO creted on 24th dec with 100 pc. your 1st scheduled date is 28th dec 30 pc, and 2nd scheduled date is 31st dec 70 pc.

100 is stored in VBAP.

30 & 70 is stored in VBEP in two lines.

now check in VBFA how many items have been issued for this VBELN & POSNR & on which date.

Say you've received 20 pc on 28th & 50 pc on 30th.

then compare the scheduled quantity & issued quantity within the scheduled and you can get the open quantity.

So, on 28th you have 10 open quantity & on 31st you've 30 open quantity.

Hope this may help you.

Reward if useful

Regards

ANUPAM

[Former Member]

Hi Anupam,

Yes Anupam u r right. I have to calculate as per your suggetion, this is the only way i think so.

Thanks.

Yusuf.

[Former Member]

if u want only the open quantities check the table VBUP.

& for schedule line check VBEP.

Reward if useful

Regards

ANUPAM

[Former Member]

Hi Anupam,

But i wont get schedule line wise. i.e. Vebeln & Posnr i will get but i wont get ETENR wise.

Schedule line Open qty.

Yusuf

[Former Member]

Hi Yusuf,

Open quantity is available in VBUP.

VBEP only contains the schedule lines.

if u want how many goods issued with delevry details according to SO check table VBFA.

I don't have SAP with me at this time, otherwise i could have given you the field details too.

Reward if useful

Regards

ANUPAM

[Former Member]

Hi Anupam,

No it wont work i VBFA. I want etenr (Schedule Line item ) wise. it gives vbeln and posnr wise but i want eter wise.

Yusuf

[Former Member]

I think you have to calculate it and compare with issue date & scheduled date.

Check LIPS once. I'm not sure if u can get scheduled line item no wise there.

Reward if useful

Regards

ANUPAM