Configuration and process steps of accrual posting process in TPM

[emekyesilyurt]

In this blog I would like to share my experiences with the configuration and process steps of accrual posting process in CRM trade promotion management (TPM). With regards to the topics covered, I have split this blog into two sections:

1.     Accruals Configuration

2.     Accrual Calculation & Posting Process

1.     Accruals Configuration

Customer Relationship Management -> Funds Management -> Accruals

1.1     Define accrual reference data types

You can define the reference data types the accrual calculation methods use.

The standard delivery reference data type is:

• ERP_SV; defines ERP sales volumes as reference data.
• TPM_PLAN; defines TPM planning data as reference data.

1.2     Define accrual methods

You can define an accrual calculation method and optional reference data that can be used to calculate the accrual amount.

There are 6 standard delivery accrual calculation methods:

• Uses Accrual Rate of ERP Sales Volume and TPM Take Rates (ERP_SV): This method calculates accruals based on ERP rebates sales volumes using and TPM take rates. It does not support accrual amounts in upcoming fiscal period (expense forecast).
• Whole Amount on a Fixed Date (FIXED_DT): This accrual method accrues the amount reserved for the fund usage on the date the accrual posting is performed (fixed date). It supports expense forecast.
• Fund-Based Amount on a Fixed Date (FUNDFIXD): This accrual method is for fund-based accruals and accrues the entire amount of the fund on the date the accrual posting is performed (fixed date). It supports expense forecast.
• Fund Usage Amount for Accrual Period (NB_DAYS): This accrual method spreads the amount reserved for the fund usage equally over the number of days that it accrues. It supports expense forecast and requires that accrual start date is chronologically before or equal to the accrual end date.
• Spread Accrual Amount Using Ref. Data (REF_DATA): This accrual method spreads the amount reserved for the fund usage over the days that it accrues according to the reference data. It supports expense forecast and requires that accrual start date is chronologically before or equal to the accrual end date.
• Spread Fund-Based Amount Using Ref. Data (FUNDRDTA): This accrual method is for fund-based accruals. It spreads the entire amount of the fund equally over the number of days that it accrues according to the reference data. It supports expense forecast and requires that accrual start date is chronologically before or equal to the accrual end date.

1.3     Define accrual profiles

You can define an accrual profile that references an accrual calculation method and optional reference data.

There are 5 standard delivery accrual profiles:

• Accrue Whole Amount at Fixed Date (FIXED_DT): This accrual profile accrues the amount reserved for the fund usage on a fixed date.
• Accrue Fund-Based Amount at Fixed Date (FUNDFIXD): This accrual profile is for fund-based accruals and accrues the entire amount of the fund on the date the accrual posting is performed (fixed date).
• Accrue Amount Equally for Accrual Dates (NB_DAYS): This accrual profile spreads the amount reserved for the fund usage equally over the number of days that it accrues. The number of days can span several periods.
• Accrue Using ERP Sales Volumes and TPM Take Rates (ERP_SV): This accrual profile accrues ERP sale volumes and TPM take rates using the ERP sales volume agreement accrual rate.
• Accrue Using TPM Planning Data (TPM_PLAN): This accrual profile accrues TPM planning data.

Customer Relationship Management -> Trade Promotion Management -> Trade Promotions -> Funds Integration

1.4     Funds Integration

You can make settings to integrate funds management functionality into your trade promotions.

Under Expense Type to Accrual Profile, select the expense type for a particular promotion type. Select the accrual date range and accrual profile to map to the expense type, by doing so you specify the accrual calculation method for each expense type.

If Accrual Profile is left blank, then there will be no accrual for this expense type and its related trade spend. It is recommended to leave this field blank for off-invoice type trade spends, as they only create pricing records and not rebate agreements. Therefore, accruals are not relevant.

2.     Accrual Calculation & Posting Process

Below is the table of TPM accrual posting process steps for different accrual profiles.

Accrual Profile	Step	Program name
ERP Sales Volume Dependent	1	RCRM_FM_ACL_ACCRUAL_UPLOAD_SV	Sales Volume Load
	2	RCRM_FM_ACL_ACCRUAL_RUN	Accrual Calculation
	3	RCRM_FM_ACL_ACCRUAL_POSTING_FM	Accrual Posting
ERP Sales Volume Independent	1	RCRM_FM_ACL_ACCRUAL_RUN	Accrual Calculation
	2	RCRM_FM_ACL_ACCRUAL_POSTING_FM	Accrual Posting

“Sales Volume Load” job uploads sales volumes from SAP ERPto SAP CRM. For the expense types having an ERP sales volume dependent accrual profile such as ERP_SV, sales volume load job should be executed before accrual calculation to transfer ERP sales volumes to CRM. The transferred sales volumes are captured in CRM table CRMD_FM_ACL_SV and will be the input of the accrual calculation for the related accrual profiles.

“Accrual Calculation” job calculates the accruals according to the accrual profile. After the calculation the accrual amounts are kept in accrual staging area, CRM table CRMD_FM_ACL_ASA, and will be the input of the accrual posting. The related entries of CRMD_FM_ACL_ASA table are cleared after the accrual posting.

“Accrual Posting” job posts the calculated accruals and creates the ‘accrue’ type fund posting documents in CRM. CRM table CRMD_FM_FPO_HEAD holds the header information and CRM table CRMD_FM_FPO_ITEM holds the item information of the fund postings.

Accruals are transferred to ERP accounting via middleware with Bdocs of CRM_FM_FPO type and create ERP accrual posting documents. In the standard delivery the reference number of the ERP accounting document is the fund posting ID of the CRM fund posting document. This number is the link between CRM and ERP accrual processes.