topic ABAP Function Module to perform validation in Application Development and Automation Discussions

ABAP Function Module to perform validation

Former Member — Fri, 07 Nov 2008 02:27:19 GMT

Hi Developers,

I'm am trying to create a function module to be later used by a Web Dynpro application. The function module should be structured as followed:

Importing

USER_ID : User ID to be searched that is entered by user.

TENANT: Tenant ID that is to be searched, also entered by user.

Changing

EXIST: A flag that will return the values Y or N based on a return from the function module.

The function module must be able to access a specified Oracle database table and perform a check on the table with the provided import values. If the combination exists, it should return a Y. If the combination does not exist it should return an N. Assumption is that tenant and userid fields exist in this table in addition to two other. User ID is the primary key.

Regards,

Re: ABAP Function Module to perform validation

Former Member — Fri, 07 Nov 2008 04:33:02 GMT

hi ,

u can put a select query on the input parameters ..

select * from z_abc where userid = param1 and tenant = param2.

if sy-subrc = 0

then return 'Y'

else return 'N'

u can make this FM as an RFC which can be later acess from WD application.

Simple ...

Edited by: Renu Gusain on Nov 7, 2008 5:33 AM

Re: ABAP Function Module to perform validation

Former Member — Fri, 07 Nov 2008 05:36:24 GMT

Hi,

For getting data from oracle the following threads may help you;

You can get more threads by [Searching|https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_library&adv=true] the Forum.

Regards

Karthik D