Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
mightyqlikers
Contributor 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
Highlighted

Re: SAP Process chain variants from qlikview

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)
Highlighted
mightyqlikers
Contributor III

Re: SAP Process chain variants from qlikview

hi Anil,

Thank you for the reply.

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

Please help.

Highlighted

Re: SAP Process chain variants from qlikview

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)
Highlighted
neha_shirsath
Valued Contributor

Re: SAP Process chain variants from qlikview

Are you fetching data from SAP Z reports?

Highlighted
neha_shirsath
Valued Contributor

Re: SAP Process chain variants from qlikview

This variant are not stored in any table.