|
Deltas Not Working for Installation
Master Data
I am having trouble with the deltas for master data object "installation".
The changes are clearly recorded in the time dependent and time independent
tables, EANL/EANLH. The delta update mode is using ALE pointers, does anyone
know of a table where I can go check where these deltas/changes are temporarily
stored, or what's the process behind this type of delta?
The following steps must be executed:
1. Check, whether the ALE changepointer are active in your source system
(Transaction BD61) and whether the number range is maintained (Transaction
BDCP).
2. In addition, check in the ALE Customizing, whether all message types
you need are active (Transaction SALE -> Model and implement business processes
-> Configure the distribution of master data -> Set the replication of
changed data -> Activate the change pointer for each message type ).
3. Check, whether the number range for the message type BI_MSTYPE is
maintained (Transaction SNUM -> Entry 'BI_MSTYPE' -> Number range -> Intervals).
The entry for 'No.' must be exactly '01'. In addition, the interval must
start with 0000000001, and the upper limit must be set to 0000009999.
4. Go to your BW system and restart the Admin. workbench.
All of the following activities occur in the InfoSource tree of the
Admin. Workbench.
5. Carry out the function "Replicate DataSource" on the affected attached
source system for the InfoObject carrying the master data and texts.
4. Activate the X'fer structure
All changes, all initial data creations and deletions of records from
now on are recorded in the source system.
5. Create an InfoPackage for the source system. In the tabstrip 'update
parameter', there are three alternative extraction modes:
Full update
Delta update
Initialization of delta procedure
First, initialize the delta procedure and then carry out the delta
update.
An update on this issue:
In the EMIGALL process, SAP decided to bypass all the standard proces
to update the delta queues on IS-U, because it would cause too much overhead
during the migration. It is still possible to modify the standard
programs, but it is not recommended, except if you want to crash you system.
The other options are as follows :
- Extract MD with full extractions using intervalls..
- modify the standard to put data in a custom table on which you are
going to create a generic delta;
- modify the standard to put the ALE pointers in a custom table and
then use a copy of the standard functions to extract these data....
- Extract the data you want in a flat file and load it in BW...
By the way, if you want to extract the data from IS-U, forget to do
it during migration, find another solution to extract after.
PS: Well if you have generic extractor and huge volume data then you
can do it with multiple INITS with RANGES as selection criteria and then
a single DELTA(which is summation of all INITS) in order to improve performance
with GENERIC DELTA.
Fast Links:
Get help for your SAP BW problems
Do you have
a SAP BW Question?
SAP BW Books
SAP Business Warehouse
and Certification Books
SAP BW Tips
SAP BW Tips and Business Information
Warehouse Discussion Forum
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com
All the site contents are Copyright © www.sap-img.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.sap-img.com is in no way affiliated with
SAP AG.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.sap-img.com or the content authors.
|