‎2007 Mar 22 11:36 AM
hello abapers,
i want to know how we can customized tale in dictionary?why we create customized tale.plz send some real time example.
‎2007 Mar 23 8:48 AM
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)
Reward points if heplful
Regds,
Rama chary .Pammi
‎2007 Mar 22 11:43 AM
nishith,
v create customized table, becoz of the requirement.
consider a realtime scenario, v need some table say zdealer, which contains details of the dealer, which is not available in the standard table. But for displaying the records of the dealer in the report, v need of a table.
V go for customized table when v can't find the fieldnames which match our requirement.
Regards....
Arun.
Reward points if useful.
‎2007 Mar 23 8:48 AM
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)
Reward points if heplful
Regds,
Rama chary .Pammi
‎2007 Mar 23 9:00 AM
For more information abt creating database table click below link:
http://help.sap.com/saphelp_erp2005vp/helpdata/en/5b/d2215e43c611d182b30000e829fbfe/frameset.htm
regrds,
Rama chary. Pammi