topic Re: changes into sap query for field length changes in Application Development and Automation Discussions

changes into sap query for field length changes

former_member530652 — Fri, 08 Jan 2021 06:16:13 GMT

Hi,

I have an existing sap query where only one table is used and one of the field length(Changed from 10 to 15 chars) of that table is changed.

Field length changes into the table would be automatically accommodated into the query?

If not, what changes I have to perform into the infoset and query?

Kindly guide.

Thanks.

Re: changes into sap query for field length changes

pfefferf — Fri, 08 Jan 2021 06:33:51 GMT

If you have no special considerations of the field length implemented in your query, nothing has to be done.

Re: changes into sap query for field length changes

former_member530652 — Fri, 08 Jan 2021 06:57:01 GMT

Thanks for your response.

I do not have special considerations of the field length, but would like to know if this field length change( into the table) will automatically be adopted by query?....Query will reflect this field length change( into the table) without doing anything?

Re: changes into sap query for field length changes

pfefferf — Fri, 08 Jan 2021 07:03:07 GMT

Like I said, no changes are necessary if you have no special length logic in the query.

Re: changes into sap query for field length changes

Dominik_Tylczynski — Fri, 08 Jan 2021 07:04:12 GMT

Hello sandeep.bhamare

SAP Query will automatically reflect the field length change.

Best regards

Dominik Tylczynski

Re: changes into sap query for field length changes

RaymondGiuseppi — Fri, 08 Jan 2021 13:58:34 GMT

Depending on

If the query is executed from transaction SQ01, START_REPORT or via program SAP_QUERY_CALL the query and Infoset will be automatically adapted.
If someone defined a transaction calling the generated program name, you may get a dump.

Re: changes into sap query for field length changes

former_member530652 — Wed, 13 Jan 2021 06:24:14 GMT

Hi Raymond,

Thanks for your inputs. I have changed the field length but unfortunately infoset and query did not adapt the field length changes.

Query length is still showing length 10 and remaining 5 characters cut off from the output.

I am trying to run the query from transaction SQ01.

Please can you guide, what changes I need to make into infoset and query?

Thanks.