Optimize a BSIS / BSEG Query

[Former Member]

Hi,

My Report Requirement:-

Selection Screen Parameters: BUKRS, EBELN, BLDAT, ZLSPR and LIFNR.

I need to extract the PO's along with their material items and the vendor details.

I am able to extract the material details eaily. But while trying to access the vendor details my query gets stuck. I need to optimize it as much as possible.

I need to hit BSEG and BKPF for this. Can anyone please suggest if BSAK or any other table can be hit for getting this data.

I tried hitting BSIS and then BSEG instead of hitting BSEG directly. And then doing a FOR ALL ENTRIES to access BKPF data. But this does not work at all. The report gets stuck at BSIS only.

In the where condition i'm passing: BUKRS, BLDAT, GJAHR and ZUONR. There is no other field that I can use in the where clause.

<removed_by_moderator>

Regards,

Namrata

Edited by: Julius Bussche on Aug 17, 2008 1:35 PM

[Former Member]

Hi,

My Report Requirement:-

Selection Screen Parameters: BUKRS, EBELN, BLDAT, ZLSPR and LIFNR.

I need to extract the PO's along with their material items and the vendor details.

I am able to extract the material details eaily. But while trying to access the vendor details my query gets stuck. I need to optimize it as much as possible.

I need to hit BSEG and BKPF for this. Can anyone please suggest if BSAK or any other table can be hit for getting this data.

I tried hitting BSIS and then BSEG instead of hitting BSEG directly. And then doing a FOR ALL ENTRIES to access BKPF data. But this does not work at all. The report gets stuck at BSIS only.

In the where condition i'm passing: BUKRS, BLDAT, GJAHR and ZUONR. There is no other field that I can use in the where clause.

<removed_by_moderator>

Regards,

Namrata

Edited by: Julius Bussche on Aug 17, 2008 1:35 PM

[ThomasZloch]

Can you list the fields you actually need to extract, maybe there is a better access path to the desired information (e.g. using table EKKN).

Thomas

[vinod_vemuru2]

Hi,

BSIS is INDEX table for G/L Account documents. You have to fetch data from BSIK which is vendor open documents(If u want closed documents as well then add records from BSAD also). Now use for all entries in this table to get data from BKPF and BSEG.

In ur case why it got stuck up is it searching whole BKPF and BSEG tables.

Hope it is helpfull.

Thanks,

Vinod.