Strange syntax of "deleting from " that i found

[former_member830601]

Hello, i am very novice in sap/abap and i am trying to figure out what does some code mean and that code look likes:

tables table1.
data begin of b_r occurs 10. <br>          include structure foobar.
data end of b_r.<br>DELETE FROM foobar<br>       WHERE day = :table1-tag AND time = :table1-zeit.

My trouble in syntax of :table1-tag what is ":" symbol purpose, thanks.

[former_member27]

Hi vitalik1

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Second, if you're interested in connecting with community members, please pay a visit to our new Check the Welcome Corner thread with advice from our champions. You'll need to sign up, but it's a great way to interact with peers and get to know other experts!
https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Regards,

Dedi

[jmodaal]

Hello,

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapexec_host.htm

IMHO the escape character is not necessary here, as it is not native SQL (not embedded in EXEC SQL... ENDEXEC). But the syntax is the same here as in Open SQL, and the escape character is obviously accepted here.

Kind regards

Jan

[former_member830601]

Thank you very much, i think it is my case