on 03-02-2007 11:38 PM
Dear All,
I wrote this code:
SELECT SINGLE /bic/zXYZ INTO RESULT
FROM /bic/pzabcd
WHERE /bic/zsxxx = SOURCE_FIELDS-sxxx
AND /bic/zpxxx_id = SOURCE_FIELDS-xxx_id
AND objvers = 'A'.
This is not pulling the data instead of data being present for a particular condition.
Any inputs would be appreciated.
Thanks.
Just the link for people searching the debugging thread
<a href="https://forums.sdn.sap.com/thread.jspa?threadID=336030&tstart=15">https://forums.sdn.sap.com/thread.jspa?threadID=336030&tstart=15</a>
Cheers
SAP NetWeaver BI Organisation
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
have u tried to debug the code?
its not good idea to extract the data directly from table in transformation routine. instead try to extract them into a a global internal table in start routine and use this internal table in transformation this give u a better performance.
regards
mohan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can somebody explain in step by step process on how to use debug mode in DTP.
I tried as explained by Andreas in this forum and it did not help. The simulation mode ends with greee ligt.
The process followed as follows...
1.) Enter the transformation you want to debug
2.) Pick the menu entry "Extras --> Generated Prgogram", and set a user break-point at the position you want to debug.
3.) Enter the maintenance of the corresponding DTP.
4.) Switch the execution mode to "Serially in the Dialog Process (for Debugging)" .
5.) Switch on any of the break-points needed by using the respective "Change" button, e.g. "Extaction Data Source" --> "Before Transformation".
6.) Execute the DTP. It should now stop first at the break-point defined 5.) and also in the break-point defined in your generated program for the transformation (see step 2.)).
This did not work.. Please advise...
Thanks,
BI
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.