Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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)
Creator III
Creator III

hi Anil,

Thank you for the reply.

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

Please help.

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)
Specialist
Specialist

Are you fetching data from SAP Z reports?

Specialist
Specialist

This variant are not stored in any table.