Do checkout this commonly asked SAP BW HANA Interviews Q/A Series and prepare for your interviews easily. This is Part 1 of 10 Part Series.
SAP BW HANA Interviews Series
1. What is the difference between subroutine and function module?
A Subroutine is used internally in the program & cant be used outside the program. Whereas a Function Module can be written outside of the program and used within the program.
A subroutine is local to any program whereas a function module is written at the global level. Because a function module is stored in the central library.A Function Module can be tested independently whereas a subroutine cannot be tested independently.
2. What Could Be the Source of Open Ods View?
The major sources of Open ODS View includes:-
- DB Tables or Views for SAP HANA DB
- Transformations (When the data to be fetch is from outside BW)
- External sources connected using Smart Data Access
- Data Sources (Eg: ODP)
- ADSO’s
3. What is the Main Difference Between Open Ods View and Hana Enabled Composite Provider?
In HANA Enabled Composite Provider, we can use the UNION and the JOIN operation, and in order to do complex reporting, HCPR can be used to combine multiple infoprovider into a single one.
Whereas
Open ODS View is being used to consume external data through various sources and tables, and didn’t want to get persists. This could save space while querying the external data. Open ODS View use the concept of Smart Data Access where they use virtual tables to consume the data.
4. How Will You Create a Lookup Code in SAP – BW in End Routine ?
When you create a lookup code from One Provider to other using the third one, no mapping is being required from the third one in transformation.
All the selection of records from lookup table and their assignments are done in the target and insertion to target is done using the end routine.
First, we have to define the Structure of the LookUp Table and choose the fields to be extracted from the lookup table.
BEGIN OF TY_xx,
Choose fields
END OF TY_xx.
Then, we need to declare the internal table to store the data to be selected from the LookUP Table.
IT_TY_xx TYPE TABLE OF TY_xx.
DATA :
Then, we are going to define the WorkArea
WA_TY_xx TYPE …
All the records which are returned from lookup table are inserted into the internal table
Then, write small code to read the data and write the data :
SELECT fields FROM lookup table INTO internal table
For all entries which are present in RESULT PACKAGE
WHERE give keys
And then assign the result fields to result package
READ TABLE internal table into workarea
With keys
And this is how we can do a lookup.
5. What is a Temporal Join?
This is one of the basic question asked in SAP BI BW Interview. When while creating the joins, you wanted to do the mapping between the master as well as transactional data using the period of time.
Basically it could be used to set the time intervals for which the data needs to be fetched.There is always atleast one time dependent characteristics is present.
Hope you like the SAP BW HANA Interviews Series Part 1.
Check out other parts at my website : https://acorporateguy.com/