Skip to Content
0
Former Member
May 11, 2010 at 06:09 AM

Radio button group to be included in the Select statement

77 Views

Hi ! This is the Select statement :-

  SELECT EKKO~EBELN EKKO~BUKRS EKKO~BSTYP EKKO~BSART EKKO~BEDAT EKKO~LIFNR EKKO~ERNAM EKKO~AEDAT EKKO~STATU EKPO~LOEKZ EKKO~EKORG
         EKKO~EKGRP EKKO~IHREZ EKKO~UNSEZ EKKO~TELF1 EKKO~FRGKE EKKO~FRGGR EKKO~FRGSX EKKO~FRGRL EKKO~FRGZU EKKO~ZTERM EKKO~REVNO
         EKKO~SUBMI LFA1~NAME1 EKPO~EBELP EKPO~MATNR EKPO~WERKS EKPO~LGORT EKPO~MATKL EKPO~MENGE EKPO~BPRME EKPO~NETWR EKPO~ELIKZ
         EKPO~EREKZ EKPO~KNTTP EKPO~WEPOS EKPO~EGLKZ EKPO~TXZ01 EKPO~ANFNR EKPO~EFFWR EKPO~MWSKZ EKPO~NETPR
  INTO CORRESPONDING FIELDS OF TABLE DISP
   FROM EKKO INNER JOIN LFA1 ON EKKO~LIFNR = LFA1~LIFNR
             INNER JOIN EKPO ON EKKO~EBELN = EKPO~EBELN
             UP TO P_MAXROW ROWS
   WHERE EKKO~EBELN   IN PO_NO    AND
         EKKO~BUKRS   IN COMP_CDE AND
         EKKO~BSTYP   IN PUR_CAT  AND
         EKKO~BSART   IN PO_DOCT  AND
         LFA1~LIFNR   IN VEN_NAM  AND
         EKKO~AEDAT   IN PO_DATE  AND
         EKPO~KNTTP   IN AC_ASG   AND
         EKKO~FRGGR   IN REL_GRP  AND
         EKKO~FRGKE   IN REL_INDI AND
         EKKO~FRGSX   IN REL_STR  AND
         EKKO~IHREZ   IN UR_REF   AND
         EKKO~ERNAM   IN PER_NAME AND
         EKKO~FRGZU   IN REL_STS  AND
         EKKO~SUBMI   IN CLVE     AND
         EKKO~EKGRP   IN PUR_GRP  AND
         EKKO~EKORG   IN PUR_ORG  AND
         EKKO~ZTERM   IN PAY_TERM AND
         EKKO~REVNO   IN VER_SN   AND
         EKPO~MATNR   IN MAT_NO   AND
         EKPO~LGORT   IN STOR_LOC AND
         EKPO~MATKL   IN MAT_GRP  AND
         EKKO~FRGRL   IN NOT_COMP AND
         EKPO~ELIKZ   IN DEL_IND  AND
         EKPO~LOEKZ   IN DEL_FLAG AND
         EKPO~ANFNR   IN RFQ_NO   AND
         EKPO~WERKS   IN PLANT1   AND
         EKPO~MWSKZ   IN TAX_COD  .

I have created a radio button group called DLST. Now, how can i include this group in my select statement. The purpose of this radio button selection :- Whenever user makes a selection on the selection screen then, the selection is in the group and I want my select statement to fetch that selected fields data only.

Please help.