06-16-2008 8:37 AM
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.
06-16-2008 8:40 AM
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR IN MATNR. <-- check this
06-16-2008 8:38 AM
the select options field MATNR
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR IN MATNR
06-16-2008 8:41 AM
06-16-2008 8:40 AM
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR IN MATNR. <-- check this
06-16-2008 8:40 AM
hii
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR IN MATNR.
reward if useful
thx
twinkal
06-16-2008 8:41 AM
hi,
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR *in matnr and MTART IN MTART*
Rgds.,
subash
06-16-2008 8:41 AM
hii
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE WA_ITAB WHERE
MATNR IN MATNR.
reward if useful
thx
twinkal
06-16-2008 8:41 AM
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
06-16-2008 8:41 AM
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