workfile creation-urgent

[milu753001]

Can anybody tell me cocept of workfile .
How can i create it from a section of a UBE.

My scenario is I want to use F4211L as BV for section ,but i need a line number field
for fetching from F4074(where its passed as 121.0001) simultaneously i want this field as level break footer
but if i use it for footer i consider the integral part (by flooring).So i cant paas only the integral part as
for ffetching from F4074.
So i will put this line number field in anther customised field ,
so that i can use one field for level break and other one for fetching from F4074

But i dont knw how to create the workfile.and what are the table I/o operartion
to perform get that

plz guid me for this

 

[eydeak]

You don't actually create an on the fly table.



Use Table Design Aid to create the table that you will use as a work
table for your report. Then, in your report you can write to and read
from that table.



For your specific scenario, I would suggest the following.



1. Copy F4211L to a new table.
2. Modify the new table, removing any fields you don't want and
adding a field for your level break value. You will probably also want
to modify the index to include the new field.
3. In your report, establish a section that will be your "driver".
This section will be invisible. You will use it to read the records you
want from the F4211L, generate the value you need for your level break
field, and insert the data into your custom table.
4. Once you've finished populating the work table, call a custom
section to display the data from the work table.



You should be able to get all the information you need from JDE help to
perform the suggested tasks. I also strongly recommend you follow the
recommended naming conventions outlined in the JDE help.



Good Luck,



Ellen Deak

Senior Analyst/Programmer

Cooper Standard Automotive

OneWorld Xe Update 7 SP22_T, AS400 DB2 V5R2M0, Citrix Clients