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

How to populate from current calendar week until next 1 year.

Hi Experts,

I am extracting data from CRM to BI (DSO) and mapped the source field Valied to to Calweek in BI.

My requirement is

1) which have Valid to date less than current date will be ignored as they no longer are valid

2) Data has been populated from current calendar week until next 1 year.

Ex:

One record with value 200 valid till 13.03.2011 --> This data will not come to BI side

Other record with value 300 valid till 31.12.9999. --> This data has been populated from current calendar week until next 1 year

(Should apper Calweek data from 201406 to 201506)

So how can i achive this?

Thanks & Regards,

Venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2014 at 06:44 AM

    Hello Venkat,

    Current calendar week will be always dependant on current system date. Each time you execute the report the query run time date (sydatum) should be assigned to calweek.

    Until next year the current week is constant in your report.

    If this does not answer your qeustion. Please draft an example with 2 records and expected output.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 19, 2014 at 11:24 AM

    Hi Venkat,

    can you please elaborate the issue with example so that it can be solved

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI venkat,

      I think you need convert form calweek to calday it can be happen with Automatic time conversion,i think you will get an idea by seeing the below thread,but data target should be cube.

      Please look over the below thread it may help you,

  • Posted on Feb 19, 2014 at 02:49 PM

    Hi venkat,

    can you please clarify below doubts so that we can help you in better way.

    • One record with value 200 valid till 13.03.2011 --> This data will not come to BI side

    - May i know what is the field for the record 200 in source..?

    based on this field we can filter out by using routine(better end routine for performance reasons)

    below is piece of code(end routine) for the same.


    Loop at RESULT_PACKAGE ASSIGNING <RESULT_FIELDS> .

    if <RESULT_FIELDS>-A EQ '200'

    and <RESULT_FIELDS>-B LQ SY-DATUM

    DELETE RESULT_PACKAGE.

    ELSE

    Other conditions also you can write in Else if part in similar way if you are unable to write please give more clarity on your 2nd point so that we can assist you in better way.

    ENDIF.

    ENDLOOP.

    • Other record with value 300 valid till 31.12.9999. --> This data has been populated from current calendar week until next 1 year

    - this requirement really i am really not understood please elaborate then only we can help out.


    Regards,

    Harish

    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.