SELECT WITHOUT JOIN

[Former Member]

Sorry people..

How can i do this without join????

SELECT c_{bldat c}bukrs c_{lifnr p}name1 c_{rmwwr c}belnr c~gjahr

*c~cpudt

• c_{reindat c}xblnr

• FROM rbkp AS c

• INNER JOIN lfa1 AS p

• ON c_{mandt = p}mandt AND

• c_{lifnr = p}lifnr

• INTO TABLE it_output

• WHERE c~blart IN p_blartm AND "Tipo de cod

• c~bukrs IN p_bukrs AND "Sociedad

• c~lifnr IN p_lifnr AND "Codi Acreedor

• c~cpudt IN p_cpudt AND "Fecha CPU

• c~gjahr IN p_gjahr. "Ejercicio

[Former Member]

SELECT bldat bukrs lifnr  rmwwr belnr gjahr
cpudt
reindat xblnr
FROM rbkp  INTO  CORRESPONDING FIELDS OF TABLE it_output
 WHERE blart IN p_blartm 
bukrs IN p_bukrs AND 
lifnr IN p_lifnr AND 
cpudt IN p_cpudt AND
gjahr IN p_gjahr.

IF NOT IT_OUTPUT[] IS INITIAL.
  LOOP AT IT_OUTPUT.
     SELECT SINGLE NAME1 FROM LFA1 INTO IT_OUTPUT-NAME1 WHERE LIFNR = IT_OUTPUT-LIFNR .
   MOFIDY IT_OUTPUT TRANSPORTING NAME1 INDEX SY-TABIX.
  ENDLOOP.
ENDIF.

[alex_m]

Use For all entries instead of join.

[Former Member]

Why are you getting rid of the JOIN? Is it for performance?

Rob