Hi experts
When open on landed cost relationship map you can see (attachment):
Invoice (Goods), Landed cost and Invoice (Transport).
Can anyone help me to build simple query please:
T0.[DocNum] (Invoice transport), T1.[DocNum] (landed cost)
Query below returns only Invoice (Goods) but not Invoice (Transport)
SELECT T0.[DocNum], T1.[DocNum] FROM OPCH T0 INNER JOIN OIPF T1 ON T0.[LndCstNum] = T1.[DocEntry]
On relationship map link exist but I cannot find way to link it in query
