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