topic Re: Efficient Select Query in Application Development and Automation Discussions

Efficient Select Query

Former Member — Thu, 05 Jul 2007 10:59:13 GMT

Hi,

I want to have an effective select query with inner join for retrieving the fields

LIKP~LFDAT

VBRK~FKDAT

VBRP~FKIMG

VBEP~BMENG

with the common field VBELN that is there in all these tables...

If inner join is used four joins will come. Is it acceptable?

Thanks

Dinesh

Re: Efficient Select Query

Former Member — Thu, 05 Jul 2007 11:03:24 GMT

hi,

here we have to have use inner join and that is acceotable.

Jogdand M B

Re: Efficient Select Query

Former Member — Thu, 05 Jul 2007 11:04:12 GMT

Hi,

See using joins are acceptable becoz of the fast access than writing more than one query...So you can work with the same format...

Plz try to check with the se30 runtime analysis...Try the two form of the queries..you can see the difference

<b>TRY TO REWARD IF USEFUL</b>

Re: Efficient Select Query

seshatalpasai_madala — Thu, 05 Jul 2007 11:04:36 GMT

Hi,

ANother option would be splitting it into two queries and then working on the Internal tables instead.

Check both approaches and see which ones performance is better.

Regards,

Sesh

Re: Efficient Select Query

Former Member — Thu, 05 Jul 2007 11:04:50 GMT

Hi,

plz go through the following example------

----

TABLE DECLERATION

----

TABLES : MARA ,

MARC ,

MARD ,

MAKT.

----

DATA DECLERATION

----

TYPES : BEGIN OF STRUCT_MAT,

MATNR TYPE MATNR,

MEINS TYPE MEINS,

WERKS TYPE WERKS_D,

LGORT TYPE LGORT_D,

MAKTX TYPE MAKTX,

END OF STRUCT_MAT.

----

INTERNAL TABLE

----

DATA : ITAB TYPE STANDARD TABLE OF STRUCT_MAT WITH HEADER LINE.

----

SELECTION SCREEN

----

SELECT-OPTIONS : S_MATNR FOR MARA-MATNR.

----

S T A R T - O F - S E L E C T I O N

----

START-OF-SELECTION.

SELECT

A~MATNR

A~MEINS

B~WERKS

C~LGORT

D~MAKTX

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM MARA AS A

INNER JOIN MARC AS B ON

A_{MATNR = B}MATNR

LEFT OUTER JOIN MARD AS C ON

B_{MATNR = C}MATNR AND

B_{WERKS = C}WERKS

INNER JOIN MAKT AS D ON

A_{MATNR = D}MATNR

WHERE A~MATNR IN S_MATNR .

IF SY-SUBRC <> 0.

EXIT.

ENDIF.

----

W R I T E

----

WRITE :5 'MATERIAL NO' COLOR 3,

25 'PLANT' COLOR 3,

40 'STORAGE LOC' COLOR 3,

60 'DESCRIPTION' COLOR 3,

120 'UOM' COLOR 3.

ULINE.

LOOP AT ITAB.

WRITE :/5 ITAB-MATNR COLOR 6 INVERSE,

25 ITAB-WERKS COLOR 6,

40 ITAB-LGORT COLOR 6,

60 ITAB-MAKTX COLOR 6,

120 ITAB-MEINS COLOR 6.

ENDLOOP.

*****do rewards if usefull

vijay

Re: Efficient Select Query

Former Member — Thu, 05 Jul 2007 11:06:59 GMT

Hi,

Use JOIN condition and check the performance. If it is good then continue otherwise comment some table and do some trial and error method.

then detach the tables with more time and delete the duplicate entries from the first table and move it to a temp table

the use for all entries

this will work faster

Regards

Shiva

Re: Efficient Select Query

Former Member — Thu, 05 Jul 2007 13:10:23 GMT

THANKS GUYS