topic SAP: KNVH Customer Hierarchy Table in QlikView

SAP: KNVH Customer Hierarchy Table

Thu, 24 Sep 2009 16:08:11 GMT

Hi,

In SAP there is an Hierarchy Table called KNVH which gives an overview of the Customer Hierarchy.

For example, in the field KUNNR you'll find a customer number which refers to its higher leveled customer number, mentioned in the field HKUNNR.

When you select this HKUNNR, and you look it up in the KUNNR, you'll find it, again with a reference to a higher leveled customer number HKUNNR.

And so on and so on.

This circular loop mechanism repeats it selves in the same table over and over again, until you reach a highest level (the HKUNNR stays empty).

Now how can you manage this table in Qlikview, How do you determine which is the highest and lowest level.

This Table is linked to the Customer MasterData table KNA1, and the key we use is customer number (KUNNR)

SAP: KNVH Customer Hierarchy Table

Mon, 12 Oct 2009 16:32:27 GMT

hi sven

You can see in table KNVH the field HZUOR. In this field it's the hierarchy level. Or you can in qlikview call the function BAPI_CUSTOMER_GET_CHILDREN .This Function, or BAPI, return a table with all the hierarchy per a customer number.

serge

SAP: KNVH Customer Hierarchy Table

Fri, 30 Oct 2009 18:35:24 GMT

Thanks,

I'll try this sugestion

SAP: KNVH Customer Hierarchy Table

Tue, 08 Dec 2009 01:37:26 GMT

Hi Sven,

Would you have an example of how to call the function. I am new to Qlikview and SAP.

Any help would be greatly appreciated.

Regards

Conor

AW:SAP: KNVH Customer Hierarchy Table

skn — Tue, 08 Dec 2009 02:57:57 GMT

...

KundenHier:
hierarchy (KUNNR, HKUNNR, CustomerName,, CustomerName,Path,'|') load
*
resident KNVH;

SAP: KNVH Customer Hierarchy Table

Tue, 08 Dec 2009 15:49:53 GMT

Hi Conor,

It was no succes for me with calling the function. But there is a good functionality in QV which can help you.

Here's an example of how I build a hierarchy. This will certainly work.

ProductHierarchy:

Hierarchy

CategoryID

CategoryName,

ParentCategoryID

FROM

;

ProductBelongsTo:

HierarchyBelongsTo

CategoryID

CategoryName as Name,

ParentCategoryID

RESIDENT

ProductHierarchy;

Hope to help you with this.

Sven

(CategoryID, ParentCategoryID, Name, CategoryTreeID, CategoryTree)

LOAD

D:\MYDOCS\Projects (CategoryID, ParentCategoryID, CategoryName)

LOAD

SAP: KNVH Customer Hierarchy Table

mmichalke — Fri, 02 Dec 2011 19:49:40 GMT

Hey all,

can somebody explain hot to call bapi from qlikview or even provide a sample code ?

That would be great !

Cheers,

Moritz