Tuesday, March 13, 2012

SAP Automotive Implementation in Sri Lanka

These days I’m involving in a SAP implementation. It’s an implementation in automotive industry.
SAP DBM (Dealer Business Management) going to implement first time in Sri Lanka. I’m directly involving in DBM implementation. It’s a new and interesting experience.

DBM is an industry specific solution in SAP (SAP IS auto solution).  This component supports the industry-specific sales and services processes of dealers and dealer organizations, as well as vehicle importers, authorized dealers, and OEM (Original Equipment Manufacturer)-dedicated vendors.
This includes handling of new and used vehicles sales, vehicle service (workshop process, warranty process, insurance process, etc…) and parts management.
Furthermore, it also supports horizontal integration between dealers. For example, members of dealer organizations can obtain an overview of the parts and vehicles in stock for the entire dealer organization.
As a dealer, you can manage an order from its creation, through its completion.
This is just an introduction on DBM, hope to update you further with the implementation experience.

Sunday, March 11, 2012

SAP FI- TFIN50- Book 1- Unit 2 -Master Data

clip_image002

  • Chart of accounts is a variant
  • You define the chart of accounts with a four character ID.
  • You define the individual components of the chart of account, for language, length of the G/L account number, group chart of accounts, status.

clip_image004

clip_image006

  • The length of the G/L account numbers can be from 1 to 10 digits.
  • If you enter a group chart of accounts in the chart of accounts, the system defines that you have to enter a group account number in the corresponding field in the G/L account definition.
  • A chart of accounts that is not yet completed can be blocked so that no company code can use it until it is ready.

clip_image007

Chart of Accounts According to Country Legislation

clip_image009

clip_image011

The Controlling component uses the same chart of accounts as the Financial Accounting component.

Chart of accounts segment contain:

  • Account number
  • Name of the account (as short and as long text)
  • Control fields (see the following graphics)
  • Consolidation fields
  • If the chart of accounts has not been translated into the appropriate logon language, the account name appears in the maintenance language.

clip_image013

  • You can search for account numbers using keywords.
  • You can define and change the layout of the tab pages for the individual processing of the G/L account master data.

Company Code Segment

clip_image015

You define the information that is relevant to each company code:

  • Currency
  • Taxes
  • Reconciliation account
  • Line item display
  • Sort key
  • Field status group
  • House bank
  • Interest calculation information

You can display texts using the report .Account Assignment Manual.

Balance Sheet and P&L Statement Accounts

clip_image017

These two types of accounts are treated differently in the closing procedure.

  • For balance sheet accounts, the balance is carried forward to the same account.
  • For profit and loss statement accounts, the balance is carried forward to a retained earnings account and the profit and loss statement account is set to zero. A key (for example, X) is assigned to the account to which the balance is carried forward. You enter this key in the field "P&L Statement Type" in the chart of accounts segment.

clip_image019

Account Group

clip_image021

clip_image023

clip_image025

By assigning a number range to an account group, you can ensure that accounts of the same type are within the same number range. Number intervals for G/L account master records can overlap.

You must enter the account group in the chart of accounts segment.

clip_image027

· The field status enables you to control the display and maintenance of an account's master data.

· Certain fields are grouped together and their field status is valid for the entire group, for example, interest calculation indicator, interest cycle, and last interest calculation key date.

· The fields Account Currency and Field Status Group are always required fields. This status cannot be changed.

· Fields that are hidden may still contain values that are taken into consideration.

Priority in the field status

  • Hide
  • Display
  • Required entry
  • Optional entry

Reconciliation Accounts - general ledger accounts assigned to the business partner master records to record all transactions in the sub-ledger.

You define a G/L-account as a reconciliation account by entering one of the following account types in the field Reconciliation Account for Account Type:

  • D for Accounts Receivable
  • K for Accounts Payable

clip_image029

You cannot post amounts directly to reconciliation accounts.

If you want to look at the business partner accounts (customer / vendor) assigned to a specific reconciliation account, you can select the field for the reconciliation account in the customer or vendor list (RFDKVZ00 or RFKKZV00) via the free selections.

Line Item Display

The .Line Item Display field is a control field in the company code segment of an account.

You can use report RFSEPA01 to subsequently activate the line item display - read the documentation for this report before you execute it.

You should not activate the line item display for:

  • Reconciliation accounts
  • Revenue accounts
  • Material stock accounts
  • Tax accounts

clip_image031

Open Item Management

Accounts with open item management must have line item display activated.

Open item management is a prerequisite if you need to check whether there is an offsetting posting for a given business transaction.

You should use open item management for the following accounts:

  • Bank clearing accounts
  • Clearing accounts for goods receipt/invoice receipt
  • Salary clearing accounts.

You can only activate or deactivate open item management if the account has a zero balance.

Account in Local Currency

You can select one of the following currencies as account currency:

  • Local currency
  • Foreign currency

If the account currency is the local currency, the account can be posted to in any currency.

This applies whether or not line item display is activated.

clip_image033

Only Balances in Local Currency

Only Balances in Local Currency" checkbox is set in the master data record, transaction figures are only managed for amounts converted to the local currency.

You should select this field for clearing accounts where you want to clear accounts by assigning items with the same local currency amount with one another, without necessitating exchange rate difference postings.

The indicator must be set in cash discount and GR/IR clearing accounts.

It must not be set in reconciliation accounts for customers or vendors.

The indicator is usually set in balance sheet accounts that are not managed in Foreign currencies and not managed on an open item basis.

Accounts with a foreign currency as the account currency can only be posted to in this foreign currency.

G/L Account creation

  1. Create manually ( in two steps )
  2. Create G/L account by coping
  3. Date transfer (To reduce data entry, programs such as RFBISA00, Batch Input

Interfaces )

clip_image035

Group Chart of Accounts

The group chart of accounts must be assigned to each operational chart of accounts. After you have done this, the .Group Account Number. Field in the chart of account segments of the operational charts of accounts becomes a required entry field.

clip_image037

You must use a financial statement version for the group chart of accounts.

clip_image039

clip_image041

Because the company codes use different operational charts of accounts, you cannot carry out cross-company code controlling.

Country Chart of Accounts

clip_image043

The country chart of accounts number (alternative account number) is entered in every company code segment.

clip_image045

Since all company codes use the same operational chart of accounts for postings, you can carry out cross-company code controlling.

Customer / Vendor Accounts

Customer vendor account segments:

  1. One segment at client level that contains general data. This data can be accessed throughout the whole organization.
  2. A segment at company code level that contains company code-specific data.

Using reports RFBIDE10/RFBIKR10, you can transfer customer/vendor master data maintained in a source company code into another company code.

clip_image047

Any sales area that wants to do business with a customer has to create a sales area segment first. The sales area segment contains sales area-specific data.

Any purchasing organization that wants to do business with a vendor has to create a purchasing organization segment first

A complete customer account consists of the following three segments:

  • General data at the client level
  • Company code segment
  • Sales area segment

Can prevent the creation of duplicate accounts as follows:

  • Use the match code before you create a new account
  • Activate the automatic duplication check

clip_image049

Important fields are:

1. Search terms: You can enter an abbreviation for the customer/vendor name in these fields.

clip_image051

2. Corporate Group: Customers or vendors who belong to one corporate group can be grouped together by a user-defined group key. This group key can be used for running reports, transaction processing, or for match codes.

clip_image053

3. Accounting clerk: The name of the accounting clerk must be saved under an ID.

clip_image055

Line item display and open item management are configured as standard for every

Customer/vendor account.

· The IBAN contains a maximum of 34 alphanumeric characters and is structured differently in every country. (It usually contains the country code, bank key, and account number.)

When you enter an IBAN for new bank details, the system can generate the country-specific bank details for certain countries.

clip_image057

In Financial Accounting, once the customer/vendor account has been created, you can no longer change the account group.

Customer / vendor Number ranges must not overlap. Each number range can be assigned to one or more account groups.

clip_image059

clip_image061

You enter the customer-/vendor-specific data for one-time customers/vendors in the document during posting.

The layout of customer/vendor master data screens can be affected by several factors:

Account group-specific control – field status

Transaction-specific control - The transaction-dependent field status should be set to display for the .change. transaction if the field is not to be changed after it has been created, such as the .reconciliation account.

field, for example

Company code-specific control - You can control the field status for fields in the company code

segment of customer and vendor master records

If you do not want to use the transaction-specific or company code-specific control, set the field status for all fields to optional. Since this field status has the lowest priority, the account group-specific control is always used.

Dual control principle

If you define a field in the customer/vendor master record as .sensitive., the

corresponding customer/vendor is blocked for payment if the entry is changed.

clip_image063

Customer/Vendor Clearing

  • If a customer is also a vendor, or vice versa, the payment and the dunning program

can clear open items against each other

  • If you set the indicator Account Control and Status in the area Additional Selections in the report for the customer or vendor list when you print the report you can see the partner relationships for the respective customer or vendor.

clip_image065

clip_image067

Alternative Payer/Payee

At the client and company code level, you can enter an alternative payer/payee. The entry in the company code segment has higher priority than the entry at client

level.

  • If Alternative payer / payee is not a existing customer

clip_image069

If alternative payer/payee is an existing customer or vendor

clip_image071

clip_image073

Head Office/Branch

All items posted to a branch account are automatically transferred to the head office account.

Usually, dunning notices go to the head office and it is the head office that makes and receives payments.

clip_image075

if the Decentralized Processing field is selected in the head office master record, the dunning and payment programs use the branch account instead.

Bank Accounts

Every bank that is used in the system you have to create a bank master record.

Bank master records are stored centrally in the bank directory (table BNKA)

Every record is identified by the bank country and the bank key

Banks that your company uses are defined as house banks.

House bank contain

Bank master data, information for electronic payment transactions, bank accounts per house bank, and general ledger accounts per bank account.

Payment program uses the house bank ID and the bank types to determine the bank to be used

clip_image077

clip_image079

clip_image081

clip_image083

clip_image085

Bank master data can be created four ways:

  1. When entering bank information in the customer or vendor master record

clip_image087

  1. Using the Create Bank transaction in the Accounts Receivable/Payable ( FI03 )

clip_image089

  1. The bank directory can be imported from disk or tape using program RFBVALL_0, Country-Specific Transfer of Bank Data.

clip_image091

  1. Customers that use the lockbox function can create a batch input session that automatically updates customer banking information in the master record.

In the customer/vendor master record, the field “Bank Type” is used to distinguish between different banks.

When processing invoices, if the customer/vendor has more than one bank, the user can choose a bank by using the match code in the partner bank field.

clip_image093

Each bank account is reflected in the SAP ERP system by a combination of house bank ID and account ID. This combination is entered in a G/L account that represents the bank account in the general ledger

The accounts can be identified by an account ID which is unique per house bank.

The bank account data contains the number of the account at your bank, the account currency, and the relevant G/L account.

For every bank account, a G/L account must be created. Both accounts have to have the same account currency.

True or false?

1. Reconciliation accounts are updated on a daily basis.

Answer: False

The reconciliation accounts are updated real time.

2. You can always display the line items of a G/L account.

Answer: False

You can only display the line items if the account is managed with line item display.

3. G/L accounts with open item management must have line item display

Answer: True

You cannot define a G/L account with open item management without selecting the Line item display option.

4. G/L accounts that are managed in local currency can only be posted to in this currency.

Answer: False

G/L accounts in local currency can be posted to in any currency.

5. G/L accounts that are managed in a foreign currency can only be posted to in this foreign currency.

Answer: True

If you select a foreign currency as the account currency, you can only post amounts in this foreign currency to this account.

6. Because the company codes use different operational charts of accounts, you cannot carry out cross-company code controlling.

Answer: True

You can carry out cross-company code controlling if each company code uses the same operational chart of accounts.

1. The customer/vendor accounts must always be maintained centrally.

Answer: False

Customer/vendor accounts can be maintained centrally or decentrally.

2. One number range can only be assigned to one account group.

Answer: False

A number range can be assigned to several account groups.

Saturday, March 10, 2012

SAP FI–TFIN50 - Book 1 - Unit 1- Organizational Units

Organizational Units in my SAP ERP Financials

clip_image002
The use of business areas is optional.

Each client is an independent unit with separate master records and a complete set of tables and data.

clip_image004

You have to select a four digit alphanumeric key as the company code key.

clip_image006

When you define a business area, you only have to enter a four digit alphanumeric key and a short description.

> If you need a company code for a country that has a country template, you can use the country installation program to copy the country-specific tables from the country template to company code 0001.

> The country installation program not only creates a country-specific company code template but also a country-specific template for controlling areas, plants, purchasing organizations, sales organizations, credit control areas, financial management areas, and so on.

clip_image008

clip_image010

clip_image012

Fiscal year variant

clip_image014

To assign business transactions to different periods, you have to define a fiscal year with posting periods

The fiscal year variant contains the definition of posting periods and special periods.

  • In total, you can define 16 periods.
  • If the posting date falls within the last normal posting period, you can post the transaction in one of the special periods.
  • The fiscal year variant does not specify whether a period is open or closed. This data is managed in another table. The fiscal year variant only defines the number of periods and their start and finish dates.

Year-Independent Fiscal Year Variant

clip_image018

Each fiscal year of a fiscal year variant uses the same number of periods, and the posting periods always start and end on the same day of the year,- year-independent

  • A non-calendar year can have between 1 and 16 posting periods.
  • Fiscal years are normally year-independent.

clip_image020

Non – calendar year – (Year shift)

clip_image022

Year-Specific Fiscal Year Variants

clip_image026

  • The start and end dates of the posting periods for some fiscal years are different to the dates for other fiscal years.
  • Some fiscal years use a different number of posting periods.
  • If one year of a fiscal year variant has less posting periods than the others, it is called a shortened fiscal year

clip_image028

clip_image030

Currencies

  • A currency key must be assigned to every currency used. Each currency key can have a validity date.
  • These different exchange rates can be used for various purposes such as valuation, conversion, translation, and planning.

clip_image035

You may use several SAP currency keys for the same ISO code. To ensure a unique assignment of the ISO code to an SAP currency key, one of the SAP currency keys must be selected as the primary currency key for the ISO code.

Enter the ISO code - If you do not already use the global standard currency key as the currency key

Currency Key

Translation Ratios

clip_image037

Base Currency
You can use more than one base currency per exchange rate type.

Exchange rate type uses special translation model – If you set this indicator, you must specify a reference currency.

Exchange rate type uses fixed exchange rates

Exchange rate type whose average rate is used to determine the selling rate.

clip_image045

If foreign currency translation is necessary between many different currencies, you can simplify the maintenance of the exchange rates by specifying a reference currency. You then only have to specify for this exchange rate type the rates of all currencies in relation to the reference currency. All foreign currency translation is then carried out in two stages via the reference currency.

Exchange rate type whose average rate is used to determine the the buying rate.

Indicator: Calculation allowed with inverted exchange rate - Indicator that in the case of a missing exchange rate entry in the system for the required translation from one currency into another, the inverted exchange rate relationship may also be used.

Tools use to maintaining exchange rates:

  • Inversion (of the tools available, inversion is the oldest and is seldom used today)
  • Base currency
  • Exchange rate spreads

Transfer external market data - You can automatically update the exchange rate table by uploading an input file in Multicash form.

clip_image047

Transferred real-time exchange rate using a data feed interface - Remote Function Call (RFC) creates a direct connection between an external system and the SAP.

Efficient combination of the exchange rate tools is:

  • Using a base currency for the average rate (M)
  • Using the exchange rate spreads to calculate the buying and selling rates (B and G)

Direct/Indirect Quotation of Exchange Rates

clip_image049

  • The use of indirect quotation is neither application nor country-specific - it affects all the components in which exchange rates are used.
  • In direct quotation, one unit of foreign currency is quoted for the local currency, whereas in indirect quotation, one unit of local currency is quoted for the foreign currency.

Direct quotation - One unit of foreign currency USD costs the displayed number of units of local currency

Indirect quotation - For one unit of the local currency EUR you will receive the displayed number of units of the foreign currency.

clip_image051

Exchange rate spared

clip_image053

Work list to update Exchange rate:

clip_image055

With work list following can be achieved:

  • Only the relevant exchange rates can be maintained. You can also assign authorizations for work lists.
  • Only the relevant quotation can be maintained.
  • The work list is smaller and therefore clearer.
  • Parallel processing of different work lists is possible.

Design of exchange rate in different quotations

  • (blank, without a prefix) * for direct quotation exchange rates
  • ./. for indirect quotation exchange rates

clip_image057

True or false?

1. You can assign a business area to a company code directly.

Answer: False
Business areas are not directly assigned to company codes. This makes it Possible to evaluate transaction figures for each business area beyond the boundaries of the company code too.

First steps in Fiori launchpad – User Guide

With new S/4 HANA, users get a   new user experience with Fiori apps. This document covers few useful tips on Fiori launchpad tile m...