Add or Remove Depreciation area in existing Assets Master

If we have created/added new Depreciation area and want to add the same in existing assets. 

We had followed three steps

1. Create Depreciation area via OADB.

I have added new depreciation area 50 in chart of depreciation

2. Activate Depreciation area via OAYZ.


3. Automatic opening of new depreciation are via AFBN and program RAFABNEW:-

Now asset no. 40000004 does not have depreciation area 50 in master

Run program RAFABNEW from SE38.

3.1 Indicator: Leave values initial - Set this indicator if you want to open the newly created depreciation area without any values i.e. blank.

3.2 Indicator: Dep terms from asset class - Set this indicator if you want to open the newly created depreciation area copied from asset class maintained in OAYZ.

AS03

By this we have find that the old assets value has been copied with new depreciation area.

Remove Depreciation area from asset master

If depreciation area is mistakenly added in asset master and we want to delete the depreciation area from asset master

there are 2 function modules, but please pay attention this are not from SAP supported standard tools. They delete areas without warning and the deletion is irreversible.

o To delete the area from standard tools: function module AA_AFABER_DELETE

o To delete area from asset   AA_AFABER_DELETE_FROM_ASSETS. 

Now we will delete the depreciation area 50 from asset master for testing purpose

Use function module AA_AFABER_DELETE from SE37

Give Chant of Depreciation & Depreciation area to be deleted.

AS03

Depreciation area 50 deleted from asset master.

Restrict the authorization to specific User base on Doc. Type

Requirement is to restrict user from posting with particular document type through authorization control.

Define custom authorization group for authorization object F_BKPF_BLA in table TBRG from SM30.


Assign Authorization object in OBA7 to each document.



Provide authorization to user as per requirement by giving authorization for particular authorization object. In below screen shot we have given authorization to user for authorization group ZDOC which mean user is not authorized to post the transaction with document type JV (Authorization object YDOC is assigned to JV doc type).


Now when user trying to post the transaction with document type JV he will face authorization issue.

Alternative Reconciliation Account for Customer Ledger Postings

Scenario
In customer master, I have maintained one reconciliation account (Sundry Debtors). Now requirement is to book the revenue in customer ledger base on product.

Customizing
1) Maintain Condition Tables
In order to fulfill this requirement, here I used combination of Sales Org/Acct assignment grp in condition tables. 

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Condition Tables

Condition Table

2) Maintain Field Catalog
Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Field Catalog

Field Catalog

3) Maintain Access Sequences

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Access Sequences

4) Maintain Condition Types

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Condition Types

Condition type used

5) Maintain Account Determination Procedure

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Maintain Account Determination Procedure

Maintain account determination procedure

6) Assign Account Determination Procedure

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Assign Account Determination Procedure

Assign account determination procedure

7) Assign G/L Accounts

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Assign G/L Accounts



Assign G/L account

8) Define Alternative Reconciliation Accounts

Path: IMG > Sales and Distribution > Basic Functions > Account Assignment/Costing > Reconciliation Account Determination > Define Alternative Reconciliation Accounts

Alternative recon account used

Testing
First, check the reconciliation account from 14000010 to 14000030.

In customer master (Company Code Data), for customer 800001, Reconciliation account default used is 14000010 (Sundry Debtors).

Default recon. Account for customer 800001 is 14000010

Material Master

Account assignment group is maintained as per requirement in material master.

VF01
Before posting account document, we can make sure if reconciliation used is correct by go to Environment > Acc.determ.analysis > Reconciliation accounts.

Check if alternative recon account worked in billing document.

Accounts assignment group is different in both the items in billing document.

Accounting Document after Posted Billing

Finally, System used alternative recon account based on account assignment group, the G/L account for reconciliation account used in this transaction is 14000020 & 14000030, since account assignment group used in material master is 01 & 02.