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

Best Practices for Loading Master Data via a Process Chain !

Posted on Nov 18, 2011 at 08:40 PM 58 Views

Hello Experts,

We have very large master data load that we have nightly (Full Load). i.e. 0DOC_NUMBER.

In order to speed up the load Can we restrict the selection on some criteria ?

Is there any best practices for loading Master data via a process chain ?

Any specific best practices to 0DOC_NUMBER ? Please help.

Many Thanks in Advance,

Sunil Patel

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Jagadeesh Mandepudi
    Jagadeesh Mandepudi
    Posted on Nov 19, 2011 at 04:26 AM
    0

    Hi

    Can you do one thing if you are loading daily full load since day1 data it is not necessary load full with time restrcitions like till last year and from current year keep loading every day.

    If it was not delta enabled.

    Regards

    Jagadeesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo T Ravi Chandra
    T Ravi Chandra
    Posted on Nov 19, 2011 at 01:17 PM
    0

    HI sunil,

    If u have large amount of data , then better to perform Load balancing.I think that is one of the way to improve the data loading.

    Regards,

    RaviChandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Charlie Belt
    Charlie Belt
    Posted on Nov 20, 2011 at 01:18 PM
    0

    Sunil-

    Many companies include document level data in their BW systems. (As does mine). This produces long data load times IF you are loading and reloading years and years of data every time.

    But also document numbers are not necessarily monotonic (in sequence) when it comes to posting dates. In our company I changed our 'load everything' model to load just those documents that had a posting date (using attribute selection) within the current and prior periods.

    Alternatively you can use a delta master data load process.

    One important key... REMOVE time dependent attributes and make the master data non time dependent. This often helps to improve performance significantly.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 03:31 PM
    0

    Hello Experts,

    Thanks for all valuable reply. After reading your answers i have few question in mind,

    @ Jagan - How to check whether the datasource is delta enabled or not ? Any best practices or Step by step information on how to full load with Time Restrictions ? Please help.

    @Ravichandra - What do you mean by "Perform Load Balancing" - does it mean use of multiple InfoPackages with selections ? Any best practices or step by step information on this ? Please help.

    FYI - 0DOC_NUMBER has below Attributes,

    Attributes Description

    0BILLTOPRTY Bill-to party

    0CAMPAIGN Sales Promotion

    0CREATEDON Date on which the re

    0DOCTYPE Purchasing document

    0DOC_TYPE Sales document type

    0OPP_NUM Opportunity

    0SAL_PROM Sales Promotion Meas

    0SLS_ACTIV Promotional Activity

    ZSALESMAN Direct Manager

    ZSALESREP Sales Representative

    ZCMGST Overall status of cr

    ZIHREZ Vendor's Internal Re

    0LOGSYS Source System

    ZCADD_NO Address

    0DOC_CURRCY Document currency

    0PH_CREATBY Created by

    0COMPL_DEL Delivery Completed

    ZCPR_RELD Release Date

    0PRPURDAT Business Data: Purch

    0INCOTERMS Incoterms part 1

    0INCOTERMS2 Incoterms part 2

    ZSLSDOCPO Purchase Order numbe

    0S_ORD_ITEM Sales document item (Navigational Attribute)

    Please help. Many thanks in advance.

    Sunil

    Add a comment
    10|10000 characters needed characters exceeded

    • T Ravi Chandra
      Nov 22, 2011 at 08:05 AM

      Hi sunil,

      If u want to know whether the datasource supports delta or not . Then ROOSOURCE table will give the details of that behaviour whether the DS supports the delta or not .

      In the ROOSOURCE(in R/3 SYSTEM) table u have a field DELTA if that field left blank then that datasource doesn't support delta , else it will support delta.

      Yes.Load balancing is nothing but creating multiple infopackages based on different selection .

      Hope it helps,

      Thanx & Regards,

      RaviChandra

      Edited by: Ravichandra.bi on Nov 22, 2011 9:55 AM

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.