Invalid Extract Structure while creating a datasource

[Former Member]

Hello,

I'm creating a datasource from a view. whenever i try to save it, it gives me an error saying that it is an invalid extract structure and that one of my fields is referenced to another table. After the threads on SDN, I think I need to remove this field from the view, activate my datasource, append my extract structure by adding the problem field and write an user exit to populate the field.

I don't have any experience in writing an user exit. I would appreciate if anyone would guide in it. Here are the details of my view:

View with 4 tables: EKBE, EKKO, EKPO AND EKKN

so that i'll get the line items of the purchase orders with the fields that i need. I didn't see any business content datasource for this.

problem field: DMBTR in EKBE table

this is referenced to T001.

How do i add this field in the extract structure and how do I write an user exit for this?

Regards,

Sam

[Former Member]

Hi,

It seem your problem because of currency field which is in t001 table.If you add that table into your view then there should be no problem.Regarding to datasource feed from ekko,ekpo did you see 2lis_02_itm ?

http://help.sap.com/saphelp_nw70/helpdata/en/58/f6383fdb800804e10000000a114084/frameset.htm

Regards.

[Former Member]

The problem is due to the currency field, but even if I add table T001 to the view, it gives me the same error. Do I have to do any specific joins with EKKO/EKPO/.... and T001?

I need some additional fields from the tables. thats why i'm not using business content.

Regards,

Sam

[Former Member]

Sam,

Please check your view once again especially the fields regarding to currency then go tables of them and see the reference table for currency and check whether it is included in the view or not.

For example:

SALKV is coming from MBEW then go MBEW chech that field's reference table.It should be in your view.

You also can try to enhance the datasource you use.

Regards.

[Former Member]

Rasim,

I got all the required fields from 2LIS_02_SCL, 2LIS_02_ITM and 2LIS_02_ACC.

So I don't have to create a generic datasource. But I'll try to correct this problem when I get some free time.

thanks for your help

Sam

[Former Member]

Hi,

I am new to this foroum and BW module....

I too am facing the same problem.

I am creating a view from 2 tables VBAK and VBAP .

I was having problem with currency fields NETWR, WAERK, NETPR. So i removed the currency fields. Still i am having same error of not being able to create my data source from the view i have made. It gives the error....

"

Invalid extract structure template Z76_VEW_VBAK_VBP of DataSource Z76_DS_VIEW_VBAK_VBAP

Message no. R8359

Diagnosis

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

Procedure

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

"

Can anyone help me out please.

Thnaks

Mansi

[Former Member]

hi mansi!!

i 2 was getting the same error.

r u gettin this error also?? "you are not allowed to make cross client changes"

[Former Member]

you are not allowed to make cross client changes

This means you are making changes in a different environment then in which has been developed. Make the change in your development server and transport it.