Online Classes SAP ERP ABAP DICTIONARY

ABAP DICTIONARY

•Define a table and table concepts including:
   –Foreign key and primary key
   –SAP table types
   –Indexes
   –Buffering
•Describe the basic functionality of the Data Dictionary, its objects and related transactions
•Define domain and data element and how they are related
•Define structures and views
•Define search help
•Describe the data browser

What is a Data Dictionary?

•A data dictionary is a system-independent interface to a database.
•A data dictionary is a “virtual database” containing metadata (data about data).
•A data dictionary provides tools for data manipulation and data processing.
Data Dictionary
Data Dictionary

Why Data Dictionary?

using data Dictionary we don't have to worry about the server and database we can use any database or we can even change the database without doing any change in application, that the biggest advantage of using data Dictionary in SAP.
data dictionary Structure
Data Dictionary Structure


ABAP Dictionary Functionality

ABAP Dictionary Functionality
ABAP Dictionary Functionality

Navigating the ABAP Data Dictionary

using following command we can view and explore ABAP Data Dictionary in SAP GUI and ADT
SAP GUI
ABAP Data Dictionary

Data Browser

using Eclipse GUI we can explore the ABAP Dictionary by following the steps below

Data Broswer
Data Browser

Using the Browser

Browser
using the Browser

Table Relationships

In a business scenario, a booking company wants to create a subset of its services using SAP, particularly about travel services.

tabel Relation
table relationship

Displaying Tables

Ctrl+Shift+A in Eclipse GUI
displaying tables
displaying tables

Basic Data Dictionary Objects

table Structure
table Structure


Table

Actual Data Container
Field name
Primary key indicator
Attributes inherited from data element

Table
Table Structure

Relationships Between Tables: Foreign Keys

primary Key
Relationship between Tables Foreign Keys

Cardinality

•Cardinality defines the type of relationship between two tables.
•The cardinality of a foreign key indicates how many dependent records a record in a check table may have.

cardinality
Cardinality Type

Check Table - System Default

check Table System Default
Check Table System Default

SAP Table Types

SAP table type
SAP Table Type

Table Definition

table Definitaion
Table Definition

SAP Data

Master Data

  • G/L Accounts
  • Vendors
  • Materials
  • Stock Locations

Transaction Data

  • Sales Orders
  • Purchase Orders
  • Journal Entries
  • Goods Receipts

System Data

  • Metadata
  • Programs
  • Documentation
  • System Settings

Configuration Data

  • Currency Codes
  • Order Types
  • Payment Terms
  • Field Status Codes

Data Element

Semantic Definition
Attributes inherited from domain
Field labels


Demo on Table Properties


Table Peoperties
Table Properties

Data Element

Attributes inherited from the domain

Data Element
Data Element

Domain

Technical Definition
Data type
Number of characters
Output length
Value table
Domain
Domain

Two-Level Domain Concept

Multi_domain
Two Level Domain

Specifying Value Ranges for a Domain

Fixed Values Example:

Domain: S_CLASS (Classes for a Flight Booking)
Values: C (business class)
F (first class)
Y (economy class)

Value Table Example:

Domain: S_CARR_ID (Carrier ID)
Value Table: SCARR

Interdependency of ABAP Dictionary Objects RECAP

Structure
Structure of ABA Dictionary


Comments

  1. Unknown11 January 2022 at 21:52

    I cannot thank you enough for the blog.Thanks Again. Keep writing.
    core java online course
    core java online training

    ReplyDelete
  2. Anonymous20 April 2022 at 01:11

    Online Classes Sap Erp Abap Dictionary >>>>> Download Now

    >>>>> Download Full

    Online Classes Sap Erp Abap Dictionary >>>>> Download LINK

    >>>>> Download Now

    Online Classes Sap Erp Abap Dictionary >>>>> Download Full

    >>>>> Download LINK mH

    ReplyDelete
  3. Sonam Singh 8 June 2023 at 03:13

    ERP TRAINING GURGAON offers top-notch SAP ABAP Training in Gurgaon , designed to equip you with the knowledge and expertise needed to succeed in this dynamic field. SAP ABAP training program covers all the essential concepts and functionalities of ABAP programming, ensuring a strong foundation for your future career. From basic syntax to advanced techniques, we leave no stone unturned in preparing you for real-world scenarios.

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP ABAP SELECT STATEMENT

Image
Module Objectives •Explain database Tables / data browser •Use the SELECT statement and the WHERE clause •Describe the SELECT SINGLE statement •Explain the ORDER BY addition •Describe retrieving individual columns •Exclude duplicate records during selection •Describe the SELECT statement syntax •Define aggregate expressions •Familiarization with ABAP 7.40 select statement new features •Discuss performance and best practices •SQL Console SELECT Statement - Basic Form the select statement is very simple in ABAP, we just use Keyword SELECT the we specified all columns of the table which we want to get we use * to show all columns with FROM keyword we specified the table. then we use a variable which will hold the result of the table and, in the end, we use ENDSELECT  to end the select query. Select Query Selecting specific fields from database table Selecting specific fields from database table Inline Declaration after INTO for ABAP 7.40 instead of defining all the fields in ABAP 7.40 w
Read more

SAP ADOBE FORMS

Image
PDF-based print forms are a part of the Interactive Forms based on Adobe software package solution and are used for mass printing in SAP systems. as well as normal output on printers, and also the choice of archiving documents, you'll be able to additionally use your application to send a PDF to the Business Communication Services (BCS). Here, you've got the choice of faxing or e-mailing your documents. The following provides you a summary of how a PDF-based print kind is structured and additionally tells you the way to create a PDF-based print from within the development setting of the ABAP work bench. The integrated Adobe LiveCycle Designer software system supports you after you do that. This software system should be put in on your forepart before you'll be able to produce a layout. to visualize a print preview of your kind, you initially got to install Adobe Reader or an entire version of Adobe athlete. This documentation doesn't discuss however documents are wri
Read more

ABAP AUTHORIZATION CONCEPT

Image
ABAP AUTHORIZATION CONCEPT Describe SAP Authorization Concept Adding authorization checks to programs using AUTHORITYCHECK statement Authorization Concept  The SAP authorization concept was developed to protect transactions, programs, and services in SAP systems from unauthorized access. The administrator (usually from BASIS) assigns authorizations to users that determine which actions (transactions/programs) a user can execute in the SAP system. The authorizations represent instances of generic authorization objects and are defined by the activity and responsibilities of the employee. Adding Authorization Checks to Programs It is almost always a good practice to add authority checks to your custom developed programs. To add authorization checks to programs, you need to do the following:  Determine the Authorization Field/s  Determine the Authorization Object/s  Add Authorization Checks in your program Use the ABAP AUTHORITY-CHECK statement. Specify alphabetic values in uppercase lette
Read more