Skip to Content
0
Former Member
Apr 10, 2008 at 12:00 PM

Select Query using Joins

113 Views

Hi,

Please give me the Select query

I have to fetch EBELN,BUKRS,LIFNR,BSART,EKORG,EKGRP,WAERS,WKURS from EKKO and

EBELP,LGORT,MATKL ,WERKS,BEDNR,IDNLF,BPRME,NETPR from EKPO and

MENGE, SAKTO,AUFNR,ANLN1,GSBER,PS_PSP_PNR from EKKN and

LPEIN,EINDT,SLFDT, from EKET.

I have to fetch all the data into an single internal table(Mandatory) by a select query using Joins.

EKKO is having EBELN as primary key

EKPO is having EBELN,EBELP as primary key

EKKN is having EBELN,EBELP as primary key

EKET is having EBELN,EBELP as primary key

Can anybody Please give me the Select query.

With Regards

Ajay