topic Re: JOIN in Application Development and Automation Discussions

JOIN

Former Member — Wed, 20 Jun 2007 13:45:23 GMT

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 — Wed, 20 Jun 2007 13:47:13 GMT

<b>use ~ instead of -

like MARA~MATNR</b>

regards

ravish

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

Former Member — Wed, 20 Jun 2007 13:48:15 GMT

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 — Wed, 20 Jun 2007 13:48:21 GMT

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