Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mightyqlikers
Creator III
Creator III

SAP Process chain variants from qlikview

Hi Team,

SAP BW team has created a process chain and used two variants one for start(var_start) and one for end(var_end).

Now I need to read those variants details like date and time stamp into qlikview.

Please help on the same.

Thanks in advance.

5 Replies
Anil_Babu_Samineni

When you call "Variant" in SAP i believe they created 2 nodes for you to pull data with different business. So, Here we were load 2 instances and/or variant of each to call them up into Qlikview. So, This is how you need SAP connector by SAP platform provider.

SAP Connection String ...

Variant1:

Load ....

Either one here Join / Concatenate

Variant2:

Load ...

From here, There is 2 manipulation as needs, If we are focusing on SQL as mediator of-course, It Would need SQL functions to change from current stamp to required like To_Char() ...

SELECT Date_Format(var_start, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;

SELECT Date_Format(var_end, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;

Meantime, I have one free offer for you, If we are loading using Qlikview LOAD statement there should be this?

SELECT TimeStamp(var_start, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;

SELECT TimeStamp(var_end, 'DD-MM-YYYY hh:mm:ss') as var_start From Table;


So, Finally you need to understand the business to create perfect Data model for 2 instances and other dimensional tables.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
mightyqlikers
Creator III
Creator III
Author

hi Anil,

Thank you for the reply.

do you know in which table this variant details will be stored in sap?

Please help.

Anil_Babu_Samineni

This is QlikView forum not a SAP.

FYQ, There is table name called "/SAPAPO/RTSINPUT_CUBE" if you have one variant it will store with in the table. And it you have many variants like you said there is Table called VARID, FM -"RS_VARIANT_CONTENTS"

So, Finally my question does your table is Transaction Data or Business data

You cannot get the variant values directly from SAP Table, First get variant name from VARID table and then use this from RS_VARIANT_CONTENTS like i said first sentence.

If this data has Transaction fields i believe we will get SHDTV Table in SAP (Just for assumption)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
neha_shirsath
Specialist
Specialist

Are you fetching data from SAP Z reports?

neha_shirsath
Specialist
Specialist

This variant are not stored in any table.