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: 

BDC data file is not showing

Former Member
0 Kudos

Hi All,         There is one BDc to upload WBS data, there is moth wise updation for all 12 months, In month filed there is amount and also there is hard code to delete left zeros in amount. Now my client want that if there is no amount than in any month then he is putting 0 than code also deleting that so its showing nothing there under month field, showing empty. Code is given below for LEFT DELETING LEADING '0'. If there is 0 value for any month,than how can do modification in this code without changing left deleting leading 0. LOOP AT wt_sumfinal INTO wa_temp1.     wa_temp3-wbs  = wa_temp1-wbs.     wa_temp3-year  = wa_temp1-year.     wa_temp3-saknr = wa_temp1-saknr.     UNPACK wa_temp1-jan TO wa_temp3-jan.     SHIFT wa_temp3-jan LEFT DELETING LEADING '0'.     UNPACK wa_temp1-feb TO wa_temp3-feb.     SHIFT wa_temp3-feb LEFT DELETING LEADING '0'.     UNPACK wa_temp1-mar TO wa_temp3-mar.     SHIFT wa_temp3-mar LEFT DELETING LEADING '0'.     UNPACK wa_temp1-apr TO wa_temp3-apr.     SHIFT wa_temp3-apr LEFT DELETING LEADING '0'.     UNPACK wa_temp1-may TO wa_temp3-may.     SHIFT wa_temp3-may LEFT DELETING LEADING '0'.     UNPACK wa_temp1-jun TO wa_temp3-jun.     SHIFT wa_temp3-jun LEFT DELETING LEADING '0'.     UNPACK wa_temp1-jul TO wa_temp3-jul.     SHIFT wa_temp3-jul LEFT DELETING LEADING '0'.     UNPACK wa_temp1-aug TO wa_temp3-aug.     SHIFT wa_temp3-aug LEFT DELETING LEADING '0'.     UNPACK wa_temp1-sep TO wa_temp3-sep.     SHIFT wa_temp3-sep LEFT DELETING LEADING '0'.     UNPACK wa_temp1-oct TO wa_temp3-oct.     SHIFT wa_temp3-oct LEFT DELETING LEADING '0'.     UNPACK wa_temp1-nov TO wa_temp3-nov.     SHIFT wa_temp3-nov LEFT DELETING LEADING '0'.     UNPACK wa_temp1-dec TO wa_temp3-dec.     SHIFT wa_temp3-dec LEFT DELETING LEADING '0'.     APPEND wa_temp3 TO wt_finaldata.   ENDLOOP.   CLEAR : ws_filedata.   LOOP AT wt_finaldata INTO ws_filedata.     w_year = ws_filedata-year. File is like: CA.700008.001.03 2013 0 0 0 0 0 0 0 0 0 0 0 0 706100 CA.700008.001.04 2013 0 0 0 0 0 0 0 0 0 0 0 0 706100 CA.700008.001.05 2013 0 0 0 0 0 0 0 0 0 0 0 0 706100 0 is not showing in after upload of file Thanks and Regards Sankil Pandya

3 REPLIES 3

Former Member
0 Kudos

Hi Sankil,

You need to add a check before using all "SHIFT <variable> LEFT DELETING LEADING '0' ".  

Like,

If wa_temp3-jan NE '0'.

    SHIFT <variable> LEFT DELETING LEADING '0'.

Endif.

Regards,

Fasi

Former Member
0 Kudos

Hi Sankil,

Do as suggested by Fasiullah.

Regards,

Shaiksha Vali.

0 Kudos

thanks