Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 24, 2007 at 08:12 AM

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

    & for schedule line check VBEP.

    Reward if useful

    Regards

    ANUPAM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 24, 2007 at 08:55 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.