Generic DataSource

[Former Member]

Hi Experts,

I have a custom application in R/3 and this data will be loaded into three table, header, item and detail using some custome abap pgm.

the structure of the tables are as follows:

HDR

Mandt

Claimkey

key1

A

B

C

ITM

Mandt

ClaimKey

key2

x

y

z

Detail

Mandt

ClaimKey

key3

d

e

f

how to decide if i need to use the table or view in RSO2 what is the difference, between them??? do i need to create two different generic extractors for HDR and Item or do i need to combine the two tables????

Thanks in advance,

Shetty.

[Former Member · Accepted solution]

Hi shetty,

Sorry for the late reply. Yes you can use view in which you will get the header records for each line item. That clearly depands on how you define the view based on the link between the header and line item table.

If you are very comfortable in ABAP you can write a function module to achieve the same. you can refer the function module RSAX_BIW_GET_DATA_SIMPLE to write the code. this is slightly different from the normal function module. This uses CURSOR to fetch data. You can link between the Header and line item tables the way you write ABAP program. Make sure the final output should be the internal table I_T_DATA whose structure should be same as the extract structure.

if you need any sample program write me at tapan.tripathy@wipro.com.

regards,

[Former Member · Accepted solution]

Thanks for the replies,

really appreciate the help.

Thank you,

shetty.

[Former Member]

Want to ask for an expert advice.

I am currently working on a problem of data transfer using Generic Extractor with Delta functionality via a Function Module . I try to figure out what function module (and how) to use for my purposes. I found that 2 most recommended modules are RSAX_BIW_GET_DATA_SIMPLE and RSVD_BW_GET_DELTA_DATA, though first one does not seem to work for DELTA.

I need to build a TRUE delta mechanism due to a huge volume of data transfer from source system to BW. I am aware of how to build a FAKE delta, but this does not suite my purpose.

I would appreciate very much if you could give me a piece of advice as well as let me know if you have a sample of a code.

Again, I only need an advice on True Delta. So far did not find solution on this Forum. I have a pretty good understanding of all the other steps that should be accomplished to set up an extraction process.

Thanks,

Alexander.

[Former Member]

Hi Shetty,

you can combine all tables in one view and use it as the extractor. You only need to take care about the delta capability based on creation/change date ....

Siggi

[Former Member]

Thanks for the reply Siggi,

can you give me an expalme how the records in the generic extractor work.

eg:if there is 1 hdr and 10 items for the same hDR? will the header info repeate for each item???

[Former Member]

Hi Shetty

view is nothing but a join between the tables.

if you create a view then you will get all the records.

cheers

shiva

[Former Member]

Hi Shetty,

sure, if you just join the tables via the header key, you get the header information with each item.

Siggi