Sales Orders

[Former Member]

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

[Former Member]

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

[Former Member]

Just try to link VBAP and LIKP or LIPS.

amit.

[Former Member]

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/

[Former Member]

Hi Vijay ,

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

THANKS,

[Former Member]

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.

[vinod_vemuru2]

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.