select query for inner join

Former Member — Sun, 19 Apr 2009 10:51:41 GMT

Hi all,

give me the query with innerjoin

Based on the input values of Material number (MARC-MATNR) from selection screen check and get the Special Procurement type details from MARC-SOBSL and Material description details from MAKT-MAKTX.

basha....

Moderator message - instead of asking, you should try to write the code yourself and get back to the forum if you have a specific question.

Edited by: Rob Burbank on Apr 19, 2009 4:46 PM

Re: select query for inner join

faisalatsap — Sun, 19 Apr 2009 13:14:49 GMT

Hi,

Please Test the following Sample Code it is according to your requirement hope will solve out your problem,

TABLES: marc.

SELECt-OPTIONS somatnr for marc-matnr.

TYPES: BEGIN OF ty_matnr,
  matnr LIKE marc-matnr,
  sobsl LIKE marc-sobsl,
  maktx LIKE makt-maktx,
  END OF ty_matnr.

DATA: it_matnr TYPE STANDARD TABLE OF ty_matnr WITH HEADER LINE.

SELECT marc~matnr marc~sobsl makt~maktx
  into CORRESPONDING FIELDS OF TABLE it_matnr
  from marc INNER JOIN makt on ( marc~matnr eq makt~matnr )
  WHERE marc~matnr in somatnr.

Best Regards,

Faisal

topic Re: select query for inner join in Application Development and Automation Discussions

select query for inner join

Re: select query for inner join