Problrm while Downloading BSEG table

[Former Member]

Hi Guys,

My program dumps the data from SAP to a text files.the tables which i am Downloading are BKPF , BSEG , BSAK BSIK and ZMMTT_WARRANTS.I am running my program in Background.But for downloading BSEg table it's taking so much of time.I kept in Backgroung1/2 hr back.BKPF got downloaded in 4 to 5 min's but for BSEG it took 25 minutes still the file is not created in the Application Server i sawed in AL11.Can any body suggest me how to increase the performance for BSEG table download.?(In se16 i entered BSEG table click enter.After that i clicked on Number of Entrieds button.It took 5 minutes still it didnot gave me the total number of entries.)

Thanks,

Gopi.

[Former Member]

Hi Guys,

My program dumps the data from SAP to a text files.the tables which i am Downloading are BKPF , BSEG , BSAK BSIK and ZMMTT_WARRANTS.I am running my program in Background.But for downloading BSEg table it's taking so much of time.I kept in Backgroung1/2 hr back.BKPF got downloaded in 4 to 5 min's but for BSEG it took 25 minutes still the file is not created in the Application Server i sawed in AL11.Can any body suggest me how to increase the performance for BSEG table download.?(In se16 i entered BSEG table click enter.After that i clicked on Number of Entrieds button.It took 5 minutes still it didnot gave me the total number of entries.)

Thanks,

Gopi.

[RichHeilman]

Performance may not get better due to the fact that BSEG is a HUGE table.

Regards

RIch Heilman

[Former Member]

Hi Rich,

In my development serverwe are having 6 million records for BSEG.I am doing Background job.Its already 51 minutes the file didn't get created in Application server AL11.so what shall i do shall i wait for some more time or shall i kill the processs?

Thanks,

Gopi.

[RichHeilman]

Well, if it is still doing the SELECT, then there wouldn't be a file yet. Check the progress via SM50, and evaluate how far it is into the SELECT statement, then make a decision.

Regards,

Rich Heilman

[Former Member]

Hi gopi,

BSEG is a huge table and normally takes a longer time. To my knowledge u need to wait.

Also depends on the biz need...whether u need all the fields or specific fields if specific fields u can get the fields from accessing the related tables also.

thank you

Ajay

[Former Member]

Hi Vijay,

I need all the fields .

Thanks,

Gopi.

[rodrigo_paisante3]

Try to verify nested loops, change select ... endselect to select ... into table, use read table and select ... for all entries when possible.

[former_member194669]

Hi,

Instead of downloading data from BSEG why don't you use

BSAD Accounting: Secondary index for customers (cleared items)

BSAK Accounting: Secondary index for vendors (cleared items)

BSAS Accounting: Secondary index for G/L accounts (cleared items)

BSID Accounting: Secondary index for customers

BSIK Accounting: Secondary index for vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary index for G/L accounts

aRs

[Former Member]

Hi aRs,

can you send me the relaion between all tables and how i have to dump the data?

Thanks,

Gopi.

[Former Member]

Download this file which has a nice pdf file of all the links between the FI/CO/SD tables. I found it pretty clear.

http://www.sap-img.com/sap-download/sap-tables.zip

<i><b>

Points are always welcome!</b></i>

Minami

[Former Member]

If you are downloading BKPF, BSAK and BSIK, why do you need BSEG?

Rob