- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
- >ABAP Constants & Literals
- >ABAP Constants & Literals
- >Types of Tables in SAP
- >Sap Data Object
- >Internal Tables and Work areas
- >Internal Table Operations in SAP ABAP
- >ABAP Report uses Internal tables and Work Areas
- >Select single and Select up to 1 rows
- >Modularization Techniques
- >Techniques of debugging
- >Types Subroutines
- >Reports of Sap Abap
- >Using At Selection Screen Output
- >Select Statements
- >Function Modules
- >Modularization Techniques 2/
- >Subroutines In Sap Abap/
- >Report Of Sap Abap 2
- >Using At Selection Screen Output 2
- >Interactive Reports
- >Interactive Reports Development
- >Interactive Report Using Hide Technique
- >Interactive Report Using Get Cursor Technique
- >Tree List Report
- >Abap Alv Reports/
- >Sap scripts/
- >Purchase Order SAP Script/
- >SAP Smartforms/
- >What is BDC in SAP ? Types of BDC ?/
- >BDC Call transaction for Material Master MM01/
- >SD flow with T-Codes and tables/
- >Introduction to module pool programming in SAP/
- >Functional Specification/
- >ASAP methodology SAP
- >ABAP Development end to end process in Companies
- >SAP SD Sales and Distribution
- Accounting Entries in SAP FICO
- Define Company in SAP
- Creating new companies
- Assign Company Code
- Business Area
- Functional Area
- Credit Control Area in SAP
- Financial Management in SAP
- Segments in SAP
- SAP Enterprise Structure
- General Ledger Accounting
- Fiscal Year Variant in sap
- Posting Period Variants in SAP
- Posting Period Variant to Company Code
- How to Assign company code to field status variants in SAP
- Posting Keys in SAP
- Tolerance Group for Employees in SAP
- Tolerance Groups For G/L Accounts
- Assign Users to Tolerance Groups in SAP
- Enter Global Parameters for Company Code OBY6
- Define Additional Local Currencies for Company code in SAP System
- Chart of Accounts in FICO
- Assign Company Code to Chart of Accounts in SAP
- How to Create G/L Account Group in SAP
- Define Sample Account Rule Types in SAP
- Data Transfer Rules
- Convolutional and recurrent neural network
- Assign company code to rule type in sap
- Create sample account in sap
- Accounting entries in sap fico sap accounting postings
- Financial statement versions in sap
SAP Data Objects
SAP data objects one can create in SAP Data Dictionary. Now many peoples are confuse in confuse SAP Data Objects related to SAP Data Dictionary with data objects related to ABAP, which are created by CREATE DATA statement in ABAP programs and function modules.
All SAP Data objects are created in SE11 transaction and share one common feature: they are related to data, for data storage or data description, whether this is transactional business data or customizing data or maintenance data. This is the distinguishing feature they differ from repository objects which are related to programmatic activities and which are created by SE80 transaction. However, in some cases scopes of these transaction overlap. For example, data elements, domains and even tables can be created from SE80 too.
Database tables are one of the main objects available for creation and maintenance in SAP Data Dictionary. There are three types of tables in SAP ECC:
- Transparent tables
- Pooled tables
- Cluster tables
Data elements are the most important pieces which most programmatic and database object comprise of, therefore one should pay special attention to them and get a good grasp of how they are constructed, maintained, understand their basic fields and properties.
Data elements are data types we use to construct tables, views and other SAP data objects. With the help of data elements, we can define either elementary types or reference types and their semantic properties. Referentially-typed data elements are used as reference to another type, class or elementary type. This is useful, when you have a need to declare a big set of similar data elements.
Elementary-typed data elements are technically similar to predefined dictionary types with the only significant difference: they can hold semantic meaning of the type.
From the above picture, we can see the main technical attributes that are specified by a data element:
Domain is important entity which defines application area of a data element, it will be discussed further.
Elementary data type which is data element based on.
Elementary type length.
It is important to keep in mind the data elements typing concept: one can specify either elementary typing for a data element or domain-based. Not both! If you select domain for a data element, Data type and Length fields will be auto-filled and become greyed out and unchangeable. For fine-tuning always use elementary types.
So, what are those semantic attributes of data element and what makes them invaluable for data definition? Here are they:
- Short text
- Field label
- Supplement documentation
- Documentation status
- Search help
- SPA/GPA parameter
- Flag for input history
- Flag for change document
The most important of them is short text, a small description which is showed in search help windows, also field labels (short, medium and long) which are showed as column labels in all ALV grids this data element is used, documentation which is pretty self-explanatory and search help. Search helps will be discussed further in this tutorial.
In other words, semantic attributes help to identify data elements, differentiate from each other, put some business sense to them. And that is the fundamental difference between them and predefined dictionary types, which can be used in specification of complex SAP data objects too.
Domains are also very important entities that used throughout the SAP Data Dictionary extensively. Domain defines the range for values that data element can hold, and the scope where this domain and all data elements based on it will be used. For the range, the following domain attributes are used.
Data type –
elementary type which is the same we saw in data elements. If we select domain during data element specification, this type is applied to data element automatically.
No. Characters –
data type length.
Decimal places –
attribute which is used for numeric types and which shows number of decimal for number.
Output length –
length of the visible area for the domain and correspondent data elements. Can be less or more than the actual length.
Conversion routine –
special procedure for showing the object. Conversion routines is the extremely interesting concept inherent only to SAP. It is used for data transformation between how it is stored actually in a database and how it should be exposed to a user. The simplest example for this is binary representation of logical variables. If we want to store booleans like 1 and 0, but want them to be shown to a user like true ad false, we can write a trivial conversion routine to implement this. The closest equivalent that comes to my mind is Java Getters and Setters for Java fields.
The scope of domain and data elements based on it is specified by following attributes.
Single values –
values that can be assigned to the target data element.
ranges that can be assigned to the target data element.
Value table –
developer can specify database table that can be used for domain values specification, so that data element based on this domain can hold only values from table.
Views is another essential type of SAP data objects used in SAP Data Dictionary for accessing database data. What are the views in fact? If you ever used JOINs in any RDBMS you are aware how they work and constructed. View in SAP is a group of columns joined in application-specific manner, in a specified order, specified sorting and with certain WHERE conditions. Of course, there are some peculiarities which will be discussed further.
There are the following types of views in SAP:
- Database views
- Projection views
- Maintenance views
- Help views
- External views
One should understand that views are purely synthetic entities which are used for more robust and comfortable access to dataset data and for hiding and exposing to user only those data which is necessary.
Views are mostly platform-independent and don’t create correspondent view object on database level, except database views type. Views can be used both for writing and reading data from database.
Database views –
the only view type that create view object in database. If basis table (table it consists of) don’t exist in database, then view object is not created too. The basis table should be transparent.
Projection views –
the special view type that is used only for hiding field from a single basis table. Multiple tables are not allowed, as well as where conditions.
Maintenance views –
special views for writing and maintenance data in all tabled of the views. The maintenance is done through special transaction SE54 through automatically created programmatic modules. During insert into view tables all fields non-existent in view are assigned initial values.
Help view –
a special view for search helps which will be discussed further.