Skip to Content
0
Dec 28, 2018 at 09:29 AM

SAP B1 Query Line Problem

134 Views

Hello,

I don`t want to see second column or third column... from "Lagerplatz" (Example : w5/2 (1.picture)). I want to take only first line for my Query.(Example : v2/3 (1. picture))

How can I do that?

Thank you

SELECT T0.[TaxDate], T0.[DocNum], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T3.[U_appBinLocation] FROM [dbo].[ORDR]  T0 INNER JOIN [dbo].[RDR1]  T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode] INNER JOIN OITW T3 ON T2.[ItemCode] = T3.[ItemCode] WHERE T0.[TaxDate] >= [%0] AND T0.[TaxDate] <= [%1]
GROUP BY T0.[TaxDate], T0.[DocNum], T0.[NumAtCard], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T3.[U_appBinLocation]

Attachments

foto2.png (37.2 kB)
foto1.png (145.2 kB)