FI & SD Integration

[Former Member]

Hi, expert

I am doing Integration with SD

We have two two type of sales account, domwstic sales and export sale, how to maintain for the same sequence (e.g. APP (V), condition type(KOFI), COA, SOrg, AAG, AAG, Act (ERL))?

I want to create Automatic Account Group (AAG) where i can create & what is the t code for create

regards

gk

[Former Member · Accepted solution]

Hi,

You can use t code ovk5 to maintain account key based on material to be sold.

You can then assign that key in VKOA transaction code under customer/Material/Account key combination.

Below mentaioned is one example

Material account assignment group

11- FG revenue

12-RM revenue

13-Scrap Revanue

Customer Account assignment group

20-Direct Domestic Revenue

21- Direct Export Revenue

Account Key

ERL- Revenue (FG) - 10001

ERL- Revenue (RM) - 10002

ERL- Revenue (Scrap) - 10003

Assigned in VKOA under customer Group/Material Group/Account key combination as follows

App-Condition Type- Chart of Acct -Sales Organization- Cust Acct Grp - Material Grp-GL Acct

V- KOFI- 0001- 1031- 20- 11- 10001

V- KOFI- 0001- 1031- 20- 12- 10002

V- KOFI- 0001- 1031- 20- 13- 10003

Assign the same in Customers Master Data in sales Data dilling documents tab account assignment field & in Material Master Data

Regards,

Sany

[Former Member]

ok

[Former Member]

G.Kumar ,

When you integrate fI/SD, need to choose AAG for Material group, AAG for Customer group and consider both combination of revenue GL Accounts(Export and Domestic GL Accounts) to the ERL ( e.g., 3 AAG Material group * 2 AAG Material groups = 6)

See the below example.

V KOFI CABE 0001 01 01 ERL 700000

V KOFI CABE 0001 01 02 ERL 700000

V KOFI CABE 0001 02 01 ERL 700000

V KOFI CABE 0001 02 02 ERL 700000

V KOFI CABE 0001 03 01 ERL 700000

V KOFI CABE 0001 03 02 ERL 700000

Rgds,

Ramesh.

[Former Member]

Hi,

There aer two account assignment categories :

1. Customer - TCODE: OVK5

2. Material - TCODE: OVK5

Domestic sales and Export sale - differentiation can be done using the "Customer account assignment category" in TCODE : VKOA.

VVR