Skip to Content
0
Former Member
Dec 31, 2007 at 06:06 AM

Problem in creating a view and generating datasource

190 Views

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