SAP SD-FI Integration (Sales and Distribution – Financial Accounting) – ROLANDO

Whenever we sale a finish material to customer, then the customer have to pay for that. We send a bill to customer.
In that position all billing document which is happens to sales and distribution module will be posted into FI module.
The account entry of respect to the billing always have two sides
One side is Customer account and other side will be revenue account. For example:
- Customer A/c Debit
- Revenue A/c Credit
As per SD module, the customer account will be picked from customer master data, which is maintained from SD module.
We just need to configure the revenue account and if there any discount and surcharges account.
We have to do that via access sequence, access sequence is just a SAP terminology to determine the G/L accounts.

SAP provides 5 ways to determine G/L account in SD modules. These are:
1. Cust.Grp/MaterialGrp/AcctKey
2. Cust.Grp/Account Key
3. Material Grp/Acct Key
4. General
5. Acct Key
The assigned G/L accounts are used to post the discount and revenue and any kind of surcharges.
To configure this, go to Path = SPRO-IMG-Sales and Distribution-Basic Functions-Account Assignment/Costing-Revenue Account Determination-Assign G/L Accounts
T-code = VKOA

You can see the below screen and you can also see the default table and description for above 5 ways.
First system checks the first table entry Cust.Grp/MaterialGrp/AcctKey. If any G/L maintained here then system will go to the transaction and the particular billing document, then system search the combination of customer group and material group. If system will find any G/L, then system will go through the G/L, if system doesn’t find the G/L, then it will search the next table.
Customer group is maintained in Customer master Data, Material Group is maintained in Material Master Data, Account key is maintained for condition type in pricing procedure.
Lets maintain One G/L account for material group and account key combination.

I have maintained the G/L for this combination. here AAG is the material grp.
Whenever system search the table and find the combination for transaction, then system will debit customer account and credit to this account (180033)
The account key determine that it is a revenue or discount or surcharges.
Press F4 on the Account Key field, you can see the all account keys.
The account keys are also maintained in calculation schema in Pricing procedure.
Path = SPRO-IMG-Sales and Distribution-Basic Functions-Pricing-Pricing Control-Define And Assign Pricing Procedures-Maintain pricing procedures
In this way SD and FI are integrated each other.

Customer Account Group

Cheers