N/APosted on - 11/18/2011
May I ask as to how I could find the master data in the tables for faster transactions? We always create customer information and details. And regularly, we make updated data in RF02D format and add tables e.g. KNA1. Often, all data and additional information are added when needed. May I ask for your recommendation on how to solve this?
Thanks in advance!
Finding master data in tables for faster transactions
This will need to have a deep analysis on your data structure. Use table linking or making database relationship so that searching for a certain data can be easily located because the data has the link to the master file. You need to have at least one unique field in your master file that matches on the linking table. Set this unique field as your primary key, this will help you easily searching a particular data in your master file. This will help you also avoid the redundancy of creating customer each time you created a transaction. You may also benefit from this for saving database space. Just make a implementation of browsing the master file on the transaction form of your application and link the data using many to 1 relationship.