queryviz
tables/relationship path
open in builder
TSPA
SPART
KNVH

KNVH

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

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 (0)

no relationships found
queryviz.io
s/4 migrationpricingcompareaboutcontactprivacyterms