topic Re: List of Open SQL Function in Application Development and Automation Discussions

List of Open SQL Function

sarbajitm — Wed, 03 Sep 2008 07:45:48 GMT

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.

Re: List of Open SQL Function

Former Member — Wed, 03 Sep 2008 07:48:46 GMT

Max , Min , Count , SUM , AVG

Re: List of Open SQL Function

Former Member — Wed, 03 Sep 2008 07:56:01 GMT

\[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

Re: List of Open SQL Function

sarbajitm — Wed, 03 Sep 2008 09:08:18 GMT

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

Re: List of Open SQL Function

christine_evans — Wed, 03 Sep 2008 09:30:24 GMT

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.

Re: List of Open SQL Function

sarbajitm — Wed, 03 Sep 2008 09:36:03 GMT

That means strlen is a ABAP/4 built in functions,then can you provide me a list of those built in functions?

Regards

Re: List of Open SQL Function

bpawanchand — Wed, 03 Sep 2008 09:40:45 GMT

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

Re: List of Open SQL Function

sarbajitm — Wed, 03 Sep 2008 10:02:21 GMT

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

Re: List of Open SQL Function

bpawanchand — Wed, 03 Sep 2008 10:04:05 GMT

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

Re: List of Open SQL Function

christine_evans — Wed, 03 Sep 2008 10:19:03 GMT

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.

Re: List of Open SQL Function

matt — Wed, 03 Sep 2008 11:18:23 GMT


> 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.

Re: List of Open SQL Function

dmitry_sharshatkin — Tue, 13 Sep 2016 09:17:20 GMT

This message was moderated.