what is the difference between application tables and custamization tables?

[Former Member]

what is the difference between application tables and custamization tables?

[Former Member]

Hi,

A--Application table (master and transaction data)(This is SAP Import)

c--Customizing table, maintenance only by cust., not SAP import

Customized Tables:

SAP is developed for the business purpose.For taking decisions in running a business the all the data should be analysed and hence normalization of data is needed where your whole data is decomposed into sevaral tables each may having some relation ships like below:

Whole data Table:

EmployeeNo || Name|| Department || DeptName

needs more memory and more maintance and complexity is involved.

Hence decompose like below:

Table1(EMP)

EmpName|| Name||Department

and

Table2(Dept)

DEptNo || DeptName

Inorder to maintain data which may be of large data(millions of records)

we need to create tables(Custom) in SE11 and maintain relation ships between tables.There can be also a single table(is it is a small application)

Hope you understand why we need/create custom tables in SAP(Dictionary-se11)

REFER:

is for Application table which holds master and transaction data. The system (thru SM30)

won't ask for a request.

2. It will only ask in case of C

check this link

http://help.sap.com/saphelp_nw04/helpdata/en/43/45860774b711d2959700a0c929b3c3/content.htm

Regards,

Shiva

[Former Member]

Hi,

Most of the Tables which are updated using the SPRO config settings are called Customization tables

They start with letter 'T'.

ike T001, T002, T003, T005 etc.

Application tables are related the Business transactions in each tables

like in SD SO related table VBAK,VBAP.

and MM related PO tables EKKO, EKPO etc.

Regards

Kiran Sure