Check the "TYPE" field in the ROOSOURCE table. The TYPE field has values "ATTR" or "TEXT" or "TRAN" for attributes, texts and transaction data respectively.
Thanks for your message,I checked what you said,I understood that,<b>but I want to know that,how can v decide that particular datasource should load first to ODS Object and then to Infocube.</b>
I came to know that by seeing ROOSOURCE table v can decide?But I could'nt able to do so.
Using ROOSOURCE table you can just identify whether the data is attr/text/transaction data. It would not give any info whether the transaction data would get loaded into a cube/ODS. That would basically be determined by your business needs. If you need detailed data to be loaded then you use an ODS and in case of summarised data it is cube. In case you know the datasource let me know the technical name I can search the help and let you know where it gets loaded.
OK,U said that u will search for me that's really great of you.Thanks once again....
<b>In case you know the datasource let me know the technical name I can search the help and let you know where it gets loaded.</b>
Let me know exactly where to search if I know the datasource name.So,that I can improve my searching ability and concentrate more in technical part of it.
Are you aware of the master data datasources. If so, check whether the datasource is view/fn module based in RSO2. You can also the table ROOSOURCE in R/3 for that.
In ROOSOURCE table <b>how to decide</b> that particular datasource should load to DATA TARGET or MASTER DATA.
Like which datasource should load to cube ,ods , master data and so on.And which should load first either ods then cube <b>or</b> MASTER DATA then ODS then cube?
I got your point,but Iam wondering how the Master data is loading.
Is there any other advantage by loading Master data first and then Transaction data other than performance.
Iam using this Sales Document Header datasource(2LIS_11_VAITM) and 2LIS_11_VASCL.This two datasource are loading to data targets.<b>Now I got a doubt from where this Master Data is been loading? and how to load this data.</b>
And we should use Infopacakge for scheduling.But how the extractor picks data from base tables.CAn u tell what actually happens in this regard.How the data will be loading from R/3 to BW.
<b>Actually first we should load data to Master data table and then to Transaction load data.By this reporting performance will be good.</b>Right?Is there any other advantage by loading this way other than performance.
Iam using this Sales Document Header datasource(2LIS_11_VAITM) and 2LIS_11_VASCL.This two datasource are loading to data targets.<b>Now I got a doubt from where this Master Data is been loading? and how to load this data.</b>
Actually in R/3 where this Master data is stored.(As you said is it in Base tables)and where can i see for Master data Base tables and Transaction data tables in R/3
<i>Actually first we should load data to Master data table and then to Transaction load data.By this reporting performance will be good.Right?</i>
Actually this will decrease the time of transaction data loading .So it improves the loading performance , not reporting performance.
<i>Now I got a doubt from where this Master Data is been loading? and how to load this data.</i>
2LIS_11_VAITM and 2LIS_11_VASCL are the DS for Transaction data , not for master data.To load the master data, first of all find out the master bearing characterstics in the data target.And then search for teh DS of master data in R/3 with tcode RSA6 .You will use characterstic(info object) as the search option here.
For example 0materail is the Master characterstic.
And you can see the DS for this Characterstic in RSA6(if it is not there, you have activate it from RSA5)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.