Business Transaction Events (BTE) Guide : FI Enhancement Technique

This article provides a step-by-step guide on the usage of Business Transaction Events, as an Enhancement technique in the Financial Accounting Module of the SAP R/3 system. The Open FI enhancement technique was developed in the Financial Accounting component.
 
It can be used as Validation, Substitution, Processing point, etc. It works based on the event like FI document simulation, before saving the FI document, after saving the FI document,
 
Click here for the full version of the document....BTE

SAP Tables for Technical Consultants & also for Function Consultants !!!

Tables on below topics :
 
Authorisation, objects, Batch input map's, Batch jobs,Correction & transport, Countries, Currency, Data elements, Development classes, Domains, Dynpro areas,  Filenames, Function modules, Function groups, Icons, Logical databases, Matchcodes, Messages, Programs, Repository objects, Purchase Requisition, SAPscript, Spool, Status (menu), Switch objects, Tables and views, Texts, Transactions, User parameters, Variants, Accounting, Accounting documents, Bill Of Material, Classification, Classification characteristics, Configurator, Cost elements, centers, activities, Customer,Equipment, Equipment status, Function location, Customising tables, General ledger accounts, Goods movement, Customising, Inventory document, Maintenance Order, Material, Material document, Notifications, Orders,Personel, Production resource tools, Customising tables, Project, Purchase Requisition, Purchasing document, Purchasing info record, Reservation, Sales Document, Sales requirements, Storage locations and stocks, Tasklist, Transfer requirement, User data, Vendor master, WM transfer, Other tables, Useful Transactions, Function modules, Standard data transfer, Helpful reports.
 
Click on SAP Tables for the document.

 

SAP Technical Upgrade – Tips and Tricks

Overview

This article describes SAP upgrade projects: What steps to follow in an upgrade, what points to be taken care of, what are various prerequisites, etc. The SAP technical upgrade scores for a short duration project ? 20 days to around 3 months duration. In technical upgrades, we aim to get the same or better SAP functionalities in the new system (SAP ECC 6.0) as in the old system (SAP 4.6).
 
Click here for the full version.....Technical Upgrade

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

RG23A Part1 -: Stocks of all raw materials    - movement type 561.
RG23C Part1 -: Assets (as a non-valuated material)  - movement type 561
RG1/DSR  - :J1I5 : Stocks of all finished goods   - the movement type 561.


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 
 
RG23A, RG23C Part I, RG1 Balances required to be uploaded (material wise, Plant wise) after proper reconciliation with the production records. For this the respective Plants are requested to reconcile the same before upload.

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)

 

You can report your consolidated financials either through BW or through Report Painter reports (T-code: GR55). For Report Painter, you will need to create a reporting Library (T-code: GR21), utilizing table FIMC. You'll also need to specify your consolidations ledger while building your reports in GRR1 (or GR52).
 
 
Basic T-codes for EC-CS
 
CX16 – Consolidation Chart of Accounts – Hierarchy Change - allows you to build your Consolidation Chart of Accounts within a hierarchy
 
CXCD – Data Montior - allows you transfer financial data from the SAP General Ledger into the consolidations ledger
 
Database Listing of Records - In CXCD, click Goto/Database Listing of Records. This allows you to view the items imported from the General Ledger as well as manually posted items. You can limit by Posting Level which indicates the type of record being viewed.
 
CX20 – Consolidation Monitor - The Consolidation Monitor allows you to:
  • 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 !!!

In case of number range intervals for a specific document type for the years like 2009 & 9999. Some times client may ask to maintain only interval for all the years, in such case number ranges already available for that specific range should delete.
 
Fallow the below procedure :


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:

  1. In KEA5 / KEA6, type in the name of the characteristic/
    value field and click on the create / change button
  2. On the next screen, double click on the data element of your
    characteristic/value field
  3. 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  

  1. It is a base ledger, which updates the cost center and consolidation.
  2. You can define only one ledger as the leading ledger – SAP provides the leading ledger "0L".
  3. The currency of the leading ledger is always used as the first currency.
  4. The leading ledger is integrated with all subsidiary ledgers.
  5. Only the values from the leading ledger are sent to CO.
  6. The leading area in Asset Accounting (depreciation area 01) must be posted to the leading ledger.
  7. Leading ledger uses the (additional) local currencies assigned to the company code.
  8. Leading ledger uses the GL Total Table: FAGLFLEXT.

 

Non-leading ledgers  

  1. Non-leading ledgers are activated by company code.
  2. You can define additional currencies that deviate from those used by the leading ledger.
  3. 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.
  4. 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.
  5. You can also define a posting period variant that differs from the leading ledger.
  6. Separate document types and number ranges can be defined for non-leading ledgers by users, to ensure continuity in ledger numbering.
  7. Non-leading ledger updates the profit center, segment.
  8. 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

In this activity, you make the specification that is necessary to be able to work in several company codes
with the same variant for open posting periods.

 

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

In this activity, you define your accounting principles.
Then you can assign the desired ledger group to the accounting principles.
For performance reasons, you can combine several different accounting principles in one entry;
for example, you create one accounting principle for IAS/US-GAAP.

  

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

In this IMG activity, you assign the variants to one or more company codes in which you have combined                              customizing settings for the real-time integration of Controlling with Financial Accounting.
If you assign no variant to a company code, no real-time integration is activated for that company code.

 

 

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

 

Only one document number interval can be defined for each document type in a company code.
The document number intervals in a company code must not overlap.
In this activity you define the number ranges which are to be used for the document types.

 

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

 

Only one document number interval can be defined for each document type in a company code.
The document number intervals in a company code must not overlap.
In this activity you define the number ranges which are to be used for the document types.

  

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

In this step, you specify an input tax indicator per company code.
Then the system uses this indicator when you post acquisitions that are not subject to tax.

 

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

In this IMG activity, you specify which additional characteristics you intend to apply for document splitting.
The additional characteristics are not relevant for General Ledger Accounting.
Instead, they are relevant for other application components (such as subcomponents in CO) that use documents transferred from General Ledger Accounting.

 

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