SAP ABAP IMG Activity SIMG_CFMENUOFDINKA (Service Charge Settlement)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate
IMG Activity
ID SIMG_CFMENUOFDINKA Service Charge Settlement  
Transaction Code S_ALR_87007758   IMG Activity: SIMG_CFMENUOFDINKA 
Created on 19981222    
Customizing Attributes SIMG_CFMENUOFDINKA   Service Charge Settlement 
Customizing Activity    
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name SIMG_CFMENUOFDINKA    

In the service charge settlement the system automatically:

  1. Posts the credit entry for the settlement unit

    The account number for the credit entry posting is derived from the account number of the account to which the costs were originally posted.

  2. Posts the debit position for service charges

    The reference flow type, " receivables from settlement", derived from the reference flow type that is used for posting advance payments, is used for postings to customer accounts. When a final settlement is posted, the debit position flow type is based on the service charge key that is to be settled.

  3. Transfers the advance payments
  4. Exceptions:
    1. Tenant service charge settlement (Austria). See Tenant service charge settlement IMG activity documentation for additional information
    2. Rounding differences (Switzerland)

Example:

One object has two rental units, RU1 and RU2. You want to post a settlement for the year 1999. The rental units were leased out as follows:

  • RU1
    Rental period:     1/1/99 - 3/31/99 with RA 1.1 to tenant 1.1
    Vacancy:     4/1/99 - 4/31/99
    Rental period:     As of 5/1/99 with RA 1.2 to tenant 1.2
  • RU2:
    Rental agreement for entire period (1/1/99 - 12/31/99) with RA 2 to tenant 2

Conditions:

  • RA 1.1 Advance payments of $100 per month
  • RA 1.2 Flat rate payments of $100 per month
  • RA 2 Final settlement, no advance payments

For the entire period (1/1/99 - 12/31/99), service charges amounted to $3000 and were posted to account 470400:

40 account 470400 with auxiliary account assignment to settlement unit

-to-

31 vendor

The apportionment units determine the breakdown of service charge costs and (if applicable) vacancy costs between tenants:

  • $ 500 tenant 1.1
  • $ 700 tenant 1.2
  • $ 600 tenant 2
  • $ 200 for the vacancy of RU1

Credit entry for the settlement unit

Breakdown accounts are specified:

IMG -> Service charge settlement -> Keys and rules for settlement -> Account determination, posting key, document types -> Accounts, posting key for breakdown and revenue postings

The following accounts are determined for account 470400:

SAP account name         Number    Description

Credit account SC         470499    Credit exp. operating costs

Clearing account RA         470500    Settl.RA

Clear.acct RA w/o furth. clear    470500    Settl. RA w/o furth. clear

Clearing account RU         470520    Settl.RU

Clear.acct non-ded. input tax    470950    Settl. n.d inpt tx

Credit non-ded.input tax         470999    Credit n.d inpt tx

When you start to post the service charge settlement, you have to specify a document type. The service charge settlement contains the following posting items:

PK            Account (auxiliary account assignment)                Amount    

50    470499 (credit account) (settlement unit) $3000

40    470500 clearing account (RA 1.1) $500

40    470500 clearing account (RA 2) $600

40    470500 clearing accnt RA w/o furth. clear (RA 1.2)                                                                                                 $700(flat rate)

40    470520 clearing acnt RU (RU1) $200(vacancy)

   

Master Settlement Unit

When a master settlement unit is to be settled, there are two steps:

  • Costs are settled to the other settlement units according to the master settlement distribution key
  • After costs have been settled to these settlement units, costs are passed on to the rental agreements and rental units as described above. Three accounts are needed for settlement to the master settlement unit:

  • One account to which the credit for the master settlement is posted
  • One account to which the debit for the (actual) settlement units is posted
  • One account to which costs are posted that cannot be passed on to the tenant.

Example: One janitor is responsible for two business entities. The costs of the janitor should be distributed as follows:

30% to the settlement unit belonging to business entity 1

50% to the settlement unit belonging to business entity 2

20% are non-apportionable costs (such as plant maintenance tasks) that are posted to a cost center

These distribution rules are defined in the master settlement unit.

The system uses the cost element 470400 apportionable operating costs to post the total costs of $ 1000 to the master settlement unit.

Make sure that these settings have been made in Customizing:

Text    Account     Account Name

Cost element credit master SU    470499    Credit apportionable operating costs

Cost element recipient of MSU*    470400    Apportionable operating costs (o.c)

Cost element resid. costs MSU    470498    Credit residual o.c of master SU

*MSU=master settlement unit

With these settings in Customizing, the system makes the following postings to the credit side of the master settlement unit:

PK    Account (subsidiary account)                        Amount

50    470499 Credit apportionable operating costs (MSU)            $1000

40    470400 Apportionable operating costs (SU for BE1)                        $300

40    470400 Apportionable operating costs (SU for BE2)            $500

40    470498 Credit residual operating costs MSU (cost center)$200

Posting: Tenant account debit position

The system posts the tenant share of the costs to the tenant customer accounts. This does not apply to tenants who pay flat rates.

The posting record to be used is determined as follows:

A flow type is assigned to the condition type "advance payment" that is included on the rental agreement. The reference flow type 'receivable from settlement' (relationship key 004) is determined for this flow type and the account determination rule that has been defined for this flow type is used.

Example:

Flow type 2001 is assigned to condition type "advance payment operating costs". In the dialog box "Assign reference flow types" the reference flow type 2005 is in the relationship key 004 ('receivable from settlement') and it is assigned to the following account determination rule:

Flow type 2005    Corp.group ID +        Main usage type +    AccDetVal +

Debit         01*        Reconcil. account

Credit         50 205        Revenue from o.c. settlement

Document type     DR

Account symbols:

*     Reconcil. account for customer master record

205     841500 Revenue from OC settlement

Text    Account

Net rev. account    841500 Revenue from operating costs settlement
RevAcctNDInpTax    841900 Revenue from non-deductible input tax operating costs

In this example the system makes these postings to tenant 1.1:

01 Customer tenant 1.1. for rental agreement 1.1.            $ 500

50 841500 revenue settlement subsidiary account RA 1.1.    $ 500

If a final settlement has been fixed in the contract, a flow type is derived from the settlement service charge key.

IMG -> Service charge settlement -> Keys and rules for settlement -> Final settlement: Assign service charge key/flow type

This flow type determines the reference flow type and the reference flow type determines the acccount.

Posting: Transferring advance payments to tenant accounts

The tenant advance payments are offset against any outstanding receivables in the settlement so you have to know in advance what advance payments

Business Attributes
ASAP Roadmap ID 105   Define functions and processes 
Mandatory / Optional 1   Mandatory activity 
Critical / Non-Critical 1   Critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG SIMG_CFMENUOFDINKA 0 I090004628 Service Charge Settlement 
Maintenance Objects
Maintenance object type    
History
Last changed by/on SAP  19981222 
SAP Release Created in