Blocking sales orders

[Former Member]

Hello,

I'm trying to block the sales orders that have been totally delivered and its purchasing orders created (sometimes the item is purchased directly and delivered by a third party). I'm modifying the user-exit MV45AFZZ overwriting USEREXIT_READ_DOCUMENT to avoid executing tx-VA02. The main problem is how can I detect if a sales order has been totally delivered (not partially or others scenarios) and its purchasing orders created (third party)? Do I have to navigate through the tables? or does exist an status table such as VBUP (in this case, which files/values I have to take in mind?).

Thanks in advance,

Ricard.

[Former Member · Accepted solution]

hi

in se16 use the table VBUP and the field LFSTA to know the delivery status

regards

[Former Member]

Hi Oscar,

VBUK-LFSTK --- Delivery status

VBUK-LFGSK-- Overal delivery status for all items

Reward points pls.

Regards,

Govind.

[Former Member]

Hello Oscar,

You can check the delivery status of the sales order through LFSTA field in VBUP table.

Hope it helps.

Regards,

Priyanka

[Former Member]

Hi

Use <b>VBUP</b> table

[Manoj_Mahajan78]

Hi..

use VBUP table for finding delivery status of sales order....

Regds

MM