data fatching from vbrk

[Former Member]

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

[Former Member]

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

[Rui_Dantas]

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