topic Re: SQL Query on BSEG in Application Development and Automation Discussions

SQL Query on BSEG

adnanmaqbool — Tue, 18 Mar 2008 07:46:37 GMT

Dear Guys

I have to pick documents from BSEG on the basis of VALUT.

Its taking too much time, is there any way to improve the query access on BSEG.

Re: SQL Query on BSEG

Former Member — Tue, 18 Mar 2008 07:54:43 GMT

Hi,

BSEG is cluster table. So dont use that in any case.

Regards

Sandipan

Re: SQL Query on BSEG

Former Member — Tue, 18 Mar 2008 07:57:28 GMT

Hi,

As BSEG is a cluster table,u will definitely get performance issue.

So u get the field VALUT(Value Date) from the table BSIS.

Hope this will resolve your issue.

Please reward points if useful.

Regards

Rose

Re: SQL Query on BSEG

Former Member — Tue, 18 Mar 2008 07:59:30 GMT

You can first use your query conditon to get key value of BSEG table from index table. Like company code,document No. and fiscal year. Index table like BSIS,BSAS and so on. You can search such tables in SE11 with search term BS*.

Regards

Chris.Xu