Help for extractors

[#1]

Hi

I'm going crazy.

I've to find in which R/3 tables are data for dataSource 2LIS_11_VAHDR (extractor MCEX_BW_LO_API I think).

I'm using transaction rsa3 in debug mode and looking for SELECT statments or using SQL trace (st05), but I cant find data tables.

where i'm wrong?

Someone know where to find documentation for this DataSource or a better way to find my tables?

thanks to all

Michele

[Former Member]

Hi Michele,

your datasource is selecting the data MC11VA0HDRSETUP in case of a full or initial load, otherwise it takes the data out of the delta queue for the datasource. The table above is getting populated from vbak, vbpa vbuk when you are doing your initial setup for that datasource. Hope this helps and please don't forget to assign some points to the guys that help you.

regards

Siggi

[Former Member]

Hi Michele,

in general, an helpful process of identification is the following:

1. run transaction SE16 and input the table ROOSOURCE

2. search for your OLTPSOURCE

3. find the field EXTRACTOR. The contents here is usually the name of a function module or table/view.

4. find the field EXMETHOD. This will determine the type of extractor. If it is a V then it is a view/table. If it is F1 or F2 it will be a function module.

5. find the field EXSTRUCT. This is populated by the function module to return the contents back to BW.

Try also this method:

SE37 -> RSA1_SINGLE_OLTPSOURCE_GET -> Input the OLTPSOURCEs and the function module will return all tables of information relating to the datasource !

Hope this helps.

Bye,

Roberto

[Former Member]

Hi Siggi, MC11VA0HDRSETUP is the extract structure?

I'd like to know how you have discovered tables vbak, vbpa vbuk.

Probably I'm in wrong way, what is best way to know if your R/3 has data you need for a load to run a Query in BW?

Michele

[Former Member]

Hi Roberto, I've done as you said, I've a list of tables but I cant find my tables (eg. I cant find tables Siggi said above).

Probably I'm in wrong way, what is best way to know if my R/3 as data i need for a load to run a query in BW?

Michele

[Former Member]

Michele,

MC11VA0HDRSETUP is the setup table (cluster)...but you are not able to see nothing from it!

but you can run RSA3 to do your type of test...if you have been filled the setup table with a selection that, in theory, includes your required data...

try to check if your selection in RSA3 works well...