topic Re: Table GLPCA in Application Development and Automation Discussions

Table GLPCA

Former Member — Mon, 27 Nov 2006 03:35:21 GMT

Hi,

I have a requirement where in I have to select data from table GLPCA ... this is a huge table ... Is there a way I can put the select query in background mode as the prg.. is getting timed out in the foreground mode... ?

Thank You,

SB.

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 03:39:47 GMT

for this either u have to use key fields or else create index on the fields which ur using in where clause....

even u can do it in background...using submit u can do this select in background mode and in foreground u have to wait till this backgroundjob gets completed and data is returned back...

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 03:49:21 GMT

Hi Ramesh,

I am already using the key fields ... but there is no increase in the performance ... & my BA did not suggest any indexes ... so only I am not using in the select ... but can you please explain how can I submit this select in the background mode ??

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 03:52:51 GMT

Could you post the code of the SELECT please?

Rob

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 03:56:35 GMT

Hi,

USe transaction SDBE to check out the efficient select statement for that table. SDBE can be used to check which select query will be maximum effective.

Cheers

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 04:05:29 GMT

Hi Rob,

The select is :-

FORM GET_GLPCA_DATA .

SELECT RYEAR

DRCRK

POPER

RBUKRS

RPRCTR

RACCT

HSL

KSL

USNAM

SGTXT

BLDAT

BUDAT

REFDOCNR

REFDOCLN

BLART

FROM GLPCA

INTO TABLE T_GLPCA

WHERE POPER IN S_POPER AND

RBUKRS IN S_RBUKRS AND

RPRCTR IN S_RPRCTR AND

KOKRS = 'ZSA1' AND

RACCT IN S_RACCT AND

USNAM IN S_USNAM AND

BUDAT IN S_BUDAT AND

REFDOCNR IN S_REFDOC AND

RYEAR IN S_RYEAR AND

RTCUR IN S_RTCUR .

IF SY-SUBRC = 0.

SORT T_GLPCA BY REFDOCNR.

ELSE.

MESSAGE I018. " No records found.

EXIT.

ENDIF.

ENDFORM. " GET_GLPCA_DATA

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 04:14:45 GMT

Hi,

Guess you are not using the KEY field in the select. Wihtout the key field the selcte will definitely be slower. Try creating secondary index.

Cheers

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 04:18:12 GMT

Hi Vijay,

How do I create & use the secondary index ??

Thank You,

Re: Table GLPCA

ferry_lianto — Mon, 27 Nov 2006 04:25:07 GMT

Hi SB,

Please check this link on how to create secondary index.

http://help.sap.com/saphelp_nw04/helpdata/en/cc/7c58b369022e46b629bdd93d705c8c/content.htm

Once you have created secondary with the key fields that you needed for the above select statement, then you just use the same select statement codes.

Hope this will help.

Regards,

Ferry Lianto

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 05:29:10 GMT

Well VJ there are already 5 indexes that are created in the table ... but unfortunately I cannot use any of those indexes... Can you please tell me what background method you were going to sugget me in your previous responses ??

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 05:34:47 GMT

Hi,

I think the only other option is to run your report in which you have defined the select statement in the background. But this option might not work if the requirement is to have the output displayed to the user in the foreground.

Cheers

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 05:46:47 GMT

So you mean background mode by using t-code SM36 ??

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 05:48:38 GMT

yes

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 05:53:12 GMT

Ok Thank You Vijay ...

Re: Table GLPCA

Former Member — Mon, 27 Nov 2006 14:35:22 GMT

There alreaqy is an index on KOKRS, RYEAR and RPRCTR for this table and you are using them in your select statement. So there is no need to create an index.

But you should make sure that neither S_RYEAR nor S_RPRCTR are empty before doing the select.

Rob