Dear Soniya,
I expect that you use the scheduling agreements with delivery schedules (if without, then the logic is similar to the standard orders). In the case of scheduling agreements with delivery schedules the open quantity is always determined dynamically during opening the scheduling agreement (the field VBEPD-OLFMNG). There are no fields on the database, which store the open quantity. The calculation of open quantity takes place in the function module RV_SCHEDULE_CHECK_DELIVERIES.
The general algorithm of calculation of the open quantity is the following one. For every scheduling agreement and every delivery schedule you have: cumulated qunatity delivered (stored in the database table S073) and cumulated quantity received (can be changed always manually in VA32). Their difference gives the cumulated in-transtit quantity.
The open qunatity is the schedule line quantities minus cumulated in-transit quantity. The quantity reduction through the transit quantity takes place from the first schedule line and goes to the later schedule lines before the complete in-transit quantity is distributed. All rest schedule lines give the open quantity, but only all delivery relevant schedule lines (if you use forecast and JIT or planning delivery schedules then not all your schedule lines are delivery relevant, according to your VBAK-ABDIS flag).
It is the logic, how the open quantity VBEPD-OLFMNG is determined in the scheduling agreements with delivery schedules. This quantity has nothing to do with VBBE / VBBS, because in the scheduling agreements you have partially delivery-requirements relevant schedule lines (they are considered), pure delivery relevant schedule lines (they are considered), pure requirements schedule lines (they are not considered) and for nothing relevant schedule lines (they are not considered).
If you have only forecast schedule, then the calculation is simpler, because all
schedule lines are delivery and requirements relevant.
Unfortunately as the field VBEPD-OLFMNG is calculated dynamically there are no options to write a simple report here which gives you the open quantity from the database table. So, there are no standard tools to calculate the open quantity so simple in the standard ERP system. As far, as I know, you can extract the open quantity into BW during saving the agreement.
I hope, the info above helps you further.
Kind regards,
Akmal Vakhidov
Development Support SD, SAP, Walldorf/Germany
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.