Generic extraction

[Former Member]

Hi Gurus

I am trying to get fields from VBRK,VBRP,VBAK and MARA so pl tell me what I need to put in join condition ? Do i need to go like follows?

MARA>>>MANDT=VBRK>>MANDT

or do i need to joint all 4 tables ? How?

also when i am trying to add NETWR in view field and and when i go to create and save data source based on this view , its giving me the following error .So pl tell me what I need to do to solve this error?

<b>Invalid extract structure template YVBILL of DataSource KR_1

Message no. R8359

Diagnosis

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

Procedure

Use the template structure to create a view or DDIC structure that does not contain the inadmissable fields</b>

[Former Member · Accepted solution]

Hi,

There are refernce fields for the fields which represents Quntity and currency. So you have to reference fields in to the View you have created.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Thanks Anil

Points given