How to Design a Data model based on a SQL query(Oracle) in QlikView

Dear All,
It is a challenge to all of us to mimic SQL query into a Data model, quite often in the current project I face such challenges.
One question you might ask is why not directly use the query in script and convert it as a qvd but in the architecture we are in right now we load most of the tables in to qvds and question comes when you have all the tables as qvds why can’t we create a model using them! Hope I am clear till now.

Below is one such query which I recently modeled as a QlikView data model.

select v1.segment1 “Item”,
       v1.supplier_num “Supplier Num”,
       v1.supplier “Supplier Name”,
       v1.description “Description”,
       v1.organization_code “Org”,
       v1.primary_uom_code “UOM”,
       v1.period “Period”,
       v1.period_sort “Period Sort”,
       v1.po_unit_price “PO Unit Price (LC)”,
       v1.stnd_unit_cost “Item Unit Cost(LC)”,
       v1.currency_code  “Local Currency”,
       ROUND(GL_CURRENCY_API.GET_RATE(v1.currency_code,’USD’, v1.delivery_date, ‘1020’), 6) “Rate to USD”,
       ROUND((v1.po_unit_price * GL_CURRENCY_API.GET_RATE(v1.currency_code,’USD’, v1.delivery_date, ‘1020’)), 5) “PO Unit Price (USD)”,
       ROUND((v1.stnd_unit_cost * GL_CURRENCY_API.GET_RATE(v1.currency_code,’USD’, v1.delivery_date, ‘1020’)), 5) “Item Unit Cost (USD)”,
       sum(v1.qty) “Qty”
from (
select msi.segment1,
       msi.description,
       mp.organization_code,
       msi.primary_uom_code,
       trunc(mmt.transaction_date) delivery_date,
       H_GET.HOLX_GET_FISCAL_P(trunc(mmt.transaction_date), ‘Month’) period,
       to_date(H_GET.HOLX_GET_FISCAL_P(trunc(mmt.transaction_date), ‘Month’), ‘MON-YY’) period_sort,
       mmt.transaction_cost po_unit_price,
       case when mp.process_enabled_flag = ‘N’
            then mmt.actual_cost
            else (select gic.acctg_cost
                    from gl_item_cst gic
                   where gic.inventory_item_id = msi.inventory_item_id
                     and gic.organization_id = msi.organization_id
                     and cost_type_id = 1000
                     and mmt.transaction_date between start_date and end_date)
            end stnd_unit_cost,
       gll.currency_code,
       mmt.primary_quantity qty,
       s.segment1 supplier_num,
       s.vendor_name supplier
  from mtl_material_transactions mmt,
       mtl_system_items_b msi,
       mtl_parameters mp,
       cst_acct_info_v cai,
       gl_ledgers gll,
       rcv_transactions rt,
       ap_suppliers s
 where mmt.transaction_type_id != 74 –Exlcude the transfer to regular trxs
   and mmt.organization_id = msi.organization_id
   and mmt.inventory_item_id = msi.inventory_item_id
   and mmt.organization_id = mp.organization_id
   and mp.organization_id = cai.organization_id
   and cai.ledger_id = gll.ledger_id
   and mmt.rcv_transaction_id = rt.transaction_id
   and rt.vendor_id = s.vendor_id
   and mmt.transaction_date >= to_date(:FROM_DATE, ‘DD-MON-YYYY’)
   and mmt.transaction_date < to_date(:TO_DATE, ‘DD-MON-YYYY’)
   and mmt.transaction_source_type_id = 1
UNION ALL
select msi.segment1,
       msi.description,
       mp.organization_code,
       msi.primary_uom_code,
       trunc(mmt.transaction_date) delivery_date,
       H_GET.HOLX_GET_FISCAL_P(trunc(mmt.transaction_date), ‘Month’) period,
       to_date(H_GET.HOLX_GET_FISCAL_P(trunc(mmt.transaction_date), ‘Month’), ‘MON-YY’) period_sort,
       mmt.transaction_cost po_unit_price,
       case when mp.process_enabled_flag = ‘N’
            then mmt.actual_cost
            else (select gic.acctg_cost
                    from gl_item_cst gic
                   where gic.inventory_item_id = msi.inventory_item_id
                     and gic.organization_id = msi.organization_id
                     and cost_type_id = 1000
                     and mmt.transaction_date between start_date and end_date)
            end stnd_unit_cost,
       gll.currency_code,
       mmt.primary_quantity qty,
       –mmt.*
       s.segment1 supplier_num,
       s.vendor_name supplier
  from mtl_material_transactions mmt,
       mtl_system_items_b msi,
       mtl_parameters mp,
       cst_acct_info_v cai,
       gl_ledgers gll,
       po_headers_all poh,
       ap_suppliers s
 where mmt.transaction_type_id = 74 –Transfer to regular trxs
   and mmt.primary_quantity > 0
   and mmt.organization_id = msi.organization_id
   and mmt.inventory_item_id = msi.inventory_item_id
   and mmt.organization_id = mp.organization_id
   and mp.organization_id = cai.organization_id
   and cai.ledger_id = gll.ledger_id
   and mmt.transaction_source_id = poh.po_header_id
   and poh.vendor_id = s.vendor_id
   and mmt.transaction_date >= to_date(:FROM_DATE, ‘DD-MON-YYYY’)
   and mmt.transaction_date < to_date(:TO_DATE, ‘DD-MON-YYYY’)
   and mmt.transaction_source_type_id = 1
) v1
 group
    by v1.segment1,
       v1.supplier_num,
       v1.supplier,
       v1.description,
       v1.organization_code,
       v1.primary_uom_code,
       v1.period,
       v1.period_sort,
       v1.po_unit_price,
       v1.stnd_unit_cost,
       v1.currency_code,
       ROUND(GL_CURRENCY_API.GET_RATE(v1.currency_code,’USD’, v1.delivery_date, ‘1020’), 6),
       ROUND((v1.po_unit_price * GL_CURRENCY_API.GET_RATE(v1.currency_code,’USD’, v1.delivery_date, ‘1020’)), 5),
       ROUND((v1.stnd_unit_cost * GL_CURRENCY_API.GET_RATE(v1.currency_code,’USD’, v1.delivery_date, ‘1020’)), 5)
 order
    by 8,1,3,5