Usage of tSAPInput and RFC_READ_TABLE

[_AnonymousUser]

I would like to use RFC_READ_TABLE with the tSAPInput component.
Can anyone explain me, how I must set the parameters for this RFC?
Which inputs parameters do I have to set, in order to pick only certain
fields out of a table (delimitation 512 characters) and how can I implement
a filter?
Thanks in advance.

[Anonymous]

Hi,

it is not that difficult.
You need to send the columns you want to the table 'FIELDS' and the parametername is 'FIELDNAME'
Obviously it has to be a table_input type and the parametervalue is a list of the wanted columns each in "" and seperated by ,
I attached a screenshot using SFLIGHT table
The last row in the input setting is the equal to a sql where planetype = 'A330-300'
Regards,
Harald

[_AnonymousUser]

If you are interested in querying SAP Tables you may try http://remoteopensql.codeplex.com/ . Remote Open SQL is an Open Source project with a lot of limitations now but I hope to solve issue as quick as possible

[_AnonymousUser]

Hi, I am using the tsapinput for the first time. I have successfully established the connection to the SAP server and created the job... I have also defined the input parameters as defined but when i run the program, i keep getting errors... One example is : " Exception in Component tSAPInput_1 com.SAP.conn.jco.JCoRuntimeException: (127) JCO_ERROR_FIELD_NOT_FOUND : Field not a member of tables at ....."
Can someone help on this please???

[_AnonymousUser]

Hi,
i am trying to use the tSapInput component successfully. Unfortunately trying to limitate the number of fields extracte dy the RFC_READ_TABLE i always obtain the following error:
Exception in component tSAPInput_2
java.lang.RuntimeException: Field FIELDS not a member of INPUT
at mdr.use_sap_rfc_original_0_1.USE_SAP_RFC_ORIGINAL.tSAPInput_2Process(USE_SAP_RFC_ORIGINAL.java:1385)
at mdr.use_sap_rfc_original_0_1.USE_SAP_RFC_ORIGINAL.tSAPConnection_1Process(USE_SAP_RFC_ORIGINAL.java:436)
at mdr.use_sap_rfc_original_0_1.USE_SAP_RFC_ORIGINAL.runJobInTOS(USE_SAP_RFC_ORIGINAL.java:2525)
at mdr.use_sap_rfc_original_0_1.USE_SAP_RFC_ORIGINAL.main(USE_SAP_RFC_ORIGINAL.java:2358)
Can you help me ?
Many thanks in advance.
Alessandro

[_AnonymousUser]

Hi,
I get the same error when I'm using the parameter type "table_input" in tSAPInput, too.
connected
Exception in component tSAPInput_1
com.sap.mw.jco.JCO$Exception: (127) JCO_ERROR_FIELD_NOT_FOUND: Field FIELDS not a member of INPUT
at com.sap.mw.jco.JCO$MetaData.indexOf(JCO.java:9278)
at com.sap.mw.jco.JCO$Record.getTable(JCO.java:14030)
at testproject.zz_rfctest_0_1.ZZ_RFCtest.tSAPInput_1Process(ZZ_RFCtest.java:594)
at testproject.zz_rfctest_0_1.ZZ_RFCtest.tSAPConnection_1Process(ZZ_RFCtest.java:344)
at testproject.zz_rfctest_0_1.ZZ_RFCtest.runJobInTOS(ZZ_RFCtest.java:943)
at testproject.zz_rfctest_0_1.ZZ_RFCtest.main(ZZ_RFCtest.java:811)
disconnected
My environment is below:
sapjco3
Talend Open Studio for Data Integration (5.1.2.r90681)
Is this error caused by using new TOS version??

[Anonymous]

Hi, 
I am also getting the same error.
connecting to socket on port 3950
connected
Exception in component tSAPOutput_2
java.lang.RuntimeException: Field MATERIALDESCRIPTION is not a member of INPUT
at fuso_mdm.sap_connectivity_0_1.SAP_Connectivity.tFileInputDelimited_1Process(SAP_Connectivity.java:1130)
at fuso_mdm.sap_connectivity_0_1.SAP_Connectivity.tSAPConnection_2Process(SAP_Connectivity.java:406)
at fuso_mdm.sap_connectivity_0_1.SAP_Connectivity.runJobInTOS(SAP_Connectivity.java:1422)
at fuso_mdm.sap_connectivity_0_1.SAP_Connectivity.main(SAP_Connectivity.java:1281)
disconnected
Is there a way to resolve this issue or an alternative ?
Talend Version: TOS 5.4.2
OS: Windows 64 bit
Environment: Java 7 (64 bit)

[Anonymous]

Hi,

it is not that difficult.
You need to send the columns you want to the table 'FIELDS' and the parametername is 'FIELDNAME'
Obviously it has to be a table_input type and the parametervalue is a list of the wanted columns each in "" and seperated by ,
I attached a screenshot using SFLIGHT table
The last row in the input setting is the equal to a sql where planetype = 'A330-300'
Regards,
Harald

thank you very much!

this sloved my current problem