Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Join with EKBE

sanjay_deshpande4
Participant
0 Kudos

Dear All,

I am having below existing query. In this query now I want modification in such a way that

it_eine_latest will retain all values and EKBE will be joined in such a way that in case no entries from EKBE, the column from EKBE will be blank in it_eine_latest and if EKBE has values for EBELN/EBELP then those values should be available.

(D~BUDAT is nothing but EKBE~BUDAT)

SELECT a~infnr
a~ebeln
a~ebelp
a~datlb
a~netpr
a~peinh
b~netpr
c~lifnr
c~waers

D~BUDAT
FROM eine AS a JOIN
ekpo AS b
ON a~ebeln = b~ebeln AND
a~ebelp = b~ebelp
JOIN ekko AS c "ADORNAL CTASK0043115
ON b~ebeln = c~ebeln "ADORNAL CTASK0043115
INTO TABLE it_eine_latest
FOR ALL ENTRIES IN it_eina
WHERE a~infnr = it_eina-infnr AND
( a~esokz = '0' OR a~esokz = '3' ) AND " Std Order⋐con
a~bstyp = 'F' AND " PO
b~loekz = space AND
( b~pstyp = '0' OR b~pstyp = '3' )
AND c~bsart = 'NB'.

I will be thankful for kindly helping with above query.

Regards.

1 ACCEPTED SOLUTION

sanjay_deshpande4
Participant

Thanks Sandra Rossi for replying.

LEFT OUTER JOIN on EKBE is the solution.

2 REPLIES 2

Sandra_Rossi
Active Contributor

In your query, there are other tables joined, so I guess it's easy to do the same for EKBE. Did you try? If yes, what is your issue?

NB: I see other alike questions in the forum with some nice answers:

join EKKO EKPO "EKBE" site:sap.com

sanjay_deshpande4
Participant

Thanks Sandra Rossi for replying.

LEFT OUTER JOIN on EKBE is the solution.