Key Mapping and Value Mapping Configuration in Central Finance

[kalavarthi]

Hi,

We are setting up Central Finance, I would like to understand the required configuration to be performed with respect to key mapping and Value mapping in MDG which will be used in central finance.

With respect to central finance, we are transferring data from our source system company code to Target system company code. In which our source system is also SAP. Now we would like replicate our source system data to Central Finance system (Target System) for this we need to perform key mapping / value mapping between source system data and target system.

Need help in this regard to understand the required settings to be performed for key mapping and value mapping without any custom enhancements to post source system data to central finance system.

Regards,

Kiran Kumar. A

[Former Member]

Hi Kiran,

I am facing the exact same issue while setting up a central finance system.

No code list configured for Type DTEL, GDT BUKRS (List ID ) and Bus. Sys.

how did you resolve the issue?

Thanks,

Stan

[kalavarthi]

Hi Stan,

Follow below steps to perform value mapping for "BUKRS' which is used in Central Finance.

Step 1: Assign Code Lists to Elements and Systems

Type - Data Element

Global Data Type - BUKRS

Business System - Your Source system ID

List ID - BUKRS

List Agency ID - Your Target System ID

List Version ID - 01

Step 2 :Maintain Value Mapping -- for object type BUKRS under display mapping relationships maintain below entries for the code list you have created in step 1

Mapping ID - 1

List Agency ID - your Target System ID

List ID - BUKRS

List Version  ID - 01

then define value mapping for this list.

Map. Combination - 1 (serial Number)

Internal Code - Your Target Company Code

External Code - Your Source Company Code

Select check box "Inbound Definition".

Regards,

Kiran Kumar. A

Message was edited by: Kiran Kumar Alavarthi

[Former Member]

Fantastic,

Thank you Kiran, You have help me resolve my issue.

[Former Member]

Kiran,

Where do we map the Plant, Profit Center, Customer, Vendor etc in Central Finance system.

[Former Member]

This message was moderated.

[kalavarthi]

Issue has been resolved.

[Former Member]

Hi,

In CF there are several "mapping categories" - codes(eg company codes), cost objects(production orders), business objects(vendors).

So Value mapping in MDG corresponds to code mapping in CF,

key mapping corresponds to object mapping.

[kalavarthi]

Hi,

Thank you! for your reply.

Yes, I would like to understand the required settings to be performed for these Mappings (Code Mapping / Object Mapping / Cost Object Mapping) which will be used in CF.

For Cost Object Mapping, we do create "Scenarios for Cost Object Mapping" and as next step we "Define Rules for cost Object mapping" for the scenarios created. This can only be done in target system.

But how do we perform code mapping and object mapping  and in which system (Source / Target) do we perform these settings. 

Regards,

Kiran Kumar. A

[Former Member]

Hi, you don't need(and you can't) to customize mapping in sourse system.

[kalavarthi]

Hi,

Thank you!. I have done mapping in my target system as below but still i am facing issues with respect to value mapping.

Below are the parameters which i have maintained in my target system for value mapping. Is this the correct mapping and do we have any additional steps to be performed for value mapping

Assign Code Lists to Elements and systems:

Type - Data Element

Global Data Type - BUKRS

Internal List ID - 01

Business System - my Target System

List ID - BUKRS

List Agency ID - My Target System

List Version ID - 01

Assign Code Lists:

Mapping ID - C0001

List Agency ID - my Target System

List ID - BUKRS

List Version ID - 01

Define Value Mapping:

Mapping Comb. - 1

Internal Code Value - My Target System Company Code

External Code Value - My Source system Company Code.

Regards,

Kiran Kumar. A

[Former Member]

Hi

Business system = sender system.

[kalavarthi]

Hi,

Thank you!. Do we have any other settings to be performed and any corrections to be done in my current customizing settings which i have done apart from business system = sender system.

Regards,

Kiran Kumar. A

[Former Member]

Hi,

Just make all customazation in node for CF.

Can't see in your example scenarios for cost object mapping

[kalavarthi]

Hi,

For Object mapping i have updated these entries in MDG_KM_MAINTAIN transaction as per below combination.

Example -

Business Object Type - Plant

Business System - Target System

Object ID Type - Plant ID (ERP) - Y1

Show and then selected Add option and included below entries.

1 - Target System - Plant - Plant ID (ERP)  -  Y1

2 - Source System - Plant - Plant ID (ERP) -   X1

For Code Mapping, i have done customizing as per below..

Assign Code Lists to Elements and systems:

Type - Data Element

Global Data Type - BUKRS

Internal List ID - 01

Business System - my Target System (This i will be correcting it as Source system)

List ID - BUKRS

List Agency ID - My Target System

List Version ID - 01

Assign Code Lists:

Mapping ID - C0001

List Agency ID - my Target System

List ID - BUKRS

List Version ID - 01

Define Value Mapping:

Mapping Comb. - 1

Internal Code Value - My Target System Company Code

External Code Value - My Source system Company Code.

Regards,

Kiran Kumar. A

[Former Member]

hi, if you made all customazation from node, then it's ok,

but sometimes you should use badis for fit with requirements

[kalavarthi]

Hi,

Eeven after maintaining the above settings, i am getting below error for company code done in value mapping.

No code list configured for Type DTEL, GDT BUKRS (List ID ) and Bus. Sys.
(Source System).

Can you please let me know, the setting i am missing.

Regards,

Kiran Kumar. A