SAP AND ABAP TIPS AND FACTS

Tuesday, July 29, 2008

SAP Retail Transaction Codes: Subsequent Settlement

Transaction CodeDescription
MEB3Display Rebate arrangement
MEU2Perform Comparison of Business Volumes
MEB4Create Settlement Document Via Report
MEB3Create Service Notification-Malfn
MEB1Create Agreement
ME81Analysis of Order Values
MEB8 Detailed Settlement
SECATTGenerating business volume with CATT
SECATTGenerating business volume with CATT


Related Articles
SAP Retail Transactions Assortment Management
SAP Retail Transaction Codes Pricing
SAP Industry Specific Solutions SAP Business Solutions By Industry
SAP IS-Retail Transaction Codes Merchandise
SAP Retail Transactions Procurement of Replenishable Merchandise
Important Transaction Codes for ABAP
SAP Retail Transaction Codes: Fresh Items Procurement
___________________________________________________________________________________

SAP Retail Transaction Codes: Fresh Items Procurement

Transaction CodeDescription
WDBIAssortment List: Initialization and Full Version
WDFRPerishables Planning
MB1COther Goods Receipts
MIGOGoods Receipt Purchase Order
WF30Merchandise Distribution: Monitor
VL06OOutbound Delivery Monitor
MB0AGoods Receipt-PO Unknown
WDFRPerishables Planning
VL10BFast Display Purchase Orders
RWBEStock Overview
ME61Maintain Vendor Evaluation
ME63Calculate Scores for Semi-Automatic and Automatic Subcriteria
MEKHMarket Price
ME64Evaluation Comparison
ME65Ranking List of Vendors
ME6BRanking List of Vendor Evaluations Based on Material/Material Group

Related Articles
SAP Retail Transactions Assortment Management
SAP Retail Transaction Codes Pricing
SAP Industry Specific Solutions SAP Business Solutions By Industry
SAP IS-Retail Transaction Codes Merchandise
SAP Retail Transactions Procurement of Replenishable Merchandise
Important Transaction Codes for ABAP
___________________________________________________________________________________

Important Transaction Codes in SAP Retail: Non-replenishable Merchandise

Transaction CodeDescription
MM41Create Article
MM42 Chang Article
WSL1Listing conditions
MR21Price Change – Overview
ME51Create Purchase Requisition
ME41Create RFQ
ME47Maintain Quotation
MB1COther Goods Receipts
ME49Price Comparison List
ME1EQuotation Price History
ME48Display Quotation
MD03Single Item, Single Level
WLB13Automatic Load Building
WLB4Results List for Automatic Load Building Run
WLB5Bundle multiple orders logically
ME63Calculate Scores for Semi-Automatic and Automatic Subcriteria
ME61Maintain Vendor Evaluation
ME64Evaluation Comparison
ME65Ranking List of Vendors
ME6BRanking List of Vendor Evaluations Based on Material/Material Group

Related Articles:
SAP Retail Transactions Assortment Management
SAP Retail Transaction Codes Pricing
SAP Industry Specific Solutions SAP Business Solutions By Industry
SAP IS-Retail Transaction Codes Merchandise
SAP Retail Transactions Procurement of Replenishable Merchandise
Important Transaction Codes for ABAP
___________________________________________________________________________________

Monday, July 28, 2008

SAP Retail Transactions Procurement of Replenishable Merchandise

SAP Retail important Transaction Codes Procurement of Replenishable Merchandise
Transaction Code Description
WLB13 Automatic Load Building
WLB2 Investment Buying Analysis
WLB6 ROI-Based PO Proposal for Purchase Price Changes
WLB1 Determining Requirements for Investment Buying
WB02 Site Change
WWP3 Planning Workbench
WWP1 Planning Workbench
MB1C Enter Other Goods Receipts
RWBE Stock Overview
ME31K Create Contract
ME33K Display Contract
MM42 Chang Article
MP30 Execute Forecast: Initial
MP33 Forecast Reprocessing
MD21 Display Planning File Entries
MD03 Requirements Planning Single-Item, Single-Level
MD05 RP List
MD04 Stock/Requirements List
MB01 Enter Other Goods Receipts
ME01 Maintain Source List
ME51 Create Purchase Requisition
ME52 Change Purchase Requisition
ME59 Automatic Creation of Purchase Orders from Requisitions
ME21N Create Purchase Order
MIGO Goods Receipt for Purchase Order
ME13 Display Info Record
MK02 Change Vendor
WLB4 Results List for Automatic Load Building Run
WLB5 Combine a Number of POs to Create a Collective Purchase Order
ME2L Purchasing Documents per Vendor
ME61 Maintain Vendor Evaluation
ME63 Calculate Scores for Semi-Automatic and Automatic Subcriteria
ME64 Evaluation Comparison
ME65 Ranking List of Vendors
ME6B Ranking List of Vendor Evaluations Based on Material/Material Group
See Also:
SAP Retail Transactions Assortment Management
SAP Retail Transaction Codes Pricing
SAP Industry Specific Solutions SAP Business Solutions By Industry
SAP IS-Retail Transaction Codes Merchandise
Important Transaction Codes for ABAP

SAP Retail Transactions Assortment Management

Important Transaction Code SAP Retail Assortment Management

Transaction Code Description
WLWB Space Management: Layout Workbench
WPLG Display Article In Layout Module
WLCN Delete All Listing Conditions From Layout Module
WSOA1 Assortment Create
WSK1 Assortment Copy
WSPL Display/edit article master segments that cannot be generated
WSL0 Merchandise Categories – Article Assortments Consistency Check
WSP6 Delete Individual Listing Material/Assortment
WSM8 Reorganize Listing Conditions By Merchandise Category
WSM4A Automatic Relisting Via Change to Assortment Master Data
WSL11 Evaluation of listing condition
WSOA3 Assortment Display
WSOA1 Assortment Create
WSOA2 Assortment Change
WSOA6 Assortment Assignment Tool
REFSITE Reference Sites Management
WSL5 Modules In Assortment
MM41 Create Article
MM42 Chang Article
WSL1 Listing conditions
WSP4 Create Individual Listing Material / Assortment
WSO1 Assortment Module Create
WSO5 Maintain Assortment Module assignment to Assortment
WB02 Site Change
MB1C Enter Other Goods Receipts
WSE4 Article Discontinuation( Article / Site Discontinuation)
WSM9 Deletion of Obsolete Listing Conditions
See Also:
SAP Retail Transaction Codes Pricing
SAP Industry Specific Solutions SAP Business Solutions By Industry
SAP IS-Retail Transaction Codes Merchandise
Important Transaction Codes for ABAP
_____________________________________________________________________________

SAP Retail Transaction Codes Pricing

Find below a list of transaction Codes for SAP Retail Pricing

Transaction Description
V-61 Create Customer Discount Condition
BD22 Delete Change Pointers
WVN0 Generate Pricing Worklist
WVN1 Release Worklist
MEI4 Create Automatic Document worklist
VA01 Create Sales Order
WVA3 Display VKP Calculation Sur
WKK1 Create Market-basket Price Calculation
WMB1 Create Price Entry
VKP5 Create Price Calculation
WPMA Direct Request For POS Outbound
WVA7 Display VKP Calculation Sur
WEV3 Display Ret. Markup SP Ca
MEKE Conditions By Vendor
V-64 Display Customer Discount
VK13 Display Condition Records
V/LD Execute Pricing Report


See Also:

SAP Industry Specific Solutions SAP Business Solutions By Industry
SAP IS-Retail Transaction Codes Merchandise
Important Transaction Codes for ABAP
________________________________________________________________________

Thursday, July 24, 2008

SAP IS-Retail Transaction Codes Merchandise

SAP for Retail is an end-to-end set of solutions that supports Demand-Management, Merchandise Management and Planning, Store Operations, and Base Finance and HR Functions.

Check the site 
SAP for Retail

Transaction Code Description
RWBE Stock Overview
MB03 Display Transfer Posting
MB1B Enter Transfer Posting
MB1C Enter Other Goods Receipts
MR21 Price Change
WSL1 Listing conditions
REFSITE Reference Sites Management
MASS_MARC Logistic/replenishment Mass Maintenance
WSO7 Display Assortment Module Assignment to Assortment
WSL11 Evaluation of listing condition
MM43 Display Article
MM42 Chang Article
MM41 Create Article
SU3 Maintain User Profile

_______________________________________________________________________________________________________________
See Also:

Important Transaction Codes for ABAP
_______________________________________________________________________________________________________________

Wednesday, July 16, 2008

Netweaver Components AUTOID Infrastructure RFID

COMPONENTS & TOOLS OF SAP NETWEAVER

SAP Auto-ID Infrastructure

SAP RFID

Radio Frequency Identification Devices are responsible for electronically capturing the data related to Materials. Once the data is captured, it is transmitted via Radio waves to the SAP server. The main use of RFID devices is in Warehouses where the data is physically moved from one location to another. It is very convenient for the warehouse personnel to make use of RFID so that all the material movement is captured automatically and the information is transferred to the SAP server.

SAP Auto-ID Infrastructure is the component in SAP Netweaver that provides gateway to the RFID Data. SAp Auto-ID Infrastructure can be used to integrate the following devices.

RFID readers and printers
Bluetooth devices
Embedded systems
Bar-code devices

 

You can read about latest happenings in RFID at the RFID Journal
Also at the SAP SDN Website.
SAP Website

 

Tuesday, July 15, 2008

SAP Supported Databases Operating Systems

SAP Databases and Operating Systems Support:

The following Matrix shows the Databases, Operating Systems and Hardware supported by SAP.

 
Windows
AIX
HP-UX
Solaris Linux

OS/400
I5/OS

 
IA32
IA64
X64
PA-RISC IA64 SPARC X64 IA32 IA64 X86_64 IBM Power IBM
System Z
 
Oracle X X X X X X X X X X X X    
Microsoft SQL Server X X X                      
IBM DB2 for Linux, Unix and windows X X X X X X X   X X X X    
MaxDB X X X X X X X X X X X X    
IBM DB2 for i5/OS X   X                     X
IBM DB2 for z/OS X   X X             X   X  

Thursday, July 10, 2008

SAP and Adobe Forms

SAP NetWeaver ABAP and Adobe Forms

SAP has extended its power by introducing ADOBE Forms. Interactive Forms based on Adobe software bridges the paper-to-digital divide by helping organizations create Adobe Portable Document Format (PDF) forms that have the same high-quality appearance and easy accessibility of familiar paper documents. By using information resident in SAP software, the Interactive Forms solution lets IT departments replace inefficient paper-based processes; include customers, partners, and employees in electronic processes; and extend the reach of enterprise applications to a much broader set of users inside and outside the firewall. Because the Interactive Forms solution harnesses the power of PDF and eXtensible Markup Language (XML), it helps IT departments streamline form processes and capture data more accurately. First, IT departments can easily design sophisticated forms that look like the pieces of paper they replace. Then, users can fill out forms with the ubiquitous Adobe Reader® software while online or offline—without buying additional software. And because PDF forms are intuitive and easy to fill out, IT departments eliminate time-consuming, expensive rekeying of data when users submit forms back to SAP systems in the enterprise.

Courtesy: Adobe Systems 

Some important links are as follows.

Adobe Forms
Adobe Forms from SDN
SAP Service Market Place

See Also:
Important Tables and Transactions Associated with SAP Scripts
SapScripts and Smart Forms Bar Codes and Swin
Important Programs Related to SAP Scripts

Wednesday, July 9, 2008

SAP Authorization Objects Tables

Table Name Description
TOBJ Authorization Objects
TACT Activities which can be Protected (Standard activities authorization fields in the system)
TACTZ Valid activities for each authorization object
TDDAT Maintenance Areas for Tables
TSTC SAP Transaction Codes
TPGP ABAP/4 Authorization Groups
USOBT Relation transaction > authorization object
USOBX Check table for table USOBT
USOBT_C Relation Transaction   > Auth. Object (Customer)
USOBX_C Check Table for Table USOBT_C


Related Topics:

System Tables in SAP
User and Authorization System Related Tables
SAP MM Tables
SAP SD Tables
SAP ABAP Data Dictionary Tables
Creating a Table in SAP
List of Important System Variables
SAP ABAP Internal Table Details
SAP ABAP Internal Table Basics
Internal Tables in SAP ABAP
Important Tables and Transactions Associated with SAP Scripts

Tuesday, July 8, 2008

SAP User−and Authorization System−Related Tables

SAP User and Authorization System Related Tables

Table Description
USR01 User master record (runtime data)
USR02 Logon data
USR03 User address data
USR04 User master authorizations
USR05 User Master Parameter ID
USR06 Additional Data per User
USR07 Object/values of last authorization check that failed
USR08 Table for user menu entries
USR09 Entries for user menus (work areas)
USR10 User master authorization profiles
USR11 User Master Texts for Profiles (USR10)
USR12 User master authorization values
USR13 Short Texts for Authorizations
USR14 Surchargeable Language Versions per User
USR30 Additional Information for User Menu
USH02 Change history for logon data
USH04 Change history for authorizations
USH10 Change history for authorization profiles
USH12 Change history for authorization values
UST04 User masters
UST10C User master: Composite profiles
UST10S User master: Single profiles
UST12 User master: Authorizations


See Also:

System Tables in SAP
SAP MM Tables
SAP SD Tables
SAP ABAP Data Dictionary Tables
Creating a Table in SAP
List of Important System Variables
SAP ABAP Internal Table Details
SAP ABAP Internal Table Basics
Internal Tables in SAP ABAP
Important Tables and Transactions Associated with SAP Scripts
_________________________________________________________________________________________________________________

Monday, July 7, 2008

SAP Industry Specific Solutions SAP Business Solutions By Industry

SAP Industry Specific Solutions SAP Business Solutions By Industry

 

Financial and Public Services
SAP Banking SAP Higher Education & Research
SAP Defense & Security SAP Insurance
SAP Healthcare SAP Public Sector
    Healthcare Providers       Public Security
Manufacturing
SAP Aerospace & Defense SAP Industrial Machinery & Components
    SAP Aerospace and Defense Manufacturers     SAP Construction and Mining Machinery
    SAP MRO/M&E Service Providers     SAP Electrical Equipment, Appliances, and Components
SAP Automotive     SAP Industrial Machinery and Equipment
    SAP Automotive OEMs     SAP Heating, Ventilation, Air Conditioning, and Plumbing Equipment
    SAP Sales and Service Organizations     SAP Industrial Tools and Metalworking Machinery
    SAP Automotive Suppliers     SAP Lifting, Material Handling, and Railroad Equipment
SAP Chemicals     SAP Measuring and Controlling Devices
Consumer Products     SAP Motion and Fluid Control Equipment
    SAP Food     SAP Oil and Gas Machinery
    SAP Beverage     SAP Semiconductor and Electronic Measurement Equipment
    SAP Home and Personal Care     SAP Textile, Paper, Printing, and Packaging Machinery
    SAP Consumer Durables and Home Appliances SAP Life Sciences
    SAP Apparel and Footwear     SAP Pharmaceuticals
SAP Engineering, Construction & Operations     SAP Biotechnology/Biopharmaceuticals
    SAP Homebuilding     SAP Medical Device/Scientific Instruments
    SAP Construction SAP Mill Products
    SAP Shipbuilding     SAP Building Materials
    SAP Commercial Real Estate     SAP Cable and Wire
    SAP Facilities Management     SAP Fabricated Metal Products
SAP High Tech     SAP Furniture
    SAP Business, Medical, and Consumer OEMs     SAP Packaging
    SAP EMS Providers     SAP Plastics
    SAP Semiconductor and Component Manufacturers     SAP Primary Metals
    SAP Software Providers     SAP Pulp and Paper
    SAP Textiles
SAP Mining
SAP Oil & Gas
    SAP Upstream
    SAP Supply, transmission, and trading
    SAP Refining and manufacturing
    SAP Downstream marketing and retail
Services
SAP Media SAP Retail
    SAP Broadcasting SAP Telecommunications
    SAP Entertainment SAP Travel & Logistics Services
    SAP Newspapers and Magazines     SAP Logistics Services
    SAP Premium Content Publishers     SAP Postal Services
SAP Professional Services     SAP Railways
    SAP Consulting and Audit & Tax     SAP Airlines
    SAP IT and BPO Services SAP Utilities
    SAP Commercial Real Estate     SAP Generation
    SAP Business Services     SAP Retail
    SAP Legal Services     SAP Transmission and Distribution
    SAP Staffing     SAP Water
    SAP Facilities Management SAP Wholesale Distribution

Wednesday, July 2, 2008

SAP Stock Per Bin

SAP Stock Per Bin

If you wish to find the stock per bin the following function module can be used.

SAP ABAP function Module to find stock per bin

L_TO_STOCK_PER_BIN_INT
_________________________________________________________


The above Function Module has the following input Parameters.

LTAK-LGNUM                  Warehouse Number / Warehouse Complex
LQUA-LGTYP                   Storage Type
LQUA-LGPLA                   Storage bin
LQUA-LENUM                  Storage unit number
_________________________________________________________


The following Values are extracted


Table
LQUA                              Quants
_________________________________________________________


Find the code below.

REPORT ZEX_BIN .

Parameter: p_lgnum like LTAK-LGNUM,
           p_lgtyp like LQUA-LGTYP,
           p_lgpla like LQUA-LGPLA,
           p_lenum like LQUA-LENUM.


Data: int_LQUA TYPE TABLE OF LQUA.


CALL FUNCTION 'L_TO_STOCK_PER_BIN_INT'
  EXPORTING
    I_LGNUM       = p_lgnum
    I_LGTYP       = p_lgtyp
    I_LGPLA       = p_lgpla
*   I_LENUM       = ' '
  TABLES
    T_LQUA        = int_LQUA
          .

If sy-subrc = 0.

endif.


See Also:
SAP Locating Plants for a Given Material
SAP get Plant Description For a given Material
SAP PLANT MATERIAL and STORAGE LOCATION
Company Code For a Plant
Plant Details Company Code and Controlling Area
SAP Storage Location Data


Tuesday, July 1, 2008

SAP Plant Storage Location Data

SAP Plant Storage Location Data

To extract SAP Plant and Storage Location Data the following Function Module can be used

SAP ABAP Function Module to extract PLANT and STORAGE Location Data.

ITOB_CHECK_PLANT_STORAGE
_______________________________________________


Important SAP MASTER Tables associated with this Function Module are as follows.

TVKO                    SAP Sales organization
TVTW                    SAP Distribution channel
TVST                     SAP Shipping point/receiving point
LFA1                     SAP Vendor's account number
KNA1                    SAP Account number of customer
T001W                  SAP Plant
TSPA                     SAP Division
______________________________________________________

Import Parameters for the above mentioned Function Module are as follows

T001L-LGORT                 Storage location
T001L-WERKS                 Plant
SY-BINPT                        Batch input, program running under batch input (Dialog Mode)
SY-BINPT                        Batch input, program running under batch input (Dialog Cursor)
DD03D-FIELDNAME       Field name
SY-STEPL                        Screens, current table line index
SY-BINPT                        Batch input, program running under batch input (Initial Message Data)
SY-MSGTY                      Messages, message type
_______________________________________________________

The following fields are outputted

Plant, Storage location, Description of storage location, Division, Negative stocks allowed in storage location, Freezing book inventory bal., allowed in stor. loc., Storage location MRP indicator, Storage location authorization for goods movements active, Storage location is allocated to resource (storage resource), Handling unit requirement, Partner storage location of the handling unit, Sales organization, Distribution channel, Shipping point/receiving point, Vendor's account number, Account number of customer.
_______________________________________________________

Code is given below.

REPORT ZEX_ITOBPLANTSTORAGELOC.

Parameter: p_werks like T001L-WERKS,
           p_lgort like T001L-LGORT.

Data: wa_T001L type T001L.

 CALL FUNCTION 'ITOB_CHECK_PLANT_STORAGE'
   EXPORTING
     LAGER_IMP               = p_werks
     WERK_IMP                = p_lgort
    USE_BUF                 = 'X'
    DIALOG_MODE             = 'X'
    DIALOG_CURSOR           = ' '
    DIALOG_STEPL            = 0
    INIT_MESSAGE_DATA       = 'X'
    X_MESS_TYPE             = 'E'
  IMPORTING
    T001L_EXP               = wa_T001L
  EXCEPTIONS
    EMPTY_KEY               = 1
    APPLICATION_ERROR       = 2
    OTHERS                  = 3
           .
 IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
 ENDIF.


See Also:
SAP Locating Plants for a Given Material
SAP get Plant Description For a given Material
SAP PLANT MATERIAL and STORAGE LOCATION
Company Code For a Plant
Plant Details Company Code and Controlling Area


ABAP TIPS

PREVIOUS                  NEXT                    RANDOM

 ABAP TIPS


Since your web browser does not support JavaScript, here is a non-JavaScript version of the image slideshow:

 ABAP TIPS
Always specify your conditions in the Where-clause instead of checking them yourself with check statements. The database system can then use an index (if possible) and the network load is considerably less.


 ABAP TIPS
For all frequently used Select statements, try to use an index. You always use an index if you specify (a generic part of) the index fields concatenated with logical Ands in the Select statement's Where clause. Note that complex Where clauses are poison for the statement optimizer in any database system.


 ABAP TIPS
If there exists at least one row of a database table or view with a certain condition, use the Select Single statement instead of a Select-Endselect-loop. Select Single requires one communication with the database system, whereas Select-Endselect needs two.


 ABAP TIPS
It is always faster to use the Into Table version of a Select statement than to use Append statements.


 ABAP TIPS
To read data from several logically connected tables use a join instead of nested Select statements. Network load is considerably less.


 ABAP TIPS
If you want to find the maximum, minimum, sum and average value or the count of a database column, use a select list with aggregate functions instead of computing the aggregates yourself. Network load is considerably less.


 ABAP TIPS
If you process your data only once, use a Select-Endselect-loop instead of collecting data in an internal table with Select Into Table. Internal table handling takes up much more space.


 ABAP TIPS
Use a select list or a view instead of Select * , if you are only interested in specific columns of the table. Network load is considerably less.


 ABAP TIPS
For all frequently used, read-only tables, try to use SAP buffering. Network load is considerably less.


 ABAP TIPS
Whenever possible, use array operations instead of single-row operations to modify your database tables. Frequent communication between the application program and database system produces considerable overhead.


 ABAP TIPS
Whenever possible, use column updates instead of single-row updates to update your database tables. Network load is considerably less.


 ABAP TIPS
Instead of using nested Select loops or FOR ALL ENTRIES it is often possible to use subqueries. Network load is considerably less.


 ABAP TIPS
Use the special operators CO, CA, CS, instead of programming the operations yourself. If ABAP/4 statements are executed per character on long strings, CPU consumption can rise substantially.


 ABAP TIPS
Some function modules for string manipulation have become obsolete and should be replaced by ABAP/4 statements or functions: STRING_CONCATENATE... -> CONCATENATE, STRING_SPLIT... -> SPLIT, STRING_LENGTH -> strlen(), STRING_CENTER -> WRITE...TO...CENTERED, STRING_MOVE_RIGHT -> WRITE...TO...RIGHT-JUSTIFIED


 ABAP TIPS
Use the CONCATENATE statement instead of programming a string concatenation of your own.


 ABAP TIPS
If you want to delete the leading spaces in a string, use the ABAP/4 statement SHIFT...LEFT DELETING LEADING... .Other constructions (with CN and SHIFT...BY SY-FDPOS PLACES, with CONDENSE if possible, with CN and ASSIGN CLA+SY-FDPOS(LEN) ...) are not as fast. In any case, avoid using SHIFT inside a WHILE-loop!


 ABAP TIPS
Use the SPLIT statement instead of programming a string split yourself.


 ABAP TIPS
Use the strlen( ) function to restrict the DO loop to the relevant part of the field, e.g. when determinating a check-sum.


 ABAP TIPS
Use "CLEAR f WITH val" whenever you want to initialize a field with a value different from the field's type-specific initial value.


 ABAP TIPS
Try to keep the table ordered and use binary search or used a table of type SORTED TABLE. If TAB has n entries, linear search runs in O( n ) time, whereas binary search takes only O( log2( n ) ).


 ABAP TIPS
A dynamic key access is slower than a static one, since the key specification must be evaluated at runtime. However, for large tables the costs are dominated by number of comparison needed to locate the entry.


 ABAP TIPS
If you need to access an internal table with different keys repeatedly, keep your own secondary indices.With a secondary index, you can replace a linear search with a binary search plus an index access.


 ABAP TIPS
LOOP ... WHERE is faster than LOOP/CHECK because LOOP ... WHERE evaluates the specified condition internally. As with any logical expressions, the performance is better if the operands of a comparison share a common type. The performance can be further enhanced if LOOP ... WHERE is combined with FROM i1 and/or TO i2, if possible.


Always use Pretty Printer and Extended Program Check before releasing the code. Do not leave unused code in the program. Comment the code thoroughly. Align the comments and the Code. Follow the SAP Standards and SAP Best Practices guidelines. It’s a good practice to take a dump of the code on your local drive.

Ole Automation Part1
Ole Automation Part 2
Processing Blocks in ABAP
Simple ABAP Report
ALV Grid - Changing Colors
ALV Report Example
Creating Variants For ABAP Reports
Recording BDC using Transaction
Sales Document Flow in ABAP
User Exits in SAP SD
SAP ABAP Naming Standards
SAP SD Tables
SAP ABAP Data Dictionary Tables
MM Important Transaction Codes in SAP
Passing g Data From One ABAP Program to Another
ABAP Compute Add Collect and Append
SAP ABAP Determining Attributes of Data
SAP ABAP Editor Icons
BAPI for Displaying Material Data
BAPI to get customer bank details
EDI Outbound Process
SAP EDI Process Overview
Function Module for Vendor Bank details
SAP IDOC
Creating a Valid Password in SAP
SAP BADIs Introduction
SAP ABAP MACROS
POP UP function Module to Confirm and Save Data
Select Options
BAPI for availability check
String to Numerical
SAP Goods Movement Process
Getting a List of Plants for a Material
SAP R3 Clients Concept
ABAP Adobe Forms
Authorization Object Tables
SAP Industry Specific Solutions

Sap Scripts and SmartForms Bar Codes
Standard Reports and Sap Scripts
Important Standard Reports in SAP
Abap Tricks and Tips
Bapi Sales Order
BAPI Purchase Order
Creating Function Modules in SAP
Creating Tables in SAP
Finding User Exits in SAP
Function Module Create Text and Read Text
Important Transaction Codes in SAP
ABAP Function Module for Submitting a Program
ABAP Game Tic Tac Toe
ABAP Internal Table To Excel Sheet
ABAP Function Module to create Directory
Different Types of Menus in SAP
Function Modules in SAP to check Loged in Users
ABAP Function Module for Adding Days to Dates
Call a Transaction From a Remote System
SAP MM simple Procurement Cycle
BAPI Material EDIT
Finding Decimal Places in Currency
Getting negative sign before a number in ABAP
Program Editor Lock Unlock
Restricting Select Options
List of BAPIs in the system
SAP Function Module Scramble a String
LSMW
POP up table contents on the screen
SAP R3 Bookmarking Websites
Stock Requirements List Function Module
Retail Transaction Codes
ABAP Debugger Break Points
ABAP Debugger WatchPoints
Drill Down Reports Concept
Creating a HOT SPOT
Interactive Programs and Hide Technique
String Concatenate
Get Week of the Year
SAP ABAP to Add Days to a Date
Add Months to a Date
Get Month in the Year
Display Clock

ABAP Code For Progress BAR
ABAP Function Module For Caluclator
ABAP Function Module For Calender
Displaying Messages in ABAP
Function Module Pop Up To Confirm
Conversion Routines in SAP
SAP ABAP Authorization
SAP ABAP Module Pool Tutorial
SAP ABAP RFC

Finding Path to SAP Transaction in Menu
SAP Purchasing Documents
SAP and ABAP Shortcuts
Logical Databases
Advantages of Logical Databases
Copy to Clipboard
BAPI Create Material
Finding and Running Programs in ABAP
Program Syntax Check and Extended Syntax Check
Select Options upper lower case
BAPI Sales Order Simulate
Get PLANT and Description for a Material
MRP List Function Module
Production Planning and Controlling
Applications in SAP R3
Tool Based Reports
Important Transaction Codes in SAP
SAP Stock per Bin
Pop Up a Calender
Module to Read a File
Module to Reverse A String
Run an Executable Program with Parameters
Program for POP up Screen
Printing Selection Parameters for a Report
Uploading and DownLoading a Report
SAP ABAP Version Management
SAP ABAP Short Cuts
List of Important System Variables

ABAP MACROS
ABAP Calling a File Selector
Some Important Function Modules
ABAP String Operations

ABAP Function Module to Check Validity of Date
Transfer Internal Table Contents to a File

SAP ABAP Program Types
BAPI to Read Customer Data
Checking Validity of Date
Download to Application Server
ABAP Debugger Breakpoint and Watchpoint
BAPI to get Company Code Details
Creating Material Using BAPI part 2
Generating a Valid Password
Logical Databases Structure
Making Fields OBligatory in Selection Screen
ABAP Views
Getting a Company Code for a Plant
Importing contents of Clipboard in SAP
Getting a Plant for a Material
Plant Material and Storage Location
SAP Production Planning Standard Reports
NetWeaver Components
Supported Databases and Operating Systems