Skip to Content
avatar image
Former Member

VERY URGENT

how will i fetch the open quantity in VA32 for a for a particular material. Is there any table from where i can fetch it. If not can any one please tell me how to calculate it.... this is very urgent,.. i am stuck up here...

Will surely reward points....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 08, 2007 at 08:59 AM

    Dear Soniya,

    I expect that you use the scheduling agreements with delivery schedules (if without, then the logic is similar to the standard orders). In the case of scheduling agreements with delivery schedules the open quantity is always determined dynamically during opening the scheduling agreement (the field VBEPD-OLFMNG). There are no fields on the database, which store the open quantity. The calculation of open quantity takes place in the function module RV_SCHEDULE_CHECK_DELIVERIES.

    The general algorithm of calculation of the open quantity is the following one. For every scheduling agreement and every delivery schedule you have: cumulated qunatity delivered (stored in the database table S073) and cumulated quantity received (can be changed always manually in VA32). Their difference gives the cumulated in-transtit quantity.

    The open qunatity is the schedule line quantities minus cumulated in-transit quantity. The quantity reduction through the transit quantity takes place from the first schedule line and goes to the later schedule lines before the complete in-transit quantity is distributed. All rest schedule lines give the open quantity, but only all delivery relevant schedule lines (if you use forecast and JIT or planning delivery schedules then not all your schedule lines are delivery relevant, according to your VBAK-ABDIS flag).

    It is the logic, how the open quantity VBEPD-OLFMNG is determined in the scheduling agreements with delivery schedules. This quantity has nothing to do with VBBE / VBBS, because in the scheduling agreements you have partially delivery-requirements relevant schedule lines (they are considered), pure delivery relevant schedule lines (they are considered), pure requirements schedule lines (they are not considered) and for nothing relevant schedule lines (they are not considered).

    If you have only forecast schedule, then the calculation is simpler, because all

    schedule lines are delivery and requirements relevant.

    Unfortunately as the field VBEPD-OLFMNG is calculated dynamically there are no options to write a simple report here which gives you the open quantity from the database table. So, there are no standard tools to calculate the open quantity so simple in the standard ERP system. As far, as I know, you can extract the open quantity into BW during saving the agreement.

    I hope, the info above helps you further.

    Kind regards,

    Akmal Vakhidov

    Development Support SD, SAP, Walldorf/Germany

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 07, 2007 at 05:54 PM

    check in VBBE & VBBS tables

    Regards

    rajendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 08, 2007 at 09:09 AM

    Dear Soniya,

    VBEH Schedule line history

    VBEP Sales Document: Schedule Line Data

    VLPKM Scheduling agreements by customer material

    VBAG Sales Document: Release Data by Schedule Line in Sch

    Hope this will help.

    Regards,

    Naveen.

    Add comment
    10|10000 characters needed characters exceeded