Skip to Content
0
Former Member
Jul 15, 2008 at 04:45 AM

CORRECT THIS CODE

114 Views

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