cancel
Showing results for 
Search instead for 
Did you mean: 

Data load issue via DTP

Former Member
0 Kudos

Hi Experts,

I am loading data onto DSO via DTP and it seems to look like data is not fully loaded onto to the target. since in my PSA I can see 15000 records but I am getting only 1035 records. the DTP is set as a full load.

I am unable to determine what will be the issue so please kindly let me know what went wrong please.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member188080
Active Contributor
0 Kudos

Hi,

You can also try debugging DTP and see where data is getting filter..

check if there are any filter value that is specified in the DTP..

Thanks and regards

Kiran

Former Member
0 Kudos

Hi Rajesh,

As you are loading data to DSO, please check the below things

1) Check if you have any routines in transformations.

2) Check if you have any selections in DTP.

3) Check if your DSO is set to overwrite mode, if yes then display the data in active table of DSO and compare it with the PSA(Say check data for one sales order).

4) Check if your DTP is set to Full or Delta.

Sometimes this is depends on how you defined your key fields in DSO.

Lets say you are loading item level data to PSA and you kept only sales order number as key field in DSO then obviously added records will be less than transferred records at DSO level.

goto DSO manage screen and check what is the number for added and transferred records.

Regards,

Venkatesh

Former Member
0 Kudos

Hi

the DTP set is for full load and even I have un checked key fields in smentic key in DTP but still the valume of the record is same. any other suggestion please let me know.

and there is no routines involved.

Former Member
0 Kudos

Hi

Not key fields in DTP, check key fields in DSO and check the data in DSO.

compare the data between your DSO and PSA.

what is the error handlig option is update tab of DTP?

Regards,

Venkatesh

former_member186445
Active Contributor
0 Kudos

did you check for any routine in transformation that can delete records?

any selection criteria in the dtp?

is it a delta or full dtp?