Skip to Content
author's profile photo Former Member
Former Member

BDC data file is not showing

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 12:32 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2013 at 01:21 PM

    Hi Sankil,

    Do as suggested by Fasiullah.

    Regards,

    Shaiksha Vali.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.