- Assignment
Client:
- Highest level in hierarchy
- Specifications apply to all company codes under it
Company code:
- Independent unit
- Legal B/S, P/L for company code
Business Area:
- Separate financial unit
- Can prepare separate B/S & P/L
Chart of Depreciation:
- Country Specific
- SAP Provides model COD
- COD contains depreciation area
- Each depreciation area represents Book depreciation, Tax depreciation etc
- One COA and COD can be assigned to one / more company codes
- Depreciation area defined by two digit numeric code
Assignment:
- Assign COD to company code
- Cost Accounting Assignment
- Exercises
Create a Chart of Depreciation
Change Description of Chart of Depreciation
- Tcode: SPRO – FA – AA – Org. Structure – Copy Reference COD – Specify description of COD
Delete depreciation Areas not required
- Tcode: SPRO – FA – AA – Org. Structure – Copy Reference COD – Copy / Delete Depreciation Areas
Assign COD to Company code
- Tcode: SPRO – FA – AA – Org. structures – Assign COD to Company code
- Tcode: OAOB
Activate account assignment object
- Tcode: SPRO – FA – AA – Integration with GL – Additional a/c assignment object – Activate a/c assignment object
- Asset Classes
Asset Classes:
- Fixed asset classified into Asset classes. E.g.: Furniture, Vehicles
- Asset Class created a client level
- Asset class can be assigned to 1 / more COD
- Can suppress individual depreciation areas (01, 02) in chart of depreciation in each Asset class if required (Tcode: ….)
- Each asset can be assigned to only one Asset Class
- Special Asset Classes: AuC, Low value Asset
- Depreciation Areas:
Chart of Depreciation:
- Country Specific catalog of Depreciation Areas
- Copy COD supplied by SAP
- Delete Depreciation Areas not required
- Now assign this COD to the company code
- COD defined at client level
- Various company codes can be assigned at to the COD
- Depreciation Areas post to GL accounts in any of the following options:
Particulars | Depreciation Area |
Post asset values (APC) : Online
Depreciation : Periodically | 01 |
Post Asset value (APC) : Periodically
Depreciation : Periodically | |
Do Not Post any values | Reporting purpose only |
Only Post Depreciation : Periodically | |
- Depreciation always posted on periodic basis
- Exercises:
0 | Area does not post |
1 | Area post in Real Time |
2 | Area Post APC & Depreciation on Periodic basis |
Master Data
- Functions of Asset Class
Screen layout
- Determine fields Displayed/ Optional/ Required in AMR
- Tcode: FA – AA – MD – Screen layout – Define screen layout for Asset Master Data
- Here decide what fields are Required / Optional / Suppressed / Displayed only in AMR
- Copy Check Box: If this indicator is set, if this asset is used as a reference to create another asset it's values copied to the other asset
- Screen layout rule assigned to Asset Class in OAOA
- Screen layout rule assigned to Depreciation areas in OAYZ
Asset Class:
- Tcode: OAOA
- Assign Account Determination : Account determination determine the GL accounts to which depreciation & APC values posted for the AMR
- Assign Screen layout
- Assign Number range
- Status of AuC: Select Line Item Settlement in case of AuC
- Check Box : Asset Classes blocked for Posting
Account Determination:
- Tcode: AO90
- Select your COA INT
- Select the Account Determination
- One Account Determination can be assigned to several Asset Classes provided they use the same COA
- Select Depreciation Area 01 : Assign GL accounts for Acquisition, Retirement, Depreciation
- Asset Master Records
Create AMR
- Enter company code and Asset Class
- Use existing AMR as reference
- Can create multiple similar Assets
Time Dependent Data
- AMR information managed on time basis in Cost center
- Time Dependent Tab – Further Interval – Enter from date and Cost center
View Changes to AMR | AS04 |
Create Asset Sub Number | AS11 |
Create AMR | AS01 |
Change AMR | AS02 |
Display AMR | AS03 |
- Mass Changes
- Create a work list: AR01
- Select Substitution Rule for mass Changes
- Release Work List: AR31
- Check Assets for changes
Exercises – Master Data
Make number range assignments for Asset Accounting for your company code MR03. Two options:
- Define a separate number range interval. Copy from company code 1000 : AS08
- Chose cross company code number range interval. Here find company code MR03 and enter company code 1000 so both company code use same number range interval for Asset Accounting: AO11
Call up transaction that provide overview of all Asset Classes: OAOA
- Tcode: OAOA
- Account Determination: Determine the reconciliation a/c in GL to which posting has to be made
- Screen Layout: Determine for AMR which fields are Required/ Optional / Suppressed
- Number range assigned to the Asset Class
- Can block Asset class from posting
- Set Chart of Depreciation: OAPL
Which B/S a/c system post for an Asset Acquit ion
- From AMR get Account determination. For this find GL a/c in AO90
Tcode: AO90
Show how field description & cost center of AMR defined ( R/O/S)
- Tcode: SPRO – FA – AA – Master Data – Screen Layout – Define Screen layout for Asset Master Data – Select layout rule 2000 – Select Logical Field group – General / Time Dependent data – Field group rules
Copy : If selected this field is copied is used as reference asset
Determine Depreciation Areas in the Asset Class
- Tcode : OAYZ
- Determine Depreciation areas for an Asset Class
- Depreciation Areas active for the Asset Class
- Depreciation Keys assigned to the Depreciation areas. Can be changed
- Screen layout assigned to the depreciation area
Use: If a useful life is not entered in the asset class, and depreciation key is not 0000, this field is a required entry regardless of the settings in the screen layout control.
Create an Asset Class (MA03) by copying another Asset Class 2100
- Tcode : OAOA
When you copy Asset Class you get Asset class Master Data + Depreciation Data
Define Maximum value for LVA (Low Value Asset) for company code MR03
- Tcode : OAYK
- Tcode: SPRO – FA – AA – Valuation – Amount Specification – Specify Maximum amount for LVA and Asset Class – Specify Asset Class (Here specify LVA Asset Class) / Specify Amount for LVA (Here specify Amount for LVA Asset Class)
- LVA : 0 : No LVA check for this AC
LVA : 1 : Each LVA with its own asset master record
- Create Asset master Record (AMR) : AS01
Account Determination | Depreciation Key | Asset |
2100 | | 2000 |
1100 | | 1000 |
2100 | | 2100 |
3000 | LINS | 3007 |
4000 (AuC) | 0000 | 7000
7001 |
5000 (LVA) | GWG | 5000 |
Create similar Asset: AS01
- Enter 5 in similar records
- Create Sub Assets: AS11
List all AMR created in a company code
- Tcode: AA- Information System – Report on AA – Day to Day Activities – International – Directory of un posted Assets
- Create a Vendor master: FK01
Post Asset Acquition to Vendor: F-90
- Tcode: Easy – FA – AA- Posting – Acquition – External Acquition with vendor
Check asset value using Asset Explorer:
- Tcode: AW01N
- Check B/S GL a/c to which asset acquition value posted: Double click on transaction
- GOTO – Call up Reports – Acquition / History
- GOTO – master data
Post Asset acquition with automatic offsetting entry
- Tcode: ABZON
- Easy – FA – AA – Posting – Acquition – External Acquition – Acquition w/automatic offsetting entry
Post acquition in current year w/o first creating AMR
- Tcode: ABZON
- Select new Asset radio button
Post Acquition to multiple assets
- Tcode; ABZON
- Select Tab Multiple Assets – Enter main Asset number in asset – click sub number – list of assets populated – Add Amount and save
Reverse Asset Acquition: AB08
- Tcode: Easy – FA – AA – Posting – Reverse Document – Other Asset Document
- Post an acquition to LVA: F-90
Ensure / restrict that only certain depreciation areas are posted with values
- Tcode: SPRO – FA – AA- Transaction – Acquition – Define Transaction types for Acquition – Limit transaction type to Depreciation Areas
- Tcode: AO73
- Tcode: OAYA
- Asset Transactions – Retirement
Post Asset Retirement with revenue with customer
- Tcode: F-92
- Tcode: Easy – AA – Posting – Retirement – Retirement with revenue – with customer
- Data:
PK | 01 |
PK | 50 |
A/C | 820000 |
Select Asset Retirement | Check box |
Select complete retirement check box | |
TT (For retirement with revenue) | 210 |
On complete retirement AMR is de activated | |
Scrapping the Asset
- Tcode: ABAVN
- Tcode: Easy – AA – Posting – Retirement – Asset Retirement by scrapping
- AMR deactivated on scrapping
- Asset Transactions – Intra/ Inter Company
Perform an Intra company transfer between asset Class 3000 (Furniture) and AC 3100 (Vehicle)
- Tcode: ABUMN
- Tcode: Easy – FA – AA – Posting – Transfer – Transfer within company code
Transfer between company codes belonging to the same Company (Group)
- Tcode: ABT1N
- Tcode: FA – AA – Posting – Transfer – Intercompany asset transfer
- Data:
Both company codes in same group company | |
Transfer variant Used | 1 |
Transfer Variant :
- Specify Asset valuation method in the receiving company code
- Transaction Type (Retirement/ Acquit ion) used for transfer
| |
Copy start date of depreciation to the New Asset
- Tcode: AA – Transaction – Intercompany asset transfer – Automatic Intercompany Asset Transfer – Define transfer variant
- Asset Transactions – AuC
Assign a settlement profile (AI) to your company code
Tcode: SPRO – FA – AA – Transactions – Capitalization of AuC -
Assign Settlement Profile
Acquition to AuC:
- Tcode: ABZON
Distribute AuC (7000) Acquition document to Final Assets (2005, 2006)
- Tcode : AIAB
- Tcode: FA – Posting – Capitalize AuC – Distribute
Steps : Chose Documents – Execute – Edit – Enter Distribution rules – Save
Execute Settlement
- Tcode: FA – Posting – Capitalize – AuC - Settlement
- Unplanned Depreciation: ABAA
Summary of Asset Accounting Tcode
Particulars | Tcode |
Overview of Asset Class | OAOA |
Account Determination | AO90 |
Define Screen Layout | SPRO – FA – AA – MD – Screen Layout |
TAB Layout for AMR | AOLA |
View Changes to AMR | AS04 |
External Asset Acquition with Vendor | F-90 |
External Asset acquition without vendor | ABZON |
Asset Explorer | AW01N |
Activate / Deactivate Depreciation areas for Asset Class in Chart of Depreciation | OAYZ |
Create Sub Assets | AS11 |
Create / Change / Display AMR | AS01 / AS02 / AS03 |
Reverse Asset Document | AS08 |
Asset Transaction Type Details | AO73 |
Retire Asset to Customer | F-92 |
Asset Class Change | ABUMN |
Inter Company Asset Transfer | ABT1N |
AuC Settlement | AIAB |
Define Asset Number Range | AS08 |
Share Asset Number Range with other company codes | AO11 |
Validation / Substitutions
- Validation & Substitution General
To Validate or Substitute an entry
Steps in Validation & substitution:
- Identify area of application
- Call up point for validation / Substitution
- Define Validation / Substitution
- Assign Validation / Substitution to company code (An Org. unit)
Activate validation / substitution
Application Area: Area where validation / substitution rule is used. e.g.
- FI
- CO
- Asset Management
- Special Purpose ledger
PCA
- Application Area Key: Specify Application area where validation / substitution is used
- Call Up Point: Point at which Validation / Substitution processing starts
Call Up Point for FI
- Document Header : Call up point 1
- Document Line Item : Call up point 2
- Complete Document : Call up point 3
At this call up point can use only numeric field, used for mathematical calculation
Formula Editor:
Interface for editing arithmetic & Logical statements
Assign Validation / Substitution to Organization Unit (Company code, Controlling area...)
- A validation / Substitution can be valid for several company codes
Activate Validation / Substitution
- 0 : Inactive
- 1: Active (Dialog + batch)
- 2: Active (Dialog but not Batch)
- Only one validation / Substitution can be activated for a company code for 1 call up point
- Validation Execution
Validation has following 3 parts
- Prerequisite
- Check
- Message
If prerequisite is true :
- Check performed
- If check false, message displayed
- Message Type
I | Information |
W | Warning |
E | Error |
A | Cancel |
- Can use predefined message or create own message
Validation Can do following Logical Statements
- Compare fields with one another. BKFP-BUDAT <>BKPF-BLDAT. Statement true if date in field BUDAT is not equal to date in field BLDAT
- Validate field contents for certain values. BKPF-BLART = "SA". Statement true if document type = SA
- Check / compare only a part of the field. Details refer notes
- Substitution Execution
Substitution steps has two parts
- Prerequisite: If prerequisite is true substitution is performed
- Replacement: Substitution
Substitution Methods:
- Constant Values
- User Exit: Name of the Exit to be carried at Run Time
- Field-Field Assignment: Name of field whose content can be used for Substitution
Rule:
- A Rule is a prerequisite or a check of validation
- A rule is normally created for a prerequisite that is frequently used. Rule can be used repeatedly
Set:
- A data structure having a range of GL accounts
- Exercise: Validation / Substitution
Create a validation rule that for GL a/c (telephone expense) 473110 / 473120 cost center must be 3336
- Tcode: OB28
- Steps:
- Double click on call up point 2 for company code MR03
- Click on validation create
- Data:
Validation | G03 |
Description | Telephone Cost |
| |
- Click on step Insert
- Data:
- Double click BSEG-HKON- click = - Click constant and enter 473110 – click OR – Double click BSEG-HKONT – click = - Click constant and enter 473120 – Double click on BSEG-KOSTL – click = and enter 3336
- Define the required message "Assign cc 3336"
- Activate Validation – Go to Step 1 for call up point 2 select Validation G03 and activate it
Create a Substitution rule that when customer invoice posted and Sales a/c = 810301 and Segment = SEG03 Then Substitute PC = PC05
- Tcode: SPRO –FA – FAGS – Document – Line Item – Define Substitution in account document
- For company code MR03 & call up point 02 create substitution rule G03
- Chose Insert – Select BSEG-PRCTR – Continue
- Enter the prerequisite
- Select Substitution and Enter PC as PC05
- Save and Activate
The New GL
Total tables when classic FI component used are:
- Classic FI: GLTO
- Cost of Sales Ledger: GLFUNCT
- Reconciliation Ledger: COFIT
- EX-PCA: GLPCT
New GL Advantage
- It has an extended data structure. Thus new fields like cost center, Segment etc can be added to GL total table
- Balance sheet can be created for entities called segment. Real time document splitting between segment
- Real time FI & CO reconciliation
- New GL is optional for existing customer during a release upgrade
- In a new installation new GL is active
- Setting up System for New GL : SAP Note 756146
Features of Leading Ledger:
- Manages additional local currencies assigned to a company code
- Uses Fiscal Year variant assigned to a company code
- Uses Posting Period Variant assigned to a company code
Only Leading Ledger values posted to controlling
Define additional currencies for leading ledger for a company code
Tcode: SPRO – FA(N)- FAGS(N)- Ledger – Ledger – Define currencies of Leading Ledger
Assign Fiscal Year variant and Posting Period to company code and Leading Ledger
Tcode: SPRO – FA(N) – FAGS(N) – Ledger – Fiscal Year and Posting Period
There are non leading ledger: Can be assigned currencies and Fiscal Year variant different from leading ledger
New GL Total Tables:
- New GL total table: FAGLFLEXT
- Classic GL Total Table : GLTO
New fields in new GL total table:
- Cost Center
- Profit Center
- Segment
- Can also add new fields predefined / new custom fields
What is a scenario
- A scenario defines which fields are updated in ledger (Leading and non leading ledger) during posting
- Cannot define own scenario
Scenarios provided by SAP:
- Cost Center update ( Update sender / receiver cost center)
- Profit Center Update ( Update Profit Center / Partner PC field)
- Segmentation ( Update segment, Partner segment and PC fields)
Preparation for consolidation
Display available scenarios
- Tcode: SPRO – FA(N) – FAGS(N) – Ledger – Fields – Display scenario for GL
Assign scenarios to ledger:
- Tcode: SPRO – FA(N) – FAGS (N) – Leading ledger – Ledger - Assign
Multiple non leading ledgers useful to show accounts as per different accounting principles
In new GL FA documents has two views : FB03
- Entry View: In account field vendor number appear
GL View: In account field vendor reconciliation account number appear
Segment Field
- It is one of the standard account assignment object
- Enable analysis below company code level
Alternative account assignment used earlier
- Profit Center
- Business Area
- Profit Segment
- A segment is assigned to master record of Profit Center. Posting is made to segment when profit center is posted
- Derive Segment from PC. Can have own rules through user exist (BADI). BADI is FAGL_DERIVE_SEGMENT
- Document Splitting
1st define for which FI characteristic document splitting is performed. FI characteristic:
- Business Area
- Profit Center
- Segment
- Tcode: SPRO – FA(N) – GL (N) – BT – Document splitting – Define document splitting characteristic for GL
Zero Balance indicator: Useful if balance sheet is to be prepared for a characteristic
Activate Document splitting
- Document splitting activated at client level
- Tcode: SPRO – FI (N) – GL(N) – BT – Document splitting – Activate document splitting
- Inheritance: In entry view 2 accounts (purchase services and travelling cost) plus 1 tax a/c. In GL view tax a/c amount split in two in the proportion of amount in purchase service and travelling cost
- Configuring New GL
Activate New GL
Tcode: SPRO – FA – FAGS – Activate New GL
Check ID of Leading ledger
- Tcode: SPRO – FA(N) – FAGS(N) – Ledger – Ledger – Define Ledger for GL
Data: OL
Check scenarios assigned to leading ledger OL
- Tcode: SPRO – FA(N) – FAGS(N)- Ledger – Ledger – Assign Scenarios to Ledger
Scenarios assigned
- Cost Center update
- Preparation for consolidation
- Profit Center Update
- Segmentation
Cost of Sales account
Create a new Segment SEG03
- Tcode: ES – Definition – FA – Define Segment
Create a Profit Center
- Tcode: KE51
Data: PC04
Update Cost center 3336 with Profit Center PC04
Tcode: KS02
Check that cost center / Profit Center / Segment defined as OPTIONAL in Field Status Group of GL a/c 417000
Tcode: FS00 – Enter a/c 417000 – Create Bank – Double click FSG G033
Check Segment splitting defined for GL
- Tcode: SPRO – FA (N) – GL(N) – BT – Document Splitting – Define Document splitting …. GL
- Zero balance indicators checked: System checks that the balance of the characteristic (Segment) is zero during posting. If not system creates additional line item to achieve zero balance
Mandatory indicator checked : System checks that all line items in the posting are assigned appropriate characteristic (Segment) after split
Activate document splitting for company code MR03
Tcode: SPRO – FA(N) – GL(N) – BT – Document splitting – Activate document splitting
Assign Item category to GL a/c
Assign Segment SEG03 to PC04
Tcode: KE52
Enter Vendor Invoice & split to cost center 3336 and 3338 so post to different characteristics
Create segment SEGA and assign to cost center
- Create PC PC05 : KE51
- Create a new segment : SEGA
- Assign SEGA to PC05
Create a CC 3339 and assign PC PC05 to it
Assign company code MR03 to controlling area 1000
- Maintain controlling area
- Create cost center, Profit Center, Segment
- Assign Segment to Profit Center
Assign Profit center to Cost Center
Create a variant for Real time FI and CO integration
- Tcode: SPRO – FI (N) – FAGS(N) – Ledger – Real time integration of controlling with Financial Accounting – Define variant for real time integration
- Data:
Variant | V03 |
Real time integration | Select |
Account Determination | Select |
Document Type | AB |
Ledger Group | 0L |
| |
Assign Variant to company code (MR03)
Tcode: SPRO – FI(N) – FAGS (N) – Ledger – Real time integration of controlling with FI – Assign variant for real time integration
Repost a line item in controlling from cost center 3338 to cost center 3339
- Tcode: Easy – Accounting – Controlling – CCA – Actual Posting – Repost line items – Enter
Tcode: KB61 ( It's reversal KB64)