topic Re: GL-wise report in Application Development and Automation Discussions

GL-wise report

Former Member — Tue, 27 Dec 2005 15:03:43 GMT

dear consultants,

i'm preparing a G/L-wise reports with,

tables: bsis,bseg.

with fields,

bukrs,hkont,zuonr,gjahr,belnr,buzei,budat,bldat,blart,gsber,shkzg,dmbtr,werks from bsis

bschl,matnr,menge,meins,ebeln,aufnr from bseg

when i've used inner join for bsis and bseg tables,

i'm getting error message that

JOIN can't be used for cluster tables

please,correct my select statement,

thanks& regards,

kalyan chandramouli

Re: GL-wise report

suresh_datti — Tue, 27 Dec 2005 15:05:31 GMT

Hi KC,

That is because BESG is a cluster table and you cannot use a JOIN on that. PL use the secondary index tables BSID & BSAD ( for open & cleared items )..

Regards,

Suresh Datti

Re: GL-wise report

Former Member — Tue, 27 Dec 2005 15:12:39 GMT

what is your requirement...

INDEXES of BSEG table

BSIS, BSIK, BSAS, BSAK.

BSEG and BSIS why are you joining...

BSIS is index of BSEG and you cannot use joins on cluster table.

regards

vijay

Re: GL-wise report

Former Member — Tue, 27 Dec 2005 15:15:36 GMT

hi suresh,

thanks for your quick reply,

you mean to say,

search all the required fields of BSEG from BSID&BSAD tables? and inner join BSIS with BSID & BSAD, instead of BSIS?

regards,

Re: GL-wise report

suresh_datti — Tue, 27 Dec 2005 15:19:44 GMT

Hi ,

like Vijay mentioned BSIS is an index of BSEG... whatever is in BSEG will also be in its INDEX tables.. ie BSIS, BSIK, BSAS, BSAK. ( BSID & BSAD for sales items).. it depends on your requirement.. but certainly you don't need to join BSEG & its index tables.. pl state your requirement.

Regards,

Suresh Datti

Re: GL-wise report

Former Member — Tue, 27 Dec 2005 15:19:54 GMT

hi vijay,

thanks for your quick reply,

i'm preparing a reports,fields from bsis and bseg database tables,

and,my select statement giving error,saying that cluster table can't be joined,

my problem is,how to write the select statement without inner join those tables,is there any alternative,

i heard there is 'select for all entries',but i don't know proper usage of that addition,

regards,

Re: GL-wise report

Former Member — Tue, 27 Dec 2005 15:29:15 GMT

you can proceed with suresh logic, you search for the fields required in BSID and BSAD and populate the data using join .

please tell your requirement...

that will be more clear..

vijay