topic Re: Maximum ALV columns number ? in Application Development and Automation Discussions

Maximum ALV columns number ?

Former Member — Thu, 12 Jul 2018 13:09:19 GMT

Hello,

I'm trying to create an alv with 115 columns and the report displayed just 100 columns.

Is it possible to find something to display more than 100 ?

Thanks for your help.

Best regards,

Jeffpige

Re: Maximum ALV columns number ?

RaymondGiuseppi — Thu, 12 Jul 2018 13:56:14 GMT

Use a Grid ALV, and better use an OO class, the limit of 99 columns is related to List ALV. (Also when printing the Grid you will face the same problem)

Hint: There is a FAQ note available, Note 1009650 - Consulting: Standard behavior in the ALV

Also, IMHO, ALV is a human reading tool, if you actually want to export some big volumn of data, better use a XML output.

Re: Maximum ALV columns number ?

Former Member — Thu, 12 Jul 2018 14:42:05 GMT

Thanks Raymond for your answer but i think clearing 'no_out' field of the fields catalog is enough.

Re: Maximum ALV columns number ?

RaymondGiuseppi — Thu, 12 Jul 2018 14:55:59 GMT

This trick is depending on version of SAP and tool used. Could you provide more information, such as which ALV tool you used, etc. I've already displayed some grids with >1000 columns.

Re: Maximum ALV columns number ?

Former Member — Thu, 12 Jul 2018 15:24:35 GMT

J'utilise le module fonction CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' pas d'alv OO donc ma solution est suffisante. Merci en tous cas pour ton investissement sur mon probleme.

Re: Maximum ALV columns number ?

RaymondGiuseppi — Fri, 13 Jul 2018 05:54:24 GMT

Pas de problème, comme tu utilises une grille et pas une liste, la limite de 99 n'en est pas réllement une, il faut juste penser à mettre à jour le catalogue de champs, SAP s'autolimitant, comme indiqué dans la note de référence.

Re: Maximum ALV columns number ?

matt — Fri, 13 Jul 2018 05:55:29 GMT

Asking for upvotes is likely to have only one consequece. Probably better not to do it again.

Re: Maximum ALV columns number ?

KarthikeyanN — Fri, 13 Jul 2018 07:10:23 GMT

Maximum no. of columns in ALV is 90 and each column can have a length up to 255 characters.

Thanks and Regards,

Karthikeyan Nataraj.

Re: Maximum ALV columns number ?

AdrianDBorja — Thu, 29 Apr 2021 01:49:41 GMT

From what I observed, using either OO and REUSE_ALV_GRID, field character limit is 128 characters, regardless of data type.

True that you can populate the internal table field beyond 128 but ultimately it will be truncated