Day: January 20, 2018

Based on the research of researchandmarkets.com, the market cap for Hybrid Integration Platforms (HIP) will grow from $17.14B in 2017 to $33.6B in 2022. This shows the importance of the Hybrid Integration Platforms and their relevance to enterprises. First of all, it is essential to understand the concept. The term “Hybrid” means a combination of more than one entity (most of the time 2). I drive a hybrid Toyota vehicle which runs on electricity (battery) as well as fuel (petrol). In the world of integration, hybrid means integrating systems which reside both on-premise and in the cloud.

When it comes to “on-premise” systems, they can be running on physical hardware, virtual machines, containers, or in a virtual private cloud. The meaning of an on-premise system in the world of integration is that the user has control over application maintenance. https://goo.gl/MstS1D #DataIntegration #ML

Author       : Bala.G.Reddy

Company   : Cognizant Technology solutions.

Created on: 22.11.2017

Author Bio

I am Bala.G.Reddy working as Senior Associate  at Cognizant Technology Solutions, India. I  joined Cognizant Technology Solutions in 2014 and I have extensively worked on multiple SAP BI implementation and support projects

Summary: In this document I am going to cover the below topics:

* How to add ABAP perspective in HANA studio
* How to create ABAP repository for CDS VIEW
* Creation of  CDS view using data extraction annotation with Business scenario
* String Function in CDS view.

* How to add ABAP perspective in HANA studio:

First Login to HANA studio and follow below steps:

Add ABAP Project as shown below:

Then search for the SAP BW System like Dev or QAS or PRD since our system is BW 7.5 SP 02, login to system.

 

2) How to create ABAP repository for CDS view

Then left side you will 2 folders one favorite packages and system library, and create new ABAP repository

Click on Data definition

 

3) Creation of  CDS view using data extraction annotation with Business scenario

Scenario: We have requirement to derive reference document number  from VBAP-VGBEL where VBAK-AUART = ZPQC. To join these 2 tables VBAP-VBAK we have created above CDS view. 

How do I find  reference number which is having ZPQC?

Step 1:

First we need to join 2 tables VBAK-VBAP with document number matching as given below screen shot:

Note: You see the tables /BIC/ADVBAK_OM and /bic/dvbap_om active tables, Actually we have replicated ECC tables VBAP and VBAK through SLT and created data source and DSO(Standard DSO) Which is enabled as real time data load. On top of the active tables we have created CDS view.

Now we actually joined above 2 tables using inner join.

Next step is we need to link the reference document from VBAP-VGBEL to VBAK-VBELN:

Pass the reference document in VBAK-VBELN and check Document where ZPQC as given below screen shots:

To achieve above scenario we have created below CDS view:

Left outer join  mapping condition is reference document from VBAP as b  and  document from vbak-vbeln(doc_number)

Output in where condition we need to take only document type is ZPQC which from VBAK table after passing the reference document.

4) String Function:

Simple scenario

CDS view is defined on  2 tables VBRK and VBRP,

If you notice below screen shot the field DZUONR from VBRK table has value ‘000000000‘1000210588, I need the value from 10th digit so  the substring function is used

substring(a./bic/dzuonr,9,10) as zuonr last 0 ends at 9th position and 1 starts from 10th position.

Final putput from CDS view:

 

  http://bit.ly/2DTJtag #SAP #SAPCloud #AI