topic Re: Data selection from Table in Application Development and Automation Discussions

Data selection from Table

Former Member — Thu, 10 Dec 2009 04:12:28 GMT

Hi ,

My requirement is to have Commercial Documents which are not Accounted. So that I've used the following logic.

SELECT a~vbeln

a~vbtyp

a~fkdat

a~bukrs

a~kunrg

SUM( b~netwr )

FROM vbrk AS a INNER JOIN vbrp AS b

ON a_{vbeln EQ b}vbeln

INTO ls_bill WHERE a~vbtyp EQ 'M' AND

a~fkdat IN s_fkdat AND

a~bukrs IN s_bukrs AND

a~kunrg IN s_kunrg

GROUP BY a~vbeln

a~vbtyp

a~fkdat

a~bukrs

a~kunrg.

l_awkey = ls_bill-vbeln.

SELECT awkey FROM bkpf INTO l_awkey

WHERE awtyp EQ 'VBRK' AND

awkey EQ l_awkey AND

bukrs EQ ls_bill-bukrs.

ENDSELECT.

IF sy-subrc NE 0.

APPEND ls_bill TO lt_bill.

ENDIF.

CLEAR : ls_bill, l_awkey.

ENDSELECT.

Is that the above logic for getting data is correct. or First taking all the entries from VBRK and VBRP table then selecting entries from BKPF and then if any entry of VBRK is not in BKPF then taking that.

Regards,

Rajiv.V

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Dec 10, 2009 9:36 AM

Re: Data selection from Table

Former Member — Thu, 10 Dec 2009 04:32:36 GMT

You should have searched SDN for Performance Tuning.

Solution :

Please search SDN for Performance Tuning and then try to understand the use of various statements that you have used in terms of performance.

Re: Data selection from Table

tobiaskugelmann — Thu, 10 Dec 2009 05:18:18 GMT

Hi,

you should not use SELECT statements for such complex business logic. I would recommend you to search some BAPI or SAP function module, which is gathering the data for you.

Tobias

Re: Data selection from Table

Former Member — Thu, 10 Dec 2009 05:25:54 GMT

No Bapi nor FM is available. Pl tel me is that the logic is acceptable or not

Re: Data selection from Table

ThomasZloch — Thu, 10 Dec 2009 12:49:44 GMT

Check if you can use tables VBUK or VBUP instead of BKPF, e.g. VBUK-BUCHK sounds relevant for your task.

Thomas

Re: Data selection from Table

Former Member — Sat, 12 Dec 2009 05:30:14 GMT

Hi Thomos,

That BUCHK field is not relevent for me

-Rajiv