How to identify open schedule line item?

[former_member184806]

Hi,

I have a requirement for identifying open schedule line items. I want to identify any indicator or any field in any table which will tell me that the schedule line item is complete. Can anyone tell me how can I know that?

Ex. Sales Order 1 has 3 materials (line items) in it A, B & C.

       For A the quantity is 10 and for which 3 schedule line have been created.

       Out of the 3 schedule lines, 1 schedule line item is complete that is the delivery has been done and the rest 2 are open.

For B and C there are 4 & 5 schedule lines created and all are open.

How can i identify that total 12 schedule line 1 is completed and 11 are open.

Please suggest tables, field names / indicators.

Regards,

Vishal

[Former Member · Accepted solution]

Hi Vishal,

You can not identify the open line items directly, rather you have to calculate the delivered quantity and copmare it with the ordered qty for each line item. The ordered qty can be idenitfy from the table VBEP and the deliverd qty can be found out by calling the function RV_SCHEDULE_CHECK_DELIVERIES.

Follow the link for more details to calculate the delvierd qty.

http://scn.sap.com/thread/279862

Rgards,

Rutvik.

[Former Member]

I am sure you know that confirm qty does not mean that delivery is always same qty.

You know VBEP table gives you confirm qty. check all VBFA on its related delivery and submmarize all delivery qty in VBFA or in LIKP/LIPS for that SO item. Then do a Total Del qty - confirm qty for that schedule line, if result is >= 0 then mark that schedule line as delivered.  Base on this concept, you may like to work out the formula for the scenarios where delivery qty <> confirm qty.

[Jelena]

The answer will depend on your definition of what "open" means (in general, in SAP "open" = no delivery created, but other companies have a different definition, e.g. "not invoiced"). Unfortunately, there is no status table (like VBUP) for the schedule lines and in our system I don't really see any completion flag in VBEP either.

If no one else has a better suggestion, you may need to start with VBUP to find the order lines that are still "open" (the field will depend on your definition above) and from there if status is A then it's easy - all schedule lines are open, but if it's B then you might have to get all the related deliveries and calculate which schedule lines are still "open" and quantities.

[siva_vasireddy2]

Hi,

you can generate a Report by yourself with SQVI  by taking logical Database -VAV