topic Re: Wrong table name or table alias name table alias name in Application Development and Automation Discussions

Wrong table name or table alias name table alias name

Former Member — Thu, 22 Jan 2015 08:45:22 GMT

Hi ,

When i activate the programme ,i get this message 'Wrong table name or table alias name table alias name 'P''. Can you help me for the below code ?

SELECT v~vbeln AS kdauf

p~posnr AS kdpos

v~kunnr v~auart

k~name1 k~land1

b~matnr AS matnr2

b~kdmat

p~edatu

b~kwmeng

FROM vbak AS v

JOIN kna1 AS k ON v~kunnr = k~kunnr

JOIN vbap AS b ON v~vbeln = b~vbeln

AND p~posnr = b~posnr

JOIN vbep AS p ON v~vbeln = p~vbeln

AND p~etenr = '000001'

* LEFT OUTER JOIN vbkd AS d ON b~vbeln = d~vbeln

* AND b~posnr = d~posnr

INTO CORRESPONDING FIELDS OF TABLE lt_mus

FOR ALL ENTRIES IN lt_plaf

WHERE v~vbeln = lt_plaf-kdauf

AND b~posnr = lt_plaf-kdpos

AND p~edatu IN s_edatu.

Re: Wrong table name or table alias name table alias name

FredericGirod — Thu, 22 Jan 2015 08:58:22 GMT

Hi,

maybe it's because you use P before declare it :

AND p~posnr = b~posnr

JOIN vbep AS p ON v~vbeln = p~vbeln

regards

Fred

Re: Wrong table name or table alias name table alias name

vinodkumar_thangavel — Thu, 22 Jan 2015 09:01:27 GMT

Hi,

Try the below code

SELECT v~vbeln AS kdauf

p~posnr AS kdpos

v~kunnr v~auart

k~name1 k~land1

b~matnr AS matnr2

b~kdmat

p~edatu

b~kwmeng

FROM vbak AS v

JOIN kna1 AS k ON v~kunnr = k~kunnr

JOIN vbep AS p ON v~vbeln = p~vbeln

AND p~etenr = '000001'

JOIN vbap AS b ON v~vbeln = b~vbeln

AND p~posnr = b~posnr

LEFT OUTER JOIN vbkd AS d ON b~vbeln = d~vbeln

AND b~posnr = d~posnr

INTO CORRESPONDING FIELDS OF TABLE lt_mus

FOR ALL ENTRIES IN lt_plaf

WHERE v~vbeln = lt_plaf-kdauf

AND b~posnr = lt_plaf-kdpos

AND p~edatu IN s_edatu.

Thanks & Regards,

Vinodkumar.

Re: Wrong table name or table alias name table alias name

Former Member — Thu, 22 Jan 2015 09:32:55 GMT

Thank you so much.. Your coding is true. it was activated.

Re: Wrong table name or table alias name table alias name

Former Member — Thu, 22 Jan 2015 09:34:32 GMT

Hi,

You are right. Thank you so much.

Re: Wrong table name or table alias name table alias name

vinodkumar_thangavel — Thu, 22 Jan 2015 09:39:54 GMT

This message was moderated.

Re: Wrong table name or table alias name table alias name

Former Member — Thu, 22 Jan 2015 11:26:00 GMT

Hi Vinodkumar

Where can i vote u ?

Re: Wrong table name or table alias name table alias name

vinodkumar_thangavel — Thu, 22 Jan 2015 11:37:58 GMT

U can do this by clicking the Correct answer icon so that this Post will be shown as Answered.

Re: Wrong table name or table alias name table alias name

Former Member — Thu, 22 Jan 2015 13:56:20 GMT

i know this icon but i can't see in my page so i can't vote

i think i opened this question from discussion part.If i opened from blog post this icon will be shown.