SAP ABAP Training - in Plain English

In this lecture we talk about a couple of things

1. WRITE statement - How to write Horizontal and Vertical Lines

2. WRITE Statement - How to write at a particular offset location

3. WRITE Statement - How to write in a new line. 

4. DO - ENDDO loop.

5. Declare DATA variables

6. Default values to variables

7. Use of TYPE to declare data variables. 

In this lecture we talk about ABAP Statement Chaining. If you have to use the same ABAP keyword again and again consecutively, you can use statement chaining to just use the keyword just once and use the colon ( : )  to repeat it as many times as you want without having to write the keyword.  This is used extensively in productive programs. 

• Basics of Data Dictionary
• What are database tables
• What are Columns
• How to define columns 
• Naming Convention for Columns
• What are Primary keys

• What are Data Elements
• Why are Data Elements used 
• Data Elements vs Data Types
• Field Labels

Introduction to Sales and Purchase cycles. Especially, this section focuses on the Sales Cycle. We talk about the basic tables available in standard SAP for sales like

Sales Tables

• VBAK
• VBAP

Delivery Tables

• LIKP
• LIPS

Invoice Tables

• VBRK
• VBRP

We discuss the structure of these transactions which are

• Header 
• Item level data

• Reuse Data Elements
• Cross reference Units ( Like Currency )

We also see the significance of having different lengths of field labels.

•Sales Order Cycle

•Reuse of Column Types – Data Elements

•Reference Units

•Field Labels of all Lengths

•Multiple WHERE Clause entries

The basic PO business cycle is discussed in this chapter along with the tables as well. It starts with the purchase order that is placed with the vendor. Once the vendor receives the order, he delivers the goods. The goods receipt in SAP produces the material documents. After that the vendor also sends the invoice which is logged in SAP as a vendor invoice. 

Purchase Order 

• EKKO ( Header )
• EKPO ( Item )

Material Document 

• MKPF ( Header )
• MESG ( Item )

Vendor Invoice

• RBKP ( Header )
• RBCO ( Item )

The primary master data for these transactions is the Vendor and Material. 

Vendor

• LFA1 ( General View )
• LFB1 ( Company Code )

Purchase Order Cycle

Composite Primary Key
Identify Primary key
Modify Primary Key
Debugging – Step-in/out/through

• Basic Material Master table - MARA
• TYPES
• Why SELECT * is expensive operation ?
• Internal Tables
• Work Areas
• What does internal tables achieve that the TABLES statement does not ?
• LOOP

• What are Table JOINs
• INNER JOIN
• Table ALIAS
• JOIN condition

Left outer join

Join 3 tables

• Take a hypothetical customer master scenario and model database tables to hold the customer data.
• Identify primary key
• Identify all the data points and start normalizing the tables

• Go over standard customer tables ( KNA1 , KNVV )

• SELECT-OPTIONS
• APPEND

• A different view of the different events
• Compare the events with a real life example. 
• What is PBO event ( Process Before Output )
• What is PAI event ( Process After Input )
• What is the difference between PBO and PAI
• Classify events as PAI vs PBO

1. Show an example of PBO event. 
2. Work with the SCREEN run time structure
3. Understand what is MODIF ID

• AT SELECTION SCREEN
• Understands that EVENTS do not have a corresponding end EVENT
• Overview of SELECT SINGLE

The following operations on an internal table are discussed

• SORT an internal table
• Control Breaks
• At FIRST
• At END OF <field>
• SUM

AT FIRST of <field> is discussed

DELETE ADJACENT DUPLICATES

• Accounting Document Concept
• Accounting Document Header and item tables
• Cleared and uncleared Concept
• Cleared and uncleared tables
• APPEND LINES OF IT1 to IT2

SELECT * from <table> APPENDING TABLE <it>

READ an internal table with multiple keys. 

COLLECT statement