Skip to Content
0
Former Member
Jan 02, 2008 at 08:12 AM

MATKL

580 Views

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.