Skip to Content

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

Finding if an R/3 table already exists in an extractor

Hi,

There is an R/3 table (LQUA) whose contents I wish to bring into BW. I can create a custom extractor easily enough, but what I'd like to know is if this table is already part of an extract structure to BW. Is there a way to do a search?

Thanks.

Dave

replied

Hi Dave,

Please take a look on table ROOSOURCE (TC SE16) .If field EXMETHOD = V (Transparent Table or DB View), name of datasource can be searched with field EXTRACTOR containing the table or view name. In SE 11 you can process the u201Cwhere usedu201D function for a table to determine the views related to it and then search for them.

Hope this helps

Joe

0 View this answer in context

Helpful Answer

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