InfoSets - Need 1-N relation + 2 1-1relation

Hi,

i am trying to make and infoset on which i will do reporting on my requirement are

Get all sales deal (With or without sales order) an report then using masterdata attributs on material and customer

Can this be achive with an infoset

the 1-1 relationship is use to get a navigationnal attribut

1 - N RelationShip = All SalesDeal(Infoobject)with SalesOrder(ODS)

1 - 1 RelationShip = for each salesOrder = 1 material(Infoobject)

1 - 1 relationShip = For earch SalesOrder = 1 Customer(Infoobject)

Rec 1

Sales Deal = 10001

sales order 200

customer A1

material B1

sales order 300

customer A1

material B1

Rec 2

Sales Deal = 10002

sales order #

customer #

material #

sales order #

customer #

material #

Thanks