topic SELECT WITHOUT JOIN in Application Development and Automation Discussions

SELECT WITHOUT JOIN

Former Member — Fri, 05 Jan 2007 15:24:32 GMT

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

Re: SELECT WITHOUT JOIN

Former Member — Fri, 05 Jan 2007 15:30:57 GMT

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.

Re: SELECT WITHOUT JOIN

alex_m — Fri, 05 Jan 2007 15:36:19 GMT

Use For all entries instead of join.

Re: SELECT WITHOUT JOIN

Former Member — Fri, 05 Jan 2007 15:52:47 GMT

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

Rob