New data source

[Former Member]

Hi all

I made a new table and have written a program to load this table everyday

to make a data source with this table , first I made a view out of it and then went to RSO2 transaction and tried to create a new data source

I get the following error.

******************************

Invalid extract structure template ZBW_V_CONDITIONS of DataSource Z_BW_CONDITIONS

Message no. R8359

Diagnosis

You tried to generate an extract structure with the template structure ZBW_V_CONDITIONS. This operation failed, because the template structure quantity fields or currency fields, for example, field BONBA refer to a different table.

Procedure

Use the template structure to create a view or DDIC structure that does not contain the inadmissable fields.

*****************************

I have many quantity and amount fields in my table.

what should I do to solve this issue and create the data source.

thanks for your timely help

MMM

[Former Member]

Hi MMM,

to solve your problem you need to have all your units of measure and currencies with a reference to the same table and not to an external one !!!

So, insert all your qty fields and related unit/currencies in the table on which you want to do your datasource...

Hope it helps.

Bye,

Roberto

[Former Member]

Hi Roberto,

Say for example by table has data from following tables

VBRK,

VBRP and KONV

My table is ZBW_XX.

There is a field BONBA which refer VBRK for its unit field.

How do I make it refer my table (ZBW_XX) instead of VBRK.

thanks for your help

MMM

[Former Member]

Delete the reference of the field BONBA with VBRK table and insert the unit directly in your table ZBW_XX as another independent field.

Then insert your ZBW_XX-unitfield as reference for the BONBA field.

To fill your ZBW_XX-unitfield you ca choose between your program or the normal userexit for transactional flow (EXIT_SAPLRSAP_001).

Hope now is clearer !

Bye,

Roberto

Let me know if now it works...

[Former Member]

Hello,

Another option to consider for RSO2 would be to create a Infoset or function module to extract out your data. But if you are populating a structure, the same reference guidelines that Roberto outlined still apply.

Cheers!