topic Re: INNER jOIN in Application Development and Automation Discussions

INNER jOIN

Former Member — Wed, 12 Dec 2007 17:47:41 GMT

Hi all,

Pls let me know why the below statement is throughing an error saying

'Wrong expression "Inner Join "' in from clause

SELECT A_{AUART A}VBELN

B_{ZZPURREQ B}ZPURREQFLAG

FROM VBAK AS A

INNERJOIN VBAP AS B

ON A_{VBELN = B}VBELN

INTO TABLE IT_VBAK_VBAP

WHERE A~AUART = 'ZDQT'

AND B~ZPURREQFLAG = 'x'.

WHy is this statement giving an error.

Re: INNER jOIN

former_member156446 — Wed, 12 Dec 2007 17:57:14 GMT

check the strucuture of IT_VBAK_VBAP are they in the same order as ur writing in select.

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 17:58:44 GMT

Hi,

They are in the same order.

DATA: BEGIN OF IT_VBAK_VBAP OCCURS 0,

AUART LIKE VBAK-AUART,

VBELN LIKE VBAK-VBELN, " Sales Document

POSNR LIKE VBAP-POSNR,

ZZPURREQ LIKE VBAP-ZZPURREQ,

ZPURREQFLAG LIKE VBAP-ZPURREQFLAG,

END OF IT_VBAK_VBAP.

SELECT A_{AUART A}VBELN

B_{ZZPURREQ B}ZPURREQFLAG B~POSNR

FROM VBAK AS A

INNERJOIN VBAP AS B

ON A_{VBELN = B}VBELN

INTO TABLE IT_VBAK_VBAP

WHERE A~AUART = 'ZDQT'

AND B~ZPURREQFLAG = 'x'.

Re: INNER jOIN

former_member156446 — Wed, 12 Dec 2007 18:00:16 GMT

DATA: BEGIN OF IT_VBAK_VBAP OCCURS 0,

AUART LIKE VBAK-AUART,

VBELN LIKE VBAK-VBELN, " Sales Document

ZZPURREQ LIKE VBAP-ZZPURREQ,

ZPURREQFLAG LIKE VBAP-ZPURREQFLAG,

<b>POSNR LIKE VBAP-POSNR,</b>

END OF IT_VBAK_VBAP.

Award points if useful

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 18:00:31 GMT

Try this.

SELECT A~AUART A~VBELN 
B~ZZPURREQ B~ZPURREQFLAG 
INTO TABLE IT_VBAK_VBAP
FROM VBAK AS A 
INNER JOIN VBAP AS B 
ON 
AND A~VBELN = B~VBELN 
AND A~AUART = 'ZDQT'
AND B~ZPURREQFLAG = 'X'.

Amandeep

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 18:01:21 GMT

Hello Sharath,

Put that tin this way.


DATA: BEGIN OF IT_VBAK_VBAP OCCURS 0,
AUART LIKE VBAK-AUART,
VBELN LIKE VBAK-VBELN, " Sales Document
POSNR LIKE VBAP-POSNR,
ZZPURREQ LIKE VBAP-ZZPURREQ,
ZPURREQFLAG LIKE VBAP-ZPURREQFLAG,
END OF IT_VBAK_VBAP.



SELECT A~AUART A~VBELN
B~POSNR B~ZZPURREQ B~ZPURREQFLAG 
FROM VBAK AS A
INNERJOIN VBAP AS B
ON A~VBELN = B~VBELN
INTO TABLE IT_VBAK_VBAP
WHERE A~AUART = 'ZDQT'
AND B~ZPURREQFLAG = 'x'.

Message was edited by:

Naren Someneni

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 18:05:51 GMT

hi here in my system iam getting error like,

No component exists with the name "ZZPURREQ"

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 18:12:05 GMT

Thats, a Z field which we created here.

Its not working...

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 18:12:14 GMT

<b>SOLUTION</b>

DATA: BEGIN OF it_vbak_vbap OCCURS 0,
auart LIKE vbak-auart,
vbeln LIKE vbak-vbeln, 
posnr LIKE vbap-posnr,
END OF it_vbak_vbap.


SELECT a~auart a~vbeln B~ZZPURREQ B~ZPURREQFLAG 
INTO TABLE it_vbak_vbap
FROM vbak AS a
INNER JOIN vbap AS b
ON a~vbeln = b~vbeln
WHERE a~auart = 'ZDQT'
AND B~ZPURREQFLAG = 'X'.

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 18:19:00 GMT

Thank Q Amandeep it worked now.

Re: INNER jOIN

Former Member — Wed, 12 Dec 2007 20:21:38 GMT

Cool. No Points ? LOL.

Amandeep

Re: INNER jOIN

Former Member — Wed, 06 Feb 2008 12:26:30 GMT

Hai Every one...

How to link Normal table to Infotypes table ?

PA001_{PERNR , PA001}KOSTL

CSKT_{KOSTL ,CSKT}LTEXT.

BOTH PA001 & CSKT Common field is KOSTL.

I try to join using innerjoin concept , it can't be work. i was try many times.. it is not work. give me ur ideas pls..

Re: INNER jOIN

Former Member — Wed, 06 Feb 2008 12:50:55 GMT

Try This

>SELECT a_{pernr b}kostl

>INTO CORRESPONDING FIELDS OF TABLE itab

>FROM PA0001 AS a

>INNER JOIN KOSTL AS b

>ON a_{kostl = b}kostl AND

a~pernr = pernr-pernr. " For each personnel number in loop of LDB PNPCE/PNP