Data load issue with DTP

[Former Member]

Hi Experts,

Am working with one data load issue:

Am trying to loading one purchasing document to DSO level,in this scenario we have two BW Systems connected to one single Ecc system.

Here when we are loading one single purchasing doument from the Datasource ( 2LIS_02_SCL ) to DSO level by using DTP,we found the difference

in both the bw systems. One system it is showing 42 Records Transferred and 8 Added Record in DSO level, and another system is showing 14

Records Transferred and 8 Added Record in DSO level. The system which is showing as 42 Records Transferred at DSO level is multipying the values.

What is the reason the same doucument got  loaded in two BW systems showing different Transferred Records.

And whats the way froward to fix this issue.

Regards,

Prasad.

[RamanKorrapati]

Hi Nag,

from PSA to DSO is this full dtp or delta dtp?

Is this doc is first time created and loaded?

if its full dtp, its pulls all req which are lied at PSA. if its delta dtp, its pick latest req which was not updated further.

You have very less number of records, so cheack it manually at PSA in two bw systems.

if you have same data in bw systems at PSA, upto PSA data was fine.

Once you loaded data into DSO, acttivate and check the records(data) on latest request wise at DSO level. you may find which data was not loaded to dso.

When you loaded to DSO, if the same records are came, it will overwrites old values with new values.

Cross check about purchase doc bw side key fig values with ecc side amount or net value(help of source team).

Thanks

[Former Member]

Hi,

Some queries ::

1) Is the structure of both the DSO's same.

2) Have you checked the data in PSA's ..are the number of records same there.

While working with LO datasources , you need to fill setup table in R/3 side to fetch the document numbers you want to load into BW side.

Br,

Arpit

[mohdshadab_shaikh]

Hi Nagendra,

Good you mention complete details while raising the issue. Atleast, we can make one conclusion that the issue lies within BW and not ECC, half job done. Now we need to investigate where in BW. As Manohar suggested about checking PSA, check and see in if there are no 2 request loaded through infopackage using the selective full load , DTP would be extracting both these request.

Are both the structures of DSO exactly same, like the key fields are alike? etc. Try checking some details using change log and active table. This will help you in your analysis.

Mohamed Shadab

[former_member186445]

did you empty the setup tables and refill for this specific doc before loading to bi?

[former_member241605]

Hello Prasad,

My first question to you

Is it loading in delta mode for the DSO (in both target system) and also is it daily mode for both or based on periodic?

Also please check the if any user exist ( ZXRSAU01) available based on your data source 2LIS_02_SCL in the source system / in Target system,then Check if any condition they have written in that code.

As they might have mentioned to get extracted based on the Target System Technical ID in the code.

Kindly check and let know.

With Regards,

PJ.

Message was edited by: p j

[former_member182343]

Hi,

Check wether both the datasources of different BW systems are delta enabled. If yes, check when last exatraction happen.Might be some one triggered load to either of one DSO.

Unlike checking No of records, validate data in DSO with table and confirm the issue.

Check the DSO strcuture of both systems. Any additional KEY FIELDs added in any of DSO.

Also check for Infopackge selections and DTP filters.

Records,

Vijay

[former_member209895]

Hi Prasad,

      Please check the number of records in PSA on both the systems for the same datasource. Right click on datasource --> Manage --> PSA symbol. Make sure that PSA holds the same number of requests (even though I believe that you are loading into standard DSO and the number of requests should not make a difference as it will be overwritten). If the data records seem same in the PSA, then the issue is with the transformation routines or the DTP filtering. Keep a look out for delete statements in the routine of the transformation to DSO with less number of records. Also run an extraction check in the source system ( through RSA3) to determine what is the number of records being supplied.

If the number of records in the two PSAs itself is different, then you better look into the infopackage data selections tab in both BW systems and make sure that they are alike.

I've assumed that the DSOs are standard DSOs with similar key fields. Just to be sure that the activation doesn't overwrite the requests differently resulting in different number of records held.

Hope this helps,

Regards,

  Manohar. D

[ravi_chandra3]

Hi prasad,

Please once check whether any routines are written.

As you have 2 different bw system, once check whether any filters are there during the data transferring phase.

Regard,
RaviChandra.