End routine does not pick all the records

[Former Member]

Hi Experts

Due to lack of ABAP knowledge I do not know how to enhance the existing end routine in INFOCUBE to pick all the records.

eg. if the record has more then 1 type of documents then it only picks 1 record rather then picking all the records.

Raw Data in DSO

Current output

here's the existing code

what changes do I need to do to the above code so it picks all the records from DSO?

Regards,

BiApp

[Former Member]

If you will see your Input RAW data & your Output data closely, you can observe that for column notif

you are getting only one data record per notif data value.
Example:
You have 2 inputs for notif with data value 1, one is doc num-123 & 789. value-10 & 20.
Same is with notif with data value 2.
Think in the direction that why this is happening.
Might help.

Current output

Thanks,
Shubham Vyas

[former_member214415]

Hi,

What is the requirement of keeping delete statement?

Thank you,

Swapna jain

[Former Member]

Please ignore the delete statement as I was trying something else.

thanks,

[Former Member]

Hi Thank you all for your reply but my problem is still not resolved.

I have made changes to the code as below but after running the DTP, it stays in yellow status.

here's the code

Any suggestions please?

thanks,

BiApp

[Former Member]

Hi,

Is Notif indicated as semantic key in the DTP ? Otherwise, data of the same Notif may be pread over multiple data packages and the data is overwritten in the infocube.

Kind Regards,

Els

[former_member214415]

Hi,

You write this code:

LOOP AT <internal table name> INTO WA WHERE customer = <result_fields>-customer and notification = <result_fields>-notification number.

Means I am using loop statement on the place of read table so there would be two loop statements.

Just try it.

Thanks,

Swapna Jain

[srikanth_rapur2]

Hi,

Sort table with all the primary keys which are in the DSO.

In READ statement use more key fields in with key I mean.. customer and add more fields.

Thanks

[ccc_ccc]

Hi,

Please confirm below things.

1. Did you add sort command to RESULT_PACKAGE similarly as you did t_xxx table
2. After that in READ Statement your passing customer object only i guess customer means 1,2,3 values in raw data and current output, if yes please add document number also in READ statement as similarly customer.
3. Please do above and check

Note: Make both t_xx table and result_package should sort same fashion

Thank you,

Nanda

[Former Member]

Hi Nanda,

in INFOCUBE transformation, Doc number field is not mapped to any source object and it is populated by the end routine which does a look up on a DSO to get data for that field.

[ccc_ccc]

Please confirm below things.

1. In READ Statement your passing customer object,  customer mean 1,2,3 values in raw data and current output?

Regards,

Nanda

[ccc_ccc]

Hi,

First thing is sort result_package similarly as you sort t_xxx table in your code.

And also, as you shared current output and pls share expected output also

Thank you,

Nanda

[Former Member]

Hi Nanda,

thank you for your reply.

exected output is same as raw data.

hope this helps.

thanks,