Skip to Content
0
Former Member
Mar 03, 2009 at 10:39 AM

Regarding number ranges

45 Views

hi,

I have a table , in which one field is 32 char.

it is been generated by number ranges.

we have customised the number range.

for eg 011111111111 to 666666666666 is one range.

but my isssue is , in the table alpha numeric is getting populated.

from where it is coming i am not able to undestand.

like 01083E49B604DF16E1000000AC128BE3 ,this is one value.

from where i got E49B... (alphabets).

can u please suggest me

i have found the following code ,is it because of this code...

*********************************************

lv_code = '0123456789ABCDEF'.

DO 16 TIMES.

lv_indx = sy-index - 1.

CONCATENATE lv_code+lv_indx(1) '%' INTO lv_prex.

CLEAR lt_guid.

SELECT case_guid INTO TABLE lt_guid FROM scmg_t_case_attr WHERE case_guid LIKE lv_prex

AND (

case_type EQ CL_GRPC_CNST_CASE=>GC_CASE_TYPE_AS

OR case_type EQ CL_GRPC_CNST_CASE=>GC_CASE_TYPE_IS

OR case_type EQ CL_GRPC_CNST_CASE=>GC_CASE_TYPE_PL

OR case_type EQ CL_GRPC_CNST_CASE=>GC_CASE_TYPE_TE

OR case_type EQ CL_GRPC_CNST_CASE=>GC_CASE_TYPE_TL

).

LOOP AT lt_guid INTO lv_guid.

CLEAR wt_guid.

APPEND lv_guid TO wt_guid.

CALL FUNCTION 'GRPC_CASE_GET_POID_DATA' DESTINATION gv_dest

EXPORTING

it_guid = wt_guid

TABLES

et_pdir = lt_pdir

et_prel = lt_prel

et_poidcr = lt_poidcr.

INSERT scmgpdir FROM TABLE lt_pdir ACCEPTING DUPLICATE KEYS.

lv_pdir_cnt = sy-dbcnt.

INSERT scmgprel FROM TABLE lt_prel ACCEPTING DUPLICATE KEYS.

lv_prel_cnt = sy-dbcnt.

INSERT scmgpoidcr FROM TABLE lt_poidcr ACCEPTING DUPLICATE KEYS.

lv_poidcr_cnt = sy-dbcnt.

IF lv_pdir_cnt > 0

OR lv_prel_cnt > 0

OR lv_poidcr_cnt > 0.

  • 0 'BACKGROUND'.

  • 1 'HEADING'.

  • 2 'NORMAL'.

  • 3 'TOTAL'.

  • 4 'KEY'.

  • 5 'POSITIVE'.

  • 6 'NEGATIVE'.

  • 7 'GROUP'.

FORMAT COLOR = 5.

WRITE: / lv_guid, 36 text-003.

FORMAT COLOR OFF.

IF gv_test IS INITIAL.

COMMIT WORK.

ENDIF.

ELSE.

FORMAT COLOR = 3.

WRITE: / lv_guid, 36 text-004.

FORMAT COLOR OFF.

ENDIF.

ENDLOOP.

ENDDO.

******************************************************

thanks in advance.

Edited by: shilpa on Mar 3, 2009 11:41 AM