Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Records in ODS

Hi All,

We have two ODS A and B and we want to combine these two ODS's and into C

for example in ODS A we have following fields

1 2 3 4 5

and in ODS B we have following fields

6 2 7 8 9

i am expecting to have a view in my C ods like this when i combine both

1 2 3 4 5 6 7 8 9

but i am getting it as

1 2 3 4 5 in one row and the rest in the second row

the key fields in my C ods are

1 2 6 7

that is 1 2 from A and 67 from B. so can somebody guide me how to achieve this into

one record. without having in two records.

thanks and regards


Former Member
Former Member replied

dear Neel,

basically we need one or more field that exist in both ods A and B that can be used for matching, then when populate C ods from A or B ods (e.g from A ods), we then look up some keyfigures value from B using the matching field.

hope this helps.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question