SAP ABAP AND WEBDYNPRO TUTORIALS

What is Search Help Exit in SAP ABAP and How to Create it? Search Help Exit You may not know the correct records when you searching for some information from the SAP Data Base, in this case, based on known values, you can filter records to retrieve the data or you can filter the data to fetch your required records with the help of Search Help Exit and also using this function module, you can modify F4 Values at run time. Search Help Exit Definition Search Help Exit is a function module which contains predefined changing and tables parameter you can be modified/filter the F4 values selected by Elementary or collective search help using Search help exit function module from the DataBase table. Consider searching for sales order through VA03, and select sales document not fully confirmed tab, enter the customer number, and press enter   The result list will be displayed as below,   Now say our requirement is to have a customer number and custome...

Table Components in SAP ABAP As a SAP ABAP ,Every ABAP Developer should know about table components and its Technical details to increase basic strong knowledge to understand the Table Components technically. A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered should be checked against existing data to ensure that there are now contradiction. While defining foreign key relationship cardinality has to be specified. Cardinality mentions how many dependent records or how referenced records are possible. What are Compound Foreign Key in ABAP Dictionary? A compound foreign key is a foreign key composed of two or more fields. In other words, a check is done to compare two fields in the foreign key table against two fields in the check table. The combination of values must exist in the check table before they can be inserted into the foreign key table. However...

SAP Data Dictionary Tcode These are important Transaction(Tcode) codes used to execute various Data dictionary Objects. SE11_OLD - abap dictionary Maintenance Basis - Dictionary Maintenance SE12_OLD - abap dictionary Display Basis - Dictionary Maintenance SE11 - abap dictionary Maintenance Basis - Dictionary Maintenance SE12 - abap dictionary Display Basis - Dictionary Maintenance SE16. SE80.       SAP Transaction codes     Data Dictionary Overview     Tables     Domain     Data element     Views     Lock Objects     Types     Search Helps     Check Table and Value Table     Pooled and Cluster Tables      Links Between SAP Tables     Data Dictionary Real time Interview Questions     Creating Structure Tutorial in SAP ABAP     Creating Domain Tutorial in SAP ABAP     Creating Type Group Tutorial in SAP AB...

What is Database Table in SAP ABAP Table is a most important Object in SAP,whether you are Functional or Technical ABAP Consultant ,first basic thing is ,you must have deep knowledge on Database Table and its structure and Table technical Settings.We are creating Database Table in SE11(Data Dictionary) You can define Tables independently of the database in the ABAP Dictionary . The fields of the table are defined with their data types and lengths(Domain) and Description(Data Element). how to create table in sap abap step by step When you activate the table, the system automatically generates a physical table definition in the database for the table definition stored in the ABAP Dictionary. The system translates the table definition from the ABAP Dictionary to a definition of the particular database.  Table Components Domain : Domain is a Data Type and Length of  Table Field. Data Element : Data Element is a combination of Domain...

SAP Master Data Tables These are very Important Master Data Tables list gathered from different Modules , useful for Functional and Technical consultants to use them in their SAP Applications. VIMI01 - Rental unit - master data Real Estat - Real Estate Management BKK42_CC - BCA Account master data: Currency Changeover IS - Master Data ACCRBD  - Accruals/Deferrals master data - Basic Data FI - Financial Accounting RSOSOHIET  - Directory for master data Hierarchies - Texts BW - Data Staging CRFH - CIM production resource/tool master data PP - Production Resources/Tools BKK42 - Current Account master data: Operative Data IS - Master Data CMDT_CC - Generic master data: Cost Center Enhancements CO - Overhead Cost Controlling RSDBCHATR - master data attributes BW - Metadata (Repository) EGERS - IS-U Device master data IS - Device Management Customer Master Tables General Data in Customer Master KNA1 Customer Master (Company Code) KNB1 ...

SAP Database table Buffering in SAP ABAP Table buffering is used to improve performance when fetching the data records of the table. The table buffers loaded locally on each application server in the system. The data of buffered tables can be retrieved directly from the buffer of the application server. This avoids the time-consuming process of accessing the database . How to Create SAP Database Table The buffering type defines which table records are loaded into the buffer of the application server when a table record is accessed.  Buffering Types Full buffering: The system loads all the records of the table into the buffer when one record of the table is accessed. Generic buffering: When a record of the table is accessed, all the records having this record in the generic key fields are loaded into the buffer. Single-record buffering: Only the records of a table that are really accessed are loaded into the buffer. What is the use of Database Table Buff...

Technical Settings of a Database Table in SAP ABAP When you are creating a Database table in the SAP ,you must be maintain the technical settings of a table to define how the table is handled. The main technical settings of table are defining the Data Clas , Size category , buffering type and Logging . Step by Step tutorial for creating SAP Table As a ABAP consultant while you are facing the interview ,interviewer will expect these basic questions to test your basic knowledge on Data Dictionary Table ,most of the times ,myself ,faced questions on table technical settings ,so keeping it on my mind ,i am sharing this post for freshers and experienced. Different Table Technical Settings  in SAP  Data Class Data Class is Physical Space in the Data Base, when you are creating the table ,If you choose the one of the data classes correctly , table is automatically assigned to that chosen Data class (table space or DB space) in the database . Each data class has...

Step by Step Tutorial on Creating Table in SAP ABAP Tables can be defined independently of the database in the ABAP Dictionary. The fields of the Database table are defined with their (database-independent) data types and lengths. A table definition in the ABAP Dictionary contains the following components: Table Fields: Table fields define the field names and data types of the fields contained in the table Foreign keys: Foreign keys define the relationships between the table and other tables. Technical settings: Technical settings control the creation of the table in the database. Indexes: To speed up data selection, secondary indexes can be created for the table. Step to create a Transparent Table or Database Table in SAP  Open The SAP Easy Acces and enter SE11 Tcode  and Give <ztable> name and click on Create Button. Next give the short description and click on delivery class and data maintenance allowed Now click on the field...

How to Copy(Transfer) fields from one Table to Another Table in SAP ABAP Some times in SAP ABAP ,we may get requirement to copy(Transfer) fields from one to table other table ,to do this , i shared step by step screen shots to copy fields between two tables. Steps to copy data(fields) from one table to other now select the following fields from the session select those fields select the needed fields and click on copy now put the cursor where we want to paste them ie obviously below the fields on our table and right click the cursor and click on the paste the table appears on the following way when we save and activate it asks for technical settings so do as following then save and move back

Step by Step tutorial on creating Help View in SAP ABAP The data of a view is derived from one or more tables, but not stored physically. The simplest form of deriving data is to mask out one or more fields from a base table (projection) or to include only certain entries of a base table in the view (selection). More complicated views can comprise several base tables, the individual tables being linked with a relational join operation. There are mainly 4 types of views in SAP ABAP 1)database views 2)projection views 3)maintenance views 4)help views help views : they use left outer join to select data while database views use inner join to select data. select help view check box and click on copy   Step to create Help View   1)  Go to  SE11   2) select the view check box    3)give the view name that we want to create   eg: z_view_help1 4) finally click on the create icon  now select the help view check box and ...