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.