Skip to Content
0
Sep 10 at 10:37 AM

UDF Value match with Purchase Order SAP Business One HANA

61 Views

Dear all,

SAP Business One HANA

Please help me on below query. Query need to link with Purchase order. How to match T4."U_UNE_PONUM" this field with purchase order document number.

SELECT T0."DocNum", T0."BPLName", T0."U_DELIVERY", T0."ShipToCode" AS "Ship From",

T0."CardCode", T0."CardName", T0."DocDate",

T1."ShipDate" AS "Row Level Delivery Date",

T0."NumAtCard", T1."ItemCode", T1."Dscription",

T1."Quantity" AS "PO QTY", T4."Quantity" AS "Standlone AP Credit Memo Qty",

T4."NoInvtryMv" AS "WithoutQtyPosting",

T4."U_UNE_PONUM" AS "PO Number",

T1."OpenQty" AS "OpenQty", T1."Price",

T1."U_UNE_MRP",T1."LineTotal" AS "Total Price(Excluding Tax)" ,

T2."USER_CODE" AS "CREATED BY USER ID",

T2."U_NAME" AS "USER NAME"

FROM OPOR T0 INNER JOIN POR1 T1 ON T0."DocEntry" = T1."DocEntry"

LEFT JOIN OUSR T2 ON T0."UserSign"=T2."USERID"

LEFT JOIN OBPL T3 ON T3."BPLId"=T0."BPLId"

LEFT JOIN RPC1 T4 ON T1."DocEntry" = T4."DocEntry" AND T1."BaseRef"= T4."BaseRef"

----LEFT JOIN ORPC T5 ON T4."DocEntry" = T5."DocEntry"

WHERE T0."DocType" ='I'

AND T0."DocDate" >= [%0] AND T0."DocDate" <=[%1]