topic Re: SAP Process chain variants from qlikview in QlikView

SAP Process chain variants from qlikview

mightyqlikers — Thu, 07 Dec 2017 04:49:51 GMT

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.

Re: SAP Process chain variants from qlikview

Anil_Babu_Samineni — Thu, 07 Dec 2017 05:03:01 GMT

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.

Re: SAP Process chain variants from qlikview

mightyqlikers — Thu, 07 Dec 2017 05:12:39 GMT

hi Anil,

Thank you for the reply.

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

Please help.

Re: SAP Process chain variants from qlikview

Anil_Babu_Samineni — Thu, 07 Dec 2017 05:19:30 GMT

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)

Re: SAP Process chain variants from qlikview

neha_shirsath — Thu, 07 Dec 2017 06:51:48 GMT

Are you fetching data from SAP Z reports?

Re: SAP Process chain variants from qlikview

neha_shirsath — Thu, 07 Dec 2017 11:51:06 GMT

This variant are not stored in any table.