tables: mara, marc, makt.
TYPES: BEGIN OF TS_MARA,
MATNR LIKE MARA-MATNR,
WERKS LIKE MARC-WERKS,
MAKTX LIKE MAKT-MAKTX,
END OF TS_MARA.
DATA: LT_MARA TYPE TABLE OF TS_MARA,
LS_MARA LIKE LINE OF LT_MARA.
RANGES: R_MATNR FOR MARA-MANTR.
R_MATNR-LOW = '00000000000060000001'.
R_MATNR-HIGH = '00000000000060000011'.
R_MATNR-OPTION = 'BT'.
R_MATNR-SIGN = 'I'.
APPEND R_MATNR.
SELECT AMATNR BWERKS INTO CORRESPONDING FIELDS OF LT_MARA
FROM MARA AS A INNER JOIN MARC AS B
ON AMATNR = BMATNR
WHERE A~MATNR IN R_MATNR
AND B~WERKS EQ '0001'.
nOW MY REQUIREMENT IS TO POPULATE LT_MARA WITH MATERIAL DESCRIPTION WITH FOR ALL ENTRIES IN LT_MARA.
mY fINAL RESULT SHOULD BE,
LT_MARA SHOULD CONTAIN,
MATNR WERKS MAKTX