Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

tSAPInput Talend - Output schema definition error

Hi,

I am trying to use the tSAPInput component with RFC_READ_TABLE function to extract data from multiple SAP tables.  I have started with SFLIGHT as a very basic & small table, where I want to extract only a couple of columns.

 

The Input - FIELDNAME I have defined without issue, but for the output schema I receive errors when trying to define the columns that I require.  If I use the default of "WA" then it works, but many of the tables that I want to extract are wider than the 512 characters of WA schema definition.

    

Therefore I have created my own schema and columns in the
output, but I receive the following error:

Starting job SAP_Test at 11:25 10/09/2014.

[statistics] connecting to socket on port 3932

[statistics] connected

Exception in component tSAPInput_3

com.sap.conn.jco.JCoRuntimeException: (127)
JCO_ERROR_FIELD_NOT_FOUND: Field MANDT is not a member of TAB512

at com.sap.conn.jco.rt.AbstractMetaData.indexOf(AbstractMetaData.java:404)

at com.sap.conn.jco.rt.AbstractRecord.getString(AbstractRecord.java:2870)

at sap_connector.sap_test_0_1.SAP_Test.tSAPInput_3Process(SAP_Test.java:959)

at sap_connector.sap_test_0_1.SAP_Test.tSAPConnection_1Process(SAP_Test.java:398)

at sap_connector.sap_test_0_1.SAP_Test.runJobInTOS(SAP_Test.java:1315)

at sap_connector.sap_test_0_1.SAP_Test.main(SAP_Test.java:1174)

[statistics] disconnected

job SAP_Test ended at 11:25 10/09/2014. [exit code=1]

Attached is a screenshot of the job and components:

Any help would be much appreciated.

    

Thanks

    

Bri

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question