Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
   

 

Net Value Accrual CP + Gross Weight

TIERS - Shipment costs detailed analysis
QVSCE_BW_QRY_MVSDTR01_0010

Global Filters

Period

Month Year

Ship Actual for Ship [C_SHIPNU2__C_COMPMON]

Geography

Zone

Ship Dep Geo Zone [C_PNTDP3__C_ZONE]

Country

Ship Dep Country [C_PNTDP3__0COUNTRY]

Organization

GBU

BFC GBU [C_SUBACT2__CPFCTR1_2]

Legal Entity

Company code [C_COMPCDE]

BU

BFC Group of activity [C_SUBACT2__CPFCTR2_2]

Site

Purchasing Site [C_PLANT__C_PSITE]

Specific Filters

Transportation

Transport Mode

Ship Transportation [C_SHIPNU2__C_TR_MODE]

Transportation Group

Transportation Group [C_MATNR2__C_BULKPAC]

Forward Agent

Forward Agent [C_FWDAGID]

Sea line

Ship Shipping Line [C_SHIPNU2__VTADD01]

Destination

Ship Dest Point

Ship Destination Point [C_PNTDS3]

Ship Dest Country

Ship Dest Country [C_PNTDS3__0COUNTRY]

Ship Dest Zone

Ship Dest Geo Zone [C_PNTDS3__C_ZONE]

Partner Type

3rd Party Type [C_PNTY3PY]

Partner

3rd Party (Cust/Vend) [C_3RPARTY]

Product

Material Division

Division [C_MATNR2__C_DIVISN]

Commercial Product

Commercial Product [C_MATNR2__C_PROD]

Product Hierarchy

Material Hierarchy [C_MATNR2__0PROD_HIER]

Reference date:

Shipment completion date

KPI:

Cost  &  Cost/Weight

Comments:

  • Net Value Accrual CP: Net Costs in provisions in EUR or USD

...

  • Gross Weight: in kilograms only

  • Conversion rules: EUR / USD

Transportation Costs  conversion from EUR to The conversion from a local currency to EUR or USD is based on the exchange rate managed by finance team for the month ‘reference month’ (month of actual completion or if empty planned completion or if still empty, shipment creation date) (Query TIERS)Finance. For each cost, the rate considered is the one of its reference month*.

* The reference month of a transportation cost is :

      • the actual completion month
      • the planned completion month if the actual completion month is not available
      • the shipment creation date if the planned completion month is also not available 

Warning
titleUSD inacurracy

For USD, we don’t have all the exchange rates because it's not the official currency at Solvay (EUR).

So for the following countries: Argentina, Bulgaria, Egypt, Mexico, New Zealand and Switzerland, when selecting USD, the unit will not be USD but the local currency.

...