topic Re: Sales Orders in Application Development and Automation Discussions

Sales Orders

Former Member — Mon, 28 Jul 2008 10:55:29 GMT

Hi,

Need to remove sales order items which are been PGI from a report . Just wondering what tables will give the info. whether a sales order item is been PGI or not .

Thanks,

Vind

Re: Sales Orders

Former Member — Mon, 28 Jul 2008 10:58:22 GMT

Just try to link VBAP and LIKP or LIPS.

amit.

Re: Sales Orders

Former Member — Mon, 28 Jul 2008 11:03:10 GMT

you can find the status using the table VBUP

VBUP-WBSTA = 'C'. then it is completely Processed.

WBSTA is the Goods Movment status.

So using the status you can delete the items from VBAP/

Re: Sales Orders

Former Member — Mon, 28 Jul 2008 11:08:42 GMT

Hi Vijay ,

The status is blank for table vbup so its not working that way though the orders itenms are PGI.

THANKS,

Re: Sales Orders

vinod_vemuru2 — Mon, 28 Jul 2008 11:09:22 GMT

Hi,

Just go to VBFA table.

Give sales order and item in VBELV and POSNV fields, capital R in vbtyp_n field. If u have a record then PGI is done. If not the PGI is not done. In the field VBELN u will get GI doc number.

This table not only give u PGI. U can check in backwards also like by giving delivery u can find sales order.

Thanks,

Vinod.

Re: Sales Orders

Former Member — Mon, 28 Jul 2008 11:16:46 GMT

You have to check the PGI from Delivery .

SO you go to Delivery

First select all the sales orders ,

Now using the sales Orders Go to table LIPS

with the LIPS-VGBEL = VBAP-VBELN and

LIPS-VGPOS = VBAP-POSNR.

Now you will get all the Deliveries.

using the deliveries you go to the Table VBUP with WBSTA = 'C' now you will be success.

what ever Delivery you will find entry in the VBUP with WBSTA = 'C' you delete those sales orders.