Applying substring to internal table

[former_member559196]

Hello,

I have the following selection into internal table.

SELECT SINGLE sobid

FROM hrp1001

INTO @wa_hrp1001-var_sobid

WHERE otype = 'O'

AND plvar = '01' AND relat = '011'

AND endda GE '99991231'

AND subty = 'A011'

AND sclas = 'K' AND objid = @wa_hrp1001-var_objid.

This produces the output: 0000555559999.

I would like to remove the leading 0 and 9999. I have removed leading 0 by SHIFT wa_hrp1001-var_sobid LEFT DELETING LEADING '0'. I can remove the 9999, in a test, by giving a value with:

DATA: str TYPE string VALUE '555559999.

str = substring( val = str off = 0 len = strlen( str ) - 4 ). write: str.

My question is, how do I loop or incorporate this into that column of data.

[Abinathsiva]

Hi,

use LIKE '%555%' this will help your requirment

[Sandra_Rossi]

I don't understand the question. SOBID is 45 characters. Maybe your question is:

• Remove all characters from 11th character included (to remove "9999" in your example)
• Then remove leading zeroes

If yes, that would be: (read ABAP doc SQL String Functions for more information)

SELECT SINGLE ltrim( left( sobid, 10 ) , '0' ) AS sobid ...

NB: don't you have native ABAP functions to operate directly on SOBID value? (like WRITE or a function module) It seems that there are many questions around HRP1001-SOBID, did your read the answers?

[former_member559196]

Thank you Sandra and S Abinath. Information provided was very helpful.

Brian