Wrong table name or table alias name table alias name

[Former Member]

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 ?

BR

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.

[FredericGirod]

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

[Former Member]

Hi,

You are right. Thank you so much.

BR

[vinodkumar_thangavel]

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.

[Former Member]

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

BR

[vinodkumar_thangavel]

This message was moderated.

[Former Member]

Hi  Vinodkumar

Where can i vote u ?

BR

[vinodkumar_thangavel]

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

[Former Member]

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.