topic Re: [resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO in Talend Studio

[resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO

Anonymous — Wed, 07 May 2014 22:01:09 GMT

Dear experts,
I'm facing of the following error with the tPLSAPSimpleInput component and this SAP table COAS or AUFK. (others tables works well as PROJ, PRPS, CSKS)
Everything works well with the wizard and I sort correctly the schematic, but after when I execute the program this error appears:
Exception in component tPLSAPSimpleInput_1
java.lang.RuntimeException: com.sap.conn.jco.AbapException: (126) FIELD_NOT_VALID: FIELD_NOT_VALID
.....
Caused by: com.sap.conn.jco.AbapException: (126) FIELD_NOT_VALID: FIELD_NOT_VALID
....
And I can't see why this error is show me.
I test the function RFC_READ_TABLE in SAP is not fails.
Thank you for your help.

Re: [resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO

Anonymous — Wed, 07 May 2014 23:28:19 GMT

Fido,
Try adding the columns one by one to see which column is causing the problem.
I had a similar issue today myself with KNA1, but when I added the columns one by one the issue went away.
Not sure how, but it worked for me. Hope this helps..
BP

Re: [resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO

Anonymous — Thu, 08 May 2014 12:17:15 GMT

Hi ArubaUser,
thank you for your help.
I found where is the error, It appears with this type of fields:
In SAP
.APPEND /CUM/APP_AUFK STRU 0 0 CU specific APPEND for order master data
/CUM/INDCU /CUM/INDCU CHAR 1 0
/CUM/CMNUM /CUM/CMNUM CHAR 12 0
/CUM/AUEST /CUM/AUEST CHAR 1 0
/CUM/DESNUM /CUM/DESNUM CHAR 12 0
En in schema tPLSAPSimpleInput
_CUM_INDCU string 1
_CUM_CMNUM string 12
_CUM_AUEST string 1
_CUM_DESNUM string 12
So I remove these fields it's works.
Thank you for your tips

Re: [resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO

Dezzsoke — Fri, 09 May 2014 17:25:09 GMT

This was fixed in our release for 5.4.1, are you using the latest version?

Re: [resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO

Anonymous — Fri, 30 May 2014 22:44:10 GMT

Hi..
Need help using ERDAT in my where cause with this component.
"where (ERDAT >=dateadd(d,datediff(d,0, getdate()),
-120) and ERDAT < dateadd(d,datediff(d,0, getdate()),
-90))"
or
"ERDAT >=dateadd(d,datediff(d,0, getdate()),
-120) and ERDAT < dateadd(d,datediff(d,0, getdate()),
-90)"
I'm trying to get 24 data.
"ERDAT = '20140527'" works.. but "ERDAT = sy-datum" also works but thats only for current date
I was not able to get "ERDAT GE (sy-datum - 1)" to work.
Any ideas?

Re: [resolved] tPLSAPSimpleInput error com.sap.conn.jco.AbapException: (126) FIELD_NO

Anonymous — Mon, 09 Jun 2014 14:02:23 GMT

Hi Dezzsoke,
The release version is 5.3.1_r104014_fixed.
Regards,