SD - Surya - Damodar - 2016-07-08 - 27571 - Service Request - Rescheduling Plant Maintenance Activity (Dan by 2016-07-10) #OrderEntry #SDSupportOrderEntry #ProductionBreakFix

2016-07-08 - 27571 - Service Request - Rescheduling Plant Maintenance

Problem Summary

Rescheduling didn't pick up a material/s for which quantity changes were carried out. The SO in question was 3189329.

Admin Info


Purpose
 1. Create required plant variables in TVARVC
2.Fix database query execution by code optimization
Requested by
 Dan Brennan
Issue Date
 07-08-2016
Resolved by
 Surya Basa
Resolved Date
 07-18-2016
Document Status
 Complete

Detailed Problem Description

(Include Screen Shots if required )
1. Rescheduling didn't pick up a material/s for which quantity changes were carried out. The SO in question was 3189329.
2. The post processing program short dumped and outstanding materials were not deleted from the variables.


Solution Analysis and Recommendations

(Include Screen Shots if required)
1. It was observed that the user exit didn't pick up materials as the variable ZRSD_RESCHEDULING_PLANTS was not created with the required plants that should undergo rescheduling.
2. NEP debugging showed the select statement query was successfully processed for 0116 but in the case on 0117 there were approx. 4K materials and the input query to get the credit blocked orders (VBUK) and the corresponding items (VBAP) and this short dumped. The issue may be attributed to DB inconsistencies.


Resolution

1. The required plants were set up with the variable in TVARVC table.
TVARVC.PNG

2. All PO's and corresponding items/materials that were changed on the delivery date and quantity from 5/26/2016 to 7/7/2016 were extracted to run rescheduling manually.
export_last_new.XLSX

3. An LSMW (ZTVARVC - ZTVARVC - CREATE) was created to load the delta (5/26 to 7/7) into the variables in NEP.

3. The Program ZRSD_RESCHEDULING_DEL was optimized to handle the DB issue and was tested in NECNED300 and NECNEQ700 subsequently.



Release Information

Provide link here to Release Notes if Technical Objects were changed