Skip to Content
author's profile photo Former Member
Former Member

How to do Stastical Setup for Master data Loading

Hi All

Thanks a lot for all guys,who are helping me a lot.

I want to do stastical setup for Master data of sales order.I know how to do for transaction data.

But what is the procedure for MAster data in SBIW-Tcode.

Regards

Balaji

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 11:07 AM

    Hi Balaji,

    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.

    Hope this helps.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Dinesh

      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.

      Can you please let me know about this.

      Regards

      Balaji

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 06:13 AM

    Hi,

    What do you mean of <i>Master data of sales order</i>?

    Anu way, there is no need to make Stastical Setup for Master data Loading .Extractor takes the data directly from base tables.

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      ANil

      Its very useful answer for me,Thanks a lot.I will check and come back later.

      Then u mean to say that directly from base tables data will be stored in this datasources

      0MATERIAL_ATTR

      0MATERIAL_LGEN_HIER

      0MATERIAL_LKLS_HIER

      0MATERIAL_TEXT

      is it true.

      come back to u later after analysising

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 06:43 AM

    Hi Balaji,

    Statistical update is only for transaction data and not for master data. What is the master data you want to use.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Dinesh

      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.

      Pl let me Know.

      Regards

      Balaji

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 07:14 AM

    Hi Balaji,

    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.

    Also refer to this link for more info:

    http://help.sap.com/saphelp_nw04/helpdata/en/8f/36f338472b420de10000000a114084/frameset.htm

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      Dinesh

      Ya,got ur point.

      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?

      Pl tell me clearly in this regard.

      Thanks A LOT IN HELPING ME OUT

      Regards

      Balaji

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 11:53 AM

    Hi Balaji,

    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.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dinesh

      Thanks a lot.

      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.

      pl let me know

      Thanks & Regards

      Balaji

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2005 at 01:02 PM

    Hi Balaji,

    Use the "search" with the datasource name in http://help.sap.com .

    Hope this helps.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.