Validations for entry into table

[Former Member]

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

[Former Member]

I'm not sure what you're asking. Are you having problems with a specific part of this report or are you wanting someone on here to write it for you?

[Former Member]

No NO, I dont want anyone to write the report for me , but I ma facing problem in getting the link to the report and how to go about in the validation process to reach the solution.Which tables do I need to realte to extract the data so that I can add my transfers to the allocation table.

Thanks