Last Date on which stock Qty was zero

Advertisement
Dear Gurus,
LIS structure S032 can tell us the date of last GR,Cons., Iss. & movement date. is there any field which tell us the last date on which stock qty was zero ?
Regards,
FR
Advertisement

Replay

Dear Bijay Pradhan,
Thank you so much for your response, actualy we are using MCBA to desing a report by which we are determining the data since then the nmaterial has not consumed but we are facing the problem when consuption made and after consumption stock was zero and after 4 or 5 month only GR made  but no consumption made so when we generate report then system shows that the material has not consumed since last 4 or 5 months whcih is wrong because if no consumption made after the stock was zero then system should consider GR date for our report.
can you plz guide me how to resolve the issue?
Thanks & regards,
FR

CLOSING STOCK QTY FOR THE DATE

Hi Can any body tell, In which table i can find the closing stock qty for the particular date and for the particular material without including intransit stock qty. Regards Mani.Dear Santhosh, Yes, we tried to take the last MBLNR(Value) of the date f

Stock qty/value on specifiec date

Hi All Can anybody explain how  can we find the Stock qty and value on paricular date period through the table instead of transaction MB5B.I am waiting for your valid inputs. ThanxThis is not possible as SAP only captures stock data at month level. T

I have a problem when I loading application. It shown your payment method was declined due to last payment problem which I've already  paid.

I have a problem when I loading application. It shown your payment method was declined due to last payment problem which I've already  paid.iTunes Store Support http://www.apple.com/emea/support/itunes/contact.htmlRead other 2 answers

What's Happening?? Some days after installing latest security up date for 10.5.8 on G4, both inernal CD/DVD drives failed to mount disks other than a cleaning disk which mounted and was imported into iTunes.No other CD or DVD disk will mount.

What's Happening?? Some days after installing latest security update for 10.5.8 on G4, both inernal CD/DVD drives failed to mount disks other than a cleaning disk which mounted and was imported into iTunes. No other CD or DVD disk will mount.Is this

Looking for a query to find first/last dates in overlapping dates...

Hi, I'm looking for a query to find the first dates and last dates in a table conaining overlapping dates. I have a subscription table which has for each Customer start and end date for different subscriptions. I want to know the different ranges of

Date option in stock reversing program(SAP NOTE 175842)

Hi Gurus, We have prepared a program with SAP NOTE 175842 for reversing stock posting.My client has done GR in march 09 and quality peoples have posted to unrestricted stock in same month.Now because of some reason stores person want to cancel GR. So

What report is run in SAP to get the DATE on which Users are locked ?

Hello, What report is run in SAP to get the DATE on which Users are locked ? I have tried with RSUSR200 ,-- last logon ,last password change , but i did not get a option to find the date on which are Users are locked . Can anyone suggest what report

Last Data packet for the data load.

Hi All, How to find the last data packet loaded to target for the data load in SAP BI? In the Table? Thank you, AdhviHi Adhvirao, When u r loading the data from ECC go to monitor ---> details ---> check the data pacaket which are failed double click

What is the formula to bring the current last date from period hierarchy

Hi, Iam working on Hyperion financial Reporting.i have created a grid with 2 dimensions(entity and period).My requirement is that the current last date of the period hierarchy should be displayed automatically in the header when the report is run.wha

HOW DO I SEE THE LAST DATE I BACKED UP ON ICLOUD

How can I see the last date that icloud was backed up?Go to Settings>iCloud>Storage & Backup and look at the very bottom under Back Up Now.Read other 2 answers

Yesterday, I used 5000 bonus points to buy 1 extra gb of data.  This hasn't shown up in my account yet. The 5000 points deduction is listed in my Smart Rewards account, but no bonus data.  I thought it was supposed to show up almost immediately.  Will it

Yesterday, I used 5000 bonus points to buy 1 extra gb of data.  This hasn't shown up in my account yet. The 5000 points deduction is listed in my Smart Rewards account, but no bonus data.  I thought it was supposed to show up almost immediately.  Wil

Hi i am from india i bought my phone last year from hongkong as it was not launch in india.now with the ios5 upgrade the home button has become very hard. i take a lot of care of my phone.the istore is not ready to repair it .please do something

hi i am from india i bought my phone last year from hongkong as it was not launch in india.now with the ios5 upgrade the home button has become very hard. i take a lot of care of my phone.the istore is not ready to repair it .please do something.it w

Min,Max for a time Range and Sum of Records for the last date/time

Hi All, I have a table with the following structure/data: create table  Events   (                                     [EventID]        int                   NOT NULL,                                     [Title]             nvarchar(200)  NOT NULL,  

Last Date for customer transaction

Is there a SAP field which stores the last date for a customer transaction. Thanks.yes there is a field which stores the last date for a customer transaction Regards PS: Be clear in your question.Read other 2 answers

Last date of month

Hi im new to java. Looking for a class that provides last date of the month according to a given year and month .java does provide a calendar object for gregorian dates.. surprising its called GregorianCalendar. :PAs I said avoid GregorianDate in Jav

Get Last date of every Month in a year

Hi All, I need to find last date of month for given year. Example: I used to pass date or year such as 2012 or 01-01-2012(DD-MM-YYYY) SQL query needs to return last date of every month such as 31-01-2012 28-02-2012 31-03-2012 30-04-2012 31-12-2012 fo

Delivered qty and put in stock qty not updated after GR reversal

Hi, We encountered a strange issue while making a 102 movement for a production order. Planned order qty  - X Production order qty  - X+Y Confirmed Qty  - X GR posted for Splits of Qty X GR Posted for Qty Y At this time Quantities in Production shows

Previous month last date in sql

hi i am using function select dateadd(day,1 - DATEPART(day,dateadd(month,24-36,GETDATE())),dateadd(month, 24- 36, getdate())) this will giveme 2014-03-01, now what changes  i need to make this function which will give me previous month last date. 201

Variable last date of previous month/last date of current month

Hello Experts, I am facing an issue while designing a query. Requirement is like this. Report will be run on monthly basis.so on execution of report, it should prompt for month/year. now on report there are two columns for which I have to get data on