Hi,
I'm trying to get details of the Customers who are not having sales document using standard tables KNA1 and VBAK to display records.
Inner join displays 236 records and Left-outer join returns 241 records, that means 5 Customers are there without sales document.
If I use the following code :
SELECT KNA1~KUNNR KNA1~LAND1 KNA1~NAME1 VBAK~VBELN VBAK~ERDAT VBAK~NETWR
INTO TABLE ITAB
FROM KNA1 LEFT OUTER JOIN VBAK
ON KNA1~KUNNR = VBAK~KUNNR
WHERE KNA1~KUNNR IN CUST
ORDER BY KNA1~KUNNR.
LOOP AT ITAB WHERE VBELN IS INITIAL.
Where Cust is a select-option to take input Customer Number Low and High value. This code returns the correct value i.e 5.
Whereas if I use
SELECT KNA1~KUNNR KNA1~LAND1 KNA1~NAME1 VBAK~VBELN VBAK~ERDAT VBAK~NETWR
INTO TABLE ITAB
FROM KNA1 LEFT OUTER JOIN VBAK
ON KNA1~KUNNR = VBAK~KUNNR AND VBAK~VBELN EQ 0
WHERE KNA1~KUNNR IN CUST
ORDER BY KNA1~KUNNR.
LOOP AT ITAB.
displays 8 records.
What I'm trying to do is, the Select statement only to fetch the number of records based on the condition where there is no sales document for the particular customer rather then getting all the records into internal table and then looping at no sales document.
Thanks in advance.
Bluesky
