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

Open Order information along with Schedule Line Information

Hi all,

We have the following scenario where, we need to get Schedule Line information along with Open Order informations. we found about the standard datasources, which are 2LIS_11_VASCL, 2LIS_12_VCSCL. .

Can anyone give us relevent scenarios/documents related to Open Order information along with Schedule Line. Please note we already have Open Order reporting in place.

regards,

partha

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 11:18 AM

    Hi,

    I may not be able to help you on providing the docs on achieving the open orders.

    But currently in my project, we acieved this by extracting the biling schedule lines, sales order item and scheduline lines and then combining them both in a ODS with a user exit appending the billing info w.r.t to sales order and then doing calculation for Order book quantity ( conf qty- inv qty) where OB qty is 0 will be a closed order where as NE 0 is an open order.

    Hope this will shed some light..

    Regards

    Srini

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 10:17 AM

    >

    > Hi all,

    >

    > We have the following scenario where, we need to get Schedule Line information along with Open Order informations. we found about the standard datasources, which are 2LIS_11_VASCL, 2LIS_12_VCSCL. .

    >

    > Can anyone give us relevent scenarios/documents related to Open Order information along with Schedule Line. Please note we already have Open Order reporting in place.

    >

    > regards,

    > partha

    Hi all,

    Can anyone please update me on this, I have asked this question before. Moreover I am not getting any information of the below mentioned datasources in help.sap.com.

    regards,

    partha

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 11:40 AM

    Open orders = Orders not yet completed

    In table VBUK-GBSTK = C means completed,Other than C is Open orders

    You can extract this table and refer it in your transformation or update rule to filter out only open orders

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:04 PM

    To extract the Open orders... You have to create the Generic DS with Functional Module... Because we have to lookup in multiple tables.... If u know the table names then create the Generic data source with functional module and write the code accordingly......

    Khaja

    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.