Table Creation In SAPR/3.

TABLE CREATION IN SAPR/3.

TABLE CREATION IN SAPR/3.

 

In ORACLE table can be created using syntax directory.

In SAPR/3 table cannot be created with syntax.

 

DOMAIN SCREEN

 

1.User can maintain a data type as well as length of the field.

2.User can also define properties of a field.

 

DATA ELEMENT SCREEN

 

1. User can maintain field labels from back end.
2. User can create a filed without data element also.

 

Under ABAP WORKBENCH

 

ABAP Dictionary --------- Domain ----------- Data Element

 

Table Creation in SAPR/3.

 

       YEMP

ENO      ENAME

 

Maintaining field with a data element (ENO)

Select SE11

Domain Screen

Y/Z Field Name

Start to create

Short text for domain: Domain for ENO Field

 

In ABAP Language ABAP program can be executed by ABAP processor.

 

ABAP PROCESSOR is an interpreter and it can execute logic sequentially.

 

While executing logic ABAP processor can execute based on character format.

 

Data Type                      :           Char

No. of Characters           :           10

(Length of field)

Click on save      -           Select Local Object         -           Development class should be blank

Activate (Control+F3)      and       Activate Domain (Ctrl+F3)

 

Save     :           Control+S                                  Back      :           F3        

Activate :           Control+F3                                Execute :           F8

 

With activation ABAP objects transfers from R/3 Application Server to R/3 Database Server.

 

Select SE11 (ABAP Dictionary)

Data Type          :           Provide Name

Click on create   -           Data Element

Short text          :           Provide short text for data element

Domain             :           Enter domain name created

Field Label         :           Length = 20 Employee Number

Save (Ctrl+S)

Development class: Blank            Select local object          Activate data element (Ctrl+F3)

 

Select SE11

Database Table              :           Provide Name (YEMP)

Data Type                      :

Click on Create

Short text                      :           Employee Table

Delivery Class                :           A

Enable Table Maintenance

Select Fields

Fields

ENO      -           Primary Key                   YENODATA

 

Steps while creating EMP Table

1. Domain (YENO)

    Short Text

    Data Type

    No. Of Characters=10

2. Data Element (YENO)

   Domain -- YENO

   Short Text

   Length = 20

3.Database Table (YEMP)

   Field = ENO

  Domain assigned --- Data Element --- Data Field

Lowest Hierarchy is DOMAIN

Next Hierarchy is DATA ELEMENT

Higher Hierarchy is DATA FIELD

 

Maintaining field without Data Element

Field

Ename  -- Direct Type (Select)

Data Type: Char

Length      : 30

 

Select Settings Option

 

Data Class     : APPL0

Size Category: 0

 

SAVE    -           F3         -           CTRL+F3

 Select Utilities from Menu Bar under it Entries Option

 

Enter Details

ENO      :

ENAME  :

Save

Select Utilities from Menu Bar under it Entries Option – Display

Press F8 (Execute)

 

 

• < Prev
• Next >