Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaycwa1981
Active Contributor

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 ItemBrief 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)
2Settle 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

3Track 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
4Display 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
5Down 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)
6Smooth Calculation of Target Cost during Variance Calculation
7Vendor 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
8Profit 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
9Modify 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)
10Change Default Document Type in Clearing transactions
  • T code OBXH: SPRO> FI > AR/AP > Busn Trans > OI Clearing > Define Posting keys
11Enhance 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
12Program to download SAP Forms / Scripts
  • RSTXSCRP
13Program to download Custom Programs / Objects
  • REPTRAN
  • Improvised version of this program also available on Google
14Post 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
15Post 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
16COPA 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
17Distribute 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
18Target 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
19Find Variables used in Report Painter Forms
  • Table CEFORMV
20Analyze 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

121 Comments
Labels in this area