Comparison amoung two tables

Hi Aaron,

You need to use IF..ELSEIF statements for your requirement.

IF <condtion1>.

statements(1).

ELSEIF <condtion2>.

statements(2).

ENDIF.

If <condtion1> is true then statements(1) are executed,if not it will check whether <condtion1> is true.If it is true then statements(2) are executed.

LOOP AT IT_MARA INTO WA_MARA.

if wa_mara-meins = pa_unit.

>>Do as per ur requirement(1)

elseif wa_mara-meins = pa_unit.

>>Do as per ur requirement(2)

endif.

ENDLOOP.

Thanks,

Vinay

Hello Aaron

You could simplify your task using two simple SELECT statements:

DATA:
  gt_mara_ok     TYPE STANDARD TABLE OF mara,
  gt_mara_nok    TYPE STANDARD TABLE OF mara.


  SELECT * FROM mara INTO TABLE gt_mara_ok
    WHERE  matkl = pa_matkl
    AND     ( meins = pa_unit    OR
                  meinh = pa_unit ).

  SELECT * FROM mara INTO TABLE gt_mara_nok
    WHERE  matkl = pa_matkl
    AND     ( meins <> pa_unit    AND
                  meinh <> pa_unit ).

Regards

Uwe

REPORT ZBASE_UNIT_SELECT.

PARAMETERS: PA_MATKL TYPE MARA-MATKL, PA_UNIT TYPE MARA-MEINS.

DATA: IT_MARA TYPE TABLE OF MARA,

WA_MARA LIKE LINE OF IT_MARA.

DATA: IT_MARM TYPE TABLE OF MARM,

WA_MARM LIKE LINE OF IT_MARM.

START-OF-SELECTION.

SELECT * FROM MARA INTO TABLE IT_MARA WHERE MATKL = PA_MATKL.

select * from marm into table it_marm where ( ur condition).

or..

select * into corresponding fields of table it_marm from marm for all entries in it_mara where matnr = it_mara-matnr.

LOOP AT IT_MARA INTO WA_MARA.

if wa_mara-meins = pa_unit.

ur requirement.

else.

read table it_marm with key meinh = pa_unit.

if sy-subrc = 0.

ur requirement.

endif.

endif.

hope this helps..

Regards

CNU

If you don't mind, look at the following:

DATA: BEGIN OF T_TABLE OCCURS 0,

MATNR,

MEINS

MEINH

END OF TABLE.

SELECT A_{MATNR A}MEINS B~MEINH INTO TABLE T_TABLE

FROM MARA AS A INNER JOIN MARM AS B

ON A_{MATNR = B}MATNR

WHERE A_{MEINS <> PA_UNIT AND B}MEINH <> PA_UNIT.

My guess is this will fill table T_TABLE with materials where the base unit of measure (MEINS) and alternate unit of measure (MEINH) do not equal the supplied unit (PA_UNIT). Is this correct?

DATA:

gt_mara_ok TYPE STANDARD TABLE OF mara,

gt_mara_nok TYPE STANDARD TABLE OF mara.

SELECT * FROM mara INTO TABLE gt_mara_ok

WHERE matkl = pa_matkl

AND ( meins = pa_unit OR

meinh = pa_unit ).

SELECT * FROM mara INTO TABLE gt_mara_nok

WHERE matkl = pa_matkl

AND ( meins <> pa_unit AND

meinh <> pa_unit ).

Here is what I have now (thanks to your wonderful help)

PARAMETERS: PA_MATKL TYPE MARA-MATKL, PA_UNIT TYPE MARA-MEINS.

DATA: BEGIN OF T_TABLE OCCURS 0,
        MATNR TYPE MARA-MATNR,
        MEINS TYPE MARA-MEINS,
        MEINH TYPE MARM-MEINH,
      END OF T_TABLE.


SELECT A~MATNR A~MEINS B~MEINH INTO TABLE T_TABLE
      FROM MARA AS A INNER JOIN MARM AS B
      ON A~MATNR = B~MATNR
      WHERE A~MEINS <> PA_UNIT AND B~MEINH <> PA_UNIT and A~MATKL = PA_MATKL.

if sy-subrc = 4.
write: / 'No records found'.
endif.


LOOP AT T_TABLE.
  IF T_TABLE-MEINS = PA_UNIT OR T_TABLE-MEINH = PA_UNIT.
    DELETE T_TABLE WHERE MATNR = T_TABLE-MATNR.
  ENDIF.
ENDLOOP.

LOOP AT T_TABLE.
  WRITE: / T_TABLE-MATNR.
ENDLOOP.

However, no records are found EVER. I guess there is something wrong with the select statement but I'm not sure what.

Hi,

Manually check in SE16 if there is any material in the tables MARA & MARM that is not having the UOM of what you have given in the selection screen with the material group (MATKL)..

Thanks,

Naren

Hi,

Did you check it in the table MARM for the material 42..Whether there is any record for GAL..

Thanks,

Naren

This reply goes to everybody. I am so sorry I didn't realize that I was looking at the tables in our production box but I was developing in our dev box. It seems like I have my code working now but I won't know until I transport it to our test box and test it out. I appreciate all of the help I received so far. I'm keeping my fingers crossed! If my solution works I will change the question to answered and award points accordingly Thanks again!

Aaron