queryviz
tables/relationship path
open in builder
T052
ZTERM
BSID
KUNNR
KNA1
KUNNR
KNVV

KNVV

customer master sales data
sd22f · 4k · 2r

fields (22)

fieldtypelengthkeydescription
KUNNRchar10pkcustomer number
SPARTchar2pkdivision
VKORGchar4pksales organization
VTWEGchar2pkdistribution channel
ANTLFnumc2maximum number of partial deliveries allowed
AUFSDchar2order block for sales area (block code preventing new orders)
BZIRKchar6sales district
FAKSDchar2billing block for sales area
INCO1char3incoterms part 1
INCO2char28incoterms part 2 (named place)
KALKSchar1pricing procedure determination (pricing group for sales area)
KDGRPchar2customer group (e.g., 01=wholesaler, 02=retailer)
KONDAchar2price group (customer price group for pricing conditions)
KONDMchar2customer material pricing group
KTGRDchar2account assignment group for customer (revenue account determination)
LIFSDchar2delivery block for sales area
LPRIOnumc2delivery priority (1=high, 5=normal, 9=low)
VKBURchar4sales office
VKGRPchar3sales group
VSBEDchar2shipping conditions (01=standard, 02=express, etc.)
WAERScuky5currency for sales area (default document currency)
ZTERMchar4payment terms for this sales area

relationships (2)

master lookup

reference to master data

references
KNA1
KUNNRKUNNR
N:1
referenced by
KNA1
KUNNRKUNNR
1:N
queryviz.iobuy me a coffee
s/4 migrationpricingcompareaboutcontactprivacyterms