Skip to Content
0
Former Member
Jan 10, 2008 at 10:00 AM

Good statement to remove this join statement

35 Views

select PA0002NACHN PA0002PERNR PA0002VORNA KNVPKUNNR KNVPPARVW KNVPPERNR KNVPSPART KNVPVKORG KNVPVTWEG VBAKAUART

VBAKERDAT VBAKERNAM VBAKERZET VBAKFAKSK VBAKKUNNR VBAKLIFSK VBAKSPART VBAKVBELN VBAKVKORG VBAKVTWEG VBUK~CMGST

VBUKVBELN TVLSLIFSP

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 KNVPPERNR = PA0002PERNR

inner join VBAK

on VBAKKUNNR = KNVPKUNNR

and VBAKSPART = KNVPSPART

and VBAKVKORG = KNVPVKORG

and VBAKVTWEG = KNVPVTWEG

inner join VBUK

on VBUKVBELN = VBAKVBELN

inner join TVLS

on TVLSLIFSP = VBAKLIFSK )

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.