cancel
Showing results for 
Search instead for 
Did you mean: 

R/3 Table from Extractors

Former Member
0 Kudos

Hi guys,

can anyone tell me how can I find R/3 Table names from Extractors.I have already gone through some previous threads about it... looking at RSA2 or Debuging Extraction from RSA3 does not help that much, does it?? At least I wasnt able to find the coresponding R/3 Table name, maximum information there is for domain field, no Table name is specified....is there any decent way to find it??( I have already looked at the Functional Modules and Structures for the DS) .......any help will be highly appritiated.....Thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

for which extractor are your looking for the tables?

in adition to other inputs, you can start a trace with ST05, run RSA3 and stop/display your trace...

some datasources doesn't even have underlying tables....

hope this helps...

Olivier.

Former Member
0 Kudos

Thanks Reetu and Oliver, I was able to trace that with ST05 and RSA3...but gives too many table name....never seen them!! to reply to Oliver's question...we need to find the Table name for documentation perpose(Blueprint and GAP Analysis)... found most of the table name for standard Extractor from help.SAP, however for some of the CS and QM (2LIS_) and some of the PS (CO_OM_WBS) are not defined in help.SAP

returning to Venkat's advice.....did you mean in RSA3?? I could not find the list you mentioned, could you explain a bit more specifically plz.....Thanks anyway...

Thanks everyone again.I know this always has been a pain for BW people and there is no easy solution for it....

Former Member
0 Kudos

Hi,

just some hints to use the trace properly:

- call rsa3 with your datasource; enter 1 call and 1 record per call, press enter

- only then start your trace in another session

- execute the extraction in your rsa3 session

- stop the trace and dislay it

- from the menu Goto, summary

- position cursor on first row and pressF6; position the cursor on the last row and hit the button select end (F6 again doesn't work...) in order to select everything

- then hit summarize and acknowledge the message.

You should now see something like the following (I ran it for 0MATERIAL_ATTR):


 Tcode/prog    Table                  SQL op  Accesses      Recs.       Time Percent                                                                                
BALDAT                    INS         1          3     15,680     3.1 
               BALHDR                    INS         1          1     37,086     7.3 
               ROMDDELTA                 SEL         1          1        634     0.1 
               ROOSOURCET                SEL         1          6      1,374     0.3 
 RSA3          BALSUB                    SEL         1          1      1,504     0.3 
 RSA3          DD01L                     SEL        52        226     56,237    11.0 
 RSA3          DD02L                     SEL         4          6      3,556     0.7 
 RSA3          DD02T                     SEL         4          6      3,105     0.6 
 RSA3          DD03L                     SEL         2        262      7,456     1.5 
 RSA3          DD04L                     SEL        52        254     72,628    14.3 
 RSA3          DD04T                     SEL        52        254     58,820    11.6 
 RSA3          DOKIL                     SEL         4          1     24,326     4.8 
 RSA3          MARA                      SEL         1         57     48,066     9.4 
 RSA3          RODCHABAS                 SEL         1          1     17,044     3.3 
 RSA3          ROMDDELTA                 SEL         3          3      2,083     0.4 
 RSA3          ROOSFIELD                 SEL         1        126      1,844     0.4 
 RSA3          ROOSOURCET                SEL         3         18      3,362     0.7 
 RSA3          RSFHGENTD                 SEL         1          1    108,445    21.3 
 RSA3          RSSGTPDIR                 SEL         1          1     13,853     2.7 
 RSA3          TRDIR                     SEL         1          1     10,906     2.1 
 RSA3          UST12                     SEL         4          2     15,539     3.1 
 RSA3          VARID                     SEL         4          0      2,867     0.6 
 ST05          TFDIR                     SEL         2          2      2,671     0.5                                                                                
Total                                             197      1,233    509,086   100.0 

Now of course somebody who has quite knowledge about R/3 tables will immediately analyze the following:

BALx are logs tables

ROx and RSx are usually BW 1plug-in system tables related to datasources, extraction and delta info...

DDx are ABAP dictionary tables

xDIR are usually related to ABAP code function modules/report

USx user master

VARID variants

If one doesn't know, simply select the table list with ctrl-y, open SE16 with DD02T table, select language EN and paste the list of tables in the TABNAME selection screen; you'll get the following:


TABNAME                          DDTEXT                                                                                
BALDAT                           Application Log: Log data                                  
BALHDR                           Application log: log header                                
BALSUB                           Application log: sub-objects                               
DD01L                            Domains                                                    
DD02L                            SAP tables                                                 
DD02T                            R/3 DD: SAP table texts                                    
DD03L                            Table Fields                                               
DD04L                            Data elements                                              
DD04T                            R/3 DD: Data element texts                                 
DOKIL                            Index for Documentation Table DOKH                         
MARA                             General Article Data                                       
RODCHABAS                        InfoObjects / basic characteristics in the source system   
ROMDDELTA                        BW: Assignment DataSource - Changer Pointer                
ROOSFIELD                        DataSource Fields                                          
ROOSOURCET                       Texts for an OLTP source                                   
RSFHGENTD                        Generated Routines for Data Extraction of Transaction Data 
RSSGTPDIR                        BW generation tool: Directory of the generated programs    
TFDIR                            Function Module                                            
TRDIR                            Generated Table for View TRDIR                             
UST12                            User master: Authorizations                                
VARID                            Variant directory                                          

Moreover you can goto DD02L and perform the same; the important field here is CONTFLAG:


"pasted from the perf assistant
Delivery class
The delivery class controls the transport of table data when installing or upgrading, in a client copy and when transporting between customer systems. 
The delivery class is also used in the extended table maintenance.

There are the following delivery classes:

A: Application table (master and transaction data).
C: Customer table, data is maintained by the customer only.
L: Table for storing temporary data.
G: Customer table, SAP may insert new data records, but may not overwrite or delete existing data records.
E: System table with its own namespaces for customer entries. The customer namespace must be defined in table TRESC.
S: System table, data changes have the same status as program changes.
W: System table (e.g. table of the development environment) whose data is transported with its own transport objects (e.g. R3TR PROG, R3TR TABL, etc.).

The selection on DD02L give the following


TABNAME                        TABCLASS CLIDEP CONTFLAG
                                                       
BALDAT                         TRANSP   X      L       
BALHDR                         TRANSP   X      L       
BALSUB                         TRANSP          E       
DD01L                          TRANSP          W       
DD02L                          TRANSP          W       
DD02T                          TRANSP          W       
DD03L                          TRANSP          W       
DD04L                          TRANSP          W       
DD04T                          TRANSP          W       
DOKIL                          TRANSP          E       
MARA                           TRANSP   X      A       
RODCHABAS                      TRANSP          E       
ROMDDELTA                      TRANSP          E       
ROOSFIELD                      TRANSP          E       
ROOSOURCET                     TRANSP          E       
RSFHGENTD                      TRANSP          L       
RSSGTPDIR                      TRANSP          L       
TFDIR                          TRANSP          W       
TRDIR                          VIEW                    
UST12                          TRANSP   X      E       
VARID                          TRANSP   X      E       

from the above screen, the only table populated with application data is MARA.

The above might not work for all datasources but for most of them.

hope this helps....

Olivier.

Former Member
0 Kudos

Olivier,Thanks a lot for your very knowledgeble answer.....

I really appritiate the time U spent for the answer....actually I lost hope in the case and did not check my thread yesterday....anyway...thanks again..for solving a million doller problem.......

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Dip,

Try Roberto's blog. I found it extremely useful.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.highlightedcontent?documenturi=...

Cheers,

Reetu

Former Member
0 Kudos

Dip,

When u go to the maintain screen of the extractor where you will get a pop-up for selection of fields, I mean the dialog where you can select the fields from right pane to left, you will find a dropdown list in the top right. There you can find all the table upon which the extractor is built

Former Member
0 Kudos

Hi,

You can try help.sap.com

eg this link http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/content.htm

click on the icon next to word BI CONTENT, a navigation bar will appear, and from there you pick the module you're looking for and drilldown to the DATASOURCE.

Note this is NW 2004 release. The BI content should be about the same.

Hope this helps.

Cheers,

Gimmo

Former Member
0 Kudos

honestly there is no decent way to find the underlying tables or the views. check the forum for a BLOG by Roberto abt the finding the underlying tables of extractors - thats good and very helpful.