Table construction for application

[Former Member]

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?

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 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 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.

[Former Member]

Vendor master data table is LFA1. In this table,there is a field ADRNR, it is address code , match the Address master data table ADRC.

When you define the master data of Vendor through T-code MK01 or XK01, the Address information save in LFA1 and ADRC table.In the original program,it use a structure to store the Address information -- ADDR1_DATA, it's type is similar to ADRC,match with the key field

LAF1-ADRNR -> ADRC->ADDRNUMBER.

I hope this maybe helpful.