Insurance Policy Tracking, Accrual and Asset Matching
Short answer: A program that records insurance policies by line, type, insurer and insured object; spreads the prepaid premium over the policy term and posts the monthly expense automatically; and matches policies to the insured fixed assets to report assets without cover and upcoming renewals.
- Estimated effort
- L · 10–15 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The asset master has fields for insurance type and insurer (ANLV), but policy number, term, premium installments and a policy covering several assets are not managed. Premium accrual can be set up as a recurring entry with FBD1, but each policy needs its own setup, amounts are corrected by hand on cancellation or endorsement, and which asset is insured by which policy cannot be seen in one list.
Who uses it? General ledger staff, insurance and risk management owners, fixed asset accountants and finance managers.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| ANLAAsset Master Record | Insured assets: class, description, capitalization date | Read | ECC + S/4 |
| ANLZTime-Dependent Asset Allocations | Asset location and cost center (policy assignment) | Read | ECC + S/4 |
| ANLCAsset Value Fields | Current cost (cover comparison) | Read | ECC + S/4 |
| ANLVAsset Insurance Data | Insurance type and insurer fields on the asset | Read / write | ECC + S/4 |
| LFA1Vendor Master (General Section) | Insurer and broker | Read | ECC + S/4 |
| BSIKVendor Open Items | Insurer invoices (policy matching) | Read | ECC + S/4 |
| BKPFAccounting Document Header | Monthly premium expense postings (written through the BAPI) | Write | ECC + S/4 |
| CSKSCost Center Master Record | Expense cost center check | Read | ECC + S/4 |
S/4HANA notes
- ANLC → ACDOCA: In S/4HANA new asset accounting the actual values are kept in ACDOCA; ANLC is only read through the compatibility view FAAV_ANLC.
- BSIK: In S/4HANA BSIK is no longer filled as a separate index table; reads work through a compatibility view. For new developments the I_OperationalAcctgDocItem CDS view is recommended.
BAPIs and functions used
- BAPI_ACC_DOCUMENT_POSTAccounting: Post Document. Posts the monthly premium expense
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Saves the posting
- BAPI_FIXEDASSET_CHANGEChange Fixed Asset. Optionally updates the insurance fields on the asset
- SO_NEW_DOCUMENT_ATT_SEND_API1SAPoffice: Send New Document with Attachments. Sends the renewal reminder
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_BUKRS | Company code | Single value | BKPF-BUKRS | Yes | 1000 |
| P_MONAT | Accrual month | Single value | — | Yes | 11.2026 |
| P_ACCR | Monthly premium accrual | Radio button | — | No | X |
| P_COVR | Coverage and renewal report | Radio button | — | No | — |
| S_ANLKL | Asset class (coverage report) | Range / multiple | ANLA-ANLKL | No | — |
| P_TEST | Test mode | Checkbox | — | No | X |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Policy number | Calculated Number in the policy register |
| 2 | Line | Calculated Fire, motor, cargo, liability etc. |
| 3 | Insurer | LFA1-NAME1 |
| 4 | End date | Calculated Policy end date |
| 5 | Asset | ANLA-ANLN1 |
| 6 | Asset description | ANLA-TXT50 |
| 7 | Current cost | ANLC-KANSW |
| 8 | Monthly expense | Calculated Premium × days in month / policy days |
| 9 | Remaining prepaid | Calculated Premium − expensed so far |
| 10 | Status | Calculated Covered, no policy, expired or due for renewal within 30 days |
Sample result list
| Policy number | Line | Insurer | End date | Asset | Asset description | Current cost | Monthly expense | Remaining prepaid | Status |
|---|---|---|---|---|---|---|---|---|---|
| YNG-2026-0114 | Fire | Örnek Sigorta A.Ş. | 31.03.2027 | 100012 | Factory building | 42,500,000 | 18,250 | 73,000 | Covered |
| KSK-2026-0451 | Motor | Demo Sigorta A.Ş. | 15.12.2026 | 400087 | Light commercial vehicle | 1,450,000 | 3,100 | 1,550 | Renewal within 30 days |
| 200045 | Forklift 2.5 t | 980,000 | 0 | 0 | No policy |
How does the program work?
- On the policy screen the policy number, line (fire, motor, cargo, liability etc.), insurer (LFA1), broker, start and end date, premium amount, installments, expense account and cost center are entered; endorsements and cancellations are added as transactions linked to the policy.
- The insurer’s invoice is matched to the policy from vendor open items (BSIK); the premium is carried on the prepaid expense account.
- The monthly run calculates the premium falling into the month on a daily basis for every active policy and moves it from prepaid expense to the expense account and cost center with BAPI_ACC_DOCUMENT_POST. On endorsement or cancellation the remaining amount is spread over the remaining term again.
- Assets covered by a policy are assigned by asset number, asset class or location (ANLA, ANLZ). After assignment the insurance type and insurer fields in ANLV can optionally be updated.
- The coverage report compares active assets (ANLA, current cost from ANLC) with the policy assignments and lists assets with no policy, an expired policy or a policy that expires within a month.
- An email goes to the owner of policies whose renewal date is near. In S/4HANA asset values are read from ACDOCA; policy data stays in custom tables.
Performance notes
In the monthly accrual read the policies once and use the option to post one summary document per company code and month instead of one per policy. In the coverage report narrow the asset list by company code and class; read ANLC with FOR ALL ENTRIES.
Features
- ALV list (sort, filter, subtotals)
- Test mode (check without posting)
- Runs as a background job The monthly accrual runs automatically at month-end close.
- Send the result by email Policies near their renewal date are notified to the owner.
- Line-by-line result and error log
Authorization objects
- F_BKPF_BUKPosting authorization for the company code
- A_S_ANLKLAsset display and insurance field change authorization
Frequently asked questions
If a policy covers hundreds of assets, must they be assigned one by one?
No. Assignment can also be made by asset class, location or cost center rule; new assets that match the rule are added to the policy automatically in the next run.
Can the premium expense be split over several cost centers?
Yes. A list of cost centers and percentages can be defined per policy, or the expense can be split to the cost centers of the insured assets weighted by current cost.
Related reports
Prepaid Expense and Deferred Revenue Accrual Program
A custom program that spreads prepaid expenses such as insurance, rent, maintenance contracts and subscriptions, and revenue collected in advance, …
Fixed Asset Register with Book and Tax Depreciation Report
A custom ALV report that shows every fixed asset on one row with acquisition cost, accumulated depreciation, depreciation of the year and net book …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.