SAP ABAP Programming Made Easy - Theory & FAQs

17) What Is A Delivery Class? Delivery Class manages the transport of table data when installing or upgrading in a client copy when transporting between customer systems. Different delivery classes available are: C - Customizing table, maintenance only by customer not SAP import. Example: Common Address Data (Country: T005) E - Control table, SAP and customer have separate key areas, defined in TRESC Example: Messages (T100) G - Customizing table, protected against SAP Upgrade Example: Communication: country dialing code (T005K) L - Table for storing temporary data, delivered empty Example: Lock Arguments (E070USE) S - System table maintenance only by SAP. Example: Language Key (T002) A - Application table (master and transaction data) Example: Personal Address Data, Username (USR01) W - System table, contents transportable via separate TR objects. Example: Transport (E070), Tables (DD02L) 18) What Are The Three Options Of Table View Maintenance While Crea...

11) What Is A Database View? The database view is combining several fields of two or more tables into single table . At least one relationship is required is required to combine tables to build a database view. Plus one can only read data from database view and cannot modify the data in the view directly (if view involves more than one table). Database views implement an Inner Join on the tables. The database view is the only type of view in SAP that is physically created at the database level. For example, consider two tables T1, T2. Fields of table T1 are F1, F2 and F3. Fields of table T2 are F1, F5. By using a Database view one can combine the fields of both tables T1 and T2, provided primary and foreign key relation is maintained between the two tables and thus final view can have fields like F1, F2, F3, F5. For more information: http://www.saptechnical.com/Tutorials/ABAP/View/Database.htm 12) What Is A Projection View? In standard SAP tables one can find there ar...

6) What Do You Mean By Pooled Tables In SAP ABAP? Also Explain What Do You Mean By Table Pool? Tables in Data dictionary which has many to one relationship with an underlying database table is called Pooled table. In simple words, Pooled tables appear as many tables in ABAP dictionary, but the thing is they are stored as a single table in the underlying database. In ABAP Dictionary, you can see each and every pooled table is assigned to a Table Pool. As it is understood that for many pooled tables in ABAP dictionary, there is a single table called as Table Pool in an underlying database. A Table Pool is an underlying database table with a special structure that enables the data of many ABAP Dictionary tables to be stored within it. Tables M_MTVMA, M_MTVMB, M_MTVMC, M_MTVMD and M_MTVME can be seen in ABAP Dictionary. These all mentioned tables are Pooled Tables. All these tables have been assigned to one Table Pool i.e. M_MTVM, which will be present in the underlying database...

1) What Is The Difference Between Native SQL & Open SQL? There are two types of SQL being used in SAP ABAP programming language. They are Native SQL Open SQL Open SQL allows to access the database tables declared in the ABAP dictionary regardless of the database platform that the SAP R/3 system is using. Native SQL allows to use database-specific SQL statements in a SAP ABAP program . This means that one can use database tables that are not administered by ABAP dictionary, and therefore integrate data that is not part of the SAP R/3 system. Open SQL is not confined to any particular type of database while a Native SQL is confined to a particular type. ABAP programs that uses only Open SQL statements will work in any R/3 system, regardless of the database system in use. Open SQL statements can only work with database tables that have been created in the ABAP dictionary. 2) What Is ABAP Dictionary Or Data Dictionary? What Is The Transaction To Access ABAP Dictionar...

There are 3 types of tables in SAP Dictionary (DDIC). They are: Transparent Table Pooled Table Cluster Table TRANSPARENT TABLES: Whenever a table is created and defined through ABAP Dictionary, then it is called a transparent table. When the table is activated in ABAP Dictionary, a table automatically gets created in the underlying database with the same name as was defined in ABAP Dictionary. So generally we say, transparent tables has one to one relationship with underlying database which means there will be only one physical table on the database for each transparent table created and defined through ABAP Dictionary. T he names of the table and fields in underlying database will correspond or have the same names as the logical table definition in the ABAP Dictionary. Transparent tables can be used to store application data which include master data as well as transaction data. Transparent tables are probably the only type of table that you will ever create as a deve...

11) State The Difference Between Client Independent & Client Dependent Objects? The data in each client may be separate from that of the other clients in a particular server. There are basically two types of data in an SAP System – Client Dependent and Client Independent data. Client Dependent data is defined as data specific to an individual client whereas Client Independent data can be defined as data contained across all clients in the system. Examples of Client Dependent data include number ranges, ABAP variants, and user masters as well as the data that is created or updated through SAP transactions (transaction data). Examples of Client Independent data include data dictionary objects (tables, views), ABAP source code, screens, and menus. Take a simple example. Suppose that your system has 2 clients in the Development System 100 and 200. When you create a test report program ZTEST in a client 100 of your development system then the report would also be avai...

6) What Do You Mean By SAP R/1, SAP R/2 & SAP R/3 System? What Does R Stands For? Differentiate Between Them. When we say SAP R/1, R/2 & R/3, here R stands for real-time data processing and 1, 2 & 3 stands for 1 tier, 2 tier and 3 tier architecture. When we say 3 Tier means 3 Layers. 1st Layer- Presentation Layer (User Screen) 2nd Layer- Application Layer (Programming such as ABAP efforts) 3rd Layer- Data base Layer (Data storage) SAP R/1 means 1 tier architecture i.e. this system includes all the three layers – Presentation, Application & Database – in one system or server. SAP R/2 means 2 tier architecture i.e. this system includes all the three layers – Presentation, Application & Database – in two different system or server. Server one is for Presentation Layer Server two is for Application + Database Layer SAP R/3 means 3 tier architecture i.e. this system includes all the three layers – Presentation, Application & Database – in thr...

1) What Is ERP? ERP (Enterprise Resource Planning) is business management software which helps in integrating the data sources and various processes of an entire organization in a unified system. In short, ERP is an integrated suite of applications to meet corporate needs ERP is just not a software but a complete business solution integrated across the entire value chain which creates an information infrastructure for efficient planning and effective execution. 2) What Are The Advantages Of ERP? Advantages of ERP are: ERP closely links, monitors, and controls primary enterprise resources like manpower, machine, material, methods, market and money. ERP enables corporate firms to readily change their processes to adapt to the ever changing business scenario. ERP provides expertise in industry specific business processes. 3) Name Some Major ERP Vendors In Market? Some major ERP vendors in market are: SAP Business Suite JD Edwards from Oracle Microsoft Dynamics Pe...

1. What Is a BADI In SAP ABAP? The use of object orientated code within SAP has led to a new method of enhancing standard SAP code called Business Add-Ins or BADI's. BADI (Business Add-Ins) is an Object Oriented way to enhance SAP System. Just like Customer Exits, BADI’s help hook custom enhancements to SAP functionality. BADI's are custom enhancements to the standard SAP system. BADI's can be used to accommodate user requirements that are not very common and should not be present in the standard configuration of SAP. For instance, in a particular industry, there might be a specific requirement in a business process that cannot be covered by the standard functionality of SAP. Such requirements can be addressed by creating or implementing a BADI that will implement the missing functionality. BADI's are nothing but enhancements through classes and methods. Hence BADI's are also called Object Oriented Enhancements. 2. What Is The Difference Between User-Exi...

Submitted By:   Shilpa Gunjan (LnT Infotech) COLLECT Keyword/Statement is used to add or insert a new entry in internal table without creating duplicate entries. COLLECT statement  doesn't directly append the new entry to the internal table rather it first checks in the internal table for any record matching the key in the work area or the header line data. If no matching records are found, then the new data in the work area or the header line will be inserted to the internal table. But in case if any record found with the same key, then instead of inserting a new record, it will add the numeric values of the work area or header line with the matched record and update the internal table record. In simple terms, COLLECT keyword is used to fill an internal table without creating duplicate entries and add up the packed, integer and floating point fields at the same time. Numeric fields include Integer (I), Packed (P) and Floating (F) data types. In case ...