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.
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
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
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?