Step 1 — Bring the data in
Import asset data from two systems
Pull existing fixed-asset master data and capitalised overhauls from SAP, and planned acquisitions from Coreplan. The bridge matches every new line to the right SAP asset class, cost centre and depreciation key, ready for the worksheet.
SAP — fixed asset history
Source · ERP / Asset Accounting (FI-AA)
| Asset no. | Description | Cls | Cost ctr | Acq. value | NBV |
|---|
Coreplan — planned acquisitions
Source · drilling project plan
| Ref | Item | Project | Qty | Unit cost |
|---|
Step 2 — Run the numbers
CAPEX worksheet
The same calculation your team does in Excel, pre-built and live. Edit the amber cells — quantity, unit cost, useful life — and acquisition value and straight-line depreciation recalculate instantly. Rows are colour-coded by where they came from.
| # | Source | Asset description | Asset cls | Cost ctr | Qty | Unit cost (AUD) | Acquisition value | Life (yr) | Depr. key | Annual depr. | In-service |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Total CAPEX — 9 assets | — | — | |||||||||
Total acquisition value
A$0
Capitalised cost to post to SAP
Annual depreciation (Y1)
A$0
Straight-line run-rate, full year
Avg. useful life
0.0
Weighted by acquisition value
Step 3 — Hand off to SAP
SAP-ready upload file
Your worksheet, mapped to the SAP asset-master upload template (transaction AS01 / LSMW). Validate, then download a file that loads straight into SAP using its standard upload format.
CAPEX_SAP_upload_2026.csv
AS01 template
| CoCd | Asset cls | Description | Cost ctr | Cap. date | Acq. value | Life | Depr. key | Qty | WBS / ref |
|---|
Validation
Posting summary
Assets to create0
Company codeFAU1
CurrencyAUD
Total acquisitionA$0
CSV · ready for LSMW import
DONEFile generated
