How to create tables in SAP System-I

 There are three ways to create a table in SAP-

1. Using Built in type or pre-defined type
2. Using top-down approach (Table, Table properties, fields, data elements, domains, check fields, currency fields, technical settings,...)
3. Using bottom-up approach (data, domains, data elements, table, table properties, fields with data element assignments, technical settings)

Creation of table:

Master data table creation using built-in type/pre-defined type-

Structure of the table

SMID_CHAR (4) key

Name - CHAR (15)

Age - NUMC (2)

ADDR  -CHAR (20)

PHONE - NUMC (10)

Navigation:

Step 1: Logon to SAP R/3 or BW system

Step 2: Create table

Enter tcode SE11. Select the radio button "Database table" and give table name as ZSALESPER

Select 'Create'

Short Description: "Sales Person Master Data table"

Delivery Class: Browse and choose A [Application table (master data and transaction data)]

Data browser / table view maintenance: Select 'Display / Maintenance is allowed'

Select 'Save'

Give a package and continue with the TR.

Step 2.1  Create table fields

Select fields tab

Field: SMID - define as key and initial value not allowed

 

Field	Key	Initial	Data Element	Data type	Length	Decimal	Short Desc
SMID	Yes	Yes	ZSMID	CHAR	4		Salesman ID
Name			ZSMName	CHAR	15		SMAN Name
Age			ZSMAge	NUMC	2		SMAN Age
Addr			ZSMAddr	CHAR	20		SMAN Address
Phone			ZSMPhne	NUMC	10		Phone No.

Give a Data element name like SMID, and double click on it. Give a description and select 'pre defined type' as CHAR, length 4.

Select 'Save' and Continue.

Step 2.2 Maintain technical settings

Select 'Technical Settings'

Data class 'APPL0' (master data, transparent table) (Browse and choose)

Size category (Size of the table) - 0 (Browse and choose)

Select 'Save'. Press F3. Select 'Save' and 'Check'.

Warnings: "Enhancement category for table is missing"

Press F3.

Note: To rectify the warnings, select 'Extras' menu. Select 'Enhancement category'

Select continue.

Select the option "Can be enhanced (character type or numeric)

Select 'Continue'

Select 'Check'

msg: no inconsistencies found

Select 'Activate'

Step 2.3 Enter data manually

Select 'Utilities' menu

Select 'Table contents'

Select 'Create entries'

Create your entries and save them.

Press F3, F3, F3.