I have a select option field SO_FKDAT (DATE FIELD) in a selection screen. Based on the value of SO_FKDAT field I have to take the records from the VBRK table. Then with the VBELN field of VBRK I have to take value from VBRP table.
Here is the code I wrote for achieving the same and it is working perfectly.
SELECT VBRK~FKDAT VBRK~VBELN VBRK~FKART VBRK~KUNAG VBRK~KUNRG VBRK~VKORG VBRK~VTWEG VBRK~NETWR VBRP~VKBUR
INTO CORRESPONDING FIELDS OF TABLE IT_FINOVR FROM VBRK JOIN VBRP ON ( VBRK~VBELN = VBRP~VBELN ) WHERE VBRK~FKDAT IN SO_FKDAT.
But I want to know whether there are any other coding styles to achieve the same. For All Entries In is not an option since it does not take duplicate entries.