cancel
Showing results for 
Search instead for 
Did you mean: 

Generic Data Source Creation Problem....URGENT!!!!!!!!!!!!!

Former Member
0 Kudos
1,294

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

View Entire Topic
Former Member
0 Kudos

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.

Former Member
0 Kudos

THANKS

BUT HOW CAN I INCLUDE THIS REFERENCE FIELDS ? I NEED TO TAKE IT FROM DIFF TABLE? I COULDN'T ABLE TO ACTIVATE THE VIEW.

ADVISE ME SOON

THANKS

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

I did the same thing but only one record is coming many times...example

BELNR

1900000037

same document number and all other respective fields are repeating but VBSEGK fields are not populating...

Please advice ..

thanks

Former Member
0 Kudos

now view is generating an error,,BELNR not unique...please advice

Former Member
0 Kudos

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.

Former Member
0 Kudos

I did the Same Settings Nagesh.. Iam getting only the first record of VBSEGK again and again...I have 219 records in VBKPF and 179 in VBSEGK

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks!!!

Former Member
0 Kudos

You realize that this an almost 9 year old thread

pallab_haldar
Active Participant
0 Kudos

Can anybody know how to add the reference table field and structure in the same view where the base table added.

I added reference table ans structure but getting error fields does not belongs to a base table.