SAP REFX: Mass Deletion of Rental Objects

We can delete rental objects in RE80 by selecting them either using Shift or control key to select them and using the delete option, Provided contracts are not created on them. If in case contracts are created on those objects, need to terminate the contracts and delete them as above.

 

You can see two text boxes in the left pane of RE80 Transcation, In the first box enter "My Objects" Second text box enter "User ID of the Creator". Then system shows list of all rental objects, from which you can select and delete as explained above. These two boxes are visible only if you are using latest GUI.

Note: In the customization of RE-FX. SPRO-> Tools->Archiving->Deletion of Real estate objects without Archiving check box should be flagged to delete objects

SAP REFX: Change of Business Partner in case of already activated Contract

Note 926520 - Consulting note: Contract partner change explains very clearly about the affects and necessary things to do in this kind of scenario.

 

Changing the main contractual partner

Changing another partner (vendor or customer)

Affects on the Cash Flow in case of change of business partner

Partner change with legal succession in an already posted period

Backdated partner change due to incorrect contract partner assignment

Backdated partner change for one-time conditions

Subsequent change of the due date
 

 

 

SAP RE-FX Tables Plan Data

TCODE: RECOPLCST02 used for entering the plan data for Contract, Building and Business Entity level in RE-FX module.

Which tables are filled with the plan data related to RE objects?
 

There are no special tables available for the plan data related to RE Objects. You can get the plan data in the TABLE: COSS

 

For Business entities the Object number starts with the "IW".

COSS-OBJNR = IWXXXX99999999

First two letters 'IW'

Next four letters 'XXXX' is your company code

Next balance '99999999' is your business entity
 

SAP REFX: Link between the Asset Master and RE-FX

Asset assignment is only informational and is available for evaluations in RE reporting.

Assets can be assigned to business entities, buildings, properties and rental objects.

When you create an asset from the RE master data dialog, the following data is automatically transferred:

1. Company code
2. Text for Real Estate object

You can transfer additional data using a dialog box or by directly going to the master data dialog.

In Asset Accounting, Real Estate objects can be used as account assignment objects for depreciation. To do this, enter the corresponding Real Estate object under the time-dependent data in the asset master record. This field is not automatically filled when the asset is created from the RE master data maintenance.

If you want to use the Real Estate object as a depreciation account assignment, proceed as follows:

Release the Real Estate object from the RE master data dialog for account assignment and choose Save.

Manually maintain the Real Estate account assignment in the time-dependent data of the asset master record. Various input helps (F4) are available for the assignment, including one that analyzes the assignments for Real Estate objects. Note that only the values of Real Estate objects released for assignment are returned.

The use of the Real Estate object as an account assignment for depreciation is only possible if the corresponding settings are made in Customizing of Asset Accounting:

--> Master Data screen layout: Under "time-dependent data"

--> Integration with the general ledger :

 1. Field status variant of asset G/L accounts
 2. Additional account assignment objects
     ---- Activate account assignment objects: IMKEY active
     ---- Define account assignment types for account assignment objects and make the relevant settings for IMKEY.
     ---- Business entities, buildings, properties and rental objects are possible as account assignment objects.

SAP REFX: Rounding off Condition type value

How to get the value of the condition type and service tax conditions to be rounded off without any decimals?

 

This can be achieved with the available configuration. details are as below :

 

Path : IMG > Flexible Real Estate Management (Enterprise Extension) > Conditions and Flows > Calculation and Distribution Formulas > Calculation Formulas

 

While define the formulas, you can select the "Rounding Category" in the "Unit Price" Section of the screen.

 

 

Help Note:

Rounding Category of Unit Price or Condition Amount

Defines how the unit price or condition amount is rounded.

1. No rounding

The unit price or condition amount is not rounded.

2. Currency rounding

The unit price or condition amount is rounded according to the definition of the condition currency.

3. Round down

The unit price or condition amount is rounded down. For this option, you also have to enter the number of decimal places or the rounding unit.

4. Round up

The unit price or condition amount is rounded up. For this option, you also have to enter the number of decimal places or the rounding unit.

5. 5/4 rounding

The unit price or condition amount is rounded up if the decimal place used for rounding is 5 or more, and down if it is 4 or less. For this option, you also have to enter the number of decimal places or the rounding unit.

How to activate SAP REFX - Flexible Real Estate Management

SAP currently offers two versions of SAP Real Estate Management. The older version "Classic Real Estate" is referred to as "old solution", and the new version "Flexible Real Estate" is referred to as the "new solution".

Classic Real Estate is available in Releases SAP R/3 and SAP ECC up to SAP ERP 6.0. Flexible Real Estate is available as of R/3 Enterprise Financials Extension Set 2.00.

 

To use the new solution, you first need to activate the Financials Extension Set (EA-FIN) for all clients and then activate the Real Estate Extension for each individual client.

Note that the old solution can then no longer be used. In order to be able to keep using the old solution in a certain client, do not activate the Real Estate Extension there.

Since each client must be activated, you cannot use Classic and Flexible Real Estate on the same client. Both solutions can only exist together if they are on separate clients.

 

Next steps after activating the REFX...can found in OSS Note: 443311

 

For new customers of SAP Real Estate Management, Classic Real Estate is no longer released for the first implementation as of the time of the general availability of SAP ERP 6.0 (as of 2006).

 

REFX: Possible Scenarios in Real Estate Management

Post total amount in Advance

 

Situation: I have a situation where user wants to create a real estate contract (RE-FX) for 15 months, and want to charge per month 10,000\-USD. Here the posting should happen for the whole amount 150000\- USD in Advance on the date of creation of contract. I can see frequency option in RECN transaction, where it is allowing me to enter monthly, daily or yearly but not only once in advance. How to post the total amount?

 

Solution: Try out the following input for frequency term:

 

Frequency 15 months

Amount Reference monthly amount payment form in advance. 

**************************************************************************************************

How do we restrict the Rental Object Measurement  

 

Situation: Problem with RE_FX Master data creation.

 

Situation: we have defined 100 sqm as a land. Further we have created 4 rental objects of 25Sqm under Land. Now the measurement is equal 

 

Land (100SQM) = 4 rental objects of 25SQM each.

 

Suppose If I am trying to create one more rental object with 30 SQM still it is accepting.

 

So how do we restrict the size of the Land?

 

Solution:

 

Use the BAdI of the rental units.

 

Like BADI_RE_BD_RO

 

Create a new implementation

Use method check_all

Use the API: API_RE_RO_GET_LIST

Read existing RO and compute the existing rental objects in this case 4 times 25sqm. If there comes the 5 RO or more than 100sqm sent hint / message error over the BAdI.

**************************************************************************************************

Delete master data (Building, BU and property) 

 

Situation: We have to delete master data of our QUA system (Building, BU and Property). Is there any way to delete data directly?

 

Solution: You can delete Master data. Please follow the steps:

 

1. Go to SPRO (for Flexible Real Estate)

2. Under Tools go to deletion of Real Estate object without archiving.

3. Select Object, which you want to delete

4. Go to TCODE: REBDBU and enter company, Business entity, Building number and DON'T PRESS ENTER

5. Go to menu bar " Building" and select delete

 

Same for Property, if you want to do mass delete, try BDC.

 

**************************************************************************************************

No Conditions were assigned for Contract 

 

Situation: In ECC6.0, while creating a Commercial Lease-In contract under condition tab when I select add new condition system displaying No conditions were assigned. And I did basic configuration settings to assign condition type for Commercial lease-In contract.

 

I defined condition type and defined condition purpose.

 

I defined condition groups and assigned condition type.

 

I assigned condition group to contract per contract type also.

 

Still I am unable to see conditions in conditions tab.

 

 

Solution: It's authorization restriction problem, so get authorization your problem will solve.

 

Authorization object: F_RECD_CN

 

 

**************************************************************************************************

Function Module for Dollar Amount  

 

Situation: We have a requirement where a REFX contract once created has to go through a series of approvals. How do I get the dollar amount on the contract so that it can be routed to the proper level for approval? Is there a function module for this?

 

Solution: For the condition (amount) on contract you can get using.

 

BAPI_RE_CN_GET_DETAIL or

API_RE_CN_GET_DETAIL

 

And if you doing currency conversion there are lot of FM.

FAQ' - Real Estate Management

Mass Account Assignment approval in FX RE -Mass release of RE Object 

Using TCODE: RE80

Display in the navigation area the list of objects you want to delete/activate/release etc. And then select them; you can select them with Shift+ down arrow, or first line, shoft, last line, etc.

Once you have selected the objects you want to process, right click and select the function you want.

**************************************************************************************************

Different conditions can be processed separately

In my REFX contract, I have multiple conditions attached to the sales rule.

For example: Condition for sales based rent, Condition for fixed amount etc.

Please suggest whether each of these conditions can be processed separately while generating invoice.

Yes, Each condition can be processed separately. But in Invoice we can see all the conditions, which are there in the said contract. More over we can select the conditions based on the tenure also. Suppose electricity for quarterly, basic rent for monthly.

**************************************************************************************************

Field status as mandatory while creation of RE-FX Lease Out Contract

This can be achieved by Implement Enhancements (BAdI) in SPRO in REFX contracts section.

RECACUST > Contract > Dialog > Screen Layout > Field Groups > Field Status per Contract Type

**************************************************************************************************

Rental Unit: Posting Parameters   - where field "Order" is stored

In the rental unit posting parameters tab, I'm having trouble finding the system table where field "Order" is stored when the rental unit is saved.

Can somebody help me please?

You can find the info that you are looking in table VITMPY (Term: Posting Rule).

**************************************************************************************************

Land Acquisition and Management

What are all the processes will carry out in the Land Acquisition?

Land acquisition may involve purchase of land (Logistics, Financials), keeping track of land related costs (Project Systems, Controlling). When it is already an Asset, it can be an object in Real Estate subject to the many management processes.

**************************************************************************************************

RE Settlement Rule Table  

We maintain settlement rule in Property - CO Settlement Rule. We require uploading settlement rule by creating a program. Can anyone tell me what is the table for RE settlement rule store?

Get the Object number from VIBDPR Table.

Go to COBRB Table and give above object number in Object number field.

Basically you will be getting CO Settlement rule from COBRB Table

We are using SAP 4.7. I cannot find table VIBDPR as you mentioned. Is it any other table store the object number?

Then it is VIOB02 for 4.7 Version for property and COBRB for CO Settlement Rule.

**************************************************************************************************

Change object" is not allowed "   - RE

For Multiple Release of Contract, transaction RECN, while going in change mode I am getting the error for "RE: Change object" is not allowed ". Please suggest.

Check the object whether its already in REL status

**************************************************************************************************

How to check activated Lease Out?

How to check date or when the Lease Out is activated?

Example: when or what date is the Lease Out has been activated via FOG9 (RE classic).

You can check the change documents of the contract when the field "Active from" had been changed.

Accounting, Posting, Entries & Account Determination in Real Estate-FX:

Accounting:

Accounting transactions in REFX can be one of these –

- - RE Developer paying rent as part of a Lease IN contract
- - RE Developer paying service charges as part of a Lease IN contract
- - RE Developer receiving periodic rent payments as part of a Lease OUT contract
- - RE Developer receiving service charges as part of a Lease OUT contract
- - RE Developer incurring internal charges if they themselves are occupying commrcl. space
- - Commercial space is vacant. This is cost to RE Developer and has to be accounted for.

Periodic Postings:

- - Periodic posting can be run for any contract type
- - Can be simulated or reversed
- - When run, creates open items which are cleared by I/G O/G cash flows
- - Posting run
     --looks at active contracts and the planned cash flow for each item
     --Determines account determination for each flow type
     --Makes a debit or credit posting in FI Cash flow marked as Posted
- - Condition purpose determines if this posting is actual or statistical. If statistical, no posting in cash flow

Journal Entries:

Commercial Lease OUT –

Credit the contract (revenue)
Debit customer (receivables)

Internal Lease OUT –

Credit the contract (revenue)
Debit Cost center (expense)

Commercial Lease IN –

Debit the contract (expense)
Credit vendor (payables)

Account determination:

- - Every contract has at least one condition
- - Each condition has a condition type
- - Each condition type has a flow type
- - Each flow type has a account schema
     --Account symbol configured in REFX
     --G/L account configured in FI