How do I stop getting duplicate records when I use only the job info. Table in a Story in PA?

[MikeC]

I’m only selecting the job info table. If I include position title or id I get duplicate records. The only way to prevent this is to not select position title or id and then bring in position as a table joined to job info table and select it from there. So I can still use position in a story. Is this really how it should be done as I tried this fix in my other stories and it didn’t fix the issues?

I can’t find any documentation about this and looking on these forum’s there seems to be a lot of questions about duplicates but trying to access any links to a possible answer seems to be hidden behind endless username and password requests. So I get no answers.

Any help would be appreciated. I’m the only person in my business learning stories so it’s up to me to figure all this out. Thanks

[Sandra_Rossi]

Please do not post a question about SAP Web sites (community, etc.) if it's not a question about SAP Web sites! You can use Technology Q&A or any groups.

[JeroenA]

Hi Mike,

When you add the position title or code from Job Info you are using an auto-join with the position table. A position can have multiple record statuses and will return a row for each status. I recommend joining the position table from Job Info and create a query filter on Position ? Record Status = "N". This will give you one row only. See an example below.

Kind regards,

Jeroen

[MikeC]

Hi. Thanks for that. This is what I've managed to figure out for myself. But it took along time to find which field in the job table was causing the duplication. In our system its called mdfsystemRecordStatus. Is there any document that shows other fields like this so I know when using certain fields it will cause duplicates and you have to do things slightly differently like in this example? Thanks.

[subbareddyven]

3211995 - Duplicate records in Story report due to selection of Foundation object fields - SAP for M...

[MikeC]

Thanks but as mentioned in my second paragraph none of the links to answers in the sap communities site work for me. I put in my username and password and get into an area called "Sap for me" but the answer never comes up. I just get 3 little circles like its loading but gets stuck there.

[subbareddyven]

Attaching KBA screenshot

[MikeC]

Thanks for the screenshot. I'm already using the Record Status = N filter. Any other ideas please?

[subbareddyven]

HI Mike,

Issue looks similar to below kba.

3211995 - Duplicate records in Story report due to selection of Foundation object fields - SAP for M...

Regards,

Subbu

[MikeC]

Thanks for the response but like all the links I click on on this site it either constantly comes up with a request for a username and apssword, or in this case knowledge base article you are referring to won’t load. I’ve experienced this over and over again and can never get answers to any of the questions I’ve seen on here. Wish I knew what the issue is. Not sure why knowledge base help has to get behind a password. Really frustrating.