topic Re: General in Application Development and Automation Discussions

General

Former Member — Mon, 08 Oct 2007 18:44:21 GMT

Hi Folks,

I am getting an error at my inner join saying column name SPART has 2 meanings , same with ERDAT too .. donno whatz the problem . could anyone rectify .

here is my code ..

select A~VBELN

A~ERDAT

A~ERNAM

A~AUART

A~VKORG

A~VTWEG

A~SPART

A~VSBED

A~KUNNR

B~VBELN

B~POSNR

B~MATNR

B~PSTYV

B~KWMENG

C~VBELN

C~POSNR

C~WMENG

C~BMENG

D~VBELN

D~POSNR

D~LFSTA

D~FKSAA

E~VBELV

E~POSNV

E~VBELN

E~POSNN

E~VBTYP_N

into corresponding fields of table GT_VBAK

from VBAK as A inner join VBAP as B on A_{VBELN = B}VBELN

inner join VBEP as C on B_{VBELN = C}VBELN and B_{POSNR = C}POSNR

inner join VBUP as D on C_{VBELN = D}VBELN and C_{POSNR = D}POSNR

inner join VBFA as E on D_{VBELN = E}VBELV and D_{POSNR = E}POSNN

where VKORG in S_VKORG

and VTWEG in S_VTWEG

and SPART in S_SPART

and AUART in S_AUART

and PSTYV in S_PSTYV

and ERDAT in S_ERDAT

and BSARK in S_BSARK

and VBTYP_N = GC_M.

Thanks in advance.

regards

rock

Re: General

Former Member — Mon, 08 Oct 2007 18:47:13 GMT

There is an error in WHERE condition.

VKORG in S_VKORG

and VTWEG in S_VTWEG

and SPART in S_SPART

and AUART in S_AUART

and PSTYV in S_PSTYV

and ERDAT in S_ERDAT

and BSARK in S_BSARK

and VBTYP_N = GC_M.

You need to give table name with fields for eg VBAK_{VKORG in S_VKORG and VBAK}VTWEG in S_VTWEG.

Please make this correction and check again.

ashish

Re: General

Former Member — Mon, 08 Oct 2007 18:51:15 GMT

Specify the corresponding Tables in the where clause.

Check the syntax for inner join hitting F1.

Sri

Re: General

Former Member — Mon, 08 Oct 2007 18:52:10 GMT

do like this

select A~VBELN

A~ERDAT

A~ERNAM

A~AUART

A~VKORG

A~VTWEG

A~SPART

A~VSBED

A~KUNNR

B~VBELN

B~POSNR

B~MATNR

B~PSTYV

B~KWMENG

C~VBELN

C~POSNR

C~WMENG

C~BMENG

D~VBELN

D~POSNR

D~LFSTA

D~FKSAA

E~VBELV

E~POSNV

E~VBELN

E~POSNN

E~VBTYP_N

into corresponding fields of table GT_VBAK

from VBAK as A inner join VBAP as B on A_{VBELN = B}VBELN

inner join VBEP as C on B_{VBELN = C}VBELN and B_{POSNR = C}POSNR

inner join VBUP as D on C_{VBELN = D}VBELN and C_{POSNR = D}POSNR

inner join VBFA as E on D_{VBELN = E}VBELV and D_{POSNR = E}POSNN

where A~VKORG in S_VKORG

and A~VTWEG in S_VTWEG

and A~SPART in S_SPART

and A~AUART in S_AUART

and B~PSTYV in S_PSTYV

and A~ERDAT in S_ERDAT

and A~BSARK in S_BSARK

and E~VBTYP_N = GC_M.

Regards

Anji