Problem with 0doc_number

Former Member — Thu, 09 Aug 2007 12:22:01 GMT

Hi,

i have my start routine like this:

start routine:

SELECT DOC_NUMBER SALES_OFF FROM /bic/AZSD_O0100 INTO TABLE

ITEM_TABLE1 WHERE

DOC_NUMBER = DATA_PACKAGE-PROJECT.

if sy-subrc = 0.

sort item_table1 by doc_number.

endif.

update routine:

READ TABLE ITEM_TABLE1 WITH KEY

DOC_NUMBER = 'comm_structure-project'

BINARY SEARCH.

IF SY-SUBRC = 0.

RESULT = ITEM_TABLE1-SALES_OFF.

ENDIF.

here i have 2 fields in ODS called DOC_NUMBER and SALES_OFF.

1 cube with PROJECT and SALES_OFF

i need to populate this sales off into another cube by comparing its DOC_NUM with Cubes PROJECT.

say,

if ODS'S DOC_NUMBER = CUBE'S PROJECT

then fetch ODS's sales offce into Cube.

problem is since DOC_NUMber is 10 in length,char data type and ALPHA -

if it is 173 it always considers it as 0000000173.

but the PROJECT is 24 length char and PROJ as conversion routine and it takes as 173 only.

here 0000000173 = 173 not possible

so not fetchin sales office into cube.

please tell me is there any possibility to truncate 0's of 0DOC_NUMBER while comparing i.e ignoring 0'S of DOC_NUM and comparing with PROJECT.

Note: and PROJECT's and 0DOC_NUMBER'S properties cant be changed.

Thanks for your patience,

ViJaYa

Re: Problem with 0doc_number

Former Member — Wed, 22 Dec 2010 05:39:35 GMT

Thanks!