ABAP Function Module to perform validation

[Former Member]

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,

JD

[Former Member]

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

[Former Member]

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