data fatching from vbrk

Former Member — Mon, 26 Apr 2010 07:55:54 GMT

Dear Friends,

i need a list of Billing numbers ( Document numbers) from table VBRK.

for "where condition" i have customer #, Sales Org, Distribution Channel.

We have more than 1,000,000 records in VBRK table.

i am writing simple select statment but speed is so slow.

i need help to come out from this problem.

Regards

Malik

Re: data fatching from vbrk

Rui_Dantas — Mon, 26 Apr 2010 08:31:24 GMT

Hi.

You need to use index table VRKPA, with KUNDE, PARVW, VKORG and VTWEG. Then you can join with VBRK if you need fields that are not in VRKPA.

Regards,

Rui Dantas