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,

please go to transaction lbwe in your source system. Select application 11 and goto the maintenance of extract structure mc11va0hdr. In there you see two tables. On the left side you see the selected fields (basically the structure of mc11va0hdr), on the right side you see a lot more fields to be selected into your extract structure. And there, on the right side, you can see the fields with the name of a structure mcvbak-<fieldname>, mcvbuk-<fieldname>. The source of these fields is then table vbak and vbuk. But anyway, BW extracts the data not directly from these tables. BW goes to the already mentioned setup tables (full or initial load). These tables needs to be filled by a special program.

regards

Siggi