Skip to Content
0
Former Member
Dec 10, 2009 at 06:49 PM

Select query

23 Views

Hi All,

In the below query, we have two mandatory fields (ERDAT and KUNNR) and rest of the fields are non-mandatoty. If I give the inputs to the mandatory fields and say execute in the program, it is not giving values. But if I give the same inputs in table VBAK (in SE11) for mandatory fields and say execute, I am getting the values.

SELECT * FROM VBAK INTO TABLE I_VBAK

WHERE ERDAT IN S_ERDAT

AND AUART IN S_AUART

and VKORG = P_VKORG

AND VTWEG = P_VTWEG

AND SPART = P_SPART

AND KUNNR IN S_KUNNR.

Could you Please advice where it is going wrong?

Thanks in advance.

Regards

Ramesh.