Convert BW 3.5 Routine

[martin_bako]

Hi,

can anybody help me bei converting this routine from BW3.5 to Bi 7.0.

SELECT SINGLE /BIC/MS1DPCOST FROM /BIC/PMS1DPRODU INTO RESULT

WHERE /BIC/MS1DPRODU = TRAN_STRUCTURE-/BIC/MS1DPRODU

AND OBJVERS = 'A'.

thanks alot in advance

Martin

[Former Member · Accepted solution]

Hi,

I think it is:

SELECT SINGLE /BIC/MS1DPCOST FROM /BIC/PMS1DPRODU INTO RESULT

WHERE /BIC/MS1DPRODU = <SOURCE_FIELDS>-/BIC/MS1DPRODU

AND OBJVERS = 'A'.

I hope it helps.

[martin_bako · Accepted solution]

Hi Alec,

Thank you for answer, when impliment the Routine as you suggest, the System does'nt

accept it and says:

E:The field "<SOURCE_FIELDS>" is unknown, but there is a field with the

similar name "SOURCE_FIELDS". "SOURCE_FIELDS".

so can you tell me what to do, thanks.

[Former Member · Accepted solution]

Are you building the routine in a transformation or in a transfer rule? If you are building it in a transfer rule you don't need to change nothing.

Try with source-fields-/BIC/...

You have to use <source-fields> in the star routine.

Sorry

Message was edited by:

Alec

[martin_bako · Accepted solution]

Hi Alec,

Thanks a lot, it works......

Martin