List of Open SQL Function

[sarbajitm]

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.

[Former Member]

Max , Min , Count , SUM , AVG

[sarbajitm]

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

[christine_evans]

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.

[sarbajitm]

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

Regards

[bpawanchand]

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

[christine_evans]

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.

[matt]

>

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

[Former Member]

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

[sarbajitm]

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

[bpawanchand]

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

[dmitry_sharshatkin]

This message was moderated.