topic Re: Help reg BAPI in Application Development and Automation Discussions

Help reg BAPI

Former Member — Thu, 22 Oct 2009 04:54:26 GMT

Hi all,

My requirement is to get a bapi or fm in which i should provide the table name and one value of a field in that table, which then should retrieve all the values of the other field matching my selection criteria. (like select statement with where condition)

Pls can anyone help me reg.

Regards,

Revathi.

Re: Help reg BAPI

kesavadas_thekkillath — Thu, 22 Oct 2009 05:17:36 GMT

Check whether any of these matches your requirement

RSAQSZT_SELECT_TABLE

LXE_COMMON_SELECT_FROM_TABLE

MONI_CREATE_SELECTION_TABLE

I_MASS_SELECT_TABLE

SELECT_ONE_TABLE

DB_SELECT_FULL_TABLE

SKTI_SELECTION_OPTIONS_TABLE

SLWY_SELECT_VALUE_FROM_TABLE

RKD_SEL_BUILD_SELECT_CLAUSE

RRW3_GET_QUERY_VIEW_DATA

Re: Help reg BAPI

anusurbab — Thu, 22 Oct 2009 06:46:19 GMT

You can use RFC_READ_TABLE function module to achieve this functionality.

Re: Help reg BAPI

paul_bakker2 — Thu, 22 Oct 2009 06:59:44 GMT

Hello,

You can use function module RFC_READ_TABLE to do exactly that.

You pass the tables 'fields' (fields to be selected)

and 'options' (the 'where' clause), and get back the table 'data'.

It also returns field descriptions (length, type etc) for each

entry in 'fields'.

An example follows below.

NB. The optional parameter 'delimiter' puts that delimiter char

between each field in the 'data' table.

data: begin of i_options occurs 0.

include structure rfc_db_opt.

data: end of i_options.

data: begin of i_fields occurs 0.

include structure rfc_db_fld.

data: end of i_fields.

data: begin of i_data occurs 0.

include structure tab512.

data: end of i_data.

specify the fields to be selected in table 'i_fields'

i_fields-fieldname = 'AUART'.

append i_fields.

i_fields-fieldname = 'AUTYP'.

append i_fields.

specify the selection conditions in table 'i_options'

i_options = 'AUART = ''OA01'''.

append i_options.

i_options = 'AND AUTYP = 01'.

append i_options.

call function 'RFC_READ_TABLE'

destination 'NONE'

exporting

query_table = 'AUFK'

delimiter = '|'

tables

options = i_options

fields = i_fields

data = i_data.

cheers

Paultje Bakker

Hanabi Technology

Re: Help reg BAPI

Former Member — Thu, 22 Oct 2009 07:59:35 GMT

Hi,

Thanx for all your replies. I'm just testing the fm RFC_READ_TABLE IN SE37. So can someone guide me to test it to perform the following statement.

select lifnr name1 from lfa1 where land1 = 'IN'.

Pls help me to solve it. What should be given in options, field and data.

Regards,

Revathi.

Re: Help reg BAPI

Former Member — Thu, 22 Oct 2009 08:46:35 GMT

specify the parameters for the function module RFC_READ_TABLE as follows:

Import parameter

Query_Table LFA1

Tables

OPTIONS LAND1 = 'IN'

FIELDS NAME1

LIFNR

The output will be available in the table DATA.

Regards,

Ginu Litta

Re: Help reg BAPI

Former Member — Thu, 22 Oct 2009 09:12:02 GMT

Hi,

Thanks for your immediate reply.

Regards,

Revathi.