topic Re: Select Query for VBRK table in Application Development and Automation Discussions

Select Query for VBRK table

Former Member — Mon, 26 Oct 2015 06:38:35 GMT

Hi Expert,

Kindly help me to sort this problem,

I am having requirement where I have to pass kunnr from knvv to kunag-vbrk where vbtyp EQ 'M' or 'O',.

where after all entries with knvv , my select query taking much more time to fetch data from vbrk as I know that key field of vbrk is VBELN but for joining knvv I had use kunag.

My code

Kindly help.

Thanks & Regards.

Re: Select Query for VBRK table

Former Member — Mon, 26 Oct 2015 06:51:51 GMT

HI Anand,

You need to narrow your search conditions. Currently you have given condition on sales org only. KNVV will have massive set of data and condition on VKORG only will result into this only.

Check with your functional consultant, whether its possible to put some more conditions on primary keys or not.

Thanks,

Swet

Re: Select Query for VBRK table

sundaramoorthy_ramalingam — Mon, 26 Oct 2015 07:08:57 GMT

Hi ,

Try using the secondary index for the field KUNRG but,

check if the switch is enabled.

Re: Select Query for VBRK table

Former Member — Mon, 26 Oct 2015 10:08:57 GMT

Did you not check Note 185530 - Performance: Customer developments in SD?

Based on this you should query table VRKPA instead of VBRK when doing a select on customer from VBRK. It will definitely improve the runtime. Don't go for unnecessary secondary index creation. It might have adverse impact on the system.

a) Search for invoices with customer number ("payer") (field VBRK-KUNRG):Incorrect: SELECT FROM vbrk WHERE kunrg = ...

Correct: SELECT FROM vrkpa WHERE kunde = ... then SELECT FROM vbrk WHERE vbeln = vrkpa-vbeln

Re: Select Query for VBRK table

Former Member — Tue, 27 Oct 2015 06:57:16 GMT

Thanks guys for your help,
Issue is solved as functional given more filters based on FKDAT in VBRK table.
Thanks & Regards.

Select Query for VBRK table