topic Re: Database view in Application Development and Automation Discussions

Database view

Former Member — Tue, 06 Oct 2009 11:12:01 GMT

how to put the data in database view (M_AEN1B ).

want to add more records.

Thanks

Re: Database view

Sandeep_Panghal — Tue, 06 Oct 2009 11:18:43 GMT

Database views are direct representation of the transparent tables , so if you are updating the tables AENR and AENV , this DB view will also be updated.

Re: Database view

Former Member — Tue, 06 Oct 2009 11:51:20 GMT

hi sir

i need help to update database record

got some help regarding cc01/cc02/cc03 t-codes , but still my problem is notsolved

because

I changed the revision level of material from D To E (AETXT field ) . It picked the change number from data base view M_AENIB and field name is AENNR. but the issue is it is picking old date with ref to change number created .

it is not picking current modified date. ?

If i have to change the revision level, should i first create change number in database view . then t-code cc12 assign this number to revision level to get current date.... ?

and main concer is this problem

How to set / change the revision level ?

t-code

My requirement is ,While creating PO ,Revision Level is COMING.

Ex M1234 B

But when u create a Delivery schedule Monthwise in that case it is not showing

Revision Level.

Ex M1234 ( in this case B is missing )

How to get the Revision Level in schedule.

Thanks

Re: Database view

Former Member — Wed, 07 Oct 2009 05:47:37 GMT

hi ALL,

T-codes cc01/cc02/cc03 /cc11/cc12/cc13 , are related to change number/ revision level .

How to set / change the revision level ?

My requirement is ,While creating PO ,Revision Level is COMING.

Ex M1234 B

where M1234 is material and B is Revision level assigned to material.

But when u create a Delivery schedule Monthwise in that case it is not showing

Revision Level.

Ex M1234 ( in this case B is missing )

How to get the Revision Level in schedule.

Thanks

Re: Database view

Former Member — Tue, 13 Oct 2009 10:29:15 GMT

no ans regarding Revision Level. PO contains material with revision level and Delivery Schedule not containg material with revision level.

how to get it revision level with material in DS ?

Re: Database view

Former Member — Wed, 14 Oct 2009 04:57:30 GMT

Revision Level. PO contains material with revision level and Delivery Schedule not containg material with revision level.

how to get it revision level with material in DS ?

Re: Database view

Former Member — Thu, 15 Oct 2009 07:55:02 GMT

HI,

Abaper , MM consultants need some information on topic revision level.

my sap version 4.7 in t-code mm01-> basic data1 -> there is revision level tab that is associated th material change number.

while creating Purchase Order this revision level is coming with change material .

but when i create Delivery schedule for same material then this revision level is not coming.

How to find PURCHASE order programe name and layout name.

how to find Delivery schedule prograe name and layout name.

are they related to same programe ?( with type )

Thanks

Re: Database view

Former Member — Fri, 16 Oct 2009 06:49:56 GMT

Hi consultants...

what is the print program and layout programe name for Standard Delivery schedule programe . want to check Std. DEL Schedule has a Revision Level for material number .

Thanks

Re: Database view

Former Member — Mon, 19 Oct 2009 05:22:24 GMT

HI,

In Sap version 4.7 in t-code mm01-> basic data1 -> there is revision level tab that is associated th material change number.

while creating Purchase Order this revision level is coming with change material .

or already created PO for material with revision level , itis not shown in Delivery schedule

but when i create Delivery schedule for same material then this revision level is not coming.

How to find PURCHASE order programe name and layout name.

how to find Delivery schedule prograe name and layout name.

are they related to same programe ?( with type )

Thanks

Re: Database view

Former Member — Mon, 19 Oct 2009 07:50:25 GMT

while creating Purchase Order this revision level is coming with change material .

or already created PO for material with revision level , itis not shown in Delivery schedule

Re: Database view

matt — Mon, 19 Oct 2009 08:15:51 GMT

One question per thread please. And please use a meaningful subject in future.

Thread locked.

matt