JUST TELL ME THE ANSWER

[Former Member]

TABLES: MARA.

SELECTION-SCREEN: BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

SELECT-OPTIONS: MATNR FOR MARA-MATNR,

MTART FOR MARA-MTART.

SELECTION-SCREEN: END OF BLOCK B1.

DATA: BEGIN OF ITAB,

MATNR LIKE MARA-MATNR,

MTART LIKE MARA-MTART,

MATKL LIKE MARA-MATKL,

LAEDA LIKE MARA-LAEDA,

END OF ITAB.

DATA: WA_ITAB LIKE ITAB OCCURS 0.

DATA WA LIKE LINE OF WA_ITAB.

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE

MATNR = ?????????.

LOOP AT WA_ITAB INTO WA.

WRITE : WA-MATKL.

ENDLOOP.

CAN U TELL ME WHAT TO WRITE IN ??????? SO THAT IT WILL FETCH DATAS FROM THE MARA TABLE BASED ON THE VALUES IN SELECTION SCREEN.

[Former Member]

the select options field MATNR

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE

MATNR IN MATNR

[Former Member]

THANKS A LOT

[Former Member]

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE

MATNR IN MATNR. <-- check this

[Former Member]

hii

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE

MATNR IN MATNR.

reward if useful

thx

twinkal

[Former Member]

hi,

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE

MATNR *in matnr and MTART IN MTART*

Rgds.,

subash

[Former Member]

hii

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE

MATNR IN MATNR.

reward if useful

thx

twinkal

[raymond_giuseppi]

SELECT * FROM MARA 
  INTO CORRESPONDING FIELDS OF TABLE WA_ITAB 
  WHERE MATNR IN MATNR AND MTART IN MTART.

The ABAP compiler is able to distinguish the field of the database and the select-options even if they have the same name.

Regards

[Former Member]

Hi Ansuman,

SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR = ?????????.

In this statement we are fetching the data from the database table depending on the WHERE condition. Here if we sepecify the MATNR value then a single record containg all the fields is selected .

IN S_MATNR gives u the number of records which are specified in the selection screen

Best regards,

raam