Header Ads

Sample Procedure for TPM with SAP ERP Enhanced Rebate Processing and Funds and Claims Management

2:12 AM

Sample Procedure for TPM with SAP ERP Enhanced Rebate Processing and Funds and Claims Management


This sample procedure maps the business process described earlier, to the steps you must follow in the SAP CRM application to run the business process.

Prerequisites

  • You have activated the following business functions:
    • In SAP CRM: Claims and Funds Management (CRM_CF_1)
    • In SAP ERP: ERP, Integration with Claims and Funds Management (ERP_CF_INTEGRATION_1) andFSCM Functions 3 (FIN_FSCM_CCD_3) (for integration with SAP Dispute Management)

Procedure

  1. In Customizing, set the aggregation type to product category (see Aggregation of Fund Usage Items).
  2. In SAP CRM, create funds plan FP_001 using an appropriate funds plan type. Set the validity period as January to December 20XX, and release the funds plan.
  3. From funds plan FP_001, create fund F_001 using a fund type for funding level account hierarchy node and product category. Enter account hierarchy level Australia/Supermarkets and product categorySweets&Snacks/Sweets. Release the fund.
  4. In fund F_001, create a new budget posting BP_001 of posting transaction type Budget Update, enter 10,000 USD, and approve the budget posting.
  5. In SAP CRM, create trade promotion TP_001 with the following data and save:
    • Account type: hierarchy node
    • Planning account: Australia/Supermarkets/North
    • Type: trade promotion type set up for SAP ERP enhanced rebate processing
    • Product planning basis: product category
    • Planning profile group
    • Funds plan ID: FP_001
    • Validation profile: validation profile set up for multi-account scenario
    • Start and end date for the planning and buying period: May 20XX
    • Product category: Sweets&Snacks/Sweets
    • Trade spend (combination of spend type, spend category, spend method): TS1 for percentage rebate with spend value of 3% (the trade spend must be set up for SAP ERP enhanced rebate processing).
      The system automatically assigns the condition type and rebate agreement type set in Customizing to the trade spend.
  6. In trade promotion TP_001, in the Planning assignment block, choose Edit List, select the trade spend, and choose Generate Conditions.
    The system generates the conditions and transfers them to SAP ERP. In the Conditions column, it sets the status of the conditions to Created.
  7. Approve trade promotion TP_001 and save your entries.
    The system does the following:
    • It determines fund F_001 and displays it in the Fund Details assignment block.
    • It creates one fund usage for the trade spend and displays it in the Fund Usages assignment block.
    • It creates one rebate agreement for the trade spend and transfers it to SAP ERP.
      In the Rebates assignment block, it displays the rebate agreement ID and corresponding rebate agreement type.
      In the Discounts assignment block, it displays the condition records.
  8. Release trade promotion TP_001.
  9. In SAP ERP, check whether the rebate agreement has been transferred correctly (transaction VBO3).
  10. In SAP ERP, create sales orders as follows (transaction VA01) and save your entries.
    • SO_001: Store1, 500 units of ChocBar1 and 1,000 units of ChocBar2
    • SO_002: Store2, 200 units of ChocBar1 and 2,000 units of ChocBar2
    The ID of the sales order is displayed at the bottom of the screen.
  11. In SAP ERP, check whether the trade promotion ID is displayed in the sales orders (transaction VA03).
    The system finds the trade promotion ID using campaign determination and displays it as a campaign ID in the Analysis screen of the sales order, together with the rebate agreement ID. The campaign ID is not identical to the trade promotion ID as displayed in SAP CRM but, for technical reasons, is mapped to a shorter SAP ERP-specific ID.
  12. If required, create deliveries (transaction VL01N) for sales orders SO_001 and SO_002. Create transfer orders and post goods issue (transaction VL02N).
  13. Create billing documents (transaction VF01).
    The billing documents are automatically transferred to SAP ERP accounting.
  14. In SAP ERP, check your rebate agreement for sales volume and accruals (transaction VBO3).
    The sales volume list also displays the trade promotion ID (campaign ID).
  15. To upload accruals built in SAP ERP to SAP CRM, use the Middleware report External Accruals Load, which is available in the batch processing framework.
    After the values are transferred to SAP CRM, the SAP CRM system generates fund postings. It posts the uploaded values into the Accrual Balance value category. You can find the aggregated values for this value category in the fund checkbook and the fund usage checkbook.
  16. In SAP CRM, create an invoice claim IC_001 using an appropriate claim type. Enter an individual account as claiming account; this step is required for technical reasons. In the Resolution assignment block, add trade promotion TP_001. The system automatically displays each trade spend on a separate line. Select trade spend TP1 and choose   More  Add Validated Account  . Search for accounts with revenue in SAP ERP (see Collective Claims Processing). The system determines the validated accounts from the planning account of the trade promotion. The search result list should display accounts Store1 and Store2. Select and add both accounts.
    The accounts are listed with one item each for the product category (see Aggregation of Claim Items), as follows:
    This graphic is explained in the accompanying text.
    The system defaults the maximum payable amounts and the accrued amounts from the sales volume in SAP ERP into the claim items and displays them in the Maximum Amount, Validated Amount, and Accrued Amount columns of the claims resolution tree (see Validation Against SAP ERP Accruals).
  17. Change the validated amount at trade promotion level to USD 134, and save your entries.
    The system prorates the validated amounts to subordinate levels (see Proration of Claimed Amount) as follows:
    This graphic is explained in the accompanying text.
  18. Approve the claim and save your entries.
  19. In the settlement due list of SAP CRM, find claim IC_001 (see Claim Settlement with Integration into SD Billing). Select the claim in the result list and choose Individual Settlement. From the claim data, the system creates a claim settlement document. Save the claim settlement document. The system automatically transfers the data to SAP ERP and creates SD billing documents in SAP ERP from this data. From the SD billing documents, it then creates FI accounting documents. The document IDs are displayed in the Follow-up Transactions assignment block of the claim settlement document. Clicking the document IDs takes you directly to the documents in SAP ERP. The status of the claim settlement document changes to Being Transferred and later to Transferred. The status of the claim changes to Settled.
    Note Note
    In business, claims are not settled individually but are processed automatically in the settlement run.
  20. In SAP CRM, in the trade promotion, select the trade spend and choose Balance Fund Usages (seeBalancing). In SAP ERP, the system reverses the accruals in FI without issuing any payments, updates the rebate statistics, and sets the status of the rebate agreements to D Finally Settled. In SAP CRM, the system sets the status of the fund usages to Balanced and releases unused fund reservations. It sets the rebate status of a trade spend in the trade promotion to To be settled.
  21. In SAP ERP, display the SD billing documents created from the claim settlement (transaction VF03) and check the proration.
    The billing documents should display the product category Sweets&Snacks/Sweets as the main item, and the products ChocBar1 and ChocBar2 as subitems underneath, with the payment amount prorated down to product level.
    The billing document for Store1 would look like this:
    This graphic is explained in the accompanying text.
  22. In SAP ERP, check the following:
    • The SD billing document (transaction VF03) displays the ID of the SAP CRM claim settlement document (Reference field). It also lists the accounting document, the profit center document, and the profitability analyses document (Accounting overview).
    • The SD rebate agreement (transaction VBO3) displays the IDs of the SD billing documents, that is, the rebate credit memos (in the menu, choose   Rebate Payments  Rebate Documents  ).
    • The FI accounting document (transaction FB03) displays the ID of the SAP CRM claim settlement document (Reference field) and the ID of the SD billing document (Reference Key field of the document header).

Post a Comment

Powered by Blogger.