Posts

Views and its types

 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.     ...

Create TMG in abap

  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 User defined table in abap

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.

amdp

13 video [amdp procedure -1] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLASS zajay_class_amdp_procedure DEFINITION PUBLIC.   PUBLIC SECTION.   INTERFACES if_amdp_marker_hdb.   TYPES: begin of typ_sales,          vbeln type vbeln,          auart type auart,          end of TYP_SALES.   TYPES:  begin of typ_mat,           matnr type matnr,           mtart type mtart,           END OF TYP_MAT.    TYPES: tt_sales_details type table of typ_sales,           tt_mat_details type table of typ_mat.   class-METHODS get_sales_details IMPORTING value(im_auart) type auart                                     EXPORTING value(ex_sales_details) type tt_sales_details .   CLASS-METHODS get_materail_details EXPORTI...

smart forms

  1 video [smart forms introduction] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ---------------------------------- header details logo item details footer details ------------------------------------ basic properties ----------------- --> pages --> windows --> page windows smartstyles ------------ --> paragraph formats --> character formats global settings --------------- --> form interface --> global definitions > global data > types > field syambols > initilization > form routines > curr/quan field other properties ---------------- --> table  --> template --> folder flow logic ---------- --> alternative --> loop --> program lines --> command driver program --------------- > sf-funation module > ssf_function_module_name 3 video [ types of windows and intro about how to debug smartform] ------------------------------------------------------------------ types of windows ~~~~~~~~~~~~~~~ > main -...

bapi introduction

 45 video ([bapi  introduction]) ---------------------------------- --> se84 --> business application programing interface. BOR--> business object repository | |__> business object type | |__>    interfaces  key fields attributes methods events 

abap reports

  26 video [abap reports] ----------------------------- report --> final output of the program. * classical report * interactive report  1 classical report --> 0 to 19 interactive report. #classical ~~~~~~~~~~~ > top-of-page > initilization > at selection-screen > start of selection > end of selection > end-of-page --> all events are optional --> every event has its own property and will be trigger based on some prerequisites. --> no sequence to be maintaned and no duplicates of the event. --> no syntax check if some event is missing. --> format and spelling must be maintained. example program --------------- REPORT ZAJAY_PRACTICE. TOP-OF-PAGE. write: / 'TOP-OF-PAGE'. INITIALIZATION. write: / 'INITIALIZATION'. at SELECTION-SCREEN. write: / 'at SELECTION-SCREEN'. START-OF-SELECTION. write: / 'START-OF-SELECTION'. end-of-SELECTION. write: / 'end-of-SELECTION'. end-of-p...