topic SAP ERP - api.use_z_talend_read_table in Talend Studio

SAP ERP - api.use_z_talend_read_table

SRoux — Tue, 06 Oct 2020 14:11:01 GMT

Hi all,

We are using Talend Data Management Platform v6.5 and we want to extract data from SAP.

We have deployed TEDK900247.zip to SAP S/4.

Now I get an error by using api.use_z_talend_read_table in combination with tSAPTableInput :

Exception in component tSAPTableInput_1 (POCTalend_readTable)

SAPException@3b35a229 [

errorCode=11

,errorGroup=126

,errorKey=FIELD_NOT_VALID

,errorMessage=FIELD_NOT_VALID

,errorMessageNumber=000

,errorMessageText=

,bapiName=Z_TALEND_READ_TABLE

,tableName=MARA

]

I tried SE37 transaction on SAP system to run Z_TALEND_READ_TABLE bapi with the same result : "FIELD_NOT_VALID"

Other components like tSAPODPInput, who uses Z_TALEND_ODP_EXTRACT_COLUMN bapi, work fine.

I attached some pictures.

Any ideas ?

Thank you

Stéphane

Re: SAP ERP - api.use_z_talend_read_table

Prakhar1 — Wed, 07 Oct 2020 01:19:09 GMT

did you installed right Talend modules to SAP ? Check the SAP version and install the modules accordingly.

If the error continues you need to contact Talend Support to provide you the new module files.

Re: SAP ERP - api.use_z_talend_read_table

SRoux — Thu, 08 Oct 2020 08:13:47 GMT

I get it ! Meta data of table keeps in Talend was different from the real SAP dictionary structure. Just refresh our meta data and all are fine. So no problem with the Talend's BAPI deployment or version.

To debug I unselected all columns of the table to retrieve. At this moment no more error. Next, by try and error, I selected column to get. Finally I identified a couple of columns returning error. By checking SAP ERP (SE16 transaction) we saw that columns were no more present, dev team had deleted them !