Hi all
In the below program i need to select the MATKL field from MARA Table and MATNR is the only common field in both MARA and S026 tables.Please help.
Vijay
REPORT ZCO_OVERHEAD_TEST1.
TABLES:S026,MARA.
DATA:IT_S026 TYPE STANDARD TABLE OF S026 WITH HEADER LINE.
DATA:IT_MARA TYPE STANDARD TABLE OF MARA WITH HEADER LINE.
DATA:IT_REPORT TYPE STANDARD TABLE OF S026 WITH HEADER LINE.
PARAMETERS:p_werks type S026-WERKS.
SELECT-OPTIONS:p_sptag FOR S026-SPTAG.
OBLIGATORY.
DATA:x TYPE i.
SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE
IT_S026 WHERE WERKS = P_WERKS AND
SPTAG IN p_sptag .
LOOP AT IT_S026.
WRITE:/ IT_S026-ENMNG,IT_S026-WERKS,IT_S026-SPTAG,IT_S026-MATNR.
IT_REPORT-ENMNG = IT_S026-ENMNG .
SELECT * FROM MARA INTO CORRESPONDING FIELDS OF TABLE
IT_MARA WHERE ERSDA IN p_sptag.
ADD IT_S026-ENMNG TO X.
ENDLOOP.
WRITE:/ 'Material Group::',IT_MARA-MATKL.
WRITE:/ 'TOTAL::',x.