inner join with for all entries

[Former Member]

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

[Former Member]

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

A_{POSNR = B}POSNR

INTO CORRESPONDING FIELDS OF TABLE GT_INVT

FOR ALL ENTRIES IN GT_IMAK

WHERE A~OBJNR = GT_IMAK-OBJNR1.

ENDIF.

Regards

Peram

[varma_narayana]

Hii Rajaram..

It is possible but not that efficient...

IF IT_EKPO[] IS NOT INITIAL.

select MARA_{MATNR MARA}MTART MAKT~MAKTX

FROM MARA

INNER JOIN MAKT

ON MARA_{MATNR = MAKT}MATNR

INTO TABLE IT_MAT

FOR ALL ENTRIES IN IT_EKPO

WHERE MARA~MATNR = IT_EKPO-MATNR.

ENDIF.

<b>Reward if Helpful</b>

[former_member404244]

Hi,

yes its possible..

If not it_lfb1[] is initial.

SELECT lfa1_{lifnr lfa1}land1

lfa1~name1

lfa1~ort01

lfa1~regio

lfm1~ekorg

FROM lfa1 INNER JOIN lfm1

ON lfa1_{lifnr = lfm1}lifnr

for all entries in it_lfb1

where lifnr = it_lfb1-lifnr.

ENDIF.

Regards,

nagaraj