Kontakt

Ansicht
Dokumentation

CACS_CREATE_ELT_FRM_EXCEL - Creation of ELT Worklists

CACS_CREATE_ELT_FRM_EXCEL - Creation of ELT Worklists

CL_GUI_FRONTEND_SERVICES - Frontend Services   General Material Data  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You use this report to create entitlement and liability (ELT) worklists from a Microsoft Excelfile.

The report CACS_CREATE_ELT_FRM_EXCELretrieves data from a Microsoft Excel file and stores this information in an internal table. This report then calls the CACS_CREATE_ELT_FRM_EXCEL_RFCfunction module that creates ELT worklists in the background by using this information.

You can specify the following information on the initial screen of this report:

  • Server
  • Presentation Server

You must choose this option if you want to upload a Microsoft Excel file that is stored locally in your system.
  • Application Server

You must choose this option if you want to upload a Microsoft Excel file that is stored in the SAP system.
  • Local File with ELT Data / Logical File with ELT Data
Based on the server that you choose, you have to specify a local file or a logical file, which has information about ELT assignments. The information required to create ELT worklists is stored in a Microsoft Excelfile under the following column headings:
  • Worklist ID

Contains the ID of the worklist for object assignment. If you specify the same ID in this column for more than one row in the input file, then all these rows are processed as a part of the same worklist.
  • Assignment Group ID

Contains the ID of an assignment group. If you specify the same ID in this column for more than one row in the input file, then all these rows are processed as a part of the same assignment group.
  • Assignment Group Description

Contains the description of an assignment group
  • Assignment Set ID

Contains the ID of an assignment set. If you specify the same ID in this column for more than one row in the input file, then all these rows are processed as a part of the same assignment set.
  • Business Object Category

Contains the business object category that triggers commission (for example, 810 for Insurance Contract)
  • Business Object ID

Contains the ID of the triggering business object (for example, policy number)
  • Source Broker ID

Contains the business partner number of the source (for example, agent ID associated with the source contract)
  • Source Contract No.

Contains the commission contract number of the source
  • Remuneration Type

Contains the remuneration type, which determines the process and parameters for calculating remuneration
  • Assignment Share

Contains a number that quantifies the share of the assignment of the object to the target; the share number is interpreted as a percentage.
  • Target Broker ID

Contains the business partner number of the target (for example, agent ID associated with the target contract)
  • Target Contract No.

Contains the commission contract number of the target
  • Effective From

Contains the date in the YYYYMMDDHHMMSS format (for example, 20110309000000)
  • Entitlement Transfer

Contains the value X if the free entitlement is to be transferred
  • Liability Transfer

Contains the value X if the remaining liability is to be transferred
  • Transfer Percentage

Contains the share of the entitlement and liability to be transferred
  • Enterprise Commission Contract

Contains the commission contract number of the company to which the remaining entitlements and liabilities are to be assigned
  • Recalculation

Contains the value X if the entitlement is to be recalculated for the receiving contract
  • Remuneration Scheduling (Received)

Specifies how remuneration scheduling is handled with the recipient
  • Remuneration Scheduling (Remaining)

Specifies how remuneration scheduling is handled with the transferring contract
  • Type of Payout

Contains the method for payout
  • Negotiated Payoff Amt

Contains the payoff amount for the compensation of commission entitlements in ELT
  • Discount Interest

Contains the discount interest for calculating the net present value of an entitlement that will be disbursed in the future
  • Liability Basis

Contains the reference base for the transfer percentage rate in a liability transfer
  • Redetermine Liability Type

Specifies whether the liability type should be redetermined after transfer
A standard template of this input Microsoft Excel file is attached to the SAP Note 1599411. To download this template file, you can use this SAP Note.
  • Worklist Definition ID
You must specify the ID of the definition for worklist (for example, 0ELT).
  • Assignment Scenario ID
You can specify the ID of the assignment scenario (for example, 0SC1).
  • RFC Destination for ICM
You can specify the standard name of the remote function call (RFC) destination for ICM. You need to specify a value only if the function call is triggered by a different system.
  • Carry out Assignments
You must select this checkbox if you want to carry out the instructions in an ELT worklist.

Integration

Prerequisites

Features

Selection

Standard Variants

Output

Activities

Example






General Material Data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 8135 Date: 20240531 Time: 173232     sap01-206 ( 75 ms )