INNER jOIN

[Former Member]

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.

[former_member156446]

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

[Former Member]

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'.

[former_member156446]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi here in my system iam getting error like,

No component exists with the name "ZZPURREQ"

[Former Member]

Thats, a Z field which we created here.

Its not working...

[Former Member]

<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'.

[Former Member]

Thank Q Amandeep it worked now.

[Former Member]

Cool. No Points ? LOL.

Amandeep

[Former Member]

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..

[Former Member]

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