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