Skip to Content
0
Former Member
Jul 16, 2008 at 07:36 AM

select queiry is not working

20 Views

Hi All,

There is a problem that iam unable to get all condition type.

geting only one record

it as to fecth all condition types

code is...

*select Sales Document: Header Data and Item Data from vbak and vbap

select avbeln aerdat aernam aauart avkorg avtweg aspart akunnr avkbur avkgrp alifsk afaksk aaugru aknumv

bposnr bmatnr bwerks blgort bkwmeng bpstyv babgru bbedae blprio bvstel bntgew bbrgew

bvolum bfaksp bktgrm btaxm1 babfor bkalsm_k bmatkl bkondm bgsber bprctr

into corresponding fields of table it_vbak

from vbak as a inner join vbap as b on avbeln = bvbeln

where a~vbeln in lr_vbeln and

a~vkorg in lr_vkorg and

a~vtweg in lr_vtweg and

a~spart in lr_spart and

b~werks in lr_plant and

a~auart in lr_auart and

a~erdat in lr_erdat.

  • Move all the data to it_sorder

IF sy-subrc = 0.

LOOP AT it_vbak.

MOVE-CORRESPONDING it_vbak TO it_sorder.

APPEND it_sorder.

CLEAR it_sorder.

ENDLOOP.

ENDIF.

*select Conditions from konv

IF NOT it_sorder[] IS INITIAL.

SELECT knumv kposn STUNR KAPPL ZAEHK kschl kbetr KAWRT

INTO CORRESPONDING FIELDS OF TABLE it_konv

FROM konv FOR ALL ENTRIES IN it_sorder

WHERE knumv = it_sorder-knumv and

kposn = it_sorder-posnr.

ENDIF.

  • Read Conditions from it_konv move it to it_sorder

LOOP AT it_sorder.

Loop at it_konv where knumv = it_sorder-knumv and

kposn = it_sorder-POSNR.

IF sy-subrc = 0.

it_sorder-kposn = it_konv-kposn.

it_sorder-STUNR = it_konv-STUNR.

it_sorder-KAPPL = it_konv-KAPPL.

it_sorder-ZAEHK = it_konv-ZAEHK.

it_sorder-kschl = it_konv-kschl.

it_sorder-kbetr = it_konv-kbetr.

MODIFY it_sorder transporting kposn STUNR KAPPL

ZAEHK kschl kbetr

Where knumv = it_sorder-knumv and

posnr = it_sorder-POSNR.

CLEAR it_sorder.

ENDIF.

Endloop.

ENDLOOP.

pls can you help me.

thanks

mars