topic Re: ragarding view in Application Development and Automation Discussions

ragarding view

Former Member — Mon, 02 Jul 2007 05:52:16 GMT

hi experts,

i have created a view using LIKP and VBAP..using join conditions.my join conditions are

VBAP-VBELN=LIPS-VGBEL.

VBAP-POSNR=LIPS-VGPOS.

LIPS-VBELN=LIKP-VBELN.

.now i want to add one more table into it ie MBEW.can anyone tell me what would be the join conditions then..i dontknow if there is any link between these tables..plz help me out..I hav to add STPRS from MBEW.

regards,

raman,

Re: ragarding view

Former Member — Mon, 02 Jul 2007 06:54:22 GMT

What your purpose for creating such view with LIPS and MBEW tables

MBEW is related to Material Evaluation data

You can link at the max with MBEW-MATNR = LIPS-MATNR

Also link MBEW-BWKEY with WERKS of LIPS also

but be sure about your requirement.

We have to use the existing Views in SAp or we can write the selects for the for the tables and fetch the data. Why to create a View like this

<b>Reward points for useful Answers</b>

Regards

Anji

Re: ragarding view

Former Member — Mon, 02 Jul 2007 07:10:58 GMT

Hi Experts,

I have created a Ztable but i need the table in Y. How can i change Ztable to Ytable.

Reagrds

Raman

Re: ragarding view

Former Member — Mon, 02 Jul 2007 07:13:17 GMT

Hi Prakash,

Just go to SE11, there is option of copy the table so just copy it to the new name.

Reward points if useful.

Regards,

Atish

Re: ragarding view

Former Member — Mon, 02 Jul 2007 07:15:38 GMT

hi,

instead of copy, you will find rename in the table menu?

you can rename from "Ztable" to 'Ytable"

rewards if useful,

regards,

nazeer

Re: ragarding view

Former Member — Tue, 09 Oct 2007 22:59:47 GMT

Hi ,

What is the navigation to rename the table....I could not find the RENAME option for the tables but I can see this option for Programs and function modules.

Thanks.

Re: ragarding view

Former Member — Fri, 12 Oct 2007 20:39:25 GMT

> What is the navigation to rename the table....I could

> not find the RENAME option for the tables but I can

> see this option for Programs and function modules.

No response....

We are on ECC 6.0. We are unable to locate RENAME function in SE11. We are wondering whether SAP taken out this option and left over with COPY and DELETE????

Appreciate your inputs...

Thanks.