Link between ordered quantity and confirmed quantity schedule lines

[former_member199670]

Hi people,

I just want to know how we relate the confirmed quantity schedule line to its relevant order quantity schedule line in sales order.

e.g. I have totally 6 schedule lines in which 2 are having the details of order quantity, and rest of 4 have the confirmed quantity.

1st schedule line - Order quantity 4, No confirmed quantity

2nd schedule line - Order quantity 6, No confirmed quantity

3rd schedule line - Confirmed quantity 3

4th schedule line - Confirmed quantity 1

5th schedule line - Confirmed quantity 3

6th schedule line - Confirmed quantity 3

All the schedule lines are ordered and confirmed in the same day. We added a field called 'Status' in each schedule line that holds the status of the schedule line whether it Scheduled or delivered or Not relevant etc(We cannot change this functionality anymore).

I just want to send the status of schedule lines, where I don't need to send the status of order quantity schedule line but the confirmed quantity schedule line once the schedule line is confirmed. If not confirmed I need to send the status of Order quantity alone.

There was no problem if ordering and confirming happens in same schedule line, the problem is when they do in different schedule lines.

In the above example I do no how to relate which confirmed quantity scheduled line will be related to the relevant ordered quantity schedule line.

Please help!

[Jelena]

I'm assuming you're asking this for some kind of report.

No simple answer here, sorry. You'd have to read all the schedule lines and then just compare them from top to bottom. We have a similar problem when we need to find which delivery relates to which schedule line. A while ago I looked through the standard SAP logic in the screen and it seemed to me it was doing exactly that.

It is, unfortunately, not very efficient way when the same information is needed for many documents but I was unable to find anything better. At least not until ECC 6.0 EHP6.

[Lakshmipathi]

While I am not sure, what is the need to bother much on the order quantity from schedule line which I never come across. We normally see the order quantity from VBAP, if at all we need to generate some report. Still if you want to correlate this, you can very well compare WMENG with BMENG from VBEP table