Step by step to create a table in DATA Dictionary in SAP ABAP:

STEP BY STEP PROCESS TO CREATE A TABLE IN DATA DICTIONARY :-

1).Go to SE11.
2).Give name to the Database table.
3).Give short description for the table.
4).Give delivery class name as A(Application table) and data browser/table view maintenance as Display/maintenance allowed.


Delivery Class
Description
A
Application table (master and transaction data).
C
customizing table, maintenance only by customer, not SAP import.
L
Table for storing temporary data, delivered empty.
G
customizing table, protected against SAP Update. Only INS all.
E
control table, SAP & Customer have separate key areas.
S
system table, maintenance. Only by SAP, change modification.
W
system table, contents transportable via separate TR objects.

5).Select fields tab.
6).Give field name data type[user defined element type/built in type] short text.
7).Select technical settings tab, give data class as appL0[master data, transparent table] & size category as 0[0-2600 data records]. 


Data class : It is the physical areas or table space that the table has to be stored in Data Base.
Data Class
Description
APPL0
Master data, transparent table.
APPL1
Transaction data, transparent table.
APPL2
Organization and customizing
USER
Customer Data Class
USER 1
Customer Data Class

Size Category : The size category defines the expected required for the table in the database. We can choose a size category form 0 to 4 for your table. Each category is assigned fixed memory size in the database, which depends on the database system used. 
Size Category
Number of Data records of table expected
0
0 to 2,600
1
2,600 to 10,000
2
10,000 to 42,000
3
42,000 to 170,000
4
170,000 to 13,000,000

8).Save it.
9).Go to utilities menu click table contents select create & enter the field values then select display in table contents & you can view the table values with field lables. 


While Creating the Table, we Can Provide the technical attributes such as Data type, Length & Description of the Fields in 2 – ways
a).One way is Providing the technical attributes Directly.
i.e., Provide the Data type, Length and Description Individually.
b).2nd way is providing the technical attributes through Data Elements and Domains.
i.e Provide the Data type, Length and Description by grouping into Data Elements and Domains.

Note: We Never Provide the Technical attributes of the field using Direct type instead it is through Domains & Data Elements.
   

Comments

Popular posts from this blog

EVENTS IN INTERACTIVE REPORTS OF SAP ABAP

SAP ABAP Fresher Resume/ CV Writing Format..

CONCEPTS OF INNER JOIN AND OUTER JOIN in SAP ABAP