Skip to Content
Home
Community
Ask a Question
Write a Blog Post
Login / Sign-up
Search Questions and Answers
-3
shanmukha tejas
Jul 10, 2020 at 01:39 PM
Inner join not working.
208 Views
Follow
RSS Feed
when i comment inner join lfa1 line, only then data is getting fetched
SELECT a~rldnr,
a~rbukrs,
a~gjahr,
a~belnr,
a~racct,
a~rcntr,
a~prctr,
a~wsl,
a~budat,
a~blart,
a~zuonr,
a~lifnr,
a~ps_posid,
a~sgtxt,
a~koart,
a~timestamp,
b~saknr,
b~txt50,
c~bukrs,
c~belnr AS belnr1,
c~gjahr AS gjahr1,
c~bktxt,
d~name1,
d~lifnr AS lifnr1,
e~posid,
e~post1,
f~kostl,
f~ltext
FROM acdoca AS a
INNER JOIN skat AS b ON a~racct EQ b~saknr AND b~spras = @sy-langu
INNER JOIN bkpf AS c ON a~rbukrs EQ c~bukrs AND a~gjahr EQ c~gjahr AND a~belnr EQ c~belnr
INNER JOIN lfa1 AS d ON a~lifnr EQ d~lifnr INNER JOIN prps AS e ON a~ps_posid EQ e~posid
LEFT OUTER JOIN cskt AS f ON a~rcntr EQ f~kostl AND f~spras = @sy-langu
INTO TABLE @DATA(lt_acdoca)
WHERE a~rldnr = @lc_led
AND a~rbukrs = @p_rbukrs
AND a~belnr IN @so_belnr
AND a~racct IN @so_racct.