Which field stores the Cancelled Sales Order Status

[senthil_kumar29]

Hi,

I am checking for duplicate PO No in sales Order header VBAK. The criteria is Slaes Order must not be a cancelled one. I am searching VBAK to find the status field to determine the whether its cancelled or not.

Thank U for Ur time.

Cheers,

Sam

[Former Member]

Hi Raj,

check in the table CDHDR.

hope it gives you the solution.

cheers,

anil.

[baerbel_haenelt]

Hello Sam,

to find out whether a sales order item is cancelled - better rejected - (if it is cancelled there is no VBAK or document any more) you could use the field reason for rejection on item level which is the field VBAP-ABGRU.

Best regards, Baerbel

[pratik_mahendra]

Good morning SAM,

Im not too sure for what you want but i will guide you thru that i understood, you can define status for each doc. may be for cancelled doc you assigen 'c' as an status. this can be done in IMg -SD- sales- sales documents - define and assign status profile.

I hope it solves your issue.

[senthil_kumar29]

Hi,

Thanx for Ur reply.

I am choosing these fileds from a report, I would like to know the table n field name to get the status.

Cheers,

Sam

[Former Member]

Hi

I am not sure about the field but i can give you the table name that is VBUK is table for sales order header status VBUP is for sales order item status.

Thanks

Mastan