Skip to Content
0
May 02, 2012 at 06:21 AM

Performance issue in production for dfkkko and dfkkop

191 Views

Hi,

I am facing a performance issue when fetching vkont and gpart from dfkkop table.

Iam confused with the following options.

Please suggest me to get better performance for large volumes of data in production.

Option 1:

Using Inner Join:

SELECT b~opbel

b~augst

b~gpart

b~vkont

b~bldat

INTO TABLE it_dfkkop

FROM dfkkko AS a INNER JOIN dfkkop AS b

ON a~opbel = b~opbel

WHERE a~bldat IN s_date

AND b~augst = ' '.

Option 2:

For all entries:

SELECT opbel


bldat


FROM dfkkko


INTO TABLE it_dfkkko


WHERE bldat IN s_date.


CHECK it_dfkkko[] IS NOT INITIAL.


SORT it_dfkkko BY opbel.


SELECT opbel


augst


gpart


vkont


bldat


FROM dfkkop


INTO TABLE it_dfkkop


FOR ALL ENTRIES IN it_dfkkko


WHERE opbel = it_dfkkko-opbel


AND augst = ' '.

Thanks & Regards

Jayasree