SAP ABAP IMG Activity REFXV_TIVCACTSHIFT (Define Translation Date Shift Rule)
Hierarchy
☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_CA_CU (Package) RE: Customizing (IMG) and Area Menu
IMG Activity
ID REFXV_TIVCACTSHIFT Define Translation Date Shift Rule  
Transaction Code S_AER_95000241   (empty) 
Created on 20060515    
Customizing Attributes REFXV_TIVCACTSHIFT   Define Translation Date Shift Rule 
Customizing Activity REFXV_TIVCACTSHIFT   Define Translation Date Shift Rule 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name REFXV_TIVCACTSHIFT    

Use

The translation date shift rule defines how the system determines a translation date on the basis of a starting date that was entered.
You have to define translation date shift rules if the following applies: You use conditions in a foreign currency, and you do not want the system to use a fixed date for the currency translation; instead the date entered should only serve as the starting date for determining the translation date.

Example

You have defined conditions with currency EUR in a company code with local currency USD. The exchange rate from dollars (USD) to euros (EUR) is entered daily in the exchange rate table. You run periodic posting on a monthly basis at the end of each month (with the posting date as the first day of the next month). For periodic posting, you want the system to use the exchange rate that was valid two days before the end of the month, that is on the third to the last day of the previous month.
In that case, you define a translation date shift rule, such as BEG-3. You have to set up this rule so that it initially shifts the entered date to the first of the month, and then moves it three days backward.
You then assign this translation date shift rule to the process REPP - Periodic Posting in the translation date rule. You use the posting date (PSTNGDATE) as the base date for the translation. Set the error response to Error.

Requirements

Standard settings

Activities

  • To create a translation date shift rule, choose New Entries. Enter a name (you assign this later in the currency translation rule) and a description.
  • On the detail screen for the translation date shift rule, specify how the starting date is shifted. You have the following options:
    • Shift in Relation to Period
      You can specify here that the date is shifted to the beginning or end of the week, month, quarter, or year in which the starting date lies.
    • Shift by Days, Months, Years
      You can specify here that the starting date is shifted by n1 days + n2 months + n3 years. If you want the resulting date to be before the starting date (as is common for currency translation), then n1, n2, and n3 must be negative numbers.
    • Shift in Relation to Calendar
      You can specify here that the shift is made in relation to a public holiday calendar. Specify to what number working day the date should be shifted, and enter a calendar that can be used to determine the working days.
  • You can use the No. field to specify the sequence in which the system performs the translation for these three group boxes. Enter a different number in each of the group boxes where you made entries.

Example

  1. For translation date shift rule BEG-3 (two days before month end), which was described above, you make the following settings:
    • Shift in Relation to Period
      No. 1
      Shift To: First Day of Period
      Move By: Month
    • Shift by Days, Months, Years
      No. 2
      Move (+/-) By: Days: -3, Months: 0, Years: 0
    • Shift in Relation to Calendar
      No. 0
      Leave all fields blank.
  2. If you do not want to shift to the third to last calendar day of the previous month, but instead to the third to last working day of the previous month, then make the following entries:
    • Shift in Relation to Period
      No. 1
      Shift To: First Day of Period
      Move By: Month
    • Shift by Days, Months, Years
      No. 2 Move (+/-) By: Days: -1, Months: 0, Years: 0
    • Shift in Relation to Calendar
      No. 3
      Move to nth (+/-):
      Number: -3
      Unit: Working day
      Calendar: <appropriate calendar for your location>
      In contrast to the calculation without considering a public holiday calendar, the date is not shifted by n days, but instead is shifted to the nth day. Therefore the entry number 2 is necessary in this example, in order to first shift to the last day of the previous month.

Business Attributes
ASAP Roadmap ID 204   Establish Functions and Processes 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-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 REFXV_TIVCACTSHIFT 0 ALN0000036 Real Estate Contract 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
V_TIVCACTSHIFT V - View SM30  
History
Last changed by/on SAP  20101217 
SAP Release Created in 700