Skip to Content

20 FICO Tips – Series 1

Hello Everyone,

In this series, I would like to present a bunch of quick 20 Tips related to FI/CO/AA that may come handy to you. I cant claim you will find all of them to be new, but there will be something for everyone, to a great extent


Sr. No. Knowledge Item Brief Description
1
Steps to activate Budget Check for assets (without IM)
  • Activate order management in controlling area
  • Activate commitment management in controlling area & Order type
  • Enable Budgetary control in Internal Order
  • Create statistical IO with “Object class – Investment”
  • Assign the statistical IO in asset master in the “Origin” Tab – “Investment Order” Field
  • Create asset recon account as statistical cost element (Category 90)
  • The FSG of asset recon account must allow IO (OBC4)
  • Activate the investment order as the additional account assignment object for asset acquisition (ACSET)
  • Enter budget for the statistical internal order (KO22)
2 Settle Production Variances by Cost Component Structure in COPA
  • Create PA Transfer Structure with as many assignments as Cost Components in Cost Component Structure
  • Choose the Option “Costs / Revenues” in each assignment, instead of “Variances”
  • Assign each assignment to a different value field

Traditionally, variances are settled to COPA as per Variance Categories. But this is also an interesting way of doing the Variance Settlement

3 Track Origin line items of an AUC asset
  • Activate “Settlement By Cost Element” in the Allocation Structure
  • Assign the Allocation Structure to Settlement Profile of the Internal Order and the Co. Code
  • Use Program RAHERK02 to see Origin line items
4 Display Cost Center Accounting and Internal Order Accounting reports in Multiple Currencies
  • Using RPC0 and RPO0 respectively, you can switch between Controlling Area currency and Object Currency (Co. Code Currency)
  • These settings are per SAP User
5 Down Payments in Asset Accounting
  • To avoid capitalizing the asset at the time of Down Payment, modify the TTY 180 and remove the check “Capitalize FA”.
  • However, once the Asset GR is posted and Asset is capitalized, Depreciation will be calculated on Down Payment amount + Asset Value. This continues till the time Down Payment is cleared
  • To avoid these issues, you can avoid updating Down payment in Asset Accounting as below
    • Create a new FSG for Vendor recon accounts (OBC4) in which Asset is SUPPRESSED
    • Modify Message F5 378 to W (OBA5)
6 Smooth Calculation of Target Cost during Variance Calculation
7 Vendor OI upload during Go Live, when vendor is liable to TDS

There are two ways of doing this

  • Create Vendor Masters, Load Open Items and then update WHT Codes in Vendor Masters (OR)
  • Create a Posting Key (Copy of 31/21) and suppress the WHT in the new posting Key
8 Profit Center in Special GL Postings
  • If the Special GL indicator is defined as for “Down payments” Profit Center Field is naturally available on the screen
9 Modify Vendor/Customer reconciliation account during postings
  • FS00 – Check the field “recon acct. ready for input”
  • Recon. Accounts can be manually changed during FB60/FB70
  • Recon. Accounts can be changed during SD postings as well
  • During MIRO, Standard SAP does not allow to change the same. Starting EhP6, a new business function can be activated to achieve this. Refer note  1836997. Else, Exit LMR1M001 can be used too. [Courtesy Aleksey Tkachenko)
10 Change Default Document Type in Clearing transactions
  • T code OBXH: SPRO> FI > AR/AP > Busn Trans > OI Clearing > Define Posting keys
11 Enhance the Open Item Selection Criteria during interest Calculation (FINT)
  • Implement User Exit RFINTITUSEREXT
  • Newly added selection fields will be visible under “Cust. Enhancement” Section of FINT screen
12 Program to download SAP Forms / Scripts
  • RSTXSCRP
13 Program to download Custom Programs / Objects
  • REPTRAN
  • Improvised version of this program also available on Google
14 Post Price Difference upon GR in Sub Contracting (When Material is valuated at ‘S’)
  • This must be specifically activated under SPRO> MM> Inventory Mngt & Phys Inv > GR > Price Differences for Subcontract Orders at Goods Receipt
15 Post separate doc for Purchase account postings (instead of 2 additional GL accounts in the same document)
  • SPRO> MM> Valuation and Account Assignment >Account Determination > Account Determination Without Wizard > Purchase Account Management > Separate Accounting Document for Purchase Account Postings
16 COPA Planning (KEPM) – Plan data for 12 periods at once
  • In the planning package, enter start period as, say, 001.2009.
  • In the planning layout, remove the char “PERIO”, from general data selection.
  • In the column for the Value field “Sales qty”, include the char PERIO and enter variable as “1”. This variable will be supplied with the value from Planing package.
  • Copy the column and change the variable as 1+1, 1+2, etc
17 Distribute Usage Variances during Repetitive Manufacturing Scenario (Where inputs are back-flushed at Std. Qty)
  • Use CKMDUVMAT functionality of Material Ledger
  • This works even without the activation of Material Ledger
18 Target Cost Tables
  • COSP: For External Postings (Target/Plan/Actual)
  • COSS: For Internal Postings (Target/Plan/Actual)
  • COSPD (Actual only): Settlement entries i.e. GR and GI upon confirmation, for Primary cost elements
  • COSSD (Actual only): Settlment entries i.e. activity confirmation
19 Find Variables used in Report Painter Forms
  • Table CEFORMV
20 Analyze Shop floor performance
  • Use KKO0 reports (Product Drill Down Reports)
  • OKN2 (Product Cost By Order Scenario)
  • OKN4 (Product Cost By Period Scenario)

Hope you enjoyed reading this. Expect more in the upcoming series

Your actions:

1) Share with your colleagues and within your teams

2) Leave your Feedback / Comments after reading the document. (You can choose not to, but it makes me happy if you do so )

Regards

Ajay Maheshwari

PS: Link to Second document in the Series is 20 FICO Tips – Series 2

122 Comments
You must be Logged on to comment or reply to a post.