List of open sales order deliveries

[Former Member]

Hi Gurus

I'm trying to fetch the list of open sales order relevant deliveries in the system. Is there any standard report to fetch the same?

In the current requirement, we have tried the below logic:

Join table VLPMA & VBUK at VBELN

VLPMA u2013 Pass MATNR(Material) & LFART(Delivery Type) and fetch VBELN values

VBUK u2013 VBELN values from above with WBSTK(Goods Movement status) Not Equal to C {open deliveries}

LIPS u2013 Pass VBELN from above and MATNR & WERKS to fetch open sales order relevant deliveries for a material in a plant.

The above logic takes a lot of time to execute and hence the report has performance issue. Is there any other means to link the multiple fields in the Deliveries to fetch, only sales order deliveries that are still open?

Regards

Deepak Prasanna S

[Former Member · Accepted solution]

Hi

I am not sure about the exact requirement which is desired.By looking at the sample code I would assume you want sales order numbers for all the delivery documents for which the goods movement has not happened.Have you tried using table VBFA. I know the code would require some rework. This logic can reduce the execution time.

If this is required for reporting purposes you can try the SAP std reports(might not fit your exact requirements); try VA05(list of open sales orders).

Let me know of you require any further inputs.

Regards

[Former Member]

Hi,

In order to going for program logic you can get open sales orders through va05 and comming to

Deliveries you can get data from item table Lips and fetch data through common data between them

Thanks

Vishnu

[sankar_roy]

Hi Deepak,

I also have the same requirement i.e to get open sales order based on delivery.

Can you provide me the code for the same.

Regards,

Sankar Roy

[eduardo_hinojosa]

Hi

I think that I understand you now. Use the tcode VL06O and do the proper selections in the selection screen for status. Futhermore you can enhance the monitor with customer fields and set information to do filters after, for instance, the quantity for the goods movement (use table VBFA to search the MM document for the movement 601). For last, see Note 128150 - VL06: Designing your own display variants.

I hope this helps you

Regards

Eduardo

[Lakshmipathi]

If the requirement is to see the sale order references from open deliveries, you can check in LIPS table itself where you see the field VGBEL.

G. Lakshmipathi

[eduardo_hinojosa]

Hi

You can also enhance tcode VA05 and create your variants to filter these SO. See these notes

SAP Note 37871 - List display of open sales documents

SAP Note 350068 - Additionl fields in VA05:Customer material number as example

So, you'd have a list with the pending orders.

I hope this helps you

Regards

Eduardo

Edited by: E_Hinojosa on Mar 6, 2012 10:01 AM

[Former Member]

Hi Hinojosa

Thanks for the reply. My requirement is to pick Deliveries and not Sales Orders.

Regards

Deepak Prasanna S

[Former Member]

Hi,

I think you have implemented the logic for open deliveries.

I also need on same requirement, please advise how you have been done.

As of now I have figured out that VBUK.GBSTK field = A or B, those are nothing but Open deliveries.

Add your comments.

Thanks,

Ram

[Former Member]

Hi,

Could you please check below transaction.

VL06F

Best regards,

Anupa

[Former Member]

Mehta & Anupa

Thanks for the reply. I'm actually executing a PP Days of Supply report. The requirement is to include the Open Delivery quantities for a material in certain calculations. Since we started referring to LIPS, VBUK & VLPMA tables, to get open delveries for a sales order, the performance has been compromised.

Will check out the option of VL06F report and look at the feasibility of incorporating the logic and see if there is improvement in the performance of the report.

Regards

Deepak Prasanna S