Skip to Content
0
P D
Aug 21, 2013 at 06:02 AM

Any Code that Replaces Inner Join?

21 Views

Hi Experts,

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.

Regards,

Marina.