Loading data from 2 ODS to 1 ODS

[former_member184624]

Hi All,

In Modeling there are 2 ODS.

ODS 1 : FI

ODS 2 : SAP

And for ODS 1 the Keyfield is Accounting document No and Item No and data field be Created by,Sales Order No and Date 1

And in ODS 2 the Keyfield is Sales document no. and data field be date 2

And in Final DSO, the data should load in the below manner.

Accouting document no	item no	created by	date 1	Sale order no	date 2
1000111	1	raj	01-02-2012	40101100	01-02-2011
1000111	2	Raj	01-02-2012	40101100	01-02-2011
100112	1	Raj	01-02-2012	40101101	01-02-2011
100113	1	Raj	01-02-2012	40101102	01-02-2011

Can you pls suggest on this.

Thanks & Regards,

Jelina.

[Former Member · Accepted solution]

you have 2 options;

1) create infoset where you do proper mapping and then use it as a data source

2) load data ODS1 --> ODS3 and read data from ODS2 in update rules.

Regards,

DL

[former_member184624 · Accepted solution]

Hi,

Please check the below contents

In GL DSO

key fields:- 1. company code

2.chart_accts

3.glaccount no

4. fiscial period

5.accounting doc number

6. item no

data :fields 1. notification no

2 amount

warranty dso

key fields 1. Notification no

data fields : 2 .date

But in final DSO

i am getting 2 different records

Please help.

[Former Member]

Hi,

Create the 3 DSO like the below structure.

Key fields: Accounting document No,Sales document no,Item No

Data Fields:Created by,Sales Order No ,Date 1,date 2.

On 3 DSO you can create report like what you asked above.

Thanks,

Vijay

[Former Member]

i think without abap code its not possible to combine 2 dso into single dso..!

without abapcode you will get 2 entries ..one from each  dso..

and if u going to implement lookup (abapcode to make single record ..pls makesure there is no impact on delta records

)

Regads,

S.K

[Former Member]

Hi,

What is the diff between Date1 and date1.

I don't see any change in date1 based accounting doc no and change in date2 based on sales order no.

Can you tell us the relation.

Regards,

Venkatesh

[former_member184624]

Hi Venkat,

Date 1 and Date 2 are coming from different ODS.

Thanks & Regards,

Jelina.