topic Re: Syntax for Remote select stmt? in Application Development and Automation Discussions

Syntax for Remote select stmt?

Former Member — Fri, 06 Oct 2006 01:01:04 GMT

Hi ,

How to write a remote select statement.?

I have to write remote slect stmt and get the details from MKPF table based on Material document number and year ,which should return TCODE2 data.

Thanks & Regards,

Gopi.

Re: Syntax for Remote select stmt?

Former Member — Fri, 06 Oct 2006 01:05:10 GMT

Hi Gopi,

You need to create a RFC ( Remote Function Call ) which would fetch the data and return the parameter.

Goto SE80. Create a function group.

Goto SE37. Create a Function Module and in the Attributes TAB, tick Remote Function.

In the Import Tab, mention MBLNR

MJAHR

In the Export tab, mention TCODE.

Write a select query.

SELECT TCODE

from MKPF

into TCODE

where MBLNR = MBLNR

MJAHR = MJAHR.

Activate it.

Best regards,

Prashant

Pls. mark points for helpful answers

Re: Syntax for Remote select stmt?

Former Member — Fri, 06 Oct 2006 01:05:49 GMT

Can be more clear on your requirement "Remote Select Stmt"

Maybe your option would be:

1. Create an RFC with 
   Import Parameters: Mat. Doc, Mat Doc Year.
   Export Parameter: Transaction Code/ Return

2. Source Code:

   select single tcode2 into out_tcode2
          from mkpf 
          where mblnr = in_mblnr
          and   mjahr = in_mjahr.
   if sy-subrc ne 0.
      move: 'Unable to retreive details for material document' to return.     
   endif.

Kind Regards

Eswar

Re: Syntax for Remote select stmt?

RichHeilman — Fri, 06 Oct 2006 01:06:19 GMT

"Remote" select statement? Do you mean getting the data from a remote system? If so you can use the function module RFC_READ_TABLE.

REgards,

RIch Heilman

Re: Syntax for Remote select stmt?

RichHeilman — Fri, 06 Oct 2006 01:21:07 GMT

For example, this code works pretty good.



report zrich_0001.

data: iopt type table of rfc_db_opt with header line.
data: ifld type table of rfc_db_fld with header line.
data: idat type table of tab512 with header line.

parameters: p_mblnr type mkpf-mblnr,
            p_mjahr type mkpf-mjahr.

* Where clause
concatenate 'MBLNR = ' p_mblnr '.' into iopt-text separated by space.
append iopt .
concatenate 'and MJAHR = ' p_mjahr '.'
        into iopt-text separated by space.
append iopt .

* Return Fields
ifld-fieldname = 'TCODE2'. append ifld.

call function 'RFC_READ_TABLE'
 destination 'PRD'      "  <---- Your RFC Destination
  exporting
    query_table                = 'MKPF'
    delimiter                  = ','
*   NO_DATA                    = ' '
*   ROWSKIPS                   = 0
*   ROWCOUNT                   = 0
  tables
    options                    = iopt
    fields                     = ifld
    data                       = idat
 exceptions
   table_not_available        = 1
   table_without_data         = 2
   option_not_valid           = 3
   field_not_valid            = 4
   not_authorized             = 5
   data_buffer_exceeded       = 6
   others                     = 7.

* Write return data.
loop at idat.
  write:/ idat.
endloop.

No need to create a custom RFC.

Regards,

Rich Heilman

Re: Syntax for Remote select stmt?

RichHeilman — Fri, 06 Oct 2006 12:51:45 GMT

Gopi, did this solve your problem? Please make sure to award points for helpful answers and mark as solved when solved completely. Thanks.

Regards

Rich Heilman