i have my start routine like this:
SELECT DOC_NUMBER SALES_OFF FROM /bic/AZSD_O0100 INTO TABLE
DOC_NUMBER = DATA_PACKAGE-PROJECT.
if sy-subrc = 0.
sort item_table1 by doc_number.
READ TABLE ITEM_TABLE1 WITH KEY
DOC_NUMBER = 'comm_structure-project'
IF SY-SUBRC = 0.
RESULT = ITEM_TABLE1-SALES_OFF.
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.
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,