Skip to Content
0
Former Member
Jul 11, 2006 at 05:06 AM

Error while activating the View

1520 Views

Hi i am trying to activate the view, but it is resulting in this below error.. i am providing the complete details of the view i created, please help me out what is wrong in this...

Tables added

ZTF_CUBD

ZTF_BTRN

TCURC

Join Conditions

ZTF_BTRN MANDT = ZTF_CUBD MANDT

ZTF_CUBD MANDT = TCURC MANDT

ZTF_BTRN MANDT = TCURC MANDT

ZTF_BTRN CALCID = ZTF_CUBD CALCID

ZTF_BTRN PSPID = ZTF_CUBD PSPID

ZTF_BTRN PROVID = ZTF_CUBD PROVID

View Fields

MANDT ZTF_CUBD MANDT

MANDT ZTF_BTRN MANDT

PDATE ZTF_BTRN PDATE

WBS1 ZTF_BTRN WBS1

FUTYP ZTF_BTRN FUTYP

PROVID ZTF_BTRN PROVID

BILLAB ZTF_CUBD BILAB

OBBUD ZTF_CUBD OBBUD

Below is the error message i am getting...

VIEW ZFAB_SUMBLCAL was not activated

Check view ZFAB_SUMBLCAL (OGILIA/07/10/06/23:01)

View allows read-only access only. Maintenance not possible.

'Display using Data Browser only' was set automatically

Key field ZTF_BTRN-CALCID missing

Key field ZTF_BTRN-PSPID missing

Key field ZTF_CUBD-FUTYP missing

Key field ZTF_CUBD-PDATE missing

Key field ZTF_CUBD-POSID missing

Key field ZTF_CUBD-RTYPE missing

All fields are evaluated as key field

Field name MANDT not unique

View ZFAB_SUMBLCAL is not consistent

Some one help me out with this.....

Thanks in advance....

Kris...