topic Re: splitting a record... in Application Development and Automation Discussions

splitting a record...

aris_hidalgo — Wed, 22 Feb 2006 01:49:24 GMT

Hello experts,

I am currently modifying a report where in I must split bkpf-awkey where ekbe-gjahr is equal to the last 4 digits and ekbe-belnr is equal to the first 10 digits from bkpf-awkey. How do I go about this guys? I have pasted below a sample record from bkpf-awkey. Thanks guys and take care!

sample 1:

0200000000GLOB1999

sample 2:

50000000081999

Re: splitting a record...

Former Member — Wed, 22 Feb 2006 01:56:57 GMT

Hi ,

try this :

Data : Strlegth type sy-tabix,

offset type sy-tabix.

ekbe-belnr = bkpf-awkey+0(10).

Strlegth = strlen( bkpf-awkey ).

Offset = Strlegth - 4.

ekbe-gjahr = bkpf-awkey+Offset(4).

Hope this may work for you.

Regards,

Lanka

Re: splitting a record...

suresh_datti — Wed, 22 Feb 2006 01:59:58 GMT

Hi,

Try this..


data: w_len type i,
      w_off type i.

w_len = strlen(bkpf-awkey).
w_off = w_len - 4.
ekbe-gjahr = bkpf-awkey+w_off(4).
ekbe-belnr = bkpf-awkey+0(10).

Regards,

Suresh Datti