A system and method for field analysis, in an organization is described herein. According to the present invention, the system parses the software code to prepare an abstract syntax tree, extract attributes and relational report, load the report in a common repository, perform impact analysis on the said common repository based on user provided seed, and prepare the list of impacted variables. Further, if required the impacted fields are expanded based on the target size information provided.