topic view creation in Application Development and Automation Discussions

view creation

Former Member — Thu, 19 Jun 2008 05:40:19 GMT

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

Re: view creation

GauthamV — Thu, 19 Jun 2008 05:43:30 GMT

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.

Re: view creation

Former Member — Thu, 19 Jun 2008 05:52:27 GMT

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

Re: view creation

Former Member — Thu, 19 Jun 2008 05:53:33 GMT

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

Re: view creation

GauthamV — Thu, 19 Jun 2008 06:03:20 GMT

hi,

u cannot join that 2 tables.

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

Referenced tables

MVKE MARA

MVKE RDPR

MVKE T000

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 TWMEG

MVKE TWSP

MVKE TWSS

Dependent tables

MABW MVKE

MSTA MVKE

CE1ACMG - no relationships defioned for this table.

reward points if hlpful.