Sap Abap Topics

CREATING TABLE MAINTENANCE GENERATOR FOR A TABLE

2013-03-12T15:04:00.001-07:00

FIRST Lets create a database table with fields

MANDT
LIFNR
LAND1
NAME1

GOTO SE11

databasetable : zTmg.
click on CREATE.
give short description : Table for TMG.
Delivery class : A
Data browser/ table view maint : Display/maintenance allowed.

click on Fields tab

(Mandt check the key and initial and dataelement give mandt
lifnr check the key and initial and dataelement give lifnr.)

fields Dataelement
mandt mandt
lifnr lifnr
name1 name1_gp
land1 land1_gp

click on Technical setings
It will ask to save and save it in a $tmp local package

Dataclass : APPLO
Size : 0.

save , goback

Click on EXTRAS----> Enhancement Category
click enter
choose can be enhanced . and click on copy.

now save, check, activate.

CREATING TABLE MAINTENANCE GENERATOR FOR A TABLE

lets create TABLE MAINTENANCE GENERATOR for the above table ZTMG.

Table Maintenance Generator is used only for customized tables not for standard tables.
It is basically used to update or delete records or to create new entries for the ztable .

open the ztmg table (se11) and then ..
Utilities----> TABLE MAINTENANCE GENERATOR

Authorization Group : &nc&
Function Group : Zfunctmg. ( SE37 you can create a function group)

Maintenance type : choose one step.

Click on Find screen numbers
choose propose screen numbers
enter
now click on CREATE button.
save it in $tmp Package and goback
save check and activate your table.

Now to Insert records or delete records.

Goto Transaction code : SM30

Table : Ztmg.

choose No restrictions.

Click on MAINTAIN.
then click on NEW ENTRIES.
And add the records
1 krish Land
save.

go and check the records in se11.( Utilities-->Table contents--->Display).
you can find them.

THE MAINTENANCE DIALOG FOR ZTABLE IS INCOMPLETE OR NOT DEFINED --ERROR

2013-03-12T14:20:00.003-07:00

Goto transaction code SE54 then enter the table name for which you have created the Table Maintenance Generator.
Then choose Generated objects
And click on display.
It will show the table maintenance dialog you have generated for the table, if doesn't show then create the table maintenance generator again,

This Error usually occurs when you are creating Table Maintenance Generator, after clicking on Find screen numbers..people usually forget to press on the CREATE button (beside the Find screen numbers)
when you don't press on CREATE button you are doing the whole procedure correctly but not creating it, so the system is not creating the Table Maintenance Generator for that particular table. So when you goto
SM30 and try to maintain entries you will get this error.

Hope you understand.

How to create a database table in SAP ABAP or Steps to create a database table

2013-02-21T23:59:00.001-08:00

Creating a Database Table in SAP ABAP:

1.Enter Transaction Code : SE11 and press Enter.

(ABAP Dictionary Initial Screen will appear)

2.Select radiobutton Database Table and provide name for the database table you want to
create. Database Table : Zstudenttable.
(lets create a student table , The table name can be 16 characters in length.)

3. Press on CREATE .

4. Provide Short Description : Table to store students yearly marks.

Delivery and Maintenance Tab
5. Delivery Class : C Customizing Table.
{A Application Table(master and transaction data) These are client specific table.}

The delivery class controls the transport of table data for installation, upgrade, client copy and
when transporting between customer systems. The delivery class is also used in the extended
table maintenance.

6. Data Browser/ Table view maint. : Display/ Maintenance allowed.

7. Save it .and it will ask for Package : $TMP. and save it.

8.Click on Fields Tab

9. Field Key Initial DataElement
StudentId. (a tick mark will appear). Zstudentid

( This is nothing but Primary Key , which ensures the uniques values for that field. every table should atleast have 1 Primary key field. )

All the key fields of a table must be stored together at the beginning of the table. A non-key
field may not occur between two key fields.
A maximum of 16 key fields per table is permitted. The maximum length of the table key is
255.
If the key length is greater than 120, there are restrictions when transporting table entries.
The key can only be specified up to a maximum of 120 places in a transport. If the key is
larger than 120, table entries must be transported generically.
A table may not have more than 249 fields. The sum of all field lengths is limited to 1962
(whereby fields with data type LRAW and LCHR are not counted).
Fields of types LRAW or LCHR must be at the end of the table. Only one such field is
allowed per table. There must also be a field of type INT2 directly in front of such a field. The
actual length of the field can be entered there by the database interface.

Initial : If we select it , it will take the respective values as below. otherwise the value is null.

Data type	Initial Value
ACCP, CHAR, CUKY, LANG, UNIT	” ” space
CURR, DEC, FLTP, INT1, INT2, INT4, QUAN	0
CLNT	000
TIMS	000000
DATS	00000000
NUMC	00000... for field length <= 32 no initial value for field length > 32
LRAW, LCHR, RAW, VARC	no initial value

10.STEPS TO CREATE A DATA ELEMENT and DOMAIN

11. Double click on the Data Element that is : Zstudentid..

It will ask to save the table, Click on YES.

It will ask to create Data Element. Click on YES.

Short Description : Data element for student id.

Domain : zstudentid.

In order to create DOMAIN Double click on Zstudentid.

it will ask to save the table , click on yes. and package : $Tmp and Save.

and it will ask to create the Domain , Click on Yes.

Short Description : Domain for Zstudentid.

Data type : Char.
No. of chars : 3.

Now save, check Activate the domain.

Go back and save, check ,activate the data element.

Go back , Click on Technical Settings.

Data class : APPLO (depends on type of data)
Size Category : 0 ( this predefines the no. of records the table can hold).

Save. go back, and check.

it will show error enhancement category

for this go back
and Click on Extras----> enhancement category

and select radiobutton can be enhanced. and press enter.

now save, check and activate.

like this add additional fields and again save , check , and activate.

now if you want to add entries to the database table.

go to Utilities------> Table Contents-----> Create Entries.

provide the values and save

and go back.

go to Utilities------> Table Contents----> display

it will display the data.

we have successfully created a database table.

ENHANCEMENT CATEGORY FOR TABLE MISSING ERROR

2013-02-21T14:54:00.000-08:00

when this error occurs go to EXTRAS---Enhancement category
and then choose options like " can be enhanced" you will not get the error.

Smartforms in sap abap

2012-06-15T12:26:00.001-07:00

Smart forms are client independent (you can access the smartform from any client like 800, 810, 820....).
Each page has its own page format and can have background pictures and can be printed in colors.
Table painter is available so that you can print data in tabular format.
Paragraphs and Character formats are reusable . you can create them using smart styles.
Function module is generated automatically at the time of activating the Smartform.

While Endwhile statement example in sap abap

2012-01-14T11:35:00.001-08:00

REPORT demo_flow_control_while .

DATA: length TYPE i VALUE 0,
strl TYPE i VALUE 0,
string(30) TYPE c VALUE 'Test String'.

strl = strlen( string ).

WHILE string NE space.
WRITE string(1).
length = sy-index.
SHIFT string.
ENDWHILE.

WRITE: / 'STRLEN: ', strl.
WRITE: / 'Length of string:', length.

Do enddo statements in sap abap with example program

2012-01-14T11:34:00.001-08:00

REPORT demo_flow_control_do .

* simple do

DO.

WRITE sy-index.
IF sy-index = 3.
EXIT.
ENDIF.
ENDDO.

SKIP.
ULINE.

* do n times

DO 2 TIMES.
WRITE sy-index.
SKIP.
DO 3 TIMES.
WRITE sy-index.
ENDDO.
SKIP.
ENDDO.

SKIP.
ULINE.

* varying

DATA: BEGIN OF text,
word1(4) TYPE c VALUE 'This',
word2(4) TYPE c VALUE 'is',
word3(4) TYPE c VALUE 'a',
word4(4) TYPE c VALUE 'loop',
END OF text.

DATA: string1(4) TYPE c, string2(4) TYPE c.

DO 4 TIMES VARYING string1 FROM text-word1 NEXT text-word2.
WRITE string1.
IF string1 = 'is'.
string1 = 'was'.
ENDIF.
ENDDO.

SKIP.

DO 2 TIMES VARYING string1 FROM text-word1 NEXT text-word3
VARYING string2 FROM text-word2 NEXT text-word4.
WRITE: string1, string2.
ENDDO.

case endcase statement example in sap abap

2012-01-14T11:29:00.001-08:00

REPORT demo_flow_control_case .

DATA: text1 TYPE c VALUE 'X',
text2 TYPE c VALUE 'Y',
text3 TYPE c VALUE 'Z',
string TYPE c VALUE 'A'.

CASE string.
WHEN text1 OR text2.
WRITE: / 'String is', text1, 'OR', text2.
WHEN text3.
WRITE: / 'String is', text3.
WHEN OTHERS.
WRITE: / 'String is not', text1, text2, text3.
ENDCASE.

If elseif statement example in sap abap

2012-01-14T11:27:00.001-08:00

REPORT demo_flow_control_if .

DATA: text1(30) TYPE c VALUE 'This is the first text',
text2(30) TYPE c VALUE 'This is the second text',
text3(30) TYPE c VALUE 'This is the third text',
string(5) TYPE c VALUE 'eco'.

IF text1 CS string.
WRITE / 'Condition 1 is fulfilled'.
ELSEIF text2 CS string.
WRITE / 'Condition 2 is fulfilled'.
ELSEIF text3 CS string.
WRITE / 'Condition 3 is fulfilled'.
ELSE.
WRITE / 'No condition is fulfilled'.
ENDIF.

Internal table declaration in sap abap with example program

2012-01-14T11:20:00.000-08:00

PROGRAM demo_internal_table.

TYPES: BEGIN OF mytext,
number TYPE i,
name(10) TYPE c,
END OF mytext.

TYPES mytab TYPE STANDARD TABLE OF mytext WITH DEFAULT KEY.

DATA text TYPE mytext.
DATA itab TYPE mytab.

text-number = 1. text-name = 'John'.
APPEND text TO itab.
text-number = 2. text-name = 'Paul'.
APPEND text TO itab.
text-number = 3. text-name = 'Ringo'.
APPEND text TO itab.
text-number = 4. text-name = 'George'.
APPEND text TO itab.

LOOP AT itab INTO text.
WRITE: / text-number,text-name.
ENDLOOP.

Structure declaration in sap abap with example program

2012-01-14T11:17:00.000-08:00

REPORT demo_structure.

TYPES: BEGIN OF name,
title(5) TYPE c,
first_name(10) TYPE c,
last_name(10) TYPE c,
END OF name.

TYPES: BEGIN OF mylist,
client TYPE name,
number TYPE i,
END OF mylist.

DATA list TYPE mylist.

list-client-title = 'Lord'.
list-client-first_name = 'Howard'.
list-client-last_name = 'Mac Duff'.
list-number = 1.

WRITE list-client-title.
WRITE list-client-first_name.
WRITE list-client-last_name.
WRITE / 'Number'.
WRITE list-number.

Hot Spot example report in sap abap

2012-01-12T12:18:00.000-08:00

Execute this report in sap abap editor ........

REPORT demo_program_submit_sel_screen NO STANDARD PAGE HEADING.

DATA: int TYPE i,
rspar TYPE TABLE OF rsparams,
wa_rspar LIKE LINE OF rspar.

RANGES seltab FOR int.

WRITE: 'Select a Selection!',
/ '--------------------'.
SKIP.

FORMAT HOTSPOT COLOR 5 INVERSE ON.
WRITE: 'Selection 1',
/ 'Selection 2'.

AT LINE-SELECTION.
CASE sy-lilli.
WHEN 4.
seltab-sign = 'I'. seltab-option = 'BT'.
seltab-low = 1. seltab-high = 5.
APPEND seltab.
SUBMIT demo_program_submit_rep1 VIA SELECTION-SCREEN
WITH paramet eq 'Selection 1'
WITH selecto IN seltab
WITH selecto ne 3
AND RETURN.
WHEN 5.
wa_rspar-selname = 'SELECTO'. wa_rspar-kind = 'S'.
wa_rspar-sign = 'E'. wa_rspar-option = 'BT'.
wa_rspar-low = 14. wa_rspar-high = 17.
APPEND wa_rspar TO rspar.
wa_rspar-selname = 'PARAMET'. wa_rspar-kind = 'P'.
wa_rspar-low = 'Selection 2'.
APPEND wa_rspar TO rspar.
wa_rspar-selname = 'SELECTO'. wa_rspar-kind = 'S'.
wa_rspar-sign = 'I'. wa_rspar-option = 'GT'.
wa_rspar-low = 10.
APPEND wa_rspar TO rspar.
SUBMIT demo_program_submit_rep1 VIA SELECTION-SCREEN
WITH SELECTION-TABLE rspar
AND RETURN.
ENDCASE.

Abap write statement/command example in sap abap

2012-01-12T10:14:00.000-08:00

Execute this program below and check you will understand different ways to use the write statement.

REPORT demo_write_statement.

DATA: number TYPE p VALUE '-1234567.89' DECIMALS 2,
len TYPE i,
pos TYPE i,
text(10) TYPE c VALUE '1234567890',
integer TYPE i VALUE 1234567890,
g(5) TYPE c VALUE 'Hello', f(5) TYPE c VALUE 'Dolly',
time TYPE t VALUE '154633',
float TYPE f VALUE '123456789.0',
pack TYPE p VALUE '123.456' DECIMALS 3,
flag1 TYPE c VALUE ' ',
flag2 TYPE c VALUE 'X',
flag3(5) TYPE c VALUE 'Xenon'.

* simple WRITE statement

WRITE 'Hello, here I am!'.

SKIP 2.

* standard output format

WRITE: 'Number', number, 'is packed'.

SKIP 2.

* positioning

WRITE 'First line.'.
WRITE 'Still first line.'.
WRITE /'Second line.'.
WRITE /13 'Third line.'.

SKIP 2.

len = 10.
pos = 13.
WRITE 'The string ------------ appears in the text.'.
WRITE AT pos(len) text.

SKIP 2.

* cutting

WRITE: (5) integer, /(5) text.

SKIP 2.

* no empty lines in lists

WRITE: 'One',
/ ' ',
/ 'Two'.

SKIP 2.

* formatting

WRITE: g, f.
WRITE: /10 g,
/ f UNDER g.
WRITE: / g NO-GAP, f.

SKIP 2.

WRITE: time,
/(8) time USING EDIT MASK '__:__:__'.

SKIP 2.

WRITE: '000123',
/ '000123' NO-ZERO.

SKIP 2.

WRITE float EXPONENT 3.

SKIP 2.

WRITE pack DECIMALS 2.

SKIP 2.

WRITE: / pack ROUND -2,
/ pack ROUND -1,
/ pack ROUND 1,
/ pack ROUND 2.

SKIP 2.

WRITE: sy-datum,
/ sy-datum YYMMDD.

SKIP 2.

* icons and symbols

INCLUDE <symbol>.
INCLUDE <icon>.
WRITE: / 'Telephone symbol:', sym_phone AS SYMBOL.
SKIP.
WRITE: / 'Alarm icon: ', icon_alarm AS ICON.

SKIP 2.

* checkboxes

WRITE: / 'Flag 1 ', flag1 AS CHECKBOX,
/ 'Flag 2 ', flag2 AS CHECKBOX,
/ 'Flag 3 ', flag3 AS CHECKBOX.

Introductory Statements for Programs in Sap Abap

2012-01-11T15:51:00.000-08:00

1. Report
2. Program
3. Function-Pool
4. Class-Pool
5. Interface-Pool
6. Type-Pool.

Internal table declaration in sap abap

2012-01-11T14:42:00.000-08:00

Types : begin of t_vbak,
vbeln type vbak-vbeln,
erdat type vbak-erdat,
ernam type vbak-ernam,
end of t_vbak. "Declaring a structure

Data : it_vbak type standard table of t_vbak, "internal table
wa_vbak type t_vbak. "work area

Elements of an SAP GUI Window

2012-01-09T12:21:00.000-08:00

Command field: You can use the command field to go to applications directly by entering the transaction code. You can find the transaction code either in the SAP Easy Access menu tree (see next slide) or in the relevant application under System® Status.

Menu bar: The menus shown here depend on which application you are working in. These menus contain cascading menu options.

Standard toolbar: The icons in the system function bar are available on all R/3 screens. Any icons that you cannot use on a particular screen are dimmed. If you leave the cursor on an icon for a moment, a small flag will appear with the name (or function) of that icon. You will also see the corresponding function key. Theapplication toolbar shows you which functions are available in the current application.

Title bar: The title bar displays your current position and activity in the system.

Status bar: The status bar displays information on the current system status, for example, warning and error messages.

OSS means

2012-01-09T12:12:00.001-08:00

OSS-- Online Service System is one of the primary sources of service and support provided by
SAP. With OSS, Customers can search the SAP information database and find solutions for
errors and problems with R/3 systems. You can also submit your problems to SAP.

What is Abap

2012-01-09T12:07:00.000-08:00

ABAP stands for Advanced Business Application Programming.It is a 4th generation Programming Language(ABAP/4).The ABAP programming language was originally used by developers to develop the SAP R/3 platform where R stands for Real Time data Processing and 3- 3tier.It supports Object Oriented Programming, in 1999, SAP released an object-oriented extension to ABAP called ABAP Objects, along with R/3 release 4.6.

Sap R/3 Enterprise release 4.70 ------December 2003
Sap R/3 Enterprise Edition 4.7
Sap R/3 Enterprise Central Component 5.0 (ECC)
Sap R/3 Enterprise Central Component 6.0(ECC).