Hallo SAP Community ,
I have a working qurey , i was trying to show the sum of the numbers in the top of resalt table .
here is the Qurey :________________________________________________________
DECLARE @FI DATETIME
DECLARE @FF DATETIME
...
hey ,
eveything is working fine with me tell I tryed to expand my where to" AND TT0.DocStatus = 'O' "
thank you all sap community
SELECT TT0.CardCode as 'GP_Nummer', TT0.CardName as 'GP_Name', count(TT0.DocNum) as 'Anzahl Bestellung', count(...
Hallo Sam ,thank you for your replay , i found the answer . I only needed to change me Where from docstatus to canceledold TT0.DocStatus = 'O' / new canceld = 'N' best wishes,Tarek