data types :
1)Integer:
data <variable name> type i.
2)Numaric:
data <variable name> type n length (length value).
3)Charecter:
data <variable name> type c length (length value).
4)string:
data <variable name> type string.
5)time:
data <variable name> type t.
6)date:
data <variable name> type d.
7)Packed decimal:
data <variable name> type p.
String Manipulation::
1)concatenate:
Syntax : Concatenate ‘<lv_1>’ ‘<lv _2>’ ‘<lv _3>’ ‘<lv _4>’ into < lv _5>.
2)Condense:
Syntax : Condense < lv _1> no-gaps. ( And ) Condense <lv_1>.
3)String length:
Syntax : < lv _1> = strlen( lv_2 ).
4)Replace:
Syntax : Replace ' ' in <lv_1> with <lv_2>.
5)Replace all occurrences of:
Syntax : Replace all occurrences of ' ' in <lv_1> with <lv_2>.
6)Search :
Syntax : Search <lv_1> for <lv_2>.
7)Find :
Syntax : Find lv_2 in lv_1.
8)Find all occurrences :
Syntax : find all occurrences of ‘ ’ in lv_v1 match count lv_v2.
9)Reverse – Used to reverse the characters for the string.
Syntax : <lv_2> = reverse( lv_1 ).
10)Translate:
Syntax :
TRANSLATE lv_var1 to lower CASE.
TRANSLATE lv_var1 to Upper CASE.
TRANSLATE lv_date USING './'.
11)split:
syntax : split lv_1 at ' ' into lv_2 lv_3 lv_4.
12)offset:
syntax :
lv_2 = lv_1+2(4).
13)shift:
syntax :
shift lv_1 right.
shift lv_1 left.
shift lv_1 left deleting leading.
shift lv_1 right deleting trailing.
internal table :
1)Append:
Syntax : Append <wa> to <lt>.
2)Insert:
Insert <wa> into <lt>.
3)Clear:
Syntax : Clear : lv_var1, ls_std, lt_std.
4)Refresh:
Refresh lt_std.
5)Free:
Syntax : Free <lt_std>.
6)Delete:
Syntax : Delete <lt_std> from 1 to 10.
Delete <lt_std> to 10.
Delete <lt_std> from 5.
Delete <lt_std> index 10.
7)Modify:
Syntax - Modify lt_std from ls_std index 3.
Modify <lt_std> from <ls_std> transporting <fd_name> where <fd_name> =
‘Value’.
8)Loop at:
Syntax – Loop at <lt_std> into <ls_std>.
9)Loop addition:
where, from ,to , between , not between.
10)Read Table :
Syntax – Read table <lt_std> into <ls_std> with key <fd_name> = ls_std-roll_no>
11)Read addition:
Transporting,
All fields,
No fields,
With key,
With table key,
Comparing,
Binary Search,
Index.
database operation:
INSERT <DBT> FROM TABLE <LT>
MODIFY <DBT> FROM TABLE <LT>
UPDATE<DBT> FROM TABLE <LT>
DELETE<DBT> FROM TABLE <LT>
select query:
SELECT * FROM <DBT> INTO TABLE <LT> WHERE <FIELD_NAME>= <VALUE>.
SELECT QUERY FOR RETRIVING SINGLE RECORD:
SELECT SINGLE * FROM<DBT> INTO <LS> WHERE <KEY FIELD>.
FOR ALL ENTRIES:
SELECT <FIELD1><FIELD2><FIELD3>
FROM <DBT1>INTO TABLE <LT1>
IF<LT1>IS NOT IINITIAL
SELECT <FIELD>FROM <DBT2>INTO <LT2>
FORALLENTRIES IN <LT1>
WHERE <KEY FIELD> = <LT1_FIELD>.