How to find exp date deviation in same column for same Posting date

[former_member1048438]

Hi,

I have a issue like -

I want to find deviation in last column for same Material Number, Same Batch , Same posting date and to find if there is any difference in Exp Date which is last column in the figure.

1. for same posting date -  If 2nd row Exp date is less than the first row exp date.

Then that row should be found.

can anyone help me out is there any logic in Graphical calculation view.

Thanks,

GnR

[lbreddemann]

Hi there,

why don't you just a self-join here?

Or a sub-select (EXISTS) to find those records?

Doing this in a graphical calc view seems unnecessarily cumbersome, but hey, it's your model

[former_member1048438]

Dear Lars,

Do you explain me n details if you dnt mind.

I need a record to find... If the 2nd row of  date(Last Column) is less than 1st row date (last Column) of the same posting date.

then that row should be the resultant.

Thanks,

GnR

[lbreddemann]

What is it about the 2nd row here?

You did not specify any order of the records.

Ok, in order to make this somewhat efficient, please provide the commands to create your table and the insert statements for your test data.

Right now all we have is a somewhat confusing description and a picture...

[former_member1048438]

Hi Lars,

Assume that

First row is Material,

2nd row is Batch Number,

3rd row is Posting date and

last row is Expiration date.

I want to find a deviation record in last row when that expiration date is Less than the previous record of the expiration date of same Posting, same Batch and same Material.

then that record is the resultant in my case.

[lbreddemann]

Sorry, not going to look any further without the requested SQL commands.

I consider that the minimal level of information that you need to provide.

Also be a lot more precise with your language here; I think you meant columns instead of rows i

In your last reply and you still left out any information on the order of rows that you expect when you talk about first/second/last row.

[former_member1048438]

Hi Lars,

here is the screen shot.

see that, MATNR, CHARG, Posting date and VFDAT.

Now VFDAT is same for Posting date.

If that VFDAT is changed for that same Posing date.

then i want to get that record.

Thanks,

GnR

[lbreddemann]

Reddy,

the point of having the create table statement and the insert commands is to be able to work with your example and produce a solution that you could take and just run.

I am not going to create a table and the data based on your screenshot. That's not worth my time.

- Lars