Skip to end of metadata
Go to start of metadata

Purpose

This page will briefly discuss about steps involved in revenue account determination in Sales and Distribution Documents.

Introduction

Revenue account determination is one critical integration point between Sales & Distribution and Financial Module.
Here on posting a billing document to account, based on this revenue account determination, system determines relevant G/L accounts for revenue posting. As like any other basic function configuration like pricing, its configuration also based on condition technique.

Steps in Configuration

The following are the steps involved in configuring revenue account determination:

Step 1. Check Master Data Relevant For Account Assignment

SPRO Path

IMG - SD - Basic Function - Account Assignment - Account Assignment/Costing -
Revenue Account Determination - Check Master Data relevant for Determination

TCode

OVK5

Here you set up field for maintaining option master data
1. Account assignment group for material
2. Account assignment group for customer
Based on these fields, account determination in respective sales document will take place.

Step 1.1 Materials: Account Assignment Groups

Here you maintain option for Account assignment group for Material. This allows you to divide materials into different groups, services and retails groups. From master data point of view, you maintain this in Material Master(MM01/MM02) under Sales: Sales Org 2 view.

Step 1.2 Customer: Account Assignment Groups

Here you maintain option for Account assignment group for Customer. This account assignment group relevance is maintain for Payer partner function. This allows you to divide customer into different groups, e.g. domestic and overseas customer. From master data point of view, you maintain this in Payer Customer Master(VD01/XD01/VD02/XD02) under billing document tab of Sales Area Data.

Step 2. Define dependency of Revenue Account Determination

Here we can create & display condition table for revenue account determination by selecting appropriate fields. Based on this field key combination, system will fetch relevant data from the determination maintained.

SPRO Path

IMG - SD - Basic Function - Account Assignment - Account Assignment/Costing -
Revenue Account Determination - Define dependency of Revenue Account Determination

Some TCode related to condition table

TCode

Desc

V/12

Account determination: Create tables

V/13

Account Determination: Change table

V/14

Account determination: Display tables

OV25

Field catalog: Allowed fields for the tables

Following are some standard condition table available:

Condition
Table Number

Short
Description

Available in
Transaction VKOA

Transp. Table
Name

1

Cust.Grp/MaterialGrp/AcctKey

YES

C001

2

Cust.Grp/Account Key

YES

C002

3

Material Grp/Acct Key

YES

C003

4

General

YES

C004

5

Acct Key

YES

C005

7

Vendor

 

C007

400

IS-H: Account key/case type/private/ext.physician

 

C400

401

IS-H: Acct key/case type/srv.catalog/srv./private/ext.phys.

 

C401

410

Chart of accts / Account key - acct assign for ED rev

 

C410

495

Document Category/Condition Type/Own-External/Account Key

 

C495

496

Condition Type/Account Key

 

C496

497

Document Category/Condition Type/Account Key

 

C497

498

Doc. Category/Condition Type/Own-Ext./Actvty Type/Acc. Key

 

C498

499

Doc. Cat./Cond. Type/Own-Ext./Acty Type/Ctlg Group/Acc. Key

 

C499

Following are some of the example for custom condition table may be created based on your requirement

Condition
Table Number

Short
Description

901

Sales org./AcctAssgGr/AcctAsgnmt/Acct key/Ord.reason

902

Sales org./Plant/AcctAssgGr/AcctAsgnmt/Acct key/Ord.reason

903

Sales org./Cond.type/Acct key/Plant

904

Sales org./Plant/AcctAssgGr/AcctAsgnmt/Acct key/Ord.reason

Step 3. Define Access Sequence and Account Determination Type

In standard revenue determination, KOFI is used as account determination types/condition type. Based on your requirement and addition of new condition table in access sequence, you can create and assign new access sequence. As there may be have to shuffle the key combination(condition table) based on your requirement. Say,

Step

Condition Table

Desc

Requirement

10

902

Sales org./Plant/AcctAssgGr/AcctAsgnmt/Acct key/Ord.reason

0

20

901

Sales org./AcctAssgGr/AcctAsgnmt/Acct key/Ord.reason

0

30

1

Cust.Grp/MaterialGrp/AcctKey

0

40

2

Cust.Grp/Account Key

0

50

3

Material Grp/Acct Key

0

60

904

Sales org./Cond.type/Acct key/Plant

0

70

496

Condition Type/Account Key

0

80

5

Acct Key

0

90

4

General

0

As these key combination in an access sequence is maintain from specific to general. Unlike pricing it doesn't have any exclusive indicator.

Step 4. Define And Assign Account Determination Procedures

Step 4.1 Define Account Determination Procedure

Following are the fields under Account Determination:

1

2

3

4

5

Step

Counter

Condition Type

Description

Requirement

10

1

KOFI

Account Determinat.

3 - Without CO acct.ass.

Here Account Determination Procedure is maintained specifying the Requirement account determination with controlling or not.

Step 4.2 Assign Account Determination Procedure

In this step account assignment procedure is assigned to respective Billing Type.

Step 5. Define and Assign Account Key

These are assigned to the condition types in the pricing procedures; this allows conditions such as freight conditions to posted to special freight revenue accounts.

Step 5.1 Define Account Key:

We can create our own Account Keys by specifying Account Number & Description.

Step 5.2 Assigning Account Key:

Here we assign Account Keys to respective Pricing Condition Type. If the you assign/change a account key to condition type, it will automatically maintain/change the account key your pricing procedure and vice versa.

Step 6 Assignment of G/L Account

Here you will be display/maintain all the possible key combination Based on your condition table maintain in access sequence which is assign to the revenue account determination procedure.

Say, your want to maintain account determination based on key combination
a. Condition Type
b. Charts of Account
c. Sales Organisation
d. Account Keys
Then you would have to maintain value in access 5 - Acct Key

Application

Condition Type

Charts of Account

Sales Organisation

Account Keys

G/L Account

V

KOFI

INT

0001

ERL

150000

Else, Say, your want to maintain account determination based on following key combination
a. Condition Type.
b. Charts of Account.
c. Sales Organisation.
d. Account Assignment Group for Payer.
e. Account Assignment Group for Materials.
f. Account Keys.
Then you would have to maintain value in access 1 - Cust.Grp/MaterialGrp/AcctKey

Application

Condition Type

Charts of Account

Sales Organisation

Account Assignment Group
for Customer

Account Assignment Group
for Materials

Account Keys

G/L Account

V

KOFI

INT

0001

01 - Domestic Revenue

03 - Finishing Goods

ERL

150000

Some useful structure

Structure

Description

KOMKCV

Account Determination Communication Header

KOMPCV

Account Determination Communication Item

1 Comment

  1. Very usefull info  Jyoti


    thanks

    Arvind Leo Pereira