SAP QUERY - SO VS GRN EXP.DATE

59 Views Last edit Jan 30, 2022 at 05:20 AM 2 rev

Hello,

Is it possible to add the "OBTN,ExpDate" field in the below query.

SELECT T0.[DocNum],T0.[NumAtCard] 'Customer Ref No.',T0.[U_SREF],T0.[DocDate] ,T0.[DocDueDate],T1.[U_NeedByDate],T5.[SlpName],T0.[CardName] as 'Customer Name',T1.[ItemCode] as 'Product Code',T2.[FrgnName] as 'Cust.Item Code',T1.[Dscription],T1.[Quantity],T1.[unitMsr],T1.[OpenInvQty] as 'Pending Qty',T2.[OnHand],T2.[IsComMited],T2.[OnOrder],T1.[PriceBefDi] as 'Price',T1.[LineTotal] AS 'Sale Total',T3.[ItmsGrpNam] as 'Item Group',T4.[FirmName],T1.[Project], T0.[DocStatus],T1.[PoTrgNum],T0.[U_InstCom]

FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode] INNER JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod] INNER JOIN OMRC T4 ON T2.[FirmCode] = T4.[FirmCode] INNER JOIN OSLP T5 ON T0.[SlpCode] = T5.[SlpCode]

WHERE T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1] AND T0.[CANCELED] <>'Y' and T0.[CANCELED] <>'C' and T0.[DocStatus]<>'C' and T1.[OpenInvQty] > '0'