01-22-2015 8:45 AM
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.
01-22-2015 8:58 AM
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
01-22-2015 9:34 AM
01-22-2015 9:01 AM
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.
01-22-2015 9:32 AM
01-22-2015 9:39 AM
01-22-2015 11:26 AM
01-22-2015 11:37 AM
U can do this by clicking the Correct answer icon so that this Post will be shown as Answered.
01-22-2015 1:56 PM
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.