JDE Techie
Active Member
Hi,
I have a requirement where I would need to validate a Processing Option value with the value entered in the immediate previous field.To explain in detail,If I have a processing option data structure with couple of fields "From Date" and "To Date",when I enter a value in "To Date",I would need to check if it is a valid date which would be taken care by the data item associated with that PO Structure as well as I would need to check if that "To Date" is a date greater than "From Date" and this second condition I would have to check before the user clicks "OK" button on the processing option.
I tried to analyse and following were my findings:
a) I checked the report R98306 which is based on the F983051 table which stored the PO values in BLOB format and for reading that,this R98306 report uses a business function "GetPOValue and Text" which takes in the input parameters as the report name ,the version name and a Cache value predetermined in the header file and then outputs the PO text value.
My concern is the PO values get written to F983051 after the user presses ok and where this cache comes into play.
I think if I would require to compare the "To Date" if it greater than the "From Date" and that too before the user clicks OK ,I would need to use temporary tables concept.
I would like to seek your advice whether my direction of analysis is correct and if anyone in the past has faced this scenario and if they could provide their inputs.
I am on ERP 9,TR 8.98
Best Regards,
Josh
I have a requirement where I would need to validate a Processing Option value with the value entered in the immediate previous field.To explain in detail,If I have a processing option data structure with couple of fields "From Date" and "To Date",when I enter a value in "To Date",I would need to check if it is a valid date which would be taken care by the data item associated with that PO Structure as well as I would need to check if that "To Date" is a date greater than "From Date" and this second condition I would have to check before the user clicks "OK" button on the processing option.
I tried to analyse and following were my findings:
a) I checked the report R98306 which is based on the F983051 table which stored the PO values in BLOB format and for reading that,this R98306 report uses a business function "GetPOValue and Text" which takes in the input parameters as the report name ,the version name and a Cache value predetermined in the header file and then outputs the PO text value.
My concern is the PO values get written to F983051 after the user presses ok and where this cache comes into play.
I think if I would require to compare the "To Date" if it greater than the "From Date" and that too before the user clicks OK ,I would need to use temporary tables concept.
I would like to seek your advice whether my direction of analysis is correct and if anyone in the past has faced this scenario and if they could provide their inputs.
I am on ERP 9,TR 8.98
Best Regards,
Josh