on 09-10-2014 12:22 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Reagrds,
Bhaskar V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.