FUNCTION MODULE

[Former Member]

Hi , hope every one is fine . i need a help in reading the data from the database table i have created in se11 using function module with reference to the created date i have given as input. help me with this. Thank you.

[MateuszAdamus]

Hello karoncdas_31

You have to be more precise.

What are the fields in your table? What records do you need to read? What should your function return?

Kind regards,
Mateusz

[Former Member]

hi i have fileds po number, purchase order created date, cocd, vendor . here i need to get data in return for specified field for example, created date. so in function module if i give created date as import parameter and all the table fields as export parameter. when i select he date i need to see the record created on that day and also records for other respective fields in output.

[MateuszAdamus]

Hi karoncdas_31

I presume you want to have more than one record in the results, if they meet the selection criteria, correct? For that, you need to create an exporting parameter of table type with line type like your table.

Here's more about table types in general: https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-us/abenddic_table_types.htm

Here's a step by step guide on how to create a table type in ABAP dictionary: https://help.sap.com/doc/saphelp_ewm70/7.0/en-US/90/8d731fb1af11d194f600a0c929b3c3/content.htm?no_ca...

Then your function also needs an importing parameters to receive selection criteria. You can either have a simple type importing parameter - this will enable user to provide a single value. Or you can have a range type (select options like) selection parameter.

Here's more about ranges: https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapranges.htm

Here's how to define them in ABAP dictionary: https://help.sap.com/doc/saphelp_qim100/1.0/en-US/00/958fb7e42b11d295f700a0c929b3c3/content.htm?no_c...

You can create a function module in the SE37 transaction. SE11 transaction can be used to create table and range types needed for importing and exporting parameters of your function.

When you have your importing and exporting parameters defined in your function, all is left to do is to select the data from database. Here's more information about the SELECT statement: https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abapselect.htm

I hope this helps you in getting to know on how to create such a function module.
Kind regards,

Mateusz