ABAP - table creation navigation steps

[Spoorthi]

hi frds,

frm today i'll post daily navigations.......it may differ frm 1 person
to other the path of following so if u r hvng different navigation so
post over here it may simple ,so tht v can knw how many ways r there
for 1 particular object.



table creation:



Enter t-code se11


Database table


Type table name


Create


Type short description


Delivery class (there r seven delivery classes) – click


Select A (application table, master transaction data)


Select check box


Click on fields tab


You can write fields names


Select key & int checkboxes (1^st filed must,
should be primary key)


Click on the data element/direct type


Then data type will be enabled


Enter data & length


Place at cursor at sal (if ur write Sal then ) & click
on currency/quant fields


(Sal asks reference table i.e. same table name & ref
field is Sal type.)


Click on fields


Save(ctr+s)


local object


click on technical settings


type data class(APPLO)


click (bcoz A is master data so data class is APPLO)


size category 0


save


back(F3)


activate ( ctr F#)


to add records utilities – table contents – create entries


then you can type records


save


reset & store another records


back


to display the records utilities – tale contents – display


********************************************************

[*]
(1^st data should be NUMC,if we gve another
like INT then buffering is not possible)[*]
(if activation log error comes then goto
utilities—database utility—click on activate—adjust database—click on yes—back)[*]
after display the records slect the record—goto table
entry—change (here allows the changes the contents,save & back)[*]
(delete all ,it delets all slected records)[*]
(delete,it deletes one record)[*]
(transport entries,it sends to other person internet or
intranet or within R/3 to other user)[*]
to add 1 more field then click on rows then it allows
to rite another field[/list]




























Edited by: spoorthi

[Spoorthi]

this is second procedure to create table





Creation o table(se11)


There r 2 approches to create a table


1.topdown approach


2.bottomup approach





in topdown approach we specify the table
properties,fields,data elemts,data domains etc.


in bottomup approach we define data domain,data
element,fieldstable & properties.





Navigation:





Enter tcode : se11


(We can create DB table , view,data type,type group,domain,
search help,lock object etc.these are called SAP R/3 DDIC (data dictionary)
objects.


Select DB table: here u can write anythinh it should start
with Z or Y (ex;Zsales)


Create


Short description


Delivery class:A


Save –package (ex:Zpack ,its already created)


Save--Continue


Select fields


(here example , field SMID , key check box selcted , dta
elemet Zzsmid)


double click on Zzsmid (here Zzsmid is my choice , u can
write ur own which starts with z )


yes


(note:to create a client dependent table the 1^st
field of the table must be mandatory)


continue-- yes


short description


domain: ----(here ex:Zzsmid)


double click on domain name


yes –save—continue--yes


short description


data type : CHAR (browse & choose)


no.characters:4


save—continue—activate—continue--f3(back)


activate—continue--f3(back)


field (here ex:PQTY (quantity)) , data element (ex:Zzpqty)


double click on Zzpqty


data type:QUAN(browse
choose)


field sales,data elemet ZZSAles


double clink on Zzsales


data type:CURR (browse & choose)


(like this u can create ur choice of fields)


keep curson on sales & click on insert row


fields:units


dataelement:zzunit


datatype:unit


field:currkey


dataelemet:zcurrkey


data type:cuky


select currency/quantity fields


reference field (write)


activate


select tech settings


data class APPL1


size category 0


save – back –activate.


Enter data into table


Select utilities-table contents-create entries


Enter entries


To display goto utilities –table content—display—execute


(or se16,enter table table name & execute)


we can view the contents of the program


enter se38


prog—(here zsales,u write ur prog name)


create


title: ---


type:executable prog


status:test prog


application:any field


save—save—req(continue)


report Zsales_rep


tables Zsales.


Data ITAB like zsales occurs 0 with header line.


Select * from zsales into table ITAB.


*display the data


loop at ITAB.


Write:/ITAB-SMID,ITAB-sales ,--(all fields).


Endloop.


Save—check for syntax error-activate

[Spoorthi]

frds try to gve other ways of navigation ,it may useful to many[img]smileys/smiley1.gif[/img]