how can i know whether z table is used for BW extraction

Question: Hi,
My question is :
There is one ztable in R/3. If some body deleted the records from this Z table in R/3 , will iit effect in BW reporting ?

I want to know R/3 side whether this z table is using for pulling data into BW . If yes, how to see in R/3 ? I also have access to B/W . How can i see in B/W also?

Pls help me
venkat

Answer:
Goto transaction SE16 -> open Table ROOSOURCE
In the selection screen…use field EXTRACTOR
Here in this give your Z table name.
If this Z table is used in any of the DataSource then will immediately display the record.
Here you can findout if it is used or not and datasource using this table.


Also in the enhancement routine check once, to make sure this table is not referred.
Generally select statements will have this table name...so in your enhancement Include if you just search for the keyword your Z Table name...you will see.
_________________
Regards,
Parin

Answer:
Hi ,
where can i find this enhancement routine ?

Answer:
1. Execute Transaction CMOD
2. Type your Project name...generally name will be "ZBW" or something similar
3. Select Component Radio Button and click on Display
4. Double click on “EXIT_SAPLRSAP_001”
5. Click on Find and give your Z Table name.
6. You can also go into the Include “ZXRSAU01” and Find.
7. Repeat the same search for EXIT_SAPLR_SAP_002,3 and 4 if used.
_________________
Regards,
Parin
Copyright ?2007 - 2008 www.jt77.com