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