How can I get Order Numbers which have status as CONFIRMED?

[Former Member]

Can you please tell me how can I get the Order Numbers which have status as CONFIRMED?

Regards,

Subho

[Former Member]

check AFRU table for order confirmation.

regards

shiba dutta

[Former Member]

But table(AFRU) stores both 'Confirmed' and 'Partially Confirmed' Orders. But I need only Confirmed Orders. Please see if you can do something.

Regards,

Subhasish

[Former Member]

select * from afru where aueru = 'X' "final one

and stokz ne 'x'."not cancelled one

Regards

Prabhu

[Former Member]

Hi,

look at table JEST or take FM

CALL FUNCTION 'STATUS_CHECK'

EXPORTING

OBJNR = CAUFV-OBJNR

STATUS = P_SYSH1

EXCEPTIONS

OBJECT_NOT_FOUND = 1

STATUS_NOT_ACTIVE = 2

OTHERS = 3.

for a special order.

Regards, Dieter

in TJ02 TJ02T are the status stored.

Regards, Dieter

Message was edited by:

Dieter Gröhn

[Former Member]

check

field AUERU of AFRU

Partial confirmation

X Final confirmation

1 Automatic final confirmation

regards

shiba dutta

[Former Member]

assuming you mean produciton orders, you can check the table JEST, which holds the statuses for the order, based on an object number, which is OR plus the order number. best to grab the object from the AUFK-OBJNR field.

Using AUFK-OBJNR, get the jest records from JEST, looking fo the confirmed status (I0009 in our system). As previously stated, the status texts are define in TJ02T by language

[RichHeilman]

One really quick and easy way to tell whether an order is confirmed or not is to simply check that the GETRI field in AFKO is not initial. If it is filled in then the order has been confirmed.

Regards,

Rich Heilman