How to separate a single join into two separate join statement

Former Member — Fri, 11 Jan 2008 10:06:57 GMT

select PA0002_{NACHN PA0002}PERNR PA0002_{VORNA KNVP}KUNNR KNVP_{PARVW KNVP}PERNR KNVP_{SPART KNVP}VKORG KNVP_{VTWEG VBAK}AUART

VBAK_{ERDAT VBAK}ERNAM VBAK_{ERZET VBAK}FAKSK VBAK_{KUNNR VBAK}LIFSK VBAK_{SPART VBAK}VBELN VBAK_{VKORG VBAK}VTWEG VBUK~CMGST

VBUK_{VBELN TVLS}LIFSP

into (PA0002-NACHN , PA0002-PERNR , PA0002-VORNA , KNVP-KUNNR , KNVP-PARVW , KNVP-PERNR , KNVP-SPART , KNVP-VKORG , KNVP-VTWEG

, VBAK-AUART , VBAK-ERDAT , VBAK-ERNAM , VBAK-ERZET , VBAK-FAKSK , VBAK-KUNNR , VBAK-LIFSK , VBAK-SPART , VBAK-VBELN

, VBAK-VKORG , VBAK-VTWEG , VBUK-CMGST , VBUK-VBELN , TVLS-LIFSP )

from ( PA0002

inner join KNVP

on KNVP_{PERNR = PA0002}PERNR

inner join VBAK

on VBAK_{KUNNR = KNVP}KUNNR

and VBAK_{SPART = KNVP}SPART

and VBAK_{VKORG = KNVP}VKORG

and VBAK_{VTWEG = KNVP}VTWEG

inner join VBUK

on VBUK_{VBELN = VBAK}VBELN

inner join TVLS

on TVLS_{LIFSP = VBAK}LIFSK )

where PA0002~NACHN in SP$00003

and PA0002~PERNR in SP$00001

and KNVP~KUNNR in SP$00004

and KNVP~PARVW in SP$00014

and VBAK~AUART in SP$00005

and VBAK~ERDAT in SP$00011

and VBAK~ERNAM in SP$00013

and VBAK~ERZET in SP$00012

and VBAK~KUNNR in SP$00006

and VBAK~SPART in SP$00009

and VBAK~VBELN in SP$00010

and VBAK~VKORG in SP$00007

and VBAK~VTWEG in SP$00008.

Re: How to separate a single join into two separate join statement

Former Member — Fri, 11 Jan 2008 10:12:30 GMT

Hi,

1.Dont use joins.

2.Create separate internal table and write select statement.

Regards,

Billa