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: 

inner join with for all entries

Former Member
0 Kudos
114

Inner join with for all entries is possible if possible pls forward the syntax.

3 REPLIES 3

Former Member
0 Kudos
79

IF GT_IMAK[] IS NOT INITIAL.

SELECT A~POSNR

A~OBJNR

B~PRNAM

B~POSID

B~GJAHR

FROM IMZO AS A

INNER JOIN IMPR AS B ON

APOSNR = BPOSNR

INTO CORRESPONDING FIELDS OF TABLE GT_INVT

FOR ALL ENTRIES IN GT_IMAK

WHERE A~OBJNR = GT_IMAK-OBJNR1.

ENDIF.

Regards

Peram

varma_narayana
Active Contributor
0 Kudos
79

Hii Rajaram..

It is possible but not that efficient...

IF IT_EKPO[] IS NOT INITIAL.

select MARAMATNR MARAMTART MAKT~MAKTX

FROM MARA

INNER JOIN MAKT

ON MARAMATNR = MAKTMATNR

INTO TABLE IT_MAT

FOR ALL ENTRIES IN IT_EKPO

WHERE MARA~MATNR = IT_EKPO-MATNR.

ENDIF.

<b>Reward if Helpful</b>

former_member404244
Active Contributor
0 Kudos
79

Hi,

yes its possible..

If not it_lfb1[] is initial.

SELECT lfa1lifnr lfa1land1

lfa1~name1

lfa1~ort01

lfa1~regio

lfm1~ekorg

FROM lfa1 INNER JOIN lfm1

ON lfa1lifnr = lfm1lifnr

for all entries in it_lfb1

where lifnr = it_lfb1-lifnr.

ENDIF.

Regards,

nagaraj