Skip to Content

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

Short question about Update routine fro ODS

I try write a update routine for update fields from ODS2 to ODS1 (for example). And I have trouble with addressing fields of ODSes. For example:

ODS1 have fields: key char(1), data1 decimal and data3 decimal. And ODS2 have key char(1) and data2 decimal. I need for write update routine for update ODS1-data3=ODS1-data1 + ODS2-data2. But I can't understand - if I declare tables for ODS1 and ODS2 (how I must do it?) and write ODS1-data1 is it mean that data1 will be get from ODS1 FROM ROW THAT UPDATING IN THIS MOMENT? I have bad English (sorri) and try ask another way: if ODS1 have records

'1', 2, 0;

'2', 3, 0;

'3', 4, 0

and I write "ODS1-data1", will I get 2 when row with key = '1' was updated and 4 when key = '3' ?

Former Member

Helpful Answer

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