Skip to Content
0
Former Member
Jul 26, 2016 at 01:05 PM

Decode status document table OPOR

491 Views

Hi, i have to do a query on Purchase Order. I would like decode the status of purchase order for use the same wording of SAP.

Which combination of field of the table OPOR determines the follow status.

Open (DocStatus = 'O' AND Opor.Printed <> 'Y' AND Opor.Canceled <> 'Y')

Open - Printed (Opor.Printed= 'Y' and opor.DocStatus = 'O')

Closed (DocStatus = 'C' and Opor.Canceled <> 'Y')

Canceled (Opor.Canceled= 'Y' and opor.DocStatus = 'O')

Unapproved (Opor.confirmed = 'N' and opor.DocStatus = 'O')

Paid ???

Delivered ???

Closed - Cancellation ???

I think to have decode correctly some status. Can you help me to decode the remaining status and possibly correct the wrong status?

Thanks in advance.

Goodbye,

Matteo