Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hierarchy with SAP Extractor Connector

Hello,

I'm trying to load the profit-center account groups (transaction KDH3) out of SAP. Therefore I'am using the data source '0ACCOUNT_0109_HIER'.

The data load works and the hierarchy nodes are beeing loaded. So far as there are just individual accounts assigned to the account group nodes it's fine. If there are intervals assigned to the nodes hovewer you just get the the name of the group in the field nodename (ex.: 1000KA1201             001), but not the effective interval (ex.: 10000000400061-10000000400067).

As I found out it's possible to get the name of the Idoc structure (in this case: E1RSHND) from the load script and look it oup in the develop idoc transaction (WE30) in SAP. For the object name ZSQAQTQVCEXTR1 i found this structure along with other related structure names (E1RSHTX, E1RSHND, E1RSHIV, E1RSHFT). With this information it is possible to copy & paste the generated load script fragment and load the information out of structure E1RSHIV 'Data transfer Idoc: Hierarchy intervals'  and to get the intervals at last.

There has to be an easyier way - but I haven't found yet... So do anyone knows how to do this straight forward with the extractor dialog?

Thanks in advance.

Tom

1 Reply
Not applicable

Re: Hierarchy with SAP Extractor Connector

Ok, since no one seems to have a easyier way I have to assume that there isn't one yet...

Regardless of that the hierarchy load via Extractor Connector seems to me the easiest way to load SAP hierarchies.

The following IDoc Segm.type are available to load necessary hierarchy information from SAP: 

   E1RSSH                         Data transfer IDoc: Header information

       E1RSHIE                        Data transfer Idoc: Hierarchy header information

           E1RSHTX                        Data transfer Idoc: Language-dependent texts of hierarchy

           E1RSHND                        Data transfer Idoc: Hierarchy nodes

           E1RSHIV                        Data transfer Idoc: Hierarchy intervals

           E1RSHFT                        Data transfer Idoc: Name of node that cannot be posted to

       E1RSTXT                        Data transfer IDoc: Texts

Given this, the script text has to look just about like this:

[TABLENAME]:

LOAD

fieldlist

;

SQL EXTRACTOR [DataSource]

UPDMODE H   // Hierarchy extractor

HIERARCHY [HierarchyName]

HIERLANGUAGE E

HIERTABLE [IDoc Segm.type]

LOGSYS QTQVCEXTR1

;

The easiest way is to generate the script text via extractor generator and to to copy & past and adapt the fieldlist and the [IDoc Segm.type] afterwards.

Unfortunately there is - at least in my case - one big problem:

If the hierarchy intervals are beeing load the first interval NODEID has no LEAFFROM and LEAFTO values, although the IDoc do have the given values in the output structure of SAP (SAP s_tcode WE02). For all the following interval nodes it works just fine. But unfortunately it's worth nothing whitout the first values... Example see below:

DataSource:            0ACCOUNT_0109_HIER

IDoc Segm.type:        E1RSHIV

HierarchyName:        any hierarchy account hierarchy with intervals

Does anyone has an idea what the problem could be and how to solve? I would already be glad if someone could test this in a first step in his own system and confirm or disprove this system behaviour.

Community Browser