Ansicht
Dokumentation

_ISUBIBDRS_000070 - Calculation for Move-In/Out

_ISUBIBDRS_000070 - Calculation for Move-In/Out

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Use the procedures described below to avoid incorrect billing during month-based calculation with a key date for move-in or move-out and to calculate time portions using exact days for move-in and move-out.

To The Day Calculation of Time Portions for Move-In

Move-in Processing Procedure 03 (To the day, new)

Examples 1 and 2 are based on key date = 15th

Example 1: Move-in on first of the month

The time portions for the time slices within the move-in month are calculated to the day.

If move-in occurs at the start of the month, the time portions calculated to the day are based on the number of days in the move-in month.

    1. Billing       2nd Billing
   !-------------!---------------------!
   !-------------!-----------!---------!
01/01          12/01        01/02      17/02

The time portion is calculated for the first billing as follows:

               12 days
Time portion  =  --------- =  0.387097 M
               31 days

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.387
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  12
TCDENOMOR  (denominator of time portion)  =  31
TIMTYPQUOT (time category of quotient)  =  2 (day)

For the second billing procedure, the move-in month is first of all separated from the other time slice.

The time portions are as follows:

  • 1. 1st time slice (01/13 01/31)

               19 days
Time portion  =  --------- =  0.612903 M
               31 days

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.612903
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  19
TCDENOMOR  (denominator of time portion)  =  31
TIMTYPQUOT (time category of quotient)  =  2 (day)

  • 2. Time slice (02/01 02/17)
Time portion for whole months with key date without move-out/in month(February) = 1.000 month
The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  1.0000
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  blank
TCDENOMOR  (denominator of time portion)  =  blank
TIMTYPQUOT (time category of quotient)  =  blank

Example 2: Move-in not on first of the month

If move-in does not occur on the first of the month, the time portions are based on the standard year (365 days).

   1. Billing       2nd billing
  !-------------!----------------------!
  !-------------!------------!---------!
03/01          12/01        01/02      17/02

The time portion is calculated for the first billing as follows:

                10 days x 12 (months)
Time portion  =  -------------------------  =  0.328767 M
                365 days (standard year)

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.328767
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  10
TCDENOMOR  (denominator of time portion)  =  365
TIMTYPQUOT (time category of quotient)  =  2 (day)

For the second billing procedure, the move-in month is first of all separated from the other time slice.

The time portions are as follows:

  • 1. 1st time slice (01/13 01/31)

                19 days x 12 (months)
Time portion  =  -------------------------  =  0.624657 M
                365 days (standard year)

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.624657
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  19
TCDENOMOR  (denominator of time portion)  =  31
TIMTYPQUOT (time category of quotient)  =  2 (day)

  • 2. Time slice (02/01 02/17) as in the example

Move-in Processing Procedure 04 (month-related if move-in on first; otherwise to the day new)

  • If the move-in occurs on the first of the month, the time slices are calculated on a monthly basis.
  • If move-in does not occur on the first of the month, the time portions are calculated to the day (see move-in procedure 03).

Note:

Pay special attention to the following during monthly billing with period-end billing/DPC over the entire period:

The billing period does not contain a key date

If move-in occurs on the first of the month and the key date is not contained in the first billing, the billing is executed with a time portion = 0 months. For proration in period-end billing, time slices with time portion <> 0 months can exist.

0.1 M                     2.9 M                          TP Bill.
!--!----------------------------------------------------!PE Bill.

   0 M         1 M                 1 M         1 M       TP Per.Bill
!------!---------------!-----------------!--------------!Per.Bill
!--x*----!-------!-------!-------!-------!-------!------!
01/01      KD     02/01      KD     03/01     KD      04/01  04/14

* = Proration date

To The Day Calculation of Time Portions for Move-Out

Move-Out Processing Procedure 03 (To the Day, New, Special Reversal)

If the key date from the move-out month was already included in the previous billing, the whole month has already been billed. During final billing a(n) (adjustment) reversal is executed for this billing to ensure that the time portions for the move-out month are calculated correctly.

If the to-date of the last periodic billing is in the move-out month, the first day of the move-out month is used as the from-date for the time portion calculation.

  • If the move-out does not occur on the last day of the month, the to the day time portions are based on the standard year (365 days)
  • If move-out does occur on the last day of the month, the to the day time portions are based on the number of days in the move-out month.

Note:

The (adjustment) reversal is only executed in the event of actual billing. If billing is being simulated, it is terminated, if necessary.

You can find further information on the reversal of move-outs here.

Example 1

   Prev. periodic billing       Period-end billing period
  !----------------------------!--------------------------!
  !--------!-------------------!--------------------------!
03/18    04/01                 04/17                       04/26
                                                              Move-Out

In periodic billing, the April is already completely billed. This periodic billing is reversed (for adjustment). This results in a period-end billing period from 03/18 to 04/26.

                         Period End Billing Period
  !-------------------------------------------------------!
  !--------!-------------------!--------------------------!
03/18     04/01                04/17                       04/26
                                                         Move-Out

The move-out month is split. The time portions of the resulting time slices are as follows:

  • 1. Time slice (03/18 03/31)
Time portion for the full month with key date without move-out/in month = 0.000 month
The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.0000
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  blank
TCDENOMOR  (denominator of time portion)  =  blank
TIMTYPQUOT (time category of quotient)  =  blank

  • 2. Time slice (04/01 04/26)

                 26 days x 12 (months)
Time portion  =  -------------------------  =  0.854795 M
                365 days (standard year)

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.854795
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  26
TCDENOMOR  (denominator of time portion)  =  365
TIMTYPQUOT (time category of quotient)  =  2 (day)

Example 2: Move-out on last of the month

Prev.Periodic Billing     Period-End Billing Period
---------------------!-----------x*-------------------!
  !--------!---------!-----------!--------------------!
03/18     04/01      04/05    04/12                        04/30
                                                          Move-Out

* = Proration date

The to-date of previous periodic billing is in the move-out month but comes before the key date. This means that the move-out month has not yet been billed.

The time portions of the resulting time slices are calculated as follows:

  • 1. Time slice (04/05 11/04)

                11 days
Time portion  =  ---------- =  0.366667 M
                31 days

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.366667
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  11
TCDENOMOR  (denominator of time portion)  =  30
TIMTYPQUOT (time category of quotient)  =  2 (day)

Note:
The from date of the first time slice is 04/05

  • 2. 2nd time slice (04/12 -04/30)

               19 days
Time portion  =  --------- =  0.633333 M
               31 days

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.633333
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  19
TCDENOMOR  (denominator of time portion)  =  30
TIMTYPQUOT (time category of quotient)  =  2 (day)

Example 3: Move-out not on last of the month

Prev. Periodic Bill        Period End Billing Period
---------------------!----------X------------------------!
  !--------!---------!----------!------------------------!
03/18     04/01      04/05    04/12                        04/23
                                                          Move-Out

The to-date of previous periodic billing is in the move-out month but comes before the key date. This means that the move-out month has notyet been billed.

The time portions of the resulting time slices are calculated as follows:

  • 1. Time slice (04/05 11/04)

                11 days x 12 (months)
Time portion  =  -------------------------  =  0.361644 M
                365 days (standard year)

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.361644
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  11
TCDENOMOR  (denominator of time portion)  =  365
TIMTYPQUOT (time category of quotient)  =  2 (day)

Note:
The from date of the first time slice is 04/05

  • 2. 2nd time slice (04/12 -04/23)

                 12 days x 12 (months)
Time portion  =  -------------------------  =  0.394521 M
                365 days (standard year)

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.394521
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  12
TCDENOMOR  (denominator of time portion)  =  365
TIMTYPQUOT (time category of quotient)  =  2 (day)

Move-out processing procedure 04 (to the day, new, time portion = 0, for move-out on the last of the month)

If the move-out occurs on the last of the month, and the move-out month has already been billed, the time portions =0

Example:

   Prev. periodic billing       Period-end billing period
  !----------------------------!--------------------------!
  !--------!-------------------!--------------------------!
03/18     04/01                04/17                       04/30
                                                         Move-Out

The key date of the move-out month lies within the previous billing period. Since the move-out occurred on the last day of the month, the time portion = 0.

The following fields in the billing line items contain data:

ZEITANT    (time portion)              =  0.0000
TIMTYPZA   (time category for time portion) =  1 (month)
TCNUMTOR   (numerator of time portion)  =  blank
TCDENOMOR  (denominator of time portion)  =  blank
TIMTYPQUOT (time category of quotient)  =  blank

Note:

Billing-relevant changes are not included in this period!

All other situations are treated as described in the move-out processing procedure 03.

You can find further information on the reversal of move-outs here






General Material Data   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 24252 Date: 20240523 Time: 165809     sap01-206 ( 118 ms )