Enhancing SAP Tables: Include and Append Structures, Domain Creation, and View Introduction

 Hey, Welcome back everyone.

Today, We will continue with creating include and append structure and add it to our already created order header table.

So, basically we have to create the below domains and data elements first.

        


Requirements:-

  1. Add Delivery number and Delivery date field to the Order Header Table with the help of include structure.

  2. Add Delivery location to the order Header table with the help of Append structure.

  3. Regenerate the table Maintenance Generator and insert the values of Delivery number, Delivery date and Delivery location.

  4. Our header table should look like this :-



Creating the required data elements and domains :-

  • Step 1: Create domain and data element ZAR_DELIVERY_LOCATION of type char and length 3 and above mentioned value range.



  • Step 2:- Create domain and data element ZAR_DELIVERY_NUMBER of data type NUMC and length 12.

  • Step 3:- Create a domain and data element ZAR_DELIVERY_DATE with data type DATS.

Creating the include Structure and adding it into the Order header table:-

  • Step 1:- go to se11 and select radio button data type and give some name { ZAR_STRUCTURE } → click on create → select structure and press enter.

  • Step 2:- Enter delivery number and delivery location in the structure and activate the structure.



  • Step 3:- We have to insert the structure after order date, So go to se 11 and open ZAR_HEADER table in change mode → select the field payment mode.

  • Step 4:- Go to edit → include → click on insert.



  • Step 5:- give the structure name and press enter and table will look like this after that.



    • Activate the table.

Creating a append Structure for delivery location field :-

  • Step 1 :- Open the table ZAR_HEADER in change mode.

  • Step 2 :- Click On append Structure and give the name and press enter.



  • Step 3 :- Enter the field and click on activate.



  • After this your table should look like this.



  • Step 4 :- Now go to TMG and delete the TMG and generate it again, so that the newly added fields get added otherwise you will not see them in SM30 and can be maintained from SM30.

  • After that go to SM30 and enter the above given data.



Views Introduction:-

  • A view is a virtual table.
  • A view is a logical database.
  • It does not have any data.

Difference between table and view :-

  • Table has data but view does not have any data.
  • A table has a physical database but view does not have any database.
  • View brings the data from the tables itself.

Types of Views :-

1. Database View :-

  • It is a collection of one or more database tables.
  • Pre-requisite :- Tables must have the relationship between them.

2. Projection View :-

  • It is applicable to single tables.
  • Select those fields which are required.

3. Maintenance View :-

  • It’s purpose is to maintain multiple tables.
  • Pre-requisite :- Tables should have the relationship between them.
  • Take MANDT field in the maintenance view.
  • Maintenance view can be used to maintain data in the tables.

4. Help View :-

  • It is used in search helps.
  • Pre-requisite :- Tables should have the relationship between them.

Note :-

  • For maintenance view and help view, not more than one record should exist in the dependent/secondary table.

We will be creating all types of views in the next blog.

Location: India

Comments

Post a Comment

Popular posts from this blog

Understanding Different Types of SAP Function Modules: Normal, RFC, and Update

Image
  1. Normal/Regular Function Module :- It can be called inside the system. Here Pass by value + Pass by reference both is fine. 2. RFC Function Modules :- You can call from same system or from another possible. In RFC function module you can only have pass by value. In the same system if you are going to add the DESTINATION NONE’ while calling the RFC then it’ll be called in separate session. 3. UPDATE Function Modules :- This is generally used to update the database record. Update Function Module can be called from the same system. ( Background RFC / trfc / grfc ) This is used to achieve generally the SAP LUW. Some time we use from performance perspective also. When COMMIT WORK gets executed then Update starts getting executed. Important Questions on Update Function Modules :- When Update function Module gets Triggered ? ON COMMIT WORK IF a update function module gets failed, under which transaction we can see that ? OR What is the T-Code for moni
Read more

Unlocking SAP ABAP Secrets: Interactive Classical Reports with GET CURSOR, At User Command, and a Comparison of HIDE Statements

Image
 Welcome back everyone, We were discussing about the interactive classical reports, so let’s continue it. Interactive Classical Reports- GET CURSOR :- In Interactive Classical Reports, GET CURSOR statement is used to create secondary list according to cursor position. The parameter FIELD provides the name of an output field. The parameter VALUE provide the output value. Syntax : GET CURSOR FIELD <lv_field> VALUE <lv_value>. In the above syntax - the field name and field value will be returned in to variables lv_field and lv_value respectively. Requirement :- If you remember, In our last two blog, We have been displaying the order header table in a basic list and order item table in the secondary list. We have used SY-LISEL and HIDE statements to achieve the requirement. Now, we have to use the get CURSOR to achieve the same to same requirement. Code :- ************************************************************* *Start of Program *Declaring Strcutrure
Read more

Mastering ABAP: A Step-by-Step Guide to Function Modules and Groups for Modularized Programming

Image
  Function Modules :- It is a modularization technique. The transaction code to create a function module is SE37. To create a function module, we need to create a function group. Function Group :- Function group is a container for the function modules. The transaction code to create a function group is SE80. A function group can store up to 99 function modules. Requirement :- let’s create a function module for sum of two numbers. 1. Creation of function group :- Step 1 :- Go to SE80 transaction code → Object Navigator. Step 2 :- From the drop down select function group. Step 3 :- Give a name of function group. Step 4 :- press enter. Step 5 :- Click on yes a popup screen will appear. Step 6 :- Give short description → press enter → Assign package and transaction request and press enter. Step 7 :- Right click on function group and click on activate to activate the function group. Step 8 :- You will see two includes, will be added after ac
Read more