Info Set

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Please restrict your time IOBJ.

Best regards,

Eugene

[Former Member]

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]

Hi Hemalata,

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

Regards

N.P.BABU

[Former Member]

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

Let me know is that what you expected?

Regards

Hema