Reservation

[Former Member]

Dear all,

for one particular material, i have checked in MMBE for reserved Quantity

it is showing reserved qty as 392 Nos

but where as i checked in SE16, in RESB table, inputting this material

it's giving so many values, but it is not showing anyware 392

in which table i will get this value 392 Nos

Regards

kumar

[former_member196398 · Accepted solution]

Kumar,

All reservation data is available in RESB table only, but you need to apply some logic to find open reservation, because what you see in MMBE is only open reservations. You wont get this value directly in any table as it is an internally calculated field.

Open reservation for a material plant would be sum of RESB-BDMNG minus RESB-ENMNG where RESB-SHKZG = "H", eliminating records where RESB-XLOEK = " "(Blank), and RESB-KZEAR = " "(Blank)

Regards,

Prasobh

[Former Member · Accepted solution]

Thanks Prasobh,

For ur prompt reply

yes at last by including, excluding , equal to , not equal to got it (some fields)

but here point is , we have already developed a Z-report for out of MRP with some fields

but now client wants to add the (reserved field of MMBE)

so i got confused because of getting some many values in RESB table

Hope u understand & reply

Regards

kumar

Edited by: kumar kumar on Sep 19, 2009 5:25 PM

[Former Member · Accepted solution]

Hi,

If you have a report which is reading MRP results, then why not use the same data to fill another column showing the reservations ?

What difficulties do you foresee to it ?

Regards,

Vivek

[Former Member · Accepted solution]

Dear Vivek,

Thanks for ur prompt reply

now client want (field of resreved qty of MMBE) to included in Z-report

Now my ABAPER is asking me which field has to fetch

because in RESB i am unale to get the Value of resreved qty

what should i reply to him

Regards

kumar

[former_member196398 · Accepted solution]

Kumar,

I am not sure of your current report logic and what data is being fetched.

Anyway I have already provided the logic to fetch the record. Please provide my post details to your ABAP person he/she should be able to get the output for the new field using the highlevel Specification given by me.

Regards,

Prasobh

[Former Member · Accepted solution]

Hi,

As Mr. Prasobh has pointed out the reservations in RESB are not stored in one field that you can directly read from. It needs a calculation to be done just as the MMBE report does, also did you give a try as per the inputs provided by him?

I am quite sure your abaper must be able to code that logic its not complex at all. Give it a try & if you or your abaper faces any issue revert back & will help you with the code.

Regards,

Vivek

[Former Member · Accepted solution]

Once again Thanks Very much Prasobh & Vivek

will give the logic, which u have posted

and get back to You

Once again thanks to Both of You

don't mind will close the thread after wards

Regards

kumar

Edited by: kumar kumar on Sep 19, 2009 5:55 PM

[csaba_szommer · Accepted solution]

There's standard report about reservatons: MB25. Your ABAP programmer can check the code of this report and apply it to your development.

Regards,

Csaba

[Former Member · Accepted solution]

Thanks Csaba,

i think this is the first time u replied to my post

Glad to see ur reply

will definently tell my ABAP'er to check MB25 report logic,

Dear all,

still i have one doubt, the orders are in TECO status & CNF also DLV

stiill reservations are showing in RESB table (against PRd orders)

why it is showing & what is the logic

Regards

kumar

[rupesh_brahmankar3 · Accepted solution]

Dear,

In CO11N or CO15 you need to select the final confirmation with clear open resrvation.

When you do TECO for the order the reservations get cancelled.

Regards,

R.Brahmankar

[Former Member · Accepted solution]

Hi,

Once TECO is set, any open reservations are closed by the system, but the entry remains in RESB.

Anyways as a thumb rule just monitor the following fields in RESB table -> Issue Relevant, Deletion Indicator, Final Issue, required qty & withdrawn qty. You should be able to figure out which are really open & which are not.

Regards,

Vivek

[csaba_szommer · Accepted solution]

Hi,

If reservation is processed it will not be deleted physically from databae that's why you'll find reservations of closed production orders in it.

It is recommended to remove old reservations physically from the database because of performance issues. First you have to mark the reservations for deletion and after that you can remove them physically from database.

Please check SAP online help for details:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/a5/63373a43a211d189410000e829fbbd/frameset.htm

Use
Management of reservations involves the following:
deletion of the reservation file 
mass changes to reservations
Deletion of the Reservation File
You should regularly delete completed, old, or unnecessary reservations to prevent the reservation file from becoming too big. Reservations are deleted as follows:
Reservation items that are completed or that are in the system longer than a certain number of days are marked for deletion by the reservations management program. 
If all of the items of a reservation are marked for deletion, the reservation is physically removed from the file.
...

(Transaction is MBVR)

Regards,

Csaba

[Former Member · Accepted solution]

Thanks to all my Repliers,

Dear Csaba,

in Transcation MBVR, we have two options as (reservation from & to, base date)

Now, how to know in the particular date which resrevations numbers should be given

is there any Std way to know that,

on the particular date, these resrvations are processced

Regards

kumar

[Former Member · Accepted solution]

Dear all,

Once again Thanks to You all,

Now asigning Points is a problem is to me

Because all of u tried to solve my query

But u people know as per SDN

at the most i can stisfy Three

so Request u experts to don't mind this time

Hope u experts understand

with this i am closing this thread

but again if a doubt raised in my mind abt Reservations

then again will post a query in SDN

and expect same kind of respose from you all

once again thanks to all my repliers

This thread is closed

Regards

kumar