09-03-2008 8:45 AM
Can anybody provide me a list of all the Open SQL Functions?
I know some of it like Minimum,Maximum,etc. but I'm looking for a complete list of it.
09-03-2008 8:48 AM
09-03-2008 10:08 AM
Hello Kartik,
So apart from the 5 functions i.e. Max , Min , Count , SUM , AVG.,there is no more built in functions in Open SQL?????
Then if anybody wants to find out the length of the name then how do he/she do that?
eg. KARTHIK---->consist of 7 letter
Edited by: Sarbajit Majumdar on Sep 3, 2008 11:08 AM
09-03-2008 10:30 AM
You'll need to select the data into variables and then use STRLEN on the variable. Compared with real SQL, open SQL is very limited in the things it will allow you to do in a SELECT.
09-03-2008 10:36 AM
That means strlen is a ABAP/4 built in functions,then can you provide me a list of those built in functions?
Regards
09-03-2008 10:40 AM
Hi
How to process strings check the below link
http://help.sap.com/saphelp_nw04/helpdata/en/79/c55479b3dc11d5993800508b6b8b11/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3357358411d1829f0000e829fbfe/frameset.htm
Regards
Pavan
09-03-2008 11:19 AM
Search the documentation in http://help.sap.com for STRLEN and you'll find information on this and on other ABAP functions for manipulating data.
09-03-2008 12:18 PM
>
> Search the documentation in http://help.sap.com for STRLEN and you'll find information on this and on other ABAP functions for manipulating data.
Or type strlen into the editor and press f1.
09-03-2008 8:56 AM
\[removed by moderator as it was just a copy and paste answer of someone else's work without giving a source\]
Edited by: Jan Stallkamp on Sep 3, 2008 3:56 PM
09-03-2008 11:02 AM
Ok Pavan
those links are useful but I'm looking for the list of built in functions :string functions, arithmetic functions , date functions.......
Can u provide me any link which can fulfill my requirement?
Regards
Sarbajit
09-03-2008 11:04 AM
Hi
https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bfunction%2bmodules
[List of most useful ABAP FM|http://www.erpgenie.com/abap/functions.htm]
Regards
Pavan
09-13-2016 10:17 AM