Count character in query

[former_member1015827]

SELECT DISTINCT equz~hequi ,equz~equnr FROM equz
INTO CORRESPONDING FIELDS OF TABLE @it_sequip.

How can i count the vaule per character in EQUZ~HEQUI?

[p244500]

Hi,

Follow the bellow link

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/20e35f5275191014ba6df6dc5f...

String Functions

https://answers.sap.com/questions/4596844/character-count-of-a-string.html

Regards,

Nawa

[former_member1015827]

thank you!

[Sandra_Rossi]

If you want to use it inside the ABAP SQL query, use the following ABAP SQL String Function:

SELECT ... LENGTH( column/expression ) FROM ...

or after the query, use the ABAP statement "strlen":

length = strlen( variable ).

[raghug]

inside the ABAP SQL query

Always learning something new! Thank you.