Posts

Showing posts with the label Domains

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 data type DATS. Creating the in

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 key