infoset how? one to many relationship

Hello BW Experts,

I have a requirement to combine 2 ODS.

both ods1 and ods2 have the object material num

relation is : but for one material num mat1.ods1 in ods1 there are two corresponding records ods2 with the same material num mat1.ods2.

difference: the difference between the two records in ods2 is transaction type trntyp.

requirement: to pick up the record mat1.ods2 with trntyp == '001'

is this possible with infosets. could you please explain the process of creation in this case.

Any suggestions appreciated.

Thanks,

BWer