2008 Jun 15 11:57 AM
Hi Experts,
I am new to table maintenance generator, i got below issue can u please guide on this.
I am having two customized tables ZARCAT, ZARCAT.
Is there any of the one of the events available before output or make the modification in the screen directly by coding F4 help. (in this case as and when table maintenance is generated code will be lost so we have to be careful) .
2) We need to put validation in "before saving data" event that if all the fields Ccode + Category + GL Account + Doc type are blank then raise an error message "All Fields Cannot be Initial"
This can happen only once since this is the primary key, but we need to make sure there are no blanks otherwise it will affect the report selection and layout both.
3) Validations to be built on ZARCAT table maintenance ,
a) Category code should not be initial
b) Check that no user is able to delete category code 00 and 99 (since these pertain to Opening bal and Closing Bal ) .
c) Field colseq should never be blank
d) Whenever SUBTOTFR is entered check that SUBTOTTO is also entered and
e) Validate SUBTOTFR is not greater that SUBTOTTO .
f) SHKZG should not be initial on any record
g) CATDESC should not be initial.
All these validations can be done using events.
Thanks in advance,
Mahamood.
2008 Jun 16 1:19 PM
Hi,
The table maintainance generator is standard program created by SAP at runtime.
But there are provisions given by SAP to put your logic in that program on the basis of specific event.
go to se11-->put your Z table name - >table maintaninance - >Environment->Modifcation->Events.
When chosse the events and code accordingly in the editor i.e. icon given beside at the table that will lead you to the code editor.
2008 Jun 16 11:56 AM
Hi Manisha,
Check this Link
[https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc|https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc]
2008 Jun 16 1:19 PM
Hi,
The table maintainance generator is standard program created by SAP at runtime.
But there are provisions given by SAP to put your logic in that program on the basis of specific event.
go to se11-->put your Z table name - >table maintaninance - >Environment->Modifcation->Events.
When chosse the events and code accordingly in the editor i.e. icon given beside at the table that will lead you to the code editor.