Sap-abap day 2 (advanced business application programming language)

2.work bench

3.ABAP Dictionary

4.Data types

5.Conditional statements , Loops ,open SQL

6. Internal tables

7.Modularisation

8.Srings
NOTE : ABAP is a '4th 'generation programming language meant for business applications.

(Application server Contains Software (SAP) to run the application)

Maximum Clients Under 1 Application Server = 126

Users = No Limit

CLIENT - It is a 3 digit number to uniquely identify organization which has its own data

TYPES : Master clients and Data Clients

FLOW OF R/3 ARCHITECTURE :

Database server => Application Server => Presentation server => Clients => Users

(1) (1........N) (1........N) (1...126) (1.....N)

........................................................................................................................

2. WORK BENCH

We can create and modify the application written in ABAP

Transactions are done using Work bench tools

All transaction codes are available in TSTC Table

Screen painter - SE51 Object navigator - SE80 SQL Trace - ST05

Menu painter - SE41 ABAP Repository - SE84 Runtime analysis - SE30

ABAP editor - SE38 Data Browser - SE16

ABAP Dictionary - SE11

PACKAGE : Storage location of data ( To Select package press F4)

TYPES : 1. Local ($TMP) 2. Transportable

3. ABAP DICTIONARY(SE11)

Centralized source of information for business applications.

@Tables : It is a 2dimensional data matrix consisting of rows and columns.

TYPES :

• 
  Transparent : Structure remains same both in dictionary as well as database.
  
• 
  Pooled
  
• 
  Clustered outdated Tables, Clustered are preferred over pooled
  

APPL0 : MASTER DATA , APPL1 : TRANSACTION DATA , APPL2 : ORGANIZATION DATA, USR , USR1.

• 
  Database view : Only transparent tables are used, frequently used by ABAPers.
  
• 
  Projection view : Only 1 DB table is used in creation.
  
• 
  Help view : F1 = Technical information
  

• 
  Maintenance view : SM30 is used to maintain database tables
  

Used to add extra fields to DB Tables.

• 
  APPEND Structure : 1 table
  
• 
  INCLUDE Structure : N tables
  

• 
  Elementary Search Help : Single search path
  
• 
  Collective Search Help : Multiple search path
  

• 
  Exclusive lock
  
• 
  Shared lock
  
• 
  Exclusive but not cumulative lock