SAP FI(Financial Accounting) FAQ
1. There is "company" field in the Company Code global settings. The R/3 help says that it is being used for consolidation. We can use Group Chart of account to do the same. What is the significance of this field.
Company is an organizational unit which is generally used in the legal consolidation to roll up financial statements of several company codes. A company can include one or more company codes. If we are going for Consolidation , we need to enter the 6 character alphanumeric company identifier that relates to this company code. Company Codes within a Company must use the same chart of accounts and fiscal year. And for consolidation purpose we use Group COA wherein we link the Operating COA thru entering the GL account no. of the Group COA in the GL Account of the Operating COA.
In the SAP system, consolidation functions in financial accounting are based on companies. A company can comprise one or more company codes. for example: Company A have 4 company codes which is existing in different state and / or country. When Company A wants to consolidated the accounts, it will give the common list of accounts which in turn called group chart of accounts. Group chart of account is used to define/ list the GL account uniformly for all company codes.
2. When we copy the COA, only one Fin Stat Version is being copied. A COA can have many Fin Stat Version. Why copying of COA allows only one Fin St Ver?
A financial statement version corresponds to the chart of accounts and wherein Individual (operational) accounts are assigned to the corresponding FS item on the lowest level of this version. But as for the rollup of Accounts is not possible in all the FSV which can be copied, n rather can update manually n create multiple FSVs if necessary depending on the Financial Statements which are necessary for the Organisation.
In SAP R/3 system, will allow only one financial statement version for single COA which you need to assign the same while copying the COA. T.code OBY7
3. What are the information that are not copied to new company code when we copy company code?
All the Organizational units (Global Data) for a company code will be copied to new company code upon using the copy function except for the transactional data.
When you want to create FYV, PPV, COA etc for new company code which is as same as existing company code, then you can copy all the information from the source company code to the target company else whatever is required as per the new company code requirement you can only copy the same, rest you can create as per the requirement. for example Fiscal year for new company code may be shortented fiscal year which is differ from the existing company code. In this case, fiscal year for new company code you have to create and assign it to company code.
4. Whether one group chart of account can be assigned to 2 Operational charts. For Eg. INTA and INTB is being used by group of company as OCA. Whether GCA GRP can be assigned to INTA and INTB?
Yes, Group COA can be assigned i.e., the GL A/c.No. is linked to the GL Accounts of the both Operating COA . That means Group COA consists of Unique set of Accounts which can be linked to Op.COA –1 and Op.COA –2.
Operational chart of accounts is something differ from the Group chart of accounts but Group chart of account can be assigned to Operating chart of account 1 and 2 through GL account no.
Operating chart of accounts: The operating chart of accounts contains the GL accounts that you use for posting in your company code during daily activities. Financial accounting and controlling both use this chart of accounts. You have to assign an operating chart of account to a company code.
Group chart of accounts: The group chart of accounts contains the GL accounts that are used by the entire corporate group. This allows the company to provide reports for the entire corporate group.
How do I know which target cost version we are using?
To find out which version is used for your Target Cost, try this menu path
IMG > Controlling -> Product Cost Controlling -> Cost Object Controlling -> Product Cost by Order -> Period-end Closing -> Variance Calculation -> Define Target Cost Versions (tcode OKV6).
How do you change the "Input tax code - Assets without input tax" value for a company in Asset Accounting? Technically, how do you change field MWSKZVA field in table T093C? TIA.
You can used transaction 'OBCL'.
Via customizing: Asset accounting -> Integration with general ledger -> Assign input tax indicator for non-taxable acquisitions
Require GR & IV report
Is there any report on GR pending for IV?
You could try executing program RFWERE00, without postings.
This is the same program which is used for period end closing- regrouping of GR/IR...but for only a report do not create postings.
May be transaction MB5S can help you out.
Retained Profit Account
After you run the GL balance carry forward, you only manage to know the balance carry forward for the retained profit account but you don't how much is actually post to the particular account. You have try almost all of the standard report but still can't find any report that can show you the figure.
The balance carried forward is only a 'calculated' figure and not a 'posted' figure. The break-up of the retained earnings figure is available when you run the balance carried forward report.
You can also derive the balance by selecting only the P&L Accounts for the relevant period. The net balance of these accounts should equal the retained earnings account.
ACH payment configuration
Based on 4.0B. Is it possible to configure the system for ACH payments or do we need to upgrade?
You can use RFFOUS_T to produce an ACH file. You may have to use user exits to write header and trailer records. Please read documentation on this program and it is self-explanatory.
Locking of Planning Data in Profit Center Accounting
How to lock planning data in profit center accounting.
In 4.6 b the transaction is S_ALR_87004395 - Maintain Versions you can lock versions for each fiscal year
Changes in vendor master
Is there a report which shows changes in vendor master data.
Not only for one like MK04 or XK04 but for a range like all changes in vendors per ccode.
(should be similar to customer master transdaction OV51)
You can used report "RFKABL00".
In the accounts payable reporting menu this program can be found via:
Accounts payable -> Adequacy and documentation -> Master data -> Display of vendor changes
(depending on your SAP version of course)
Bank Statement Upload
How to used the program RFEBKATX? This creates two files STATE.TXT and ITEM.TXT.
How are these files imported into SAP?
Try using program RFEBKA00 to upload the two files.
- one is the header file containing the House bank & account information along with the date and the statement number
- the other is the item details.