SAP AND ABAP TIPS AND FACTS

Monday, April 28, 2008

SAP ABAP Data Dictionary Tables

SAP ABAP Data Dictionary Tables

Find below a list of SAP ABAP Data Dictionary Tables.

  
Table Name Short text
DD01L Domains
DD01T R/3 DD: domain texts
DD02ALL Table Parameters for ALLBASE
DD02DB2 DB2/390: Table Parameters
DD02DB6 Table Parameters for DB2 Version 2
DD02INF Table Parameters for INFORMIX, Version 6
DD02L SAP tables
DD02MSS Table Parameters for Microsoft SQL Server
DD02ORA Table parameters for ORACLE, version 6
DD02SYB Storage Parameters for Tables in SYBASE
DD02T R/3 DD: SAP table texts
DD03L Table Fields
DD03T DD: Texts for fields (language dependent)
DD04L Data elements
DD04T R/3 DD: Data element texts
DD05S Foreign key fields
DD06L Pool/cluster structures
DD06T R/3 DD: texts on SQL tables
DD07L R/3 DD: values for the domains
DD07T DD: Texts for Domain Fixed Values (Language-Dependent)
DD08L R/3 DD: relationship definitions
DD08T Texts on the relationship definitions
DD09C ABAP/4: Sytem-dependent attributes of tech. settings
DD09L DD: Technical settings of tables
DD10L Lock table for DD activation
DD12DB2 DB2/390: Index Parameters
DD12DB6 Index Parameters for DB2 Universal Database Version 2
DD12INF Index parameter for INFORMIX
DD12L R/3 S_SECINDEX: secondary indexes, header;
DD12MSS Index Parameters for MS SQL Server
DD12ORA Index Parameters for ORACLE
DD12SYB Index Parameters for SYBASE System_10
DD12T Text Table for DD12L (Short Descriptions of Sec. Indexes)
DD14S R/3 DD: components of SAP objects
DD15L R/3 DD: SAP objects
DD15T R/3 DD: texts on SAP objects
DD16S R/3 DD: SQL table fields
DD17S R/3 S_SECINDEX: secondary indexes, fields
DD20L Matchcode objects
DD20T AS400-T_MCOBJECT: MC Object Texts
DD21S S-MCIDTABLE: Tables for a MC ID
DD23L Matchcode ID
DD23T AS400_L-MCID: Matchcode ID Texts
DD24S Fields of a matchcode ID
DD25L Aggregate Header (Views, MC Objects, Lock Objects)
DD25T Short Texts for Views and Lock Objects
DD26S Base tables and foreign key relationships for a view
DD27S Fields in an Aggregate (View, MC Object, Lock Object)
DD28S Lines of a selection condition
DD29L Selection Condition for Views and MC IDs
DD29T AS400_L-SELCOND: Selection Condition Texts
DD30L Search helps
DD30T Search help texts
DD31S Assignment of search helps to collective search helps
DD32S Search Help Parameter
DD33S Assignment of search help fields
DD35L Search help attachments to structures: Headers
DD36S Parameter-field assignments for search help attachment
DD40L Table types (internal tables defined in DD)
DD40T Text on table types
DD42S Key fields for table types (internal tab. defined in DD)
DD90L Header Information for External Index
DD90T R/3-DD: Text for External Index
DD91S DocID Key Definition of External Index
DD92S Mapping of R/3 Data on External Index
DD93S Attribute of an External Index
DD94S Languages of an Index Category
DD96S Synchronization Tables
DD97S Statements for Trigger and Stored Procedures
DDACL Exclusion times for ABAP/4 Dictionary actions
DDALIAS DD: Second name for accessing tables
DDART DD: Data Class in Technical Settings
DDBUF DD: For transferring the new buffering parameters
DDCDIM DD: Conversion, number of table lines
DDCNVEXIT DD: External conversion methods
DDCNVSTAT DD: Statistical Data for Conversion
DDCNVTABL DD: Contains incr. conv. tables depend. on release/component
DDCNVTIMES DD: Exclusion times for conversion
DDCNVUSR DD: Exception table of converter
DDCPRO DD: Conversion projects
DDCPROT DD: Text on conversion projects
DDCPROTAB DD: Table for conversion projects
DDCQUEUE DD: Queue for CNV Operations
DDCSTA DD: Conversion, number of table lines
DDCSTAT DD: Statistics table for conversions
DDDTRENUPG DD: Table for Renaming Data Elements During Upgrade
DDF4PSINDX Contains Information for Personalizing the F4 Help
DDFTX Run-time object with Screen Painter texts
DDFTX*  
DDFTX2  
DDFTX3  
DDFTX4  
DDFTX5  
DDFTX6  
DDFTX7  
DDFTX8  
DDFTX9  
DDICNVCTRL Control String for Transaction ICNV
DDICNVDAYS DD: Days of Week
DDICNVDIST Distribution of data records of base tables
DDICNVLST Contains information on converter exits
DDLBBUFTST Test: Recognize Access to Buffered Tables
DDLOADD R3load-data table for migration
DDLOADH R3load-header table for migration
DDPAMSCTRL DD: Controls Parallel Handling during Mass Activation
DDPART DD: Partitioned form of TBATG
DDPATH DD: Definition of access paths
DDPRH R/3 DD: Log header
DDPROF DD: Settings for DDIC programs
DDPRS R/3 DD: log lines
DDPRTUVAR User settings for printing DD objects
DDSERVPERF DD: Performance Key Figures of Server for Par. Execution
DDSHDEFSH Default value - search help per user and collective s.h.
DDSHENTITY Table of data elements which need the value table help
DDSHHVALUE Historic Help Values
DDSHLPVERS Current Version of Search Help Activator
DDSHPVALUE Personal Help Values
DDSPAR Storage clause for tables and indexes
DDSPAR1 Storage clause for tables and indexes
DDSPAR2 Storage clause for tables and indexes
DDSTATHIST DD: Statistical Data for Conversion
DDSTORAGE Storage clause for tables and indexes
DDSTORAGE1 Storage clause for tables and indexes
DDSTORAGE2 Storage clause for tables and indexes
DDSYN Parameters for Buffer Synchronization
DDTYPES Table of all Dictionary types and classes
DDTYPET ABAP/4 Dictionary: Texts for type groups
DDVE1 Value Table for Domain DDVERINT4
DDVEPR Check Table with Two Key Fields
DDXTF Nametab field structure for delayed writing
DDXTT Nametab header structure for delayed writing
DDYTF Substitution Nametab (shadow-shadow-nametab for DDXTF)
DDYTT Substitution Nametab (shadow-shadow-nametab for DDXTT)

SAP ABAP COMPUTE ADD COLLECT and APPEND

SAP ABAP COMPUTE ADD COLLECT and APPEND

COMPUTE The COMPUTE statement is used to assign the result of the mathematical statement to a variable. The use of COMPUTE statement is optional. Please examine the following program.

Data: d_result type i,
          d_num1 type i,
          d_num2 type i.


COMPUTE d_result = d_num1 + d_num2.

is the same as

d_result = d_num1 + d_num2.
 

Note: If you want to add 2 numbers then it can also be done as follows in SAP ABAP. 

add d_num1 to d_num2.
In this case the result is stored in d_num2.
COLLECT To Sum up the entries in the internal table you can use the COLLECT statement. The syntax is as shown below.
COLLECT wa INTO itab.
 

Please note that when using COLLECT you should ensure that all the fields that are not a part of the table key  should be numeric. This means that fields that are not part of the table key should be either f,i or p.

Example

DATA: BEGIN OF d_collect,
        key(5) TYPE c,
        num1(2) TYPE n,
        num2    TYPE i,
      END OF d_collect
.
DATA itab LIKE STANDARD TABLE OF d_collect.
d_collect-key = 'First'.
d_collect-num1 = '20'.
d_collect-num2 = '30'.
 
COLLECT d_collect into itab.
 
d_collect-key = 'First'.
d_collect-num1 = '20'.
d_collect-num2 = '15'.
 
COLLECT d_collect into itab.
 
d_collect-key = 'Second'.
d_collect-num1 = '20'.
d_collect-num2 = '15'.
COLLECT d_collect into itab.
 

The result is as follows. 

After first collect

    First 20 30 >>>>> First 20 30  

After Second Collect

    First 20 15 >>>>> First 20 45  

After Third Collect

    Second 20 15 >>>>> First 20 45  
            Second 20 15  

Please make a not that the first and the third COLLECT statements act as insertion statements and they just append the row to the table.


APPEND

The APPEND statement will just insert lines in the internal table. See the example given below.

Example:

DATA: BEGIN OF d_append,
        key(5) TYPE c,
        num1(2) TYPE n,
        num2    TYPE i,
            END OF d_append
.
 
DATA itab LIKE STANDARD TABLE OF d_append.
 
d_append-key = 'First'.
d_append-num1 = '20'.
d_append-num2 = '30'.
 
APPEND d_append to itab.
 
d_append-key = 'First'.
d_append-num1 = '20'.
d_append-num2 = '15'.
 
APPEND d_append to itab.
 
d_append-key = 'Second'.
d_append-num1 = '20'.
d_append-num2 = '15'.
APPEND d_append to itab.

After first APPEND

    First 20 30 >>>>> First 20 30  

After Second APPEND

    First 20 15 >>>>> First 20 30  
            First 20 15  

After Third Collect

    Second 20 15 >>>>> First 20 30  
            First 20 15  
            Second 20 15  

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