Posts

Showing posts with the label Unraveling SAP Structures

Unlocking SAP Views: Navigating Maintenance Views and Help Views in Your Database Journey

Image
 Welcome back everyone So basically we already have created database view and projection view in our previous blog and in this blog we will see about Maintenance view and help view. Maintenance View Creation :- Note :- We can only create help view, if not more than one record should exits in dependent/secondary tables. Step 1:- Go to se11 and select view radio button and give some name for maintenance view and click on create button. Step 2:- Select maintenance view radio button and press enter → give short description. Note:- Since in our order item table we have multiple data for same data in order header and since maintenance view does not allow presence of multiple data in secondary table. Therefore, we will be creating two more tables with the following data in them, and then we will start with the maintenance view.      So, basically create the two tables, I don’t think it will cause any problem to anyone because we already have discussed in details how to create a ta

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