Posts

Showing posts from December, 2023

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

Image
 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:- Add Delivery number and Delivery date field to the Order Header Table with the help of include structure. Add Delivery location to the order Header table with the help of Append structure. Regenerate the table Maintenance Generator and insert the values of Delivery number, Delivery date and Delivery location. 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 d...

Mastering SAP Data Management: From Data Types to Tables and Structures

Image
1.Types of SAP data :- Master data :- A type of data which is accessed very frequently, but changed very rarely. Transaction Data :- A type of data which is always changing and number of records are continuously increasing. Configuration Data :- A type of data which we can customize. Customizing depends on the business scenario and customer requirements. Examples :- Suppose there is a company ABC. Master data :- Employee data of the company ABC. Transaction Data :- Transactions in the company ( Banking transactions , Revenue transactions ). Configuration Data :- (Employee Designation) :- Senior Consultant ( Vehicle allowance applicable ) (Employee Designation) :- other than Senior Consultant ( Vehicle allowance not applicable). Data Class :- A portion or physical area of the database where table will be stored. Delivery Class:- It is used for controlling data transport of tables during installation, upgrade and transporting between customer systems. 2. Creating ...

Mastering SAP Table Maintenance: Insert, Update, and Delete Data with Ease

Image
 Welcome back everyone. So basically, we have created our ZAR_HEADER table yesterday, So we will learn how to maintain { insert, update, delete } data in the table. Open the table in change mode → go to utilities → table contents → create Entries. We can see the client number automatically appears. Enter the following details and click on save. You will get the message, database records successfully created. Similarly put some more records and click on save. If, I want to see the records in the button, there is a content button {Ctrl + Shift + f10}→ click on this button and press f8 {execute button }. OR You can click on utilities → table contents and display Changing data in table :- Note :- We can change, only non primary key data in our table. Display the entries, select the row where you want to change the data and click on change pencil button. Click on save and data will be changed, Again note we can only change data in non primary...

SAP ABAP Dictionary Demystified: Practical Implementation of Data Elements and Domains for Table Creation

Image
 Data Dictionary is also called ABAP dictionary or DDIC. Since, in our previous blogs we have already discussed the header and item table, now we will start with the practical implementation part. We will create the following below table. In the above table we have 5 columns, Order Number, Order Date, Payment Mode, Total Amount and Current. So, we will create domain and data element for these fields. Do not confuse with the Client Number, we will discuss it about later. Now, the question arises in mind, what is data element and domain. Domain :- Domain tells us about the technical characteristics of a field or column. Technical characteristics :- Data type , length. Data Element :- Data element tells us how the column/field will be visible to the end user. So, just think about how many data element and domain we need to create for the table. The answer is, we need to create 5 domains and 5 data elements. Creation of Domains :- Go to transaction ...

SAP Insights: Navigating the Easy Access Screen, Customization Tips, and Project Overview

Image
  SAP Easy Access :- After logging to SAP system through GUI, the first screen that appears on system is SAP Easy Access. It is a user specific point of entry. It is also called as SAP User Menu. The user menu contains only those items that are required to perform daily tasks such as transactions, reports etc. Adding Existing Item as Favorite :- Choose the existing item from the User Menu. Click on Favorites - Add 1. ABAP workbench :- It is a collection of tools which are used to perform certain specific actions. SE38 → Program/Report { ABAP Editor } SE11 → ABAP Dictionary SE37 → Function Module SE24 → Class Builder 2. Transaction Code :- It is a shortcut to access ABAP workbench tools. Examples :- /nxxxx - To call Transaction xxxx ( override the existing session ) /oxxxx - To call transaction xxxx in a new session , where xxxx is the transaction code. /NEX → To close all the sessions /n → to cancel a session /o → display an overview o...