Question:
hi,
I got a problem when creating a datasource, it prompts a message saying "Invalid extract structure template ZIVSUBCHR of DataSource ZSURCHR". I realized that I am asked for a reference currency for a value field, but I found a structure rather than a transperant table for the currency.
The view for the datasource includes the following tables:
RBCO
RBKP
T001
and the problematic field is RBCO-WRMTR.
Your help is highly appreciated.
Many thanks in advance!
CK
Answer:
Hi AFCK,
Did you resolve the error when creating the Datasource? How did you resolve it? Please share. I appreciate. Thank you.
Diane.
Answer:
I find that using a regular table instead of a view is much better. Here we use tables instead of a view and specify the table name and the unit. For example, if the table name is ZTABLE1, we specify the reference table ZTABLE1 and the Ref field as RUNIT, and RUNIT is one fo the fields in the table ZTABLE1. HOwever this you will have to right a program and pick and choose the fields for the regular table.
For your problem try adding a unit field to the view, for example, RUNIT or UNIT, etc. and reference the view table name. See if this works.
Answer:
You cannot extract directly from this table, but you need to create a special view that links to the reference tables and uses the reference table fields. Take a look in the documentation (Just joking)...
Answer:
Thank you guys for your inputs