Open Order information along with Schedule Line Information

[Former Member]

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

[srinivas_anilkumar · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

>

> 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