I'm very new tp SAP ABAP, how to create a function module..V.URGENT

[Former Member]

hi folks,

I'm very new to sap abap.

I want to create a function module.

the following is my requirement.

by passing(eporting parameters to funtion module from pgm point of view) a field, i want to get(importing parameters from the funtion module, from pgm point of view) some 7 fields(of various tables).

please also tell me how can code an inner join for tables 5 tables(a,b,c,d,e). i'm joining a on b, b on c, c on d,the problem here is that i can not join d on e as there are no common fields in d and e.

can i join e and c or b, there are no common fields even in a and e.

please tell me the solution as soon as possible, this very important and urgent deliverable.

thanks in advance

[Manohar2u]

Here is link for creating function modules

<a href="http://help.sap.com/saphelp_47x200/helpdata/en/9f/db98fc35c111d1829f0000e829fbfe/frameset.htm">Creating Function Modules</a>

Regds

Manohar

[Former Member]

Hi Manohar,

Can you please let me know the answer for my second question about select quesry i.e. inner join.

thanks fr the reply

[Former Member]

Pex,

An INNER JOIN requires a "like" condition between the 2 tables. If one does not exist, then it is not possible.

[Former Member]

hi,

As you are new to ABAP, try to complete the work by using SELECT from a single table for all those 5 tables, instead of using Join. so use FOR ALL ENTRIES if requires & complete the function module & test it. then everything is ok then replace these 5 different select statements with the inner join of 1 or 2 .

regards

srikanth

[abdul_hakim]

hi pex,

these are all the basic things in which every ABAP Developers should know.i would strongly advice you to read the documentation under the knowledge pool http://help.sap.com

Cheers,

Abdul Hakim