Show TOC

Object documentationNet Calculation Document

 

This document is generated during the net calculation (see Net Calculation). It combines gross payment items and deduction items in which the following payment parameters are identical:

  • Payment recipient

  • Payment family

  • Payment frequency type

  • Due date rule

  • Due date

This bundling is not associated with a specific social service plan (SSP).

Note Note

The result of a net calculation document can be positive or negative, for example in the case of overpayments.

End of the note.

If you want to use this function, you must activate the business function Social Services - Benefit Calculation (CRM_IPS_4S_1) and the business function Social Services - Benefit Calculation and Payment (ERP_IPS_4S_1).

Structure

A net calculation document (NCD) is structured as follows:

Header data

The net calculation generates a header data record that is used as the input value for the mass billing run for each due date in a payment frequency. The following overview lists the central fields required for processing (field names are shown in brackets):

  • Payment Recipient Number PAYM_RECIPI_NO

  • Payment Family (PAYMENT_FAMILY)

  • Payment Frequency Type (PMNT_FRQ_TYPE)

    This defines whether payments are made with reference to a day, month or week.

  • Due Date Rule Type (DDR_TYPE)

    This defines when the payment is to be made with reference to the payment frequency type (for example at the start or end of a month).

  • Due Date (DUE_DATE)

    The net calculation determines this date, which is subsequently used by the mass run for billing.

  • Start Date of Payment Period (BEGDA)

  • End Date of Payment Period (ENDDA)

  • NCD Status (NET_HDR_STATUS)

    For more information, see Status Change.

  • Billing Document Number (BILLDOCNO)

  • Reversal Document Number for Billing (REVERSALDOC)

  • NCD Currency (Header) (CURRENCY_HDR)

  • Gross Amount for a Payment Frequency Period (GROSS_AMOUNT)

  • Net Amount for a Payment Frequency Period (NET_AMOUNT)

  • Additional customer-specific fields

The system uses the following fields during the net calculation to process rule-based deductions. They provide information about whether over and underpayments are also included.

  • Gross Amount Regular Payment per Payment Frequency Period (REG_GR_AMNT)

  • Gross Amount for Underpayment per Payment Frequency Period (UNDER_GR_AMNT)

  • Gross Amount for Overpayment per Payment Frequency Period (OVER_GR_AMNT)

Item Data

The following overview lists the central fields required for processing (field names are shown in brackets):

  • Item Number (POSNR)

    External key that the system uses to assign a logical sequence to an item.

  • Gross Payment or Deduction Plan Item (SXP_KIND)

  • Amount (AMOUNT)

  • Currency (CURRENCY)

  • Benefit ID (BENEFIT_ID)

    This represents the product and is relevant for subsequent billing.

  • Benefit ID (external display) BENEFIT_ID_EXT)

  • Item Process Category (PROCESS_CATEGORY)

    This makes a distinction between a periodic regular payment and an additional payment (required due to an underpayment).

  • Item Type in SAP CRM (ITM_TYPE)

    This is only relevant for deductions.

  • Deduction Type (DEDUCTION_TYPE)

    This defines whether you can enter the deduction using the CRM user interface (decision-based) or whether you need to implement a Business Add-In (BAdI) in the SAP ERP System.

  • Deduction Percentage Rate (DEDUCT_PERCENT)

  • Gross Amount (BASE_AMOUNT)

  • Remaining Amount for Deductions (REMAINING_AMOUNT)

  • Partial Deduction (DEDUCT_PARTIAL)

    The partial deduction is only performed for a rule-based deduction.

  • Priority for Items with the Same Deduction Type (DEDUCT_PRIORITY)

    Deduction Type Ranking (DEDUCT_TYPE_RANK)

  • Deduction Only Partially Applied to Net Calculation Item (NET_PART_DEDUCT))

  • Process Category for Deduction Plan Item (DEDUCT_PROC_CAT)

    This makes a distinction between Third-Party Deduction, Allocated Deduction, and Withholding Deduction.

  • Deduct-to Party (DEDUCT_TO_PARTY)

    GUID for the business partner that is used by the system to identify an FI-CA account for the subsequent posting.

  • Start Date of Original Payment Frequency Period (DUE_PER_BEG_ORIG)

    The start date is used to perform an example tax calculation for under and overpayments.

  • End Date of Original Payment Frequency Period (DUE_PER_END_ORIG)

    The end date is used to perform an example tax calculation for under and overpayments.

  • Amount per Entitlement Period (ENTITLEM_AMT)

  • Number of Entitlement Periods for a Payment Period (ENTITLEM_PERIODS)

  • Start Date of Entitlement Period for Payment Period (ENTITLEM_BEGDA)

  • End Date of Entitlement Period for Payment Period (ENTITLEM_ENDDA)

  • Reference to Net Calculated GPD VersionID (GPI_VERSIONID)

  • Reference to Net Calculated GPD Item (GPI_ITEMID)

  • Tax Category (TAX_CATEGORY)

    The tax category is used in the Business Add-In BAdI: Rule-Based Deduction Determination.

  • Additional customer-specific fields

Example

The result of the net calculation could be as follows in a simple example:

Header Data:

Payment Period: 01.02. to 28.02.

Item Data

  • Amount: $1600

    The net calculation determines the amount from the data for the gross payment items:

  • Payment period: Month: February

  • Entitlement period: Week

    The payment period contains four entitlement periods of $400. The net calculation creates a net calculation item with the following information for the payment period: <ABCD> 30%, $480.

    The system displays the key for the rule-based deduction type (in this case income tax), the percentage value and the absolute amount in the item. The system generates a corresponding net deduction item that is used in the FI-CA component for clearing.