Skip to Content

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

sequencing 3 sceanrios as one logical unit of work

Hi,

I have 3 business services BS1,BS2,BS3

BS1 is source database DB1 which has 2 tables DB1_table1,DB1_table2

BS2 is another source datbase DB2 which has one table DB2_table1

BS3 is target database DB3 which has 2 tables DB3_table1,DB3_table2

And the three scenarios are as below

1.Data from DB1_table1 has to be inseted into DB3_table1 -


from BS1 to BS3

2.Data from DB1_table2 hasto be inserted into DB3_table2 -


from BS1 to BS3

3.Data from DB2_table1 has to be inserted into DB3_table2 -


from BS2 to BS3

But i want all these 3 sceanrios as one logical unit of work and 1,2,3 should be in a sequence.If any one of these fails remaining processes should fail. for ex if 1 fails 2,3 should not occur.

How can i achieve this?

Thanks & Regards,

Jyothsna

Helpful Answer

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