Skip to Content

Get latest record based on date to avoid duplicate records

Hi Everyone,

I am trying to load 0COSTCENTER master data from BW to BPC Dimension but it throwing duplicate records error.

Yes,I've duplicate records in my Info objects but there are two attribute Valid from and Valid to, These values are different for each record.


Please see the below ss on the same.


So how i can load latest record which contains latest Valid from and Valid to values? As per Snap shot the latest record is third one right?

Can you please guide me on this. Thanks in advance!

Regards,

Vishu


CC1.png (54.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 10, 2015 at 04:58 PM

    Hi Vishnu,

    What Package are you using to load that data?

    In standard Package for load of MD there is a Key data which is usually current date. This way load selects a record that is valid for today. If you don't want such record, but want the latest, set that date to the far future, like 30.12.9999.

    Regards,

    Gersh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2015 at 06:07 AM

    Hi Vishu,

    You can filter it from "Set Selection" while loading the data.

    Shrikant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2015 at 06:46 AM

    Hi Vishu,

    You can't select the valid to date in the set selection, you need to use end routine in your transformation file to filter your data.

    you need to write a routine BADI.

    Andy

    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.