Dealing with Union Views

Chapulin

Active Member
Hi! I'm using in a report a standard view (V42119B) which is a union between F4211 and F42119 tables.
My doubt is how to difference to which table a record belongs so I can get the right values for all fields.
When I'm designing I always have in a record both options for every field (example: Document Number (F4211) and Document Number (F42119).
I think in an union the correct implementation should be that I'll always have the same values in both fields so I can treat them undifferently but I don't know how One World deals with this issue.
Maybe for the F4211 records the corresponding F42119 fields are left empty or blank, and I should always check in which table I have the right values!
I really don't know. I hope you can understand what I'm trying to say!! :)
Thanks a lot!!
 
I am not very sure about your question. I belive that once they close the orders then G/L dates are available in F42119(which i am not sure.This needs to be confirmed).May b you can go by the G/L dates to check for the records.
 
Back
Top