SAP ABAP

 Types of views 1) database view *  A view created on two or more tables by clubbing the fields using inner join is called                database view *  We can only read the data. *  We cannot do any maintenance operation. *  A database view can include an entire table. business reqs-> develop a db view on mara ,makt tables to display                                                                            matnr,mtart,mbrsh,meins,spars,maktx. Steps         *  Go  se11.           *   Select view and give name as : zdbview1           *  Click create button.     ...

  Creation of TMG 1) create table name zcust with mandt,cno,cname,lan1. 2) save and activate table. 3) click on utilities->select table maintanance generator. 4) provide the details as below. 5) authorization group =&NC& 6) function group = zcust {table name} 7) maintenanace type as one step. 8) click on find screen number butoton. 9) a pop up is displayed just press enter. 10) the screen number will be automatically proposed. 11) click on create icon. 12) the tmg will be created in the form of function module.

Create database table  1--> se11 2-->  table name starts with z/x. 3-->  click create. 4-->  provide description. 5-->  specifies delivery class A. 6-->  specifies display and maintenance allowed. 7-->  click on field tab. 8-->  provide field name , data element name. 9-->  save. 10-->  click on technical settings button. 11-->  provide details of data class -->APPL0, size-->0. 12-->  click on save and click back. 13-->  save and activate table. INSERT values ---> utilities -->table contents -->create. Display values --> utilities -->table contents -->display.