cancel
Showing results for 
Search instead for 
Did you mean: 

Info Set

Former Member
0 Kudos

Hi All,

I am having a production problem with infoset, where in we have a join on Sales Order Header & Item data and Material ODS. Now when we execute the query on this infoset, it gives duplicate records for some of the sales order, the reason for that is "Material is Time dependent".

Could any one help to over come this problem?

Thanks & Regards

Hema

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Please restrict your time IOBJ.

Best regards,

Eugene

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Hemlata,

You have mentioned that you used Material ODS. So time dependancy doesn't come into picture. i am assuming you have one record for material in the ODS. If you have more than one record for material then you will get duplicate records. Then you should restrict by the date.

former_member181955
Contributor
0 Kudos

Hi Hemalata,

can u provide the definition of query what u have written against info set

Regards

N.P.BABU

Former Member
0 Kudos

I am restricting the query by Sales Order # and selecting the rows.

Let me know is that what you expected?

Regards

Hema