第 97 页 / 共 184 页
Click on
Update the following:-
第 98 页 / 共 184 页
Click on
Click twice
Click on
Now We can see the that for transaction ESE GL Account 119905
has been Assigned.
Click
Click on
第 99 页 / 共 184 页
3. Creating G L account codes in the Chart of accounts
3.1 Create GL account in Chart accounts and company code
GL – General Ledger
Menu Path
SAP menu (cid:198) Accounting (cid:198) Financial Accounting (cid:198) General
Ledger(cid:198) Master Records(cid:198) Individual Processing
Transaction Code
FS00 – Centrally (6 Tabs)
OR
FSP0 - In Chart of Accounts (3Tabs)
FSS0 - In Company Code (3Tabs)
The GL Code in SAP has two segments:-
1) The Chart of accounts segment – The chart of account
segment is at client level. Any company code wishing to use
the GL code can extend it and create a company code view
2) The Company code segment – A company intending to use the
GL code from chart of accounts has to create the company
code view so that it can post to the GL code.
This way there are 2 methods of creating GL codes in SAP:-
1) One step creation – Here We create both the chart of accounts
view as well as the company code view in one step
2) Two-step creation – We first create the chart of accounts view
in the first step. In the second step we create the company
code view.
We will see the GL code creation using the one step creation:-
Click on and enter the following
第 100 页 / 共 184 页
第 101 页 / 共 184 页
第 102 页 / 共 184 页
Click to save GL Code
Below screen shows creation of RM consumption GL a/c.
第 103 页 / 共 184 页
第 104 页 / 共 184 页
Click to save GL Code
第 105 页 / 共 184 页
第 106 页 / 共 184 页
4. Configuration for GL Automatic clearing: -
4.1 Automatic Clearing
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Open Item Clearing (cid:198) Prepare Automatic
Clearing
The program for clearing clears the open items that are grouped
together if their total balance assigned equals to zero in local and
foreign currency.
We can enter the criteria for grouping an ledger account's open
items for automatic clearing.
The following standard criteria has to entered properly,
a) Account type
b) account number or a number interval
We can also enter a further five criteria.
We select these five additional criteria from the fields in table
BSEG or BKPF. If possible, We should choose fields that are also
contained in table BSIS (G/L accounts), BSID (customers), or BSIK
(vendors).
Automatic clearing is required for GR/IR clearing accounts and
Bank accounts; further automatic clearing is also required for
Vendors and customers
Select the existing entries in SAP
第 107 页 / 共 184 页
Click on enter the chart of accounts USCA
Update the following:-
第 108 页 / 共 184 页
The account type is D for debtors K for creditors and S for General
Ledger.
The first criterion specified is the assignment field for account
types.
These criteria’s can be selected based on the individual company
requirements. The GRIR account can be cleared using the criteria
purchasing document and line item therefore also select EBELN
(purchasing document)
Click
第 109 页 / 共 184 页
4.2 Define Tolerance Groups for G/L Accounts
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Open Item Clearing (cid:198) Clearing Differences
(cid:198) Define Tolerance Groups for G/L Accounts
Tolerance groups define the limits for each ledger account clearing
within which differences are accepted and automatically posted to
predefined accounts.
These predefined groups can be assigned in the general ledger
account master record.
第 110 页 / 共 184 页
Click on
Update the following:-
Click on
第 111 页 / 共 184 页
4.3 Assigning accounts for GL Clearing Differences
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Open Item Clearing (cid:198) Clearing Differences
(cid:198) Create Accounts for Clearing Differences
Here We define the accounts to which these differences should
be posted.
We can define the limits within which differences are accepted
for G/L account clearing.
Enter chart of accounts USCA
Click on to save the rules
Click on to update the posting keys
第 112 页 / 共 184 页
Update the following:-
Click
第 113 页 / 共 184 页
And update GL code 470706, which is clearing difference account
(G/L). It is an expense account
Click
第 114 页 / 共 184 页
5. Configuration for Foreign currency Valuation
Here, we define the specifications required for the valuation of
foreign currency balances e.g. Bank accounts holding foreign
exchange and Open items in foreign currency e.g. Customers and
Vendors
第 115 页 / 共 184 页
5.1 Define Valuation methods
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Closing (cid:198) Valuating (cid:198) Foreign Currency
Valuation (cid:198) Define valuation methods
Transaction Code
(OB59)
Foreign Currency Valuation can be defined as a procedure for
determining at a key date the value of the current assets and
liabilities posted in foreign currency.
Assets and liabilities are valuated using the unit account method of
valuation which means that the individual open items are valued.
If this is not possible (because the account is not managed on an
open item basis) the balance of the account is valuated instead.
Here, for unrealized gains or losses we define the valuation methods
for the open items. With the valuation method, we group
specifications together, which we need for the balance and
individual valuation. Before every valuation run, we mention the
required valuation method.
M is the average rate of any foreign currency.
SAP uses exchange rate type M to value all foreign currency items.
Various valuation methods are provided by the SAP.
We can create our own key starting with Z.
第 116 页 / 共 184 页
SAP provides following valuation methods: -
Let us create our own valuation methods.
Click on
Update the following:-
第 117 页 / 共 184 页
Relevant for open items
Exchange rate type B is Bank selling and Exchange rate G is bank
buying rate.
In the valuation procedure various configuration options are
available
The valuation is only displayed if the valuation
difference between the local currency amount and the valued
第 118 页 / 共 184 页
amount is negative that is an exchange loss has taken place. The
valuation is carried out per item total.
The valuation is only displayed if, as a
consequence, the new valuation has a greater devaluation and/or a
greater revaluation for credit entries than the previous valuation.
The valuation is calculated per item total.
If We select this procedure, revaluations are also taken
into consideration.
If We select this method system only does a revaluation
if applicable but does not do devaluation where there is exchange
loss.
If We select this parameter then the open items are
valuated at the acquisition price. This way the valuation difference
is set to zero. The old valuation method is reset. The account
determination is reversed: The revenue that arises is posted to the
expense account.
Exchange rates are types are attached to the valuation method.
If We select this field, the account
balance/group balance in the relevant foreign currency is used to
determine the exchange rate type. This is relevant for account
balance revaluation
A document type SA is attached to the valuation method.
Let us configure another valuation method for Bank Balance:
Click on
第 119 页 / 共 184 页
Click
第 120 页 / 共 184 页
5.2 Assign GL accounts for Foreign Currency valuation
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Closing (cid:198) Valuating (cid:198) Foreign Currency
Valuation (cid:198) Prepare Automatic Postings for Foreign Currency
Valuation
Transaction Code
(OBA1)
Exchange rate difference in foreign currency balances e.g. bank
accounts held in foreign currency
Double click on KDB Line
第 121 页 / 共 184 页
Enter Chart of accounts USCA
Here we will enter the following
Exchange rate difference key: Can be kept blank or we can enter
a key with 4 digit e.g. 0001. In case We create this exchange rate
key then the same has to be updated in the GL code of the foreign
currency account i.e. control data tab which has the field exchange
第 122 页 / 共 184 页
rate difference key. Only when it is attached the system will revalue
the foreign currency account.
Expense account: We need to enter the expense GL code for
unrealized foreign exchange loss. The loss on revaluation is
unrealized and will be automatically reversed in the next month e.g.
472002 Unrealized Exchange Gain/Loss – Trade
E/R gains: We need to enter the revenue GL coded for Unrealized
Foreign exchange gain. The loss on revaluation is unrealized and
will be automatically reversed in the next month e.g. 472002
Unrealized Exchange Gain/Loss – Trade. We can have a separate
account or the same account.
Exchange rate difference in open items e.g. Accounts
Receivable and Accounts Payable
第 123 页 / 共 184 页
Double click on KDF Line
Here We will enter the GL code for Accounts receivable or
Accounts Payable (the reconciliation account). We can enter
different GL codes for each currency code and currency type.
Alternatively if We do not want different GL codes for each
currency We can keep them blank
Enter chart of accounts USCA in the pop up
Click on and update the following:-
第 124 页 / 共 184 页
119020 is the GL code for Account Receivables trade 3rd parties
Loss: Here We enter the GL code for exchange loss, which is
realized
Gain: Here We enter the GL code for exchange gain, which is
realized.
Val. loss 1: Here We enter the GL code for unrealized exchange Loss
on revaluation of open items i.e. accounts receivable and accounts
payable
第 125 页 / 共 184 页
Val. gain 1: Here We enter the GL code for unrealized exchange gain
on revaluation of open items i.e. accounts receivable and accounts
payable
Bal.sheet adj.1 : Here We enter the GL code to which the receivable
and payables adjustment is posted during foreign currency
valuation of open items.
The SAP System supports two valuation areas in parallel. This
account is used during valuation of the first valuation area.
The first valuation area reflects the local view of the Company code,
the second valuation area takes the corporate policy for the
valuation into consideration.
第 126 页 / 共 184 页
6. Configuration for regrouping postings
6.1 Define Adjustment Accounts for GR/IR clearing
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Closing (cid:198) Regrouping (cid:198) Define
Adjustment Accounts for GR/IR Clearing
Transaction Code
(OBYP)
Whenever we receive goods that have not been invoiced yet or
whenever we receive invoices for goods that have not been delivered
yet, it is posted to the goods receipt/invoice receipt (GR/IR) clearing
account.
The goods receipt/invoice receipt (GR/IR) clearing account is a
provision account.
Here we define the numbers of the adjustment and target accounts
for the automatic postings for the GR/IR clearing account.
Transfer postings have to be made at the balance sheet date to
reflect the goods invoiced but not delivered and the goods delivered
but not invoiced. Transaction code F.19 analyzes the GR/IR
clearing account and posts adjustments entries for outstanding
amounts to adjustment accounts. It makes the offsetting entry to
the account for goods delivered but not invoiced or to the account
for goods invoiced but not delivered (target account).
第 127 页 / 共 184 页
Double click BNG
Update the following:-
第 128 页 / 共 184 页
Update the following: -
Reconciliation account: Enter the GL code 219914 i.e. GR/IR
clearing account (Goods Receipt/Invoice receipt)
Adjustment account: Enter the GL code 219915 i.e. GR/IR
correction account
Targ. Acct: Enter the GL code 119522 GR/IR Invoiced but goods not
yet received
Click Save
第 129 页 / 共 184 页
Double click GNB
Enter chart of accounts USCA if the pop up comes
第 130 页 / 共 184 页
Update the following: -
Reconciliation account: Enter the GL code 219914 i.e. GR/IR
clearing account (Goods Receipt/Invoice receipt)
Adjustment account: Enter the GL code 219915 i.e. GR/IR
correction account
Targ. Acct: Enter the GL code 219916 GR/IR Shipped not invoiced
Click Save
第 131 页 / 共 184 页
7. Creating Balance sheet and Profit and Loss account
7.1 Define Financial Statement Version (FSV)
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting(cid:198)
Business Transactions(cid:198) Closing (cid:198) Documenting (cid:198) Define
Financial Statement Versions
Financial Statement Versions means a hierarchical positioning of
G/L accounts and this positioning can be based on specific legal
requirements for creating financial statements.
We can create number of financial statement versions for the chart
of accounts, one for the local reporting, and one for parent
reporting. In each version we can group the GL codes differently as
required for the reporting purpose. We define FSV because we need
to represent our balance sheet and profit and loss account in a
particular manner.
We can define versions for a specific chart of accounts, for a group
chart of accounts, or without any specific assignment.
We then determine the financial statement items for the version
which we have created for our company code.
We assign groups of accounts to the items at the lowest levels of the
hierarchy. We can select the criteria that determine which items the
accounts are displayed in. For example, accounts or groups of
accounts can be assigned to particular items based on their
balance.
第 132 页 / 共 184 页
Other way, We can also assign functional area intervals at the
lowest level of the structure, instead of account intervals. Either
account intervals or functional area intervals can be assigned to a
financial statement item. We must explicitly define financial
statement versions to which functional areas are assigned as such.
We do this by setting the "Fun. area allowed" indicator. This
financial statement version can then also be used by the notes to
financial statement in the G/L account information system.
Click on or to start creating FSV from scratch. In case
We want to copy from existing FSV We need to position the cursor
on the FSV as source FSV e.g.
and then
click on and update the following parameters
第 133 页 / 共 184 页
And then click on
We will cover here Creating FSV from scratch.
Click on
Give the code for the FSV e.g. USCA and name for the version.
Give the maintenance language code e.g. EN (for English)
If the item keys are required automatically then We need to select,
else deselect it.
Enter the chart of accounts USCA
第 134 页 / 共 184 页
Click on
Click on
The above nodes are created automatically:-
P+L Result gives profit and loss in income statement
Net result: profit profit carried forward to balance sheet
Net result: loss Loss carried forward to balance sheet
Position the cursor on the node USCA and then
第 135 页 / 共 184 页
Click on
Update the following information and click the continue button
第 136 页 / 共 184 页
Thereafter click and click on
and then click on and click on Reassign
Select subordinate
第 137 页 / 共 184 页
Similarly assign the various nodes to the respective elements which
should finally look like this.
第 138 页 / 共 184 页
Double click on and update the
following
第 139 页 / 共 184 页
Thereafter change the description of item
by double clicking and updating the following information
第 140 页 / 共 184 页
Rename everything to look like this
第 141 页 / 共 184 页
To create further nodes below Assets proceed as follows:-
Position the cursor on and click on
and update the following information
第 142 页 / 共 184 页
After updating Wer FSV will look like this
第 143 页 / 共 184 页
Create further nodes as follow under Current assets
第 144 页 / 共 184 页
Under Cash & Cash Equivalents create further nodes 11000 Petty
cash and 11100 Bank – Current accounts.
After creating all the above nodes the FSV configuration will appear
like this
第 145 页 / 共 184 页
Now we will see how to assign GL accounts to the the node
Bank – current accounts
Place the cursor on the node and click on
and update the bank GL codes
第 146 页 / 共 184 页
D and C are debit and credit balance of the account.
After assigning the accounts FSV will look as follows:-
第 147 页 / 共 184 页
Here assuming that if this bank account is an overdraft account i.e.
Bank balance can become a debit or credit balance. In case bank
balance becomes credit i.e. negative then it should be regrouped to
the liabilities side of balance sheet under current liabilities.
第 148 页 / 共 184 页
We will similarly create the various nodes under liabilities which
appear as shown below:-
Now to regroup the balance from Bank – Current assets node to the
current liabilities node we proceed as follows:-
Position the cursor on item in Bank -Current
accounts on Current asset side and click on Select , the bank
accounts get highlighted as follows:-
Thereafter position the cursor on the
in bank overdraft under current
liabilities and then click on Edit (cid:198) Debit/credit shift (cid:198) Define
第 149 页 / 共 184 页
Click since 114500 should be debit and 2114500 node should
be credit
The display will appear as follows:-
The item should be placed
under Shareholder's Equity. To do so proceed as follows:-
第 150 页 / 共 184 页
Position the cursor on and
click on Select and position the cursor on
and click on Select .
Thereafter click on the item and click on
Reassign and select subordinate
Similarly, We need to create various node under Income statement
and assign GL account codes to each of the lowest level node.
Finally after assigning GL code to each node, we need check the
non assignment of GL codes to our company code.
Proceed as follows:-
Click on
And update company code 1100
第 151 页 / 共 184 页
This step will give We list of accounts not assigned to the various
nodes
After assigning the non assigned GL codes to various nodes The
FSV is ready to be used by company code 1100.
第 152 页 / 共 184 页
8. FI Integration with other modules
8.1 Integration with Overhead Cost Controlling
When a reconciliation ledger is implemented in the CO, We need to
define this account. Postings will happen from the controlling
module to the FI in order to balance FI.
Scenario:-
Let’s assume controlling allocations has happened between 2
company codes. Since allocation has taken place in the controlling
module, there will be no corresponding posting in FI in both the
company codes.
In order that posting happens in both the company codes in FI, We
need to configure this setting.
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting (cid:198)
Business Transactions (cid:198) Integration (cid:198) Overhead Cost Controlling
(cid:198) Define Accounts for Overhead Cost Controlling
Transaction Code
(OBYB)
Enter chart of accounts USCA and Click on Save
Enter GL code 450020 Reconciliation Ledger Adjustment Account
第 153 页 / 共 184 页
Click
第 154 页 / 共 184 页
8.2 Integration with Materials Management
In this topic we will learn how the integration within FI MM, and SD
takes place .We will also learn how accounting entries are posted
automatically and how do we configure them?
There are certain simple things We need to understand to know
how this integration happens.
First all Materials in SAP should have a material master.
This material master has various views right from Basic views to
Purchasing views, production, sales and distribution and
accounting and controlling views. We will not get into the detail of
Material master at this stage but it would suffice for us to
understand that Material Master is the heart of all integration.
In the accounting view of Material master amongst other values we
have a Valuation Class field. This Valuation class is the vital link
which ensures that Accounting documents are posted
automatically. Every material will have a valuation class field.
We can go to transaction code mm03 put any material no and click
on Accounting 1 view on which We will find the Valuation Class
field.
Examples of Valuation Class could be Finished Goods,Semi
Finished goods, Raw Material etc
The combination of this Valuation Class+ the Movement
Type(which I have defined below) helps in determining the Gl
accounts. Read this statement twice to understand how gl accounts
are automatically updated
What is a Movement Type?
第 155 页 / 共 184 页
All Material movements in MM happen with respect to a Movement
Type.
For eg Goods receipt is defined with movement type 101
Goods issue to production order is defined with movement
type 261
Scrapping of goods is defined with movement type 551
Goods delivered to the customer with movement type 601
Initial upload of stock is defined with movement type 561
SAP helps us to have different gl accounts for the various
movements for the same material by linking this movement type to
a transaction key. So where do we do we go and fit in all the
different Gl accounts which we require?
Before we get into that let us take an example of a movement type
and see how Gl accounts are automatically updated. If We are with
me till now lets move ahead. If not I suggest We read the above page
once again. All right lets get going dear friends.
Quick recap.
Material Master->Valuation Class-(cid:198)Movement Type-Transaction
key.
Stick in all the gl accounts at this place. How we do this will see
very shortly.
Let us now understand a few MM transactions and its accounting
integration:-
1) Goods Receipt of Raw Material against a purchase order:-
Movement type for goods receipt against purchase order is 101.
第 156 页 / 共 184 页
The accounting entry posted is as follows:-
Inventory of Raw Material Debit
GR/IR (Goods Receipt/Invoice Receipt) Credit
The GR/IR is a provision account in SAP.
The configuration to be done for this entry is as follows:-
Menu Path
IMG (cid:198) Materials Management (cid:198) Valuation and Account
Assignment (cid:198) Account Determination (cid:198) Account Determination
Without Wizard (cid:198) Configure Automatic Postings
Transaction Code
(OMWB)
Or
Transaction Code
(OBYC)
第 157 页 / 共 184 页
As We see above the second column contains all the Transaction
keys where We need to stick the Gl accounts. So lets see for the
goods receipt transaction what do we do.
We need to update the BSX transaction key with the GL code
Inventory of Raw material account.
Double click BSX and select Valuation modif. and valuation class.
第 158 页 / 共 184 页
Valuation modif. - Should be selected if the valuation grouping code
is active in the Materials Management module and if separate GL
codes are desired plantwise. Even if it is not required currently, still
it is a better option to select.
For the GR/IR account We need to update the WRX transaction key
with the GL code GR/IR account.
A very important point from now on. Every accounting entry with
respect to a material will have a impact on the inventory. So one
side of the posting (either a debit or a credit) will always be taken
from the BSX field We have defined above. The second side of the
posting will be determined based on Wer movement type which in
the above case was a GR/IR.
If We understood example 1 We will understand all the other
examples. As the methodology of finding Gl accounts is the same.
第 159 页 / 共 184 页
So dear friends if We want to learn SAP quickly We should learn
how the things are integrated and not go through reams of material
and keep on studying. Understand those vital areas and We will
learn quickly. Alright lets move on
We will go through more examples below:
2) When Raw material is issued to the production order.
Movement type used for posting the above transaction is 261 –
Goods issue to order
The accounting entry generated in the system is:-
Raw material consumption Debit
Inventory of Raw Material Credit
The transaction Key GBB needs to be updated. GBB key is used for
various offsetting posting entries. Within GBB transaction there are
various account grouping (general modification). In this case We
need to update general modification VBR with the Raw Material
consumption account.
第 160 页 / 共 184 页
Click on
第 161 页 / 共 184 页
Click on
3) When Initial stock is uploaded for Raw Material
Movement type used for posting – 561 (Initial stock upload)
The accounting entry generated is as follows:-
Inventory of Raw Material Debit
Stock data takeover account Credit
The transaction key GBB needs to be updated. General modification
Key BSA needs to be updated with the GL code Stock data
takeover account
第 162 页 / 共 184 页
.
4) When goods receipt is made for finished goods against a
production order
Movement type used for posting – 101(GR agst prod order)
The accounting entry generated is as follows:-
Finished goods Debit
Change in Finished goods Credit
In transaction key BSX for the valuation class finished goods we
attach the Finished goods GL code.
For change in Finished goods we update transaction key GBB and
general modification key AUF.
5) When goods issues are posted for sales:-
Movement type used for posting – 601
Accounting entry posted:-
Cost of goods sold Debit
Inventory of Finished goods Credit
For cost of goods sold transaction key GBB is updated with general
modification key VAX
6) When goods are scrapped:-
Movement type use for posting – 551
第 163 页 / 共 184 页
Accounting entry posted:-
Raw material scrapped Debit
Inventory of Raw Material Credit
The Raw Material scrapped account is attached to transaction key
GBB and general modification key VNG
7) When goods issued to sampling for Quality
Movement type used is 331
Raw Material consumption Debit
Inventory raw material Credit
Raw Material consumption account is attached to GBB and general
modification key VQP is used.
If We noticed lot of account modifiers in transaction key GBB are
used in various movement type. It is difficult to remember the
standard account modifiers. In that case we can also use the
Simulation mode. This helps us in identifying what are the general
modification (account modifiers) used in GBB:-
Use the following path:-
Menu Path
IMG (cid:198) Materials Management (cid:198) Valuation and Account
Assignment (cid:198) Account Determination (cid:198) Account
Determination Without Wizard (cid:198) Configure Automatic Postings
Transaction Code
OMWB
第 164 页 / 共 184 页
We can select the application area as follows:-
第 165 页 / 共 184 页
Thus We can do a simulation for Inventory management movements
or also a simulation for invoice verification transactions.
Let us do a simulation for Inventory management movements.
第 166 页 / 共 184 页
Now we select the input mode
Here we can select the input of material number or input of
valuation class.
We will select the input of valuation class, as it easier to enter
valuation class rather than material number. But if We want to be
more specific We can select the input of material number.
Click
Further we will also select Account check
第 167 页 / 共 184 页
Here we select, whether we want check of referenced G/L accounts
in the company code. Currently we will not select this.
Click
Click
Update the following:-
第 168 页 / 共 184 页
Double click so that it becomes blue
第 169 页 / 共 184 页
Click
Now here it shows the offsetting entry posting and the required
account modifier. In this case the general modification required is
VBR.
第 170 页 / 共 184 页
Thus simulation helps us in finding the general modification
required for transaction key GBB and the general modification for
transaction key PRD (price difference).
Let us now check the general modification key required for
movement type 601 for finished goods.
Update the following:-
Double click
第 171 页 / 共 184 页
Click
Here we notice that general modification key required for 601 is
VAX
第 172 页 / 共 184 页
8.3 Integration with Sales and Distribution
FI – SD account determination:-
All Billing transactions happening in the Sales and distribution
module will result in FI postings.
All accounting entries with respect to the billing will have one side
of the account as a Customer or receivable and the other side to be
a revenue account
Example:
Customer –Dr
To Revenue Account- Cr
We have to bear in mind that the customer account gets picked up
from the customer master data . All we need to do is to configure
the revenue account or the discounts and surcharges
Where and how do we do this?
We make the allocation for each of these through access sequences.
Access sequence is nothing but SAP’s terminology of
determining the Gl accounts. SAP provides the following six
ways of determining the Gl accounts in SD.
• Application (key for the Sales and Distribution application)
• Account determination type
• Chart of accounts (from the FI System
• Customer account assignment group
• Materials account assignment group
第 173 页 / 共 184 页
• Account key
The allocated accounts are used to post revenues, surcharges and
discounts automatically.
Menu Path
IMG (cid:198) Financial Accounting (cid:198) General Ledger Accounting (cid:198)
Business Transactions (cid:198) Integration (cid:198) Sales and Distribution(cid:198)
Prepare Revenue Account Determination
or
Menu Path
IMG (cid:198) Sales and Distribution (cid:198) Basic Functions (cid:198) Account
Assignment/Costing(cid:198) Revenue Account Determination (cid:198) Assign
G/L Accounts
Transaction Code
(VKOA)
The account determination in SD happens through an access
sequence which can be seen in the below table.
第 174 页 / 共 184 页
The system goes about checking for the gl account(which we will
stick in here We will see more of that later) from more specific
criteria to less specific criteria.
Thus We can maintain different GL codes for each combination
of the above table entry.
This is how SAP will determine the revenue account:
It will go through first table entry CustGrp/Material grp/ account
key. If any Gl account is maintained here the system will then go to
the transaction data of the particular billing document and see
whether such a combination of Customer group and material group
exists if it does it will pick that relevant Revenue account and post
第 175 页 / 共 184 页
the accounting document . Iif it does not it moves to the next
combination in the table which is Customer group/account key and
so on and so forth
Customer grp is maintained in the Sales view of the customer
master.
Material grp is maintained in the Sales view of the material master.
Account key is maintained in the pricing procedure for that
condition type.
The last option it checks is account key entry
We will now maintain the Gl account for the combination of
Material Grp/account key
Double Click
AAG is the material grp. We maintain this since we want it to post
to a different GL code as Sales 3rd parties.
Click on
第 176 页 / 共 184 页
Click on
That’s it . The system will look into this table see this combination
and if the relevant combination exists in the transaction it will debit
the customer account and credit this account 800000.
As simple as it is. So basically the FI-Sd integration is for picking
up the revenue accounts or the discounts and surcharges.
The account key determines whether it is a revenue or a surcharge
or discount. Examples of some are given down below:
第 177 页 / 共 184 页
Various account keys are available
Let us now maintain for the table entry account key. And post to a
different GL code.
Click on
And update the following information
App: V (Sales/distribution)
Cond type: KOFI (Account determination)
Chrt/accounts: USCA
SOrg: Sales organization
Act Key: ERL
GL account no: 810203
第 178 页 / 共 184 页
Click on Save
So We are done.
It is also useful to know a bit of the configuration of the Sales and
Distribution.
The account keys are attached to the condition type in the sales
pricing procedure.
Let us see the sales pricing procedure.
第 179 页 / 共 184 页
Menu Path
IMG (cid:198) Sales and Distribution (cid:198) Basic Functions (cid:198) Pricing
(cid:198)Pricing Control (cid:198) Define And Assign Pricing Procedures
Double click
第 180 页 / 共 184 页
Select
Double click
Here we see that account key ERL and ERS is attached to various
condition types.
第 181 页 / 共 184 页
第 182 页 / 共 184 页
NOTE: Transaction Codes are an important and integral part of the
whole SAP functioning. Once you get acquainted with the SAP
configuration, Transaction Codes will help you to function or
maneuver in faster and accurate manner.
Here are two tips in relation to Transaction Codes,
1) How to search the menu path for a particular Transaction
Code
a) Type Search_sap_menu in Menu field and execute
b) Enter the Transaction Code in the search text entry and enter.
You will get the menu path for a particular Transaction Code,
sometimes there might be more than one menu paths available out
of which you have to choose the right one according to our
requirement.
2) How to search for a Transaction Code
a) Type SE16 in Menu field and execute
b) Enter table name TSTC and enter.
c) Enter a search word along with *,
e.g. FS* which will give you all the transactions starting with FS
and text of that transaction in the last column of that report.
So for example if you are searching for GL creation but you only
know that it starts with F or FS but not the whole transaction than
in the above statement you can find out the transaction as required
by you i.e. FS00
第 183 页 / 共 184 页
So that’s it then my dear friends. I hope you enjoyed reading it. All
.
our packs are shipped thru FedEx and reaches you in three
days time. One more thing this configuration pack is compatible
with version 4.7, version 5.0 and 6.0 So you really do have to worry
about the version at all.. We have taken care of that… Also all
future version changes will be provided as free updates to you. So
you can sit back relax and play the music …. Get the SAP FICO
Complete Configuration pack right now and join the elite league of
thousands of successful SAP FICO consultants.
Prosperity and Success Be On To You .
http://www.sap-topjobs.com/SpecialPP/8431654231.html
☼☼☼☼☼☼
第 184 页 / 共 184 页
SAP General Ledger
Configuration
SAP R/3 ENTERPRISE ECC6
Published by Team of SAP Consultants at
SAPTOPJOBS
Visit us at www.sap-topjobs.com
Copyright 2009-11@SAPTOPJOBS
All rights reserved. No part of this publication may be reproduced,
stored in a retrieval system, or transmitted in any form, or by any
means electronic or mechanical including photocopying, recording
or any information storage and retrieval system without permission
in writing from SAPTOPJOBS.