FI Program Custom development Background program

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

  • FBD1 Enter Recurring Entry. Sets up a recurring entry for the premium; no policy register, endorsements or asset matching.
  • AS03 Display Asset Master Record. Shows insurance data on one asset at a time; no list by policy.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
ANLAAsset Master RecordInsured assets: class, description, capitalization dateReadECC + S/4
ANLZTime-Dependent Asset AllocationsAsset location and cost center (policy assignment)ReadECC + S/4
ANLCAsset Value FieldsCurrent cost (cover comparison)ReadECC + S/4
ANLVAsset Insurance DataInsurance type and insurer fields on the assetRead / writeECC + S/4
LFA1Vendor Master (General Section)Insurer and brokerReadECC + S/4
BSIKVendor Open ItemsInsurer invoices (policy matching)ReadECC + S/4
BKPFAccounting Document HeaderMonthly premium expense postings (written through the BAPI)WriteECC + S/4
CSKSCost Center Master RecordExpense cost center checkReadECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_BUKRSCompany codeSingle valueBKPF-BUKRSYes1000
P_MONATAccrual monthSingle value—Yes11.2026
P_ACCRMonthly premium accrualRadio button—NoX
P_COVRCoverage and renewal reportRadio button—No—
S_ANLKLAsset class (coverage report)Range / multipleANLA-ANLKLNo—
P_TESTTest modeCheckbox—NoX

Result list columns

#ColumnSource
1Policy numberCalculated Number in the policy register
2LineCalculated Fire, motor, cargo, liability etc.
3InsurerLFA1-NAME1
4End dateCalculated Policy end date
5AssetANLA-ANLN1
6Asset descriptionANLA-TXT50
7Current costANLC-KANSW
8Monthly expenseCalculated Premium × days in month / policy days
9Remaining prepaidCalculated Premium − expensed so far
10StatusCalculated Covered, no policy, expired or due for renewal within 30 days

Sample result list

Policy numberLineInsurerEnd dateAssetAsset descriptionCurrent costMonthly expenseRemaining prepaidStatus
YNG-2026-0114FireÖrnek Sigorta A.Ş.31.03.2027100012Factory building42,500,00018,25073,000Covered
KSK-2026-0451MotorDemo Sigorta A.Ş.15.12.2026400087Light commercial vehicle1,450,0003,1001,550Renewal within 30 days
200045Forklift 2.5 t980,00000No policy
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. The insurer’s invoice is matched to the policy from vendor open items (BSIK); the premium is carried on the prepaid expense account.
  3. 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.
  4. 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.
  5. 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.
  6. 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

FI Program Custom Background program

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, …

BSIS · BSEG · BKPF · SKB1

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.

Related report: Insurance Policy Tracking, Accrual and Asset Matching