po line items to grpo

99 Views Asked by At

I have 2 condtions in my query if my line item from po (container no) having a grpo so it should display 'shipment received' if no grpo so it should display 'no shipment received' need your expertise here please.

SELECT
    OPOR.DocNum ,
    POR1.U_ContainerNo ,
    CASE
        WHEN POR1.U_ContainerNo IS NOT NULL THEN 'Shipment Received'
        ELSE 'No Shipment Received'
    END 
FROM
    OPOR
INNER JOIN POR1 ON POR1.DocEntry = OPOR.DocEntry 
LEFT JOIN
    OPDN ON OPOR.DocEntry = OPDN.DocEntry
LEFT JOIN
    PDN1 ON POR1.DocEntry = PDN1.BaseEntry
0

There are 0 best solutions below