Error in view

[Former Member]

Hi,

I have created a view which is picking the data from PBIM & PBED

In both the tables Primary key is Requirement pointer

From PBIM I picking the fields MATNR, BDZEI(Requirement pointer)

From PBED I picking the fields FIXMG(Planned quantity) ,LAEDA(Date of Last Change)

When I activated it did not give any error

But when I am using it in my BW generic datasrc I mentioned in this datasrc to pick the data from this view then it is giving me the error

Invalid extract structure template ZPPPLAN of DataSource PLAN

Message no. R8359

Diagnosis

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

Procedure

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

How to solve this

[ranjit_alapati]

Hi Maya,

Is FIXMG(Planned quantity) is of type QUAN and whose existence is not valid without a unitfield(TYpe:UNIT).

So while creation of view also you need to make use of the unit field to add significance to your FIXMG(Planned quantity).

This might be the reason, please do check.

Regards,

Ranjit

[Former Member]

Hi

In both the tables Requirement pointer is not the key field.

Use the join condion as like this and give the four fields in view fields and activate the view .

PBED-BDZEI = PBIM-BDZEI

Hope this will create the view..Pls let me know if you have any issues..

Regards,

Jayram..

[Former Member]

In this case, the alternate is to go for ABAP Infoset or creation of function modules.

Thanks

Viswa