vaibhav
Member
Hi,
I have a find browse form that is working fine so far. however a new requirement needs the grid to show some records based on a new header field that is not a part of the business view. The value from the header field will go to couple of tables(F0413 and F0414) with many to many relationship of records and finally with have to fetch the data from the tables(F55XXX) in the business view and show them in the grid. I am taking the value from the header field something as shown below:
F04311.select (pass the header field value DOCM)
F04311.fetch next (will retrieve multiple records,PYIDs)
while file IO status is CO Success
F0414.select (based on many PYIDs retrieved frm F0413)
F0414.fetch next (will retrieve multiple DOCS)
while file IO status is CO Success
BC or ?? (of a custom table on which grid is based) = F0414.DOC
F0414.fetch next
End while
F0413.fetch next
End While.
The concern is where to write this code and to which parameter(FC,GC,BC) to pass in order to get the records in grid.
I have a find browse form that is working fine so far. however a new requirement needs the grid to show some records based on a new header field that is not a part of the business view. The value from the header field will go to couple of tables(F0413 and F0414) with many to many relationship of records and finally with have to fetch the data from the tables(F55XXX) in the business view and show them in the grid. I am taking the value from the header field something as shown below:
F04311.select (pass the header field value DOCM)
F04311.fetch next (will retrieve multiple records,PYIDs)
while file IO status is CO Success
F0414.select (based on many PYIDs retrieved frm F0413)
F0414.fetch next (will retrieve multiple DOCS)
while file IO status is CO Success
BC or ?? (of a custom table on which grid is based) = F0414.DOC
F0414.fetch next
End while
F0413.fetch next
End While.
The concern is where to write this code and to which parameter(FC,GC,BC) to pass in order to get the records in grid.