Finding master data in tables for faster transactions

Asked By Hollis 0 points N/A Posted 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!

• Status: Open
• Question Views: 838
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Internet

Answered By Trevor 0 points N/A #112133

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.

 

About Trevor

Questions
2

Answers
315

Best Answers
83

• Vote Up 0 Vote Down

• Posted on - 11/19/2011
• Question Category: Internet