JOIN

[Former Member]

Hi experts,

I tried the following program.i got a error like 'mara-matnr' is unknown...could you please help me....

TABLES:MARA,MARC.

DATA:BEGIN OF ITAB OCCURS 0,

MATNR TYPE MARA-MATNR,

MTART TYPE MARA-MTART,

WERKS TYPE MARC-WERKS,

END OF ITAB.

SELECT MARA-MATNR MARA-MTART MARC-WERKS INTO TABLE ITAB FROM MARA

INNER JOIN MARC ON MARA-MATNR = MARC-MATNR.

[Former Member]

hi

<b>use ~ instead of -

like MARA~MATNR</b>

regards

ravish

<b>plz dont forget to reward points if helpful</b>

[Former Member]

HI,

try this:

SELECT MARA_{MATNR MARA}MTART MARC~WERKS INTO TABLE ITAB FROM MARA

INNER JOIN MARC ON MARA_{MATNR = MARC}MATNR.

Regards

Kannaiah

[Former Member]

Hi

You have to use tilda (~) symbol instaed of '-' symbol between fields

write the fileds as mara_{matnr mara}mtart marc~werks

Reward points for useful Answers

Regards

Anji

[Former Member]

HI

TABLES:MARA,MARC.

DATA:BEGIN OF ITAB OCCURS 0,

MATNR TYPE MARA-MATNR,

MTART TYPE MARA-MTART,

WERKS TYPE MARC-WERKS,

END OF ITAB.

SELECT MARA_{MATNR MARA}MTART MARC~WERKS INTO TABLE ITAB FROM MARA

INNER JOIN MARC ON MARA_{MATNR = MARC}MATNR.

rgds,

bharat.