on 2007 Feb 02 3:28 PM
Hello BW Experts...!
I need to create a Generic Data Source out of a table called VBSEGK... I was trying in the usual way with RSO2 , but when I press save button after entering the Table name the following error is coming:
" Invalid Extract Stucture Template VBSEGK of Data Source ZPARK_01"
and when I click on the error message its showing
Diagnosis
You tried to generate an extract structure with the template structure VBSEGK. This operation failed, because the template structure quantity fields or currency fields, for example, field DMBTR refer to a different table.
Procedure
Use the template structure to create a view or DDIC structure that does not contain the inadmissable fields.
VBSEGK is a standard table , so I cant change the Table structure. Can any one give me some idea of how to create Data source with this table ASAP ASAP please....
Please ask me questions if you didnt get this...
thanks
Request clarification before answering.
Harish,
this is problem with Currency and Quantity fields(Reference Fields).Please create Database View on top of the Table. Make sure you include reference fields in that.
Then you will get rid of this problem.
all the best.
Regards,
Nagesh Ganisetti.
Assign Points if it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I can able to create a view with /without DMBTR and WRBTR (Amount in Local Currency Amount in Document Currency).
But to I am not able to create a Generic Data Source if add DMBTR/WRBTR.But for Reporting Purpose I need those 2 fields. How can I do that.
Can I enhance the data source for this purpose?
Please advice
thanks
Hi Harish,
Please check OSS note 335342.
*********************************************************
Symptom
The creation of a generic DataSource which is extracted from a DDIC view or a transparent table terminates with error message R8359:Invalid extract structure template &2 of Datasource &1
Other terms
OLTP, DataSource, extractor, data extraction, generic extractor
Reason and Prerequisites
The problem is caused by a program error.
Solution
The table or view used for extraction must have currency and unit fields within the field list of the table/view for all currency and quantity key figures.Otherwise the consistency of the extracted data cannot be ensured.To make the generation possible, check whether all key figures of your table refer to unit fields that are within the field list.If this is not the case, there are two possibilities:
1. A table is used for extraction.
Create a view in which you have a currency / unit field contained in the view for each key figure. The currency / unit field from the table must be included in the view to which the key figure actually refers.
Example:
Field WKGBTR of table COEP refers to the unit field WAERS of table TKA01. In a view that contains field COEP-WKGBTR, table TKA01 and field WAERS must be included in the field list.
If the currency or the unit a key figure refers to is not located in a table but in a structure, the key figure has to be removed from the view and read via a customer exit (see below). Structures cannot be included in a view.
ATTENTION!! Often the key of the table in which the referenced unit is located, does not agree with the key in the table with the corresponding key figure. In this case, the join condition of both tables is not unique in the view definition, that means for each key line of the table with the key figure, several lines of the table with the unit may be read: the result is a multiplying of the number of lines in the view by a factor corresponding to the number of lines that fit the key figure, in the unit table. To be able to deliver consistent data to a BW system, check whether the unit of the key figure in question should always have a fixed value. If yes then you can determine that in the view definition via 'GoTo -> Selection conditions'. If no, then you must proceed as follows:
a) Remove the key figure from the view
b) Define the DataSource
c) Enhance the extract structure by key figure and unit for each append (Transaction RSA6)
d) Add the key figure and the unit in a customer exit
2. A view is already used for the extraction
If it is not possible to obtain a unit of measure from a table on which the view is based, the unit field must be deleted from the field list.
A note in relation to the upward compatibility of BW-BCT InfoSources: BW-BCT 1.2B was not yet able to check units and currency fields. For this reason, it is possible that InfoSources which were defined in the source system as of BW-BCT 1.2B must be redefined as of 2000.1 in the manner described above. However, checks are absolutely essential for the consistency of the extracted data.
********************************************************
Regards,
Praveen
Harish,
in your table VBSEGK, for the cyrrency and quantity fields you could see which table it is refereing(se11-> display table--> goto currency and quanty fields tab page). join that table in your view( <b>i<u> mean create view using VBSEGK and VBKPF table,select HWAER and WAERS fields from VBKPF Table</u></b>).
Then you won't get this error.
all the best.
Regards,
Nagesh Ganisetti.
assign points if it helps.
Thanks , but I was able to see the data in RSA3 when I created a view without DMBTR and WRBTR fields. But now I have created a view with Reference currency fields of VBKPF Table and activated . Iam not getting any data in that view ..
Can any one let me know wheere might be the prolem is ...
Thanks
Harish,
Please provide the join condition like below...Select required fields from VBSEGK Table. select both currency from VBKPF Table.
VBKPF MANDT = VBSEGK MANDT
VBKPF AUSBK = VBSEGK AUSBK
VBKPF BUKRS = VBSEGK AUSBK
VBKPF BELNR = VBSEGK BELNR
VBKPF GJAHR = VBSEGK GJAHR
all the best.
Regards,
Nagesh Ganisetti.
Assign points if it helps.
Harish,
You are not follwing the process corectly. I generated a view, created same Datasource for your Tables, i can able to see the exact data whta the View is showing.
1. Check the View contents, how many number of entries View contains?.
2. check the number of entries in RSA3. These 2 counts should match.
Note: In RSA3, change the Data Records to 100,000 and Data Calls to 100.
View is working perfectly for me. VBKPF contains 110 records, VBSEGK contains 90 records. In RSA3, it is showing 90. Mine is working perfectly. Please check the process again you followed.
For the view error, please put View join conditions as i mentioned in my earlier message.
All the best.
Regards,
Nagesh Ganisetti.
Assign points if it helps.
Harish,
I'm thinking you are getting only one record in the View(Please confirm me this, try to be more descriptiove)). if that is the case, it's problem with view. You don't have same document in both of the cases. Header documents should be available in Segment tables also. Please check the contents of both the tables VBSEGK and VBKPF tables. i think you have only one document number in both the documents.
You need to <u>refer that VBKPF table</u> to my knowledge. Otherwise you need to <u>enahnce</u> the Table for DMBTR feild. You can get the Reference currency for WRBTR from T001.
I'm facing problem with DMBTR, reference currency HWAER pointing to VBKPF( if i want to exclude VBKPF table fro view).
Check with Source System users, whether both tables contains same document or not. To my knowledge, ig <u>header table document numbers that should contain in segment Table also</u>.
all the best.
Regards,
Nagesh Ganisetti.
Assign points if it helps.
Hi,buddy:
you can just got the other fields from the view and left the CURRENCY fields as blank and then you enhanced it in the RSAP0001,then you will get what u want.
The key point is that you don't include the DMBTR fields in the view but enhance it through RSA6->enhance datasource.
Hope this can help you.
Bets Regards.
Martin Xie
User | Count |
---|---|
50 | |
10 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.