Differences Between ABAP CDS Views & ABAP Dictionary Views

ABAP Dictionary Views or Database Views are made in the SE11 in the ABAP Dictionary. ABAP CDS Views are made in Eclipse – for the present. The theory is, that at some point or another they can be created in the Web IDE also.

Where an ABAP Dictionary View and an ABAP CDS Views gets made is the main evident contrast. In any case, first of all – what are ABAP Dictionary Views and what are ABAP CDS Views.

ABAP Dictionary Views

ABAP Dictionary Views get from the database pre-characterized information. The ABAP Dictionary Views gets from the database by SQL Statements the information required for an application what is the full meaning of erp in sap   to process the ideal outcome.

For instance, an ABAP application needs to yield all items. For this, the application needs to get from the database the important information of an item. What’s more, rather than doing this legitimately by a SQL explanation the application utilizes an ABAP Dictionary View.

The ABAP Dictionary View gets the information of an item from the tables of the database by SQL. It associates just for an item vital tables of the database by Inner Joins and chooses from the tables all the important fields for an item.

At that point the ABAP application does not utilize straightforwardly a SQL explanation to get the information of the item from the database however the ABAP Dictionary View. The ABAP Dictionary View resembles an extra layer between the ABAP application and the database.

For instance, the name of the ABAP Dictionary View is ZPRODUCTS. It contains all tables and fields which are essential for an item.

In the ABAP code the view could be utilized this way:

SELECT * FROM zproducts

Request BY product_name


cl_products_output=>display( result ).

An ABAP Dictionary View is a view for at least one database tables. It is actually a view. Envision you are glancing through binoculars at a database. You just center certain tables or even only one table. Same goes with ABAP Dictionary Views: You pick one certain table or group certain tables together. In addition, you can likewise concentrate just on specific fields from those picked tables.

For instance, a database contains a bundle of tables. The point of your application is to return information which lives in three of the tables of the database. Also, just a single field of each table is vital. Here comes the view: The view associates those three tables and picks just the fields of the tables which are required.

When you enact an ABAP Dictionary View then a SQL View is made. This SQL View contains the SQL language structure of the characterized ABAP Dictionary View. For instance, in the event that you interface more than one table with an ABAP Dictionary View, at that point the SQL explanation of the SQL View does this by an Inner Join.


lives in the database

bolster just HANA database

the various highlights of ABAP CDS Views

unequivocal highlights for the HANA database

Why use ABAP CDS Views rather than ABAP Dictionary Views

There are 5 motivations to utilize ABAP CDS Views rather than ABAP Dictionary Views in a R/3 framework:

Upward similarity to S/4

Simple age of undeniable OData Services

Simple utilization of SAP UI5 Smart Controls and Fiori Elements

Certain approval checks

Execution help (see beneath)

Full Form of SAP HANA

The full type of HANA is High Performance Analytic Appliance.

HANA is a social database the board framework. HANA is in-memory and segment arranged. The essential capacity of HANA is as a database server: To store and recover information as mentioned by applications.

Yet, HANA can accomplish more than being an excessively quick database server in light of its in-memory and section situated plan: HANA is competent to perform progressed investigation and to what is the full form of erp in sap extricate, change and burden. Besides, it incorporates an application server.

Henceforth, the SAP HANA full structure is Software, Applications and Products High Performance Analytic Appliance.

Full Form of SAP ABAP

The full type of ABAP initially is as SAP a German abbreviation. ABAP remained in German for Allgemeiner Berichtsaufbereitungsprozessor. Meant English it is Generic Report Preparation Processor.

Later ABAP was renamed to Advanced Business Application Programming in light of its evolvement.

ABAP is a programming language and was discharged in the year 1983. It was named in any case Generic Report Preparation Processor due to that the language was just equipped for programming reports. ABAP couldn’t do any database changes.

Be that as it may, ABAP has been updated and is overhauled consistently – for instance, it is currently fit to do database changes as well as is object situated also. What’s more, during the time spent the constant evolvement of ABAP it was renamed to Advanced Business Application Programming.

Full Form of SAP ERP

The full type of ERP is Enterprise Resource Planning.

A meaning of ERP is: Enterprise asset arranging (ERP) is the incorporated administration of center business forms, regularly continuously and interceded by programming and innovation.

To put it progressively basic: Software and equipment to run an organization.

Henceforth, the SAP ERP full structure is Software, Applications and Products Enterprise Resource Planning. SAP ERP was utilized as an equivalent word for the principal ages of the focal programming result of SAP: R/1, R/2, and R/3.

Full Form of SAP R/3

The full type of R/3 is Real Time 3 Tier.

The Real Time of R/3 is a direct result of the accompanying reason: IBM put away information on punch cards precisely when SAP was established by 5 previous IBM workers in the year 1972. SAP unexpectedly put away information by means of a UI electronically in a database – Real Time.

The 3 Tier of R/3 is on the grounds that before R/3 was R/1, and R/2:

R/1 (Real Time 1 Tier) was discharged in the year 1973. At first, R/1 was a monetary bookkeeping framework. Later it filled in as the foundation in the consistent improvement of further programming modules for the framework. R/1 was running on centralized server PC frameworks on location of the clients.

R/2 (Real Time 2 Tier) was discharged in the year 1979. R/2 extended the abilities of R/1 to different territories, for example, material administration and creation arranging.

R/3 (Real Time 3 Tier) was discharged in the year 1992. R/3 supplanted later the centralized computer registering of R/1 and R/2 with a customer server design.

ECC (ERP Central Component or Enterprise Core Component) 5.0 was discharged in the year 2004. ECC supplanted R/3. The most recent adaptation is 6.0 and this was discharged in 2006. From that point forward it has been refreshed by improvement bundles. The latest improvement bundle 8 was discharged in the year 2016.

Thus, the SAP R/3 full structure is Software, Applications and Products Real Time 3 Tier.

Full Form of SAP S/4

The full type of S/4 is Business Suite 4 Tier. S/4 was discharged in the year 2015 and is the later form of the ERP frameworks of SAP. S/4 runs just on a HANA database. Hence, S/4 seems frequently as S/4HANA or SAP S/4HANA. The SAP S/4HANA full structure is Software, Applications and Products Business Suite 4 Tier High Performance Analytic Appliance.

S/4 is less complex and quicker in contrast with the past SAP ERP age. In addition, it includes a ton of highlights. That is all conceivable because of the fundamental HANA database.

S/4 can be sent on-premise like all SAP ERP ages previously and furthermore in the cloud or through a half breed model of on-reason and cloud.