For SAP Project Implementation, Project Support, Placement, Training and Certification reach me at "SAPISPTC@gmail.com"
Business Transaction Events (BTE) Guide : FI Enhancement Technique
SAP Tables for Technical Consultants & also for Function Consultants !!!
SAP Technical Upgrade – Tips and Tricks
Overview
SAP CIN: Uploading of Excise Balances - during Cut Over
Check the below master & config data in the system before the upload of balances.
GL Accounts, Tax codes and Withholding tax codes, Cost Elements, Cost Centres, Material master, Vendor & Customer Master, CIN Masters, User Profiles
Quantity Balance : TCODE: J1I5
GL and Register balance:
RG23A Part2 & RG23C Part2 - pass an Excise JV – The credit account has to be changed to the initial GL balance upload account.
Transferring of balance credit to RG23C Part2 - Posting a normal FI-JV shall transfer the balances of the CENVAT-On-Hold account during the GL balance upload. However, the subsequent credits to RG23C Part2 on account of these purchases is to be posted using an Excise JV- Additional Excise and the credit entry should go to the CENVAT-On-Hold account.
PLA - FI-JV is posted to debit the PLA-On-Hold account for the initial balance.
Number ranges:
Number Range Object | Description |
J_1I57FC | 57AC5 Number Range |
J_1IEXCEXP | Export Excise Invoice Number |
J_1IEXCLOC | Local Excise Invoice number |
J_1IINTNUM | Internal document number |
J_1IPLA2 | PLA part2 serial number |
J_1IRG1 | RG1 number Range |
J_1IRG23A1 | RG23A Part1 serial number |
J_1IRG23A2 | RG23A Part2 serial number |
J_1IRG23C1 | RG23C Part1 serial number |
J_1IRG23C2 | RG23C Part2 serial number |
J_1IINTPR2 | Despatch Register serial number |
Reconciliation of balances
Please ensure that proper reconciliation process/measures are in place. All excise balances are required to be signed off before allowing business transactions.
SAP-FICO: Overview of EC-CS Consolidations
Consolidating multiple companies into a unified, consolidated set of financial statements is an art form. In SAP, two common ways of producing consolidated financials are EC-CS (Enterprise Controlling – Consolidation System) and through reporting in BW (Business Warehouse). This post deals primarily with EC-CS.
EC-CS gives you a means of rolling up multiple company codes into a unified set of books. If you use multiple charts of accounts, the best option is to create Group Chart of Accounts and map your other charts to it. Your Group Chart of Accounts can then feed into your Consolidation Chart of Accounts.
Features of EC-CS
- Consolidate multiple company codes
- Import data from the General Ledger to cons units
- Manual and automatic eliminations between Consolidation Units (cons units are tied to a Company, which is tied to a Company Code(s))
- Eliminations within a cons unit
- Reclassifications
- Database viewer to view imported records, elimination/reclass records, and manual journal entry records
- Upload data from Non-SAP systems (set up this feature in: CXCC). I'm not familiar with the capabilities of this function
- Report Painter reporting (GR55)
- Eliminate inter-unit payables and receivables
- Eliminate inter-unit sales
- Eliminate investment income
- Perform manual eliminations
- Consolidate investment income
- Perform manual reclassifications
- Validate consolidated data
Number Ranges entry DELETION !!!
For deleting the interval, you must first reset the status of that number range to zero, that means put the zero in the current number.
e.g. Current number is 70885200
Reset the current number status in every year for which you want delete.
Once the status becomes zero, delete the interval.
Create the interval agian for 9999 year only.
Set the current number in 9999 year to the previous value (i.e., 70885200).
COPA Char / Value fields : Description change
If you want to change the description of a characteristic or value field you must change the descriptions of the related data element.
Therefore you need to perform the following steps:
- In KEA5 / KEA6, type in the name of the characteristic/
value field and click on the create / change button - On the next screen, double click on the data element of your
characteristic/value field - On the 'Display Data Element' screen, click on the tab strip
"Field label". You can see the four field lables short, medium, long
and heading. You should change all four field labels and then
regenerate the data element. After having done this you may have to
to regenerate the characteristic/value field and the operating
concern.
Leading ledger & Non-leading ledgers
Leading ledger
- It is a base ledger, which updates the cost center and consolidation.
- You can define only one ledger as the leading ledger – SAP provides the leading ledger "0L".
- The currency of the leading ledger is always used as the first currency.
- The leading ledger is integrated with all subsidiary ledgers.
- Only the values from the leading ledger are sent to CO.
- The leading area in Asset Accounting (depreciation area 01) must be posted to the leading ledger.
- Leading ledger uses the (additional) local currencies assigned to the company code.
- Leading ledger uses the GL Total Table: FAGLFLEXT.
Non-leading ledgers
- Non-leading ledgers are activated by company code.
- You can define additional currencies that deviate from those used by the leading ledger.
- As a second and third currency of a non-leading ledger, you may only use currency types that you have already assigned to the relevant company code for the leading ledger.
- You can define a fiscal year variant that differs from the leading ledger. If you don't specify a FYV, the FYV of the company code is automatically used.
- You can also define a posting period variant that differs from the leading ledger.
- Separate document types and number ranges can be defined for non-leading ledgers by users, to ensure continuity in ledger numbering.
- Non-leading ledger updates the profit center, segment.
- The non-leading ledgers are used as parallel ledger together with the leading ledger. This can be used to apply different accounting standards, such as IAS/IFRS or US-GAAP
SAP ECC 6.0: New GL Configuration Steps
1. Define Field Status Variants
Use
In this activity you create a field status variant with the corresponding field status groups
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Ledgers > Fields > Define Field Status Variants |
2. Assign Company Code to Field Status Variants
Use
In this activity you assign the company code to the field status variant.
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Ledgers > Fields > Assign Company Code to Field Status Variants |
3. Define Currencies of Leading Ledger
Use
In this IMG activity, you specify the currencies to be applied in the leading ledger. You can make the following settings for each company code:
- The local currency (as company code currency) is specified in the company code settings.
- You can define one or two additional local currencies that you store per company code parallel to the first local currency.
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Ledgers > Ledger > Define Currencies of Leading Ledger |
4. Assign scenarios and customer fields to ledgers
Use
In this activity, you assign the following to your ledgers:
- Scenarios: determines what fields in a ledger are updated when it receives posting from other application components.
- Custom Fields: you can add custom fields (that you have already defined) to the ledger.
- Versions: this enables you to make general version settings for the ledger that depend on the fiscal year. In the versions, you specify whether actual data is recorded, whether manual planning is allowed, and whether planning integration with Controlling is activated.
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Ledgers > Ledger > Assign scenarios and customer fields to ledgers |
Scenario for General Ledger Accounting | Long Text |
FIN_PCA | Profit Centre Update |
FIN_SEGM | Segmentation |
5. Assign Posting PeriodsVariants to Company Code
Use
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Ledgers > Fiscal Year and Posting Periods > Posting Periods > Assign Variants to Company Code |
6. Define Accounting Principles
Use
IMG Menu | Financial Accounting (New) > Financial Accounting Global Settings (New) > Ledgers > Parallel Accounting > Define Accounting Principles |
Accounting Principles | Name |
HGB | Local GAAP Germany |
7. Assign Accounting Principle to Ledger Groups
Use
In this IMG activity, you assign the desired ledger group to your accounting principles.
IMG Menu | Financial Accounting(New) > Financial Accounting Global Settings (New) > Ledgers > Parallel Accounting > Assign Accounting Principle to Ledger Groups |
Accounting Principles | Target Ledger Group |
HGB | 0L |
8. Assign Variants for Real-Time Integration to Company Codes
Use
IMG Menu | Financial Accounting(New) > Financial Accounting Global Settings (New) > Ledgers > Real-Time Integration of Controlling with Financial Accounting > Assign Variants for Real-Time Integration to Company Codes |
9. Define Foreign VAT Registration Numbers
Use
In this activity, you define the VAT registration number which you received in another EC member state for every company code which has its headquarter in an EC country and maintains business transactions with other EC member states.
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Global Parameters for Company Code > Tax > VAT Registration Numbers (VAT Reg. No.) > Define Foreign VAT Registration Numbers |
10. Define Document Number Ranges for Entry View
Use
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Document > Document Number Ranges > Documents in Entry View > Define Document Number Ranges for Entry View |
11. Define Document Number Ranges for General Ledger View
Use
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Document > Document Number Ranges > Documents in General Ledger View > Define Document Number Ranges for General Ledger View |
12. Define Document Types for Entry View
Use
In this IMG activity, you have to define for your leading ledger the document types for the documents. You do this in the entry view and assign at the same time a number range interval to the document types.
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Document > Document Types > Define Document Types for Entry View |
13. Change Message Control for Document Processing
Use
In this activity, you can configure the appearance of system messages according to requirements.
IMG Menu | Financial Accounting (NEW) > Financial Accounting Global Settings (New) > Document > Default Values > Change Message Control for Document Processing |
Work Area | Message | Online | Batch Input |
F5 | 671 | W | W |
F2 | 145 | I | I |
F2 | 144 | I | I |
14. Classify Document Types for Document Splitting
Use
Every business transaction that is entered is analyzed during the document splitting process. In this process, the system determines which splitting rule is applied to the document. In order that the system can determine the splitting rule, you have to assign a business transaction variant to each document type.
To ensure that a splitting rule is used appropriately, the relevant documents have to meet certain requirements. These requirements relate in particular to certain item categories that either must or must not be available. This information is specified for each business transaction variant and is checked against the current document during posting. If the document does not meet these requirements, the system rejects the posting.
IMG Menu | Financial Accounting (NEW) > General Ledger Accounting (New) > Business Transactions > Document Splitting > Classify Document Types for Document Splitting |
Document Type | Transaction Type | Variant |
DV | 0200 | 0001 |
KZ | 0000 | 0001 |
15. Define Document Splitting Characteristics for General Ledger Accounting
Use
IMG Menu | Financial Accounting (NEW) > General ledger accounting (NEW) > Business transactions > Document splitting > Define Document Splitting Characteristics for General Ledger Accounting |
Field | Zero Balance | Partner Field | Mandatory |
SEGMENT Segment | √ | PSEGMENT Partner Segment | √ |
16. Define Document Splitting Characteristics for Controlling
Use
IMG Menu | Financial Accounting (NEW) > General ledger accounting (NEW) > Business transactions > Document splitting > Define Document Splitting Characteristics for Controlling |
Field |
AUFNR Order |
KOSTL Cost Center |
17. Activate Document Splitting
Use
In this IMG activity, you have to activate document splitting. The splitting method used is the SAP standard one, which contains the splitting rules for the different business transactions. If this splitting method does not meet your requirements, you can first define and then select your own method in Customizing for document splitting. You can do this choosing Extended Document Splitting > Assign Splitting Method.
The activation then applies for the entire client. You can explicitly exclude individual company codes from document splitting. This means, however, that you are then no longer able to create any cross-company-code transactions containing company codes that have divergent settings for document splitting.
IMG Menu | Financial Accounting (NEW) > General ledger accounting (NEW) > Business transactions > Document splitting > Activate Document Splitting |
Field name | User action and values |
Document Splitting | √ |
Inheritance | √ |
Standard A/CAssgnmnt | √ |
Constant | ZBP01 |
18. Define Tolerance Groups for G/L Accounting
Use
When G/L accounts are cleared, tolerance groups are used to define limits which differences are accepted and posted automatically to predefined accounts. The groups which are defined here are assigned in the G/L account master record.
IMG Menu | Financial Accounting(NEW) > General Ledger Accounting (NEW) > Business Transactions > Open Item Clearing > Clearing Differences > Define Tolerance Groups for G/L Accounting |
19. Define Posting Key for Incoming Invoices/Credit Memos
Use
When you enter incoming invoices and credit memos, the posting keys for the open items and G/L account items are generated automatically by the system. You can not change these keys when entering invoices and credit memos.
IMG Menu | Financial Accounting (NEW) > Accounts Receivable/Accounts Payable > Business Transactions > Incoming Invoices/Credit Memos > Incoming Invoices/Credit Memo – Enjoy > Define Posting Key for Incoming Invoices/Credit Memos |
Make the following entries for transaction EGX (Vendor item with special G/L indicator):
Post. Key Debit | Posting Key Credit |
29 | 39 |
20. Set country-specific check
Use
For all countries, which maintain business relationships with your company, you have to include rules for checking the following data.
IMG Menu | SAP Net Weaver > General Settings > Set Countries > Set country-specific check |
Country | Bank Key | Length of Bank Key | Checking rule (VAT registration no.) | Other Data |
FR | 4 | 11 | 3 | X |
US | 4 | 11 | 3 | X |
21. Create Dummy Profit Center
Use
The dummy profit center receives postings concerning objects for which no profit center assignment exists. This ensures that your data will be complete in Profit Center Accounting.
To create the master record for the dummy profit center use this special transaction. To change or display it, use the normal profit center maintenance functions.
The name of the dummy profit center is displayed in the controlling area settings for Profit Center Accounting.
Choose the function Extras > Set controlling area first to make sure that the correct controlling area is set.
Transaction Code | KE59 |
IMG Menu | Financial Accounting (NEW) > General Ledger Accounting (NEW) > Master Data > Profit Center > Create Dummy Profit Center |