Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with 0doc_number

Former Member
0 Kudos
64

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

1 REPLY 1

Former Member
0 Kudos
24

Thanks!