cancel
Showing results for 
Search instead for 
Did you mean: 

End Routine Field not populating

Former Member
0 Kudos

Hi,

I've write a code in End routine but it's not populating. We're in SAP BW 7.3. I'd similar issue in SAP BW 7.3 , when I double click on transformation ctl+shif+f7 and check independent something...and it worked.

I've given constant value to these fields but it's still not working. I'm attaching my code. Please have a look and see what's wrong there.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member185177
Contributor
0 Kudos

Hi Pawan,

1)   Your sort condition is on three fields print dt, plant, mainplant.  so you need to refer the same condition in the same sequence in your read statement.  Because you are using binary search.

2)  select where conditions remove runtime condition.  You need to pass the runtime value from the data you are fetching.

Check with these options

Regards,

Krishna Chaitanya.

Former Member
0 Kudos

Hi Krishna,

Thanks for correcting me. It solved my issue.

Thanks,

Pawan

Answers (5)

Answers (5)

aarif_baig
Active Participant
0 Kudos

Hi Pawan,

                Do you have any duplicate entries in lt_tab table please check, and if possible remove binary search they have a tendency of not working sometimes if you use multiple fields in read statement and also in select statement put maintplant and then use it in read statement. and why are you using runtime in select statement when you are not using it in your read statement

Read this blog for better idea on binary search.

Your Friendly ABAPer: The pure and simple truth about BINARY SEARCH

Thanks.

Former Member
0 Kudos

Thanks everyone -

bhaskar_v3
Explorer
0 Kudos

Hi ,

The Sort order and read order must be same if we use a binary search.

After changing this still the data is not displaying means try to see the data in the internal by debugging the transformation.

Please find below the links which will help you for debugging:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/205e46d2-0b30-2d10-cba0-ea9dba0cb...

     

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0038ad7-a0c7-2c10-cdbc-dd674682c...

Reagrds,

Bhaskar V

Former Member
0 Kudos

There is a setting on transformation called "update behavior of fields in the end routine"  in BW 7.0 whereas in 7.3 there is a new window called "select target fields for end routine".

Check that option and that will solve your problem.

dhrubojyoit_saha
Explorer
0 Kudos

^This. Check if you are getting the data in the new table and is longer present once you activate it. If that is the case, the above is your solution. Or you can just assign a constant/make it initial in the general mapping, so that it treats this object to be modifiable in the end routine.

former_member185132
Active Contributor
0 Kudos

The conditions in your WHERE clause do not match those in the READ statement. The READ statement probably isn't able to find the records matching the condition. Please try to make the conditions in WHERE and READ the same.

shaik_sajid
Active Contributor
0 Kudos

Hi,

Modify your code with the following and let us know if it works .

sort lt_tab by /BIC/ZP_PLANT /BIC/ZPRINT_DT MAINTPLANT.

Regards

Shaik

Former Member
0 Kudos

Hi

Thanks for reply. I made this change but it's still not populating.

Thanks

former_member976
Active Contributor
0 Kudos

Hi,

it seems to be look like correct,

in DTP option use select the debug mode under execute tab. then check it.

Thanks,

Phani.

Former Member
0 Kudos

Hi Pawan,

Can you see if the data is present in table from where you are selecting as per the conditions you have provided?

Also can you let us know what do you mean by:

"

when I double click on transformation ctl+shif+f7 and check independent something...and it worked.

"

What do you mean by it worked? Is it something you are testing local end routine?

Can you debug the routine?

Thanks

Amit