ragarding view

[Former Member]

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,

[Former Member]

Hi Experts,

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

Reagrds

Raman

[Former Member]

Hi

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

[Former Member]

Hi Experts,

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

Reagrds

Raman

[Former Member]

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

[Former Member]

hi,

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

you can rename from "Ztable" to 'Ytable"

rewards if useful,

regards,

nazeer

[Former Member]

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.

[Former Member]

> 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.