Finding if an R/3 table already exists in an extractor
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?
joe _bi replied
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