Problem in creating a view and generating datasource

[Former Member]

Hi Gurus,

I am trying to create a Generic Data Source (ZGG_TEST) on a View (ZV_TEST1)

View as Follows:

Table1 has the Following Fields

Field Type

MANDT CLNT

RECNO NUMC

STATUS CHAR

LMODF CHAR

Table2 has Fields

Fields Type

MANDT CLNT

RECNO NUMC

PHCOS QUAN

MATNR CHAR

EQSFS QUAN

MEINS UNIT

In Table2 under Currency and Quantity Field tab

For Field PHCOS The Reference table is MSEG and Reference Field is MEINS

For Field EQSFS the Reference Table is MSEG and reference field is MEINS

View Description

Tables:

Table1

Table2

MSEG

Join condition For the View is

TABLE2-MANDT=TABLE1-MANDT

TABLE2-RECNO=TABLE1-RECNO

TABLE2-MANDT=MSEG-MANDT

TABLE2-MATNR=MSEG-MATNR

The Problem is While saving the Data Source it is Giving an Error as Follows

Invalid extract structure template ZV_TEST1 of DataSource zgg_test

Message no. R8359

Diagnosis

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

Procedure

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

Please help me In Solving this Issue

Thanks in advance

Santosh

[Former Member · Accepted solution]

Hi,

I think the problem here might be due to the fact that you are using MSEG table in your views.

I see that you have used MEINS in your Table2. So for Field PHCOS give your reference table as TABLE2 and field as MEINS as MEINS is already present in your table. Please leave out MSEG from your View.

Hope this helps. Please revert in case of any issues

Regards,

Pramod

[Former Member · Accepted solution]

Hi pramod,

Thanks, Your proposal is working.

thanks and regards,

santosh