topic Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS in Application Development and Automation Discussions

FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

Former Member — Thu, 15 Mar 2018 13:01:50 GMT

Hi! How are you?

When I execute the transaction FBL5H

The next dump is generated:

Do you have any suggestions for where I could check or do you know if there is a Sap Note that corrects this error?

Beforehand thank you very much!

Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

UweFetzer_se38 — Thu, 15 Mar 2018 13:37:35 GMT

Can you please give us the whole content of the table LT_WHERE? (or does the table only contain one line?)

And by the way: we don't have this class in none of our systems. Is it a special industry solution class?

Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

Former Member — Thu, 15 Mar 2018 15:27:13 GMT

Our system is used in Retail Industry.

LT_WHERE only content one line filtered from IT_WHERE:

With this logic:

Content of Variable LD_SLAVE_SEL_FIELD is "KUNNR"

Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

harald_lesche-holzbecher — Thu, 15 Mar 2018 18:57:27 GMT

Well, so only line 10 of it_where is taken over into lt_where and line 11 is skipped. So the upper limit and closing bracket is missing in the SQL-statement.

Seems the logic within the above code snippet needs to be corrected.

Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

Former Member — Thu, 15 Mar 2018 20:21:40 GMT

Harald, you're right but I have not found any note that corrects the standard code and I need help with that.

Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

RaymondGiuseppi — Mon, 19 Mar 2018 10:31:24 GMT

Is OSS note 2574627 - FI Line Item Browsers: Runtime Error SAPSQL_PARSE_ERROR suitable for your version?

Re: FBL5H - Dump on dynamic sql select - Class FAGL_LIB_PIVB Method SELECT_OTHER_ARAP_ITEMS

Former Member — Thu, 14 Jun 2018 13:46:26 GMT

Raymond,

I can't say you and community if that is right because I don't work anymore for this client, but thanks for your answer little friend!

I close this thread.

Best regards!