topic Re: selections in Application Development and Automation Discussions

selections

Former Member — Fri, 22 Jun 2007 08:11:24 GMT

If we want to select multiple customers to get all selected cutomer order details ?

Re: selections

Former Member — Fri, 22 Jun 2007 08:14:05 GMT

Write

table kna1.

select-options: s_kunnr for kna1-kunnr.

select vbeln kunnr audat from VBAK into table itab

where kunnr in s_kunnr.

this will fetch all the customers sales orders entered on the selection screen.

Reward points for useful Answers

Regards

Anji

Re: selections

alex_m — Fri, 22 Jun 2007 08:14:38 GMT

Can you please explain in detail.

Re: selections

varma_narayana — Fri, 22 Jun 2007 08:15:10 GMT

Hi,

What i understatnd from ur doubt is:

In the basic list u want to display all the Customer details

(Here you display a Check box for each customer.

Eg:

DATA :BOX.

START-OF-SELECTION.

SELECT * FROM KNA1 INTO TABLE IT_KNA1.

END-OF-SELECTION.

LOOP AT IT_KNA1.

WRITE: / BOX AS CHECK-BOX,

IT_KNA1-KUNNR.

ENDLOOP.

In the Secondary list you can display the Orders of all customers selected.

i.e Checkboxes selected.

AT line-selection.

case SY-LSIND.

WHEN 1.

DO .

READ LINE SY-INDEX

FIELD VALUES BOX IT_KNA1-KUNNR.

IF SY-SUBRC NE 0.

EXIT.

ENDIF.

IF BOX = 'X'.

SELECT * FROM VBAK APPENDING TABLE IT_VBAK

WHERE KUNNR = IT_VBAK-KUNNR.

ENDIF.

ENDDO.

Hope this will solve.

Regards.

ENDCASE.