Best Practices for Loading Master Data via a Process Chain !

[Former Member]

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

[Former Member]

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

[ravi_chandra3]

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

[former_member211907]

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.

[ravi_chandra3]

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

[jagadeesh_mandepudi2]

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