Skip to Content
avatar image
Former Member

ABAP Client proxy to JDBC (two tables update and deletion)

Hi Champs

We have a source structure lpopulated via Proxy looks like:

(A) Header

___Log_Rec

-


TimeStamp

-


Rec_Count

-


Rec_Type

(B) Data

-


Master_Data

-


LFA1- NAME

....

(C) Trailer

-


Total Packages

-


Actual Package Number

From Proxy we are sending records in batches of say 500 records, if there are 5000 records pulled by report then proxy will be sending 500 records at a time. we say 500 records as 1 package, so total 10 packges will be received by XI during one report execution. After receiving first package(In source structure when Actual Package number is 1) in XI, XI has to first clear the data from table(Clearinf of sata can bve done based on timestamp from SAP data and Database table records time stamp value) and then post master data(B) to one of the table in SQL, Once XI received all the packages(10) then one log entry has to be done in separate log table,

We were planning like is there any way we can compare Total Packages and Actual Package number based on which we can do operations on Database table.

What will be the best practice to achieve this scenario?

Best Regards,

Div

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 25, 2009 at 09:50 AM

    Div,

    You can do this easily using ccBPM,do you have any reason not to use ccBPM.

    A BPM instance can manage 10 packages (or one report output ) and do exectly what you want.

    Since you gave the total pacakage and the current pacakage info in the message,you can use that to contriol the BPM.

    Bikram

    Add comment
    10|10000 characters needed characters exceeded