- Maps are also known as Table Maps/AOT Maps. Table Map is a element/object the makes possible to link/associate map fields with fields(same type with different names) in different tables.
- like, I have create a MAP with field (AccountNum) and Same field exist in CustTable and also in VendTable,so I can associate field in CustTable and in VendTable with Maps, so basically Maps enables to access the fields with different name in different tables.
Procedure For Creating a AOT Map:
- I created a Map by navigating to AOT>Data Dictionary>Maps and right click and new and gave it name ‘MapTest’.
- I have created 4 fields under Fields node in Map (Best Practice drag and drop from EDT).
- Now the next thing I need to do is to associate the fields in map witch i created with the fields in different tables, let say I am taking two tables (CustTable and VendTable).
Notice that above, four fields that I have created in Maps also exist in
CustTable as well as VendTable with different names.
- To associate fields, go to Mapping node, right click it and click New mapping and enter the table that you want to associate in Mapping Table field as following,