topic Re: linking VBAP and PRPS.. in Application Development and Automation Discussions

linking VBAP and PRPS..

former_member192432 — Fri, 07 May 2010 08:01:03 GMT

Hi friends ,

I am doing performance tuning for one report in that select stmt is written as below which is taking more time , i want change it so that it should use primary index ,. Is there any way to tune below statement

SELECT VBELN PS_PSP_PNR FROM VBAP INTO TABLE GT_VBAP1

FOR ALL ENTRIES IN GT_PRPS1

WHERE PS_PSP_PNR = GT_PRPS1-PSPNR.

Regards

Chetan

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 08:09:18 GMT

Hi,

IF not GT_PRPS1[] is initial. ---> Add condition

SELECT VBELN PS_PSP_PNR FROM VBAP INTO TABLE GT_VBAP1

FOR ALL ENTRIES IN GT_PRPS1

WHERE PS_PSP_PNR = GT_PRPS1-PSPNR.

endif.

your only passing item number in where conditon if possible can you please let me know what are the fiels in internal table "GT_PRPS"

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 08:09:29 GMT

Primary index: then you need the full key of VBAP in the WHERE clause. Unless you make sure the VBAP key is included in GT_PRPS1 there's no way to get it to use the primary index.

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 08:12:29 GMT

Hi,

Hope your first selection is on VBAK Table. Select the data from VBAP for all entries in VBAK

Try Below coding

Select <fields> from VBAP
into table GT_VBAP1
for all entries in IT_VBAK
where vbeln = it_vbak-vbeln.

data : l_tabix type sy-tabix.

loop at gt_vbap1 into wa_vbap1.
  move sy-tabix to  l_tabix.
  read table gt_prps1 into wa_prps1 with key pspnr = wa_vbap1-ps_psp_pnr.
  if sy-subrc ne 0.
    delete gt_vbap1 index l_tabix.
  endif.
endloop.

Regards

Vinod

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 08:14:29 GMT

First Check if GT_VBAP1 is not initial.

Secondly for using primary index your query should contain the key fields of VBAP

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 08:14:56 GMT

Try with below code

GT_PRPS1_tmp[] = GT_PRPS1[].

sort GT_PRPS1_tmp by PSPNR.

delete adjacent duplicates from GT_PRPS1_tmp comparing PSPNR.

SELECT VBELN PS_PSP_PNR FROM VBAP INTO TABLE GT_VBAP1

FOR ALL ENTRIES IN GT_PRPS1_tmp

WHERE PS_PSP_PNR = GT_PRPS1_tmp-PSPNR.

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 08:19:12 GMT

GT_PRPS1_tmp] = GT_PRPS1[.

sort GT_PRPS1_tmp by PSPNR.

delete adjacent duplicates from GT_PRPS1_tmp comparing PSPNR.

delete GT_PRPS1_tmp where PSPNR EQ 0.

IF not GT_PRPS1_tmp[] is initial.

SELECT VBELN PS_PSP_PNR FROM VBAP INTO TABLE GT_VBAP1

FOR ALL ENTRIES IN GT_PRPS1_tmp

WHERE PS_PSP_PNR = GT_PRPS1_tmp-PSPNR.

endif.

Re: linking VBAP and PRPS..

former_member192432 — Fri, 07 May 2010 08:49:39 GMT

Hi Sudheer ,

GT_PRPS1 contains below fields..

SELECT PSPNR PSPHI STUFE OBJNR

FROM PRPS INTO TABLE GT_PRPS1

FOR ALL ENTRIES IN GT_PROJ

WHERE PSPHI = GT_PROJ-PSPNR.

Regards

Chetan

Edited by: chetan teli on May 7, 2010 10:50 AM

Re: linking VBAP and PRPS..

former_member192432 — Fri, 07 May 2010 08:52:32 GMT

Hi Vinod ,

I am not using VBAK table before VBAP select statement.

Regards

Chetan

Re: linking VBAP and PRPS..

Former Member — Fri, 07 May 2010 09:02:14 GMT

Hi,

If you want to use the Primary key for VBAP, then the flow of data selection should come from VBAK to VBAP. If you are not using VBAK, then performance improvement on VBAP with reference to the field PS_PSP_PNR can be done by creating a seconday index on this field.

Regards

Vinod

Re: linking VBAP and PRPS..

former_member192432 — Thu, 23 Sep 2010 13:07:55 GMT

This message was moderated.