im trying to have a query that will show relationship map. header will look like this. Sales Order as my starting base document. Here are the trail scenario:
ORDR#>ODLN#>OINV#>ORCT#>ODPS#>OPOR#>OPDN#>OPCH#>OVPM#
ORDR#>OINV#>ODLN#>ORCT#>ODPS#>OPOR#>OPDN#>OPCH#>OVPM#
null> null> null> null> null>OPOR#>OPDN#>OPCH#>OVPM#
Hope anyone can help me to sort this out.
Thank you in advance.