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

Precautions in R/3

Hi all,

If I am going to extract data from R/3 using LO data sources then what kind of precautionary steps I need to follow in Source System, relating to data sources, timestamps.........

( I know steps for LO extraction)

Regards,

Pavan

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2009 at 06:26 AM

    Hi,

    There is no steps related to timestamp for the LO data source as they are not time stamp based as such like FICO data source.

    The delta is managed internally by SAP once you schedule the collective update jobs through job control.

    All you need to make sure that you schedule the delta through the job control every half an hour or 10 minutes depdending upon your requirement.

    No specific settings for the timestamp or for the data sources.

    I hope you know the exact steps for LO data sources...

    Thanks

    Ajeet

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2009 at 06:36 AM

    Hi,

    In fact, scheduling timing process is very important and it should be based on the basis of

    1) the amount of activities on a particular OLTP system and on

    2) the particular requirements related to the updating needs of data displayed in BW reports.

    For example (relating to the first point), a development system with a relatively low/medium of new/modified/deleted documents may only need to run the V3 update on a weekly/daily basis.

    Instead, a full production environment, with really many thousands of transactions everyday, may have to be updated hourly, otherwise postings will queue and can affect performance heavily.

    About the second point: if, for example, the reporting timing refers to a monthly periodic view, successfully monthly scheduling the V3 update will ensure that all the necessary information structures are properly updated when new or existing documents are processed in the meanwhile.

    Finally, the right choice will be the result of all these considerations; by doing so, the information structures in BW will be current and overall performance will be improved.

    Itu2019s possible to verify that all V3 updates are successfully completed via transaction SM13.

    Hope this helps u..

    Best Regards,

    VVenkat..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You can see details in the following tables:

      ℹ️ BWFI_AEDAT

      (ii) BWOM2_TIMEST

      Also,

      in RODELTAM table, can we get the details of timestamp and other details about delta.

      Hope this helps u..

      Best Regards,

      VVenkat..

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.