Add missing record by Executing info package-full falls under DTP

[Former Member]

Hi,

I am missing one record in BW which is sourced from the ECC. So i want to add it again by executing the info package  falls under the DTP of one of the billing DSO. This execution is based on the selective execution in which i want to load only one record in Active table of perticular DSO. Can any one show me exact steps to be carry out to add missing record in active table.

Thanks

[KodandaPani_KV · Accepted solution]

Hi,

if you want load the data to BW for one record, if yes.

ECC Steps

first check the data in RSA3 -  data source name

delete the setup table 09 - billing information

check the data in RSA3 -empty reocrds

for particular sales order fill the set up table using the tcode - OLI9BW

now the records in RSA3 for the sales billing document no

BW Steps.

create the another info package for repair the record.

use the indicate repair request.

if create repair full info package delta loads will not disturb

run the info package -> check the data in PSA.

after run the DTP -> data will move to DSO.

Thanks,

Phani.

[Former Member]

HI Aniket,

follow the steps:

For the missing record you need to fill setup tables in OLI*BW selectively.

2.Run Repair full with InfoPackage Selections so the delta wont be disturbed.

3.Run DTP to load subsequent.

At last mark this question as Answered , If you find the solution.

Best regards,

MS.

[Former Member]

Hi,

First you need to check if the record you need its an item of a billing or is it a a complete billing doc with all their items. If you load a billing you will load all items and you may sum KF of the rest of items.

Please be sure if you need an item or a complete document and check your transformation and the aggregation for your Key Figures. For instance, If you have 4 items for a billing and you want to load ony 1 item, you have two options; 1) delete the billing doc with selective deletion 2) Load only the item you need.

After this, the same check procedure is needed in ALL datamodel. (after the DSO)

The Billing doc already exists in upper levels ? Check it to avoid duplicate the billing.

Now,

Do you know if the DOC you need is still in PSA?IF yes you only have to execute a DTP with that billing doc as a FULL.

If not,

FOLLOW Phani's instructions.

Best Regards

[RamanKorrapati]

Hi Ani,

Whats your data flow and at which level your missing one record?

Thanks