cancel
Showing results for 
Search instead for 
Did you mean: 

how to merge FI & MM data

Former Member
0 Kudos

Hi all

may be similiar threads are also present in sdn, but my question is very specific ,hence i hv posted it again

my requirement is to merge the data from MM & its corresponding FI data into a single record to display in the report.

eg.

FI doc PO CC CO PC MAT MG AMT INV

510000000 45000000 0030 4000 40001 # # 10000

510000000 45000000 # # # 100 200 10000

but i want to see this as

FI doc PO CC CO PC MAT MG AMT INV

510000000 45000000 0030 4000 40001 100 200 10000 100000

that is in a one single record & avoid the # .I did a lot of r&d , & tried a lot of stuffs , but none gave results yet.

i tried using an infoset over the 2 DSO's using join over FI doc no , FY & CC . here it was not picking up the few values, where my FI doc is not present (some rare cases ).

I tried infoset with outer join - here the results are same as above

I tried an DSO over this infoset , with FI doc, Inv no, PO , item no all in key fields. still results are same.

With multiprovider also , same results.

Is there any better way to do this. ?

or if change my key fields or the join conditions , do u think it can achieved ? (can u pls be specific with some eg fields)

Thanks

Ramesh

Accepted Solutions (1)

Accepted Solutions (1)

former_member205352
Active Contributor
0 Kudos

How about trying the below :

Say ODS1 has FI data ODS2 has MM data.

Create a new ODS3 which has both FI fields and MM fields.

Load from ODS1 or ODS2 to ODS3.Let me assume ODS1 to ODS3.

While loading to ODS3 in the update rules/transformation make a look up to ODS2 and populate your MM fields.

Now you ODS3 is combination of MM and FI data.This you can further load to cube and report on it.

Hope this helpls

Former Member
0 Kudos

Hi Praveen

Thnks for the reply.

But in my scenario, it might happen that sometimes , e.g Cost center info usually comes from FI . But for those PO whose Fi doc is notyet generated , i wanted the CO info to fetched from MM dso.

so i am not very sure , from where the data would come . & if thr is no corresponding data available i'm fine with a 'Empty' cell.

but whenever there is a data coming FI & MM for one single transaction . i want all the info for this transaction to be displayed in a single record.

Thanks

Ramesh

former_member205352
Active Contributor
0 Kudos

In the code you can make a check saying.

Is costcenter initial from MM if its initial you fetch from FI else you put the value from MM itself.

So when cost center is not there in MM then only the code will fetch from FI.

For this to work you should make sure which stands higher costcenter from FI or MM so that you can write the code accordingly.

Hope this helps.

Former Member
0 Kudos

even after prioritizing the fields that CO should come from FI & MG should come from MM & so on..

i am again going to get the same 2 records as of now because i need to execute 2 dtps to fetch data from those 2 DSOs. hence i dont think it will improve my condition.

now , my problem is i am actually 4 records to be specific.

FI doc PO CC CO PC MAT MG AMT INV tax

510000000 45000000 0030 4000 40001 # # 10000 0

510000000 45000000 # # # 100 200 10000 0

510000000 45000000 0030 4000 40001 100 200 10000 100000

510000000 45000000 # # # # # 0 0 4000

record 1 - FI

record 2 - MM

record 3- merged record . this is only record which i need

record 4 - tax line item. i dont know why it is coming as a separate record & that too with most of field info.

is there anyway , i can select only this record 3 & also show my tax amt in record 3 itself. & record 1,2 & 4 be deleted.

Guys , pour in some ideas.

Thanks

Ramesh

former_member205352
Active Contributor
0 Kudos

Not sure if you got what I tried to tell.

Why will you have 2 DTPS ??

Loading is like this :

ODS1 <--- FI (one DTP)

ODS2 <---- MM (one DTP)

ODS3 <--- ODS2 (one DTP) (in transformation here you write look up logic)

record 1 - FI -


>ODS1

record 2 - MM -


>ODS2

record 3- merged record . -


>ODS3

Since you want record 3 you got it in ODS3.

Answers (1)

Answers (1)

Former Member
0 Kudos

Integrate FI & MM data on FI doc and PO fields in an ODS, then do what ever you want..

If you still don't get how to do, let me know..

Former Member
0 Kudos

Hi,

I am also trying to do the same thing. merging FI & MM data based on FI doc no to another DSO.

but it is still not giving not me the desired results.

can u help me out, pls.

Thanks

Ramesh