topic Re: select in Application Development and Automation Discussions

select

Former Member — Wed, 11 Jun 2008 10:29:39 GMT

Hi ,

Can any one split the code which is written using join conditions in to normal select ,for vbak,vbrk,likp

select VBAK_{AUART VBAK}KUNNR VBAK_{VBELN VBAK}VTWEG VBFA_{POSNN VBFA}VBELN VBFA_{VBELV VBFA}VBTYP_N VBRK_{ERDAT VBRK}NETWR VBRK~VBELN

VBRK_{VBTYP VBRK}WAERK ZVBFA_{POSNN ZVBFA}VBELN ZVBFA_{VBELV ZVBFA}VBTYP_N LIKP_{VBELN LIKP}WADAT_IST

into (VBAK-AUART , VBAK-KUNNR , VBAK-VBELN , VBAK-VTWEG , VBFA-POSNN , VBFA-VBELN , VBFA-VBELV , VBFA-VBTYP_N , VBRK-ERDAT

, VBRK-NETWR , VBRK-VBELN , VBRK-VBTYP , VBRK-WAERK , ZVBFA-POSNN , ZVBFA-VBELN , ZVBFA-VBELV , ZVBFA-VBTYP_N , LIKP-VBELN

, LIKP-WADAT_IST )

from ( VBAK

inner join VBFA

on VBFA_{VBELV = VBAK}VBELN

inner join VBRK

on VBRK_{VBELN = VBFA}VBELN

and VBRK_{VBTYP = VBFA}VBTYP_N

inner join VBFA as ZVBFA

on ZVBFA_{VBELN = VBRK}VBELN

and ZVBFA_{VBTYP_N = VBRK}VBTYP

left outer join LIKP

on LIKP_{VBELN = ZVBFA}VBELV )

Former Member — Wed, 11 Jun 2008 10:31:14 GMT

Hi,

Fetch the data in different internal tables.Make use of FOR ALL ENTRIES...........Then consolidate the data into final internal table.

Former Member — Wed, 11 Jun 2008 10:39:09 GMT

Can you help in writing in one select statement for vbak,

the where condition is

where VBAK~AUART in SP$00004

and VBAK~KUNNR in SP$00006

and VBAK~VBELN in SP$00001

and VBAK~VTWEG in SP$00005

and VBFA~POSNN in SP$00008

and VBRK~ERDAT in SP$00007

and VBRK~VBELN in SP$00002

and ZVBFA~POSNN in SP$00009.

%dbacc = %dbacc - 1.

if %dbacc = 0.

stop.

endif.

add 1 to %count-VBAK.

%linr-VBAK = '01'.

extract %fg01.

endselect.

Thanks in advance ......will be rewarded greatfully