reconcile 0material numners from two different source systems

[Former Member]

Hello Experts !

We are extracting data from ECC as well as Oracle DB. For same material, we have different material IDs are coming in from these two different systems.

For example:

For Material : Paper, material ID from ECC is 10 and material ID from Oracle DB is 20.

In my report I want to show a single material ID.

What should be my strategy for loading master data and transaction data, where I can change Oracle DB material ID to ECC material ID.

Please explain.

Thanks

Mary.

[mathew_muthalaly · Accepted solution]

Hi,

When you report on material from the BW system, do you want to differentiate between material from ECC and Oracle and the transactions thereon?

If you don't and you know which material in Oracle is which in ECC, you may resolve the Oracle material id before it comes to BW. It is also possible to do that in transformations on the BW side.

You would also want to look at whether the material pertaining to ECC and Oracle would be seen as belonging to different plants.

BR/

Mathew.

[Former Member · Accepted solution]

How do I do it in transformation.

Start routine or Transformation routine.

Which way to go.

I need reports against each customer, where I should get summarized data of both source systems.

Thanks

Mary.

[mathew_muthalaly · Accepted solution]

Hi,

See the link below for detailed information: 'Start Routine' appears to be the way to go.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/dc43c445-0d01-0010-23a1-ca348ff5...

BR/

Mathew.

[Former Member]

Mary,

MDM is the based solution for this. However, if you dont have MDM, the same can be done thru Start routine also.

You need to write two start routing ... one for ECC datasource and one for DB data source....

Start routine is needed because you wanted to harmonize all the data.

In the start routine, write your logic.

Read the description of the material and assign a unique code for this.

I.e, in ECC...if

Material-descr = paper,

then materail-code= 1000

in DB datasource ..if

Material-descr = paper,

then materail-code= 1000

Thanks..

Shambhu

[former_member345199]

Hi,

Compounding should solve your issue.

Refer this link and the example given.

Compounding

http://help.sap.com/saphelp_nw04s/helpdata/en/ff/f470375fbf307ee10000009b38f8cf/frameset.htm

Characteristic Compounding with Source System ID

http://help.sap.com/saphelp_nw04s/helpdata/en/80/1a6399e07211d2acb80000e829fbfe/content.htm

Hope this helps.

Thanks,

JituK

[Former Member]

Master data management is the way to go or Compound material with source system...which will let you know the source system from which the material Id is coming from..

Hope it helps