2023 Mar 02 9:44 AM
Why Does My Code Eror?
Please Help Me
2023 Mar 03 7:43 AM
Please post the code as text instead of image, so that one can easily answer by copying your code in order to complete it. Then, select your code and press the button [CODE], which makes the code appear colored/indented, it will be easier for people to look at it. Thank you!
2023 Mar 06 2:24 AM
select sum( mssl~sllab * eine~netpr )
from mssl
inner join eina on mssl~matnr = eina~matnr and mssl~lifnr = eina~lifnr
inner join eine on eine~infnr = eina~infnr
into ls_data-netpr_service
where mssl~sllab GT 0
and eina~loekz EQ ''
and eina~lifnr EQ ls_lfa1-lifnr
2023 Mar 06 2:25 AM
can you help me please?
or can not support for this code in sap?
2023 Mar 06 8:15 AM
If I write this code:
DATA netpr_service TYPE i.
SELECT SUM( mssl~sllab * eine~netpr )
FROM mssl
INNER JOIN eina ON mssl~matnr = eina~matnr AND mssl~lifnr = eina~lifnr
INNER JOIN eine ON eine~infnr = eina~infnr
INTO netpr_service
WHERE mssl~sllab GT 0
AND eina~loekz EQ ''
AND eina~lifnr EQ ''.
I have this error message (ABAP 7.52):
If the new Open SQL syntax is used, it must be used throughout.
This includes using @ to escape host variables.
So, replacing this line, the program activates:
into @netpr_service