view creation

[former_member1215196]

Hi Friends

I am working As BI consultant. i want to create is VIEW using

CE1ACMG & MVKE tables.

MVKE MATNR = CE1ACMG ARTNR.

MATNR values equal to ARTNR values. Can i create the view using the MATNR as primery key.

only valuse equal. both table MVGRP1 is common field

Please advise on this.

Regrds

Patel

[GauthamV]

hi,

u can create a database view if the 2 tables mentioned have common primary key fields.

try it in se11.

for assistence check the already existing views in ur system.

reward points if hlpful.

[former_member1215196]

HI friend

thanx for u replay. matnr is primery key in mvke. but ARTNR is

not primery key. that is only common fields.

My doute is that ARTNR & MVKE fields are diffrent only values

same.can i jion both table

plese read the care fully .

Regrds

P.shiva kumar

[GauthamV]

hi,

u cannot join that 2 tables.

u can create a view with mvke with these tables only.

Referenced tables

MVKE MARA

MVKE MARA

MVKE RDPR

MVKE T000

MVKE T006

MVKE T006

MVKE T178

MVKE T179

MVKE TPTM

MVKE TVBO

MVKE TVKM

MVKE TVKO

MVKE TVKWZ

MVKE TVM1

MVKE TVM2

MVKE TVM3

MVKE TVM4

MVKE TVM5

MVKE TVMS

MVKE TVPR

MVKE TVSM

MVKE TVTW

MVKE TWLV

MVKE TWLV

MVKE TWMEG

MVKE TWSP

MVKE TWSS

Dependent tables

MABW MVKE

MSTA MVKE

CE1ACMG - no relationships defioned for this table.

reward points if hlpful.

[Former Member]

Hi,

Check the below link which will give you a step by step method to create a view / structure.

[|http://www.saptechnical.com/Tutorials/ABAP/Structure/Demo.htm].

Even see that both tables have same or matching primary key fields.

Hope this will help you.

Plz reward if useful.

Dhanashri.

Edited by: Dhanashri Pawar on Jun 19, 2008 7:52 AM