queryviz
tables/relationship path
open in builder
T002
SPRAS
T001
BUKRS
VBRK
KUNAG → KUNNR
KNA1
KUNNR
KNVH

KNVH

customer hierarchy per sales area
sd15f · 6k · 4r

fields (15)

fieldtypelengthkeydescription
DATABdats8pkvalidity start date
HKUNNRchar10pkhierarchy customer number (the parent/node in the hierarchy)
MANDTclnt3pkclient
SPARTchar2pkdivision
VKORGchar4pksales organization
VTWEGchar2pkdistribution channel
BOKREchar1indicator: customer is rebate-relevant
DATBIdats8validity end date
GRESSIONnumc2hierarchy level
GRPNOnumc3number of the routine used for copying
HITYPchar1hierarchy type (a=price-relevant, b=stats only, etc.)
HSPARTchar2higher-level division
HVKORGchar4higher-level sales organization
HVTWEGchar2higher-level distribution channel
KUNNRchar10customer number (the child/leaf customer assigned to this hierarchy node)

relationships (4)

master lookup

reference to master data

references
KNA1
KUNNRKUNNR
N:1
configuration

reference to config tables

references
TSPA
SPARTSPART
N:1
TVKO
VKORGVKORG
N:1
TVTW
VTWEGVTWEG
N:1
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms