Dear friends:
We are creating a custom application, one of the data fields in it is Vendor.
My question is how should address data for the vendors be stored in a custom table?
What is the correct oracle datbase mangement practice? Should the custom application database table store Vendor value only and not any of the address related fields? Or can both vendor and address fields be stored in the custom application tables?
The reason I am asking this is, I noticed in PO/PR data tables (EKKO, EKPO, EKKN,...) Vendor alone is stored, not address fields, they are fetched from the address management system. However, in a/c assignment tables EKKN/EBKN all of the accounts linkage data is stored, ie WBSE, Cost Center, Bus Area, Asset, fund, fundscenter, even though individual account objects are linked in controlling.
Please help.
Thank you.
Bluesky
