topic Re: Reading Data from different Client in Application Development and Automation Discussions

Reading Data from different Client

Former Member — Sat, 22 Jul 2006 04:39:46 GMT

Hi, Currently i have some requirement to get some data from different client and process and display the process result on the report...... I dont have any clue... is it starting with BAPI, RFC or t-rfc .... can anyone guides me ?

Thanks.

Re: Reading Data from different Client

Simha_ — Sat, 22 Jul 2006 04:44:30 GMT

Hi,

U can do this with RFC.

refer to this thread..

cheers,

Simha.

Re: Reading Data from different Client

dani_mn — Sat, 22 Jul 2006 04:48:57 GMT

Hi,

You can use remote enable function modules to fetch data from different clients.

when you call the function module there is addition 'DESTINATION' in whcih you specify the system.

Regards,

Wasim Ahmed

Re: Reading Data from different Client

Former Member — Sat, 22 Jul 2006 05:28:59 GMT

Thanks for the reply.... ok... lets say i have already created to RFC connection to other client... how am i going to retreive data from other client.... take example i'm creating reports in FI client how am i going to access HR client table ?

Thanks

Re: Reading Data from different Client

Former Member — Sat, 22 Jul 2006 05:35:40 GMT

Hi,

create a FM in HR as RFC enabled.In this FM retrieve all the details and pass to export parameter.

Now in ur report in FI call this FM with addition DESTINATION logsys. this wiil give u the required data in in ur report.

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Re: Reading Data from different Client

dani_mn — Sat, 22 Jul 2006 05:38:48 GMT

Hi chen,

Go through this PDF file, It contains every step and detail about RFC.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCFESDE2/BCFESDE2.pdf

Regards,

Wasim Ahmed

"Reward for helpful answers.

Re: Reading Data from different Client

Former Member — Sat, 22 Jul 2006 05:40:04 GMT

Hi,

U can directly read data form any on different system using

RFC_READ_TABLE :- Function Module

input

-->Table Name ( name of the table from which data to be read )

-->Fields ( name of the fields )

Eg:-



*----------------------Data table--------------
DATA : BEGIN OF T_DATA OCCURS 0.
          INCLUDE STRUCTURE TAB512.
DATA : END OF T_DATA.

*------------Table name-------------------------*
Table name ---> TADIR.

*-------------------FIELD Name to Read----------------*
T_FIELDS-FIELDNAME = 'PGMID'.                      
T_FIELDS-OFFSET    = 000000.                       
T_FIELDS-LENGTH    = 000004.                       
T_FIELDS-TYPE      = 'C'.                          
T_FIELDS-FIELDTEXT = 'Program ID in requests and tasks'.      
APPEND T_FIELDS.                                   
T_FIELDS-FIELDNAME = 'OBJECT'.                     
T_FIELDS-OFFSET    = 000004.                       
T_FIELDS-LENGTH    = 000004.                       
T_FIELDS-TYPE      = 'C'.                          
T_FIELDS-FIELDTEXT = 'Object Type'.                
APPEND T_FIELDS.                                   
T_FIELDS-FIELDNAME = 'OBJ_NAME'.                   
T_FIELDS-OFFSET    = 000008.                       
T_FIELDS-LENGTH    = 000040.                       
T_FIELDS-TYPE      = 'C'.                          
T_FIELDS-FIELDTEXT = 'Object Name in Object Directory'.        
APPEND T_FIELDS.                                   



*
*
*-------------------Call to FM----------------*
CALL FUNCTION 'RFC_READ_TABLE'                    
     DESTINATION P_RDEST                           
     EXPORTING                                     
          QUERY_TABLE          = 'TADIR'           
     TABLES                                        
          OPTIONS              = T_OPTIONS         
          FIELDS               = T_FIELDS          
          DATA                 = T_DATA            
    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    .

Reward Points & Mark Helpful Answers

Re: Reading Data from different Client

athavanraja — Sat, 22 Jul 2006 06:04:01 GMT

If its just reading from different client from one client,

you can use the addition

CLIENT SPECIFIED to select data from a particular client from another client.

Regards

Raja

Re: Reading Data from different Client

Former Member — Sat, 22 Jul 2006 08:02:05 GMT

hi,

search for client-specified option in the select statement,

using select statement and using where clause you can get data from different client,

best of luck,

regards,

kcc

Re: Reading Data from different Client

Former Member — Thu, 15 Mar 2007 06:19:55 GMT

hi try as below

Copying Standard Texts

Choose Tools ® SAPscript ® Standard text

Choose Utilities ® Copy from client.

This takes you to the dialog window for copying texts between clients.

Make the following entries:

Text name

Enter the name of the standard text you want to copy. You can enter a generic name such as ST* or *.

Text ID

Enter the text ID (type) of the text(s) you have selected.

Language

Enter the appropriate language key.

Source client

Specify the client in which the standard text was created. By default, this is client 000.

Target name

Specify the name of the new standard text.

Action log

Select

to create an action log.

No entry

not to create an action log.

Choose Execute.

If you selected the field Action log, the system displays a log after the copy process.

Copying Forms

Choose Tools ® SAPscript ® Form

Choose Utilities ® Copy from client.

This takes you to the dialog window for copying forms between clients.

Make the following entries:

Form name

Enter the name of the form you want to copy. You can enter a generic name such as ST* or *.

Source client

Specify the client in which the form was created. By default, this is client 000.

Target form

Specify the name of the new form.

Action log

Select

to create an action log.

No entry

not to create an action log.

Choose Execute.

If you selected the field Action log, the system displays a log after the copy process.

Copying Styles

Choose Tools ® SAPscript ® Style

Choose Utilities ® Copy from client.

This takes you to the dialog window for copying styles between clients.

Make the following entries:

Style name

Enter the name of the style you want to copy. You can enter a generic name such as ST* or *.

Source client

Specify the client in which the style was created. By default, this is client 000.

Target style

Specify the name of the new style.

Action log

Select

to create an action log.

No entry

not to create an action log.

Choose Execute.

If you selected the field Action log, the system displays a log after the copy process.