linking VBAP and PRPS..

[former_member192432]

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

[Former Member]

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"

[former_member192432]

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

[Former Member]

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.

[Former Member]

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

[former_member192432]

Hi Vinod ,

I am not using VBAK table before VBAP select statement.

Regards

Chetan

[Former Member]

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

[Former Member]

First Check if GT_VBAP1 is not initial.

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

[Former Member]

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.

[Former Member]

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.

[former_member192432]

This message was moderated.