Skip to Content
0
Former Member
Feb 26, 2009 at 06:22 PM

BI Report

43 Views

Hi Experts,

We have a job which extracts data from 2 sap tables i.e ANEA and BSEG based on following condition.

ANEA.BUKRS IN ('GF2V','GF3J') AND

ANEA.ANLN1 = BSEG.ANLN1 and

ANEA.GJAHR = BSEG.GJAHR AND

ANEA.BUKRS = BSEG.BUKRS AND

ANEA.AFABE = 1 AND

ANEA.GJAHR >= 2008 AND

ANEA.NAFAV = BSEG.DMBTR

Job is extracting only one column u201CPosting dateu201D from BSEG table and remaining columns from ANEA table.

While job executing it is requesting SAP to process the job, but SAP is not processing (showing as running in SAP)

BSEG table is having very huge data and we have tested by given two of above conditions i.e. ANEA.BUKRS IN ('ABC','XYZ') AND ANEA.GJAHR >= 2008 in SAP. Actually this will retrieve only for 2 companies 'ABC','XYZ' and 2008/2009 data only. For this SAP is taken 10 to 15 min time because there are 44,16,521 records (only for these 2 conditions).

Can some one suggest is there any other way around to make this job easier and faster ? fetching data from BSEG is very very slow. This job is taking very long time.

I would appreciate some one suggest a better way to execute this job in faster way.

Regards

Madan