cancel
Showing results for 
Search instead for 
Did you mean: 

Routine in transformation

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member192700
Active Contributor
0 Kudos

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

Former Member
0 Kudos

andreas

see your table /bic/pzabcd if you have version A or version M in your data,

or ....

if your fields have the same alpha conversion.

or...

if you have added a source field in the second time please recreate the transformation, if you can. may be a program error generation...

alessandro

former_member563406
Active Participant
0 Kudos

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

Former Member
0 Kudos

No issues with the code... but somehow not pulling the data...

Could anyone suggest a different code?

former_member563406
Active Participant
0 Kudos

that can be analyzed only in debug mode....

former_member563406
Active Participant
0 Kudos

Some times routine code will be syntactically correct but ...there might be some problem with execution in runtime.. so just start debuging and debug for one single record.. where can see the execution step by step... and u can get lot of clues why the select i statment s not working.

Former Member
0 Kudos

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

former_member563406
Active Participant
0 Kudos

Please open a is seperate question in new thread orum.. it woul be more appropriae and can get more answers

Former Member
0 Kudos

I tried storing in a table and debugging it still it doesnt pull any data