select queiry is not working

[Former Member]

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 a_{vbeln a}erdat a_{ernam a}auart a_{vkorg a}vtweg a_{spart a}kunnr a_{vkbur a}vkgrp a_{lifsk a}faksk a_{augru a}knumv

b_{posnr b}matnr b_{werks b}lgort b_{kwmeng b}pstyv b_{abgru b}bedae b_{lprio b}vstel b_{ntgew b}brgew

b_{volum b}faksp b_{ktgrm b}taxm1 b_{abfor b}kalsm_k b_{matkl b}kondm b_{gsber b}prctr

into corresponding fields of table it_vbak

from vbak as a inner join vbap as b on a_{vbeln = b}vbeln

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

[Former Member]

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 a_{vbeln a}erdat a_{ernam a}auart a_{vkorg a}vtweg a_{spart a}kunnr a_{vkbur a}vkgrp a_{lifsk a}faksk a_{augru a}knumv

b_{posnr b}matnr b_{werks b}lgort b_{kwmeng b}pstyv b_{abgru b}bedae b_{lprio b}vstel b_{ntgew b}brgew

b_{volum b}faksp b_{ktgrm b}taxm1 b_{abfor b}kalsm_k b_{matkl b}kondm b_{gsber b}prctr

into corresponding fields of table it_vbak

from vbak as a inner join vbap as b on a_{vbeln = b}vbeln

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

[Former Member]

Hi,

Data from (VBAK,VBAP) both tables are not coming into it_vbak while using the Select statement.Anyway you are moving the data from table it_vbak to it_sorder.So declare an final internal like it_sorder which consists of both tables fields. Instead of using it_vbak, use it_sorder in the Select statement.I hope it will work fine.