HI !
I have this custom table which is the allocation table and by running a transaction we can update the table automatically. Now I have to create another transaction to update the same table but after validating and checking few entries from the mseg table so further drill down can be done and then the values entered. Can anyone help me out with this please, its really urgent.I even have an existing report which is doing it but I need to create a new one with the following specifications.
Selection Screen:
Material Document of Original Transfer Posting (101/311): __________ (ZALLOC- ZMBLNR)
Receiving Plant/S.Loc. Item of Original Transfer Posting (101/311): ____ (ZALLOC- ZZEILE)
Material Document of Pro-rationed Transfer Posting (901/911): __________ (ZALLOC-ZMBLNR_PRO)
Receiving Plant/S.Loc. Item of Pro-rationed Transfer Posting (901/911): ____ (ZALLOC- ZZEILE_PRO)
--end block
--new block
Issuing Plant: ____ (ZALLOC-ZWERKS_ISS)
Issuing Storage Location: ____ (ZALLOC-ZLGORT_ISS)
Receiving Plant: ____ (ZALLOC-ZWERKS)
Receiving Storage Location: ____ (ZALLOC-ZLGORT)
Batch: TRANSFERS (ZALLOC-ZCHARG non-changeable default TRANSFERS)
--end block
Program Flow:
- Find the material document lines of the pro-rationed transfer posting.
- Check to see if the pro-rationed document is a 901 or a 911 material document. Display hard error Pro-rationed document item is not a 901 or 911 movement type
- Check to make sure that the MSEG-WERKS and LGORT match the receiving plant and storage location ZWERKS and ZLGORT. Display Hard Error Provided pro-rationed item plant and storage location does not match the provided receiving plant and storage location.
- Check the material document ZMBLNR_PRO and ZZEILE_PRO for MSEG-SHKZG = S. Display hard error Item Line is not an Inbound Item into Receiving Facility. Check for correct item line in pro-rationed material document (901/911)
- Check to see if this key has already been entered into the ZALLOC table.
- If it is grab the volume from the item line, populate all fields
- Use the Posting Date as the date.
- Insert it into the table.
- Provide success/error report to show the record entered.
If someone can provide some help will be highly appreciated and ofcourse points awarded as always..please.
Thanks
Aarav