KNVV

Transparent Table Application Table
76 Fields 21 CDS Views

Customer Master Sales Data

KNVV is an SAP database table in S/4HANA. Customer Master Sales Data. It contains 76 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
/SCMTMS/CV_SupplCustOrg view left_outer View to get supplier and cust org data
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
Arun_I_Sto_Reqmt view left_outer STO selection for Normal mode
ARUN_I_STO_REQMT_PREV view left_outer STO selection from Preview table
Arun_Reqsrt_Mm view left_outer Requirement sorting - MM
Arun_Reqsrt_Sd view left_outer Requirement sorting - SD
Arun_So_Reqmt view left_outer Sales Order Requirement
Arun_Sto_Reqmt view left_outer Stock Transport Order Requirement
E_BPSALESAREA_D view from EXTENSION Extensibility BP Sales Area Core
EWA_ALY_I_CRV view inner
EWA_ALY_P_CRK view from
FNDEI_KNVV_BLOCKINGINFO view from Blocking View for table KNVV
FNDEI_KNVV_FILTER view from Filter View for table KNVV
I_CustomerSalesArea view from BASIC Customer Sales Area
I_RFM_CustomerSalesArea view from BASIC Customer Sales Area
I_SupDmndSalesArea view from BASIC Basic View for STO
P_CustomerOrder view inner BASIC
rfm_mm_seasons_basic_view view left_outer RFM Stock Transport Seasons Basic View
rfm_psst_so_redet view inner PSST - SO redetermination
VC_INTEGRATION_KNVV view from Extraction for KNVV

Fields (76)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY kunnr kunnr Customer
KEY vkorg vkorg Sales Org.
KEY vtweg vtweg Distr. Channel
KEY spart spart Division
ernam ernam Created By
erdat erdat Created On
begru begru AuthorizGroup
loevm loevm_v Del.ID SlsArea
versg stgku Cust.Stats.Grp
aufsd aufsd_v Ord.blk:sls ar.
kalks kalks Cust.Pric.Proc.
kdgrp kdgrp Customer Group
bzirk bzirk Sales District
konda konda CustPrice Group
pltyp pltyp Price List Tp.
awahr awahr Order Probab.
inco1 inco1 Incoterms
inco2 inco2 Incoterms 2
lifsd lifsd_v DelBlckSalesAr.
autlf autlf Complete Dlv.
antlf antlf Max.Part.Deliv.
kztlf kztlf Part.dlv./item
kzazu kzazu_d Order Combinat.
chspl chspl Batch split
lprio lprio Delivery Prior.
eikto eikto Acct at Cust.
vsbed vsbed Shipping Conditions
faksd faksd_v BBlock for SlsA
mrnkz mrnkz Man.Inv.Maint.
perfk perfk Invoicing Dates
perrl perrl Inv.List Sched.
kvakz kvakz Cost estimate
kvawt kvawt Max.cost estim.
waers waers_v02d Currency
klabc klabc ABC class
ktgrd ktgrd AccAssmtGrpCust
zterm dzterm Pyt Terms
vwerk dwerk_ext Deliver.Plant
vkgrp vkgrp Sales Group
vkbur vkbur Sales Office
vsort vsort Item proposal
kvgr1 kvgr1 Customer Grp 1
kvgr2 kvgr2 Customer Grp 2
kvgr3 kvgr3 Customer Grp 3
kvgr4 kvgr4 Customer Grp 4
kvgr5 kvgr5 Customer Grp 5
bokre bokre Rebate
boidt boidt Rebate index
kurst kurst Exch. Rate Type
prfre prfre Price determin.
prat1 kuat1 Product attr.1
prat2 kuat2 Product attr.2
prat3 kuat3 Product attr.3
prat4 kuat4 Product attr.4
prat5 kuat5 Product attr.5
prat6 kuat6 Prod.attribute6
prat7 kuat7 Product attr.7
prat8 kuat8 Prod.attribute8
prat9 kuat9 Product attr.9
prata kuata Prd.attribute10
kabss kabssch_cm Paym.guar.proc.
kkber kkber Cred.Contr.Area
cassd cassd_v Sales Block
rdoff rdoff Rounding off
agrel agrel Settlem. Mgmt.
megru megru UoM Group
uebto uebto Overdeliv. Tol.
untto untto Underdel. Tol.
uebtk uebtk_v Unlimited Tol.
pvksm pvksm PP cust. proc.
podkz podkz POD-relevant
podtg podtg POD timeframe
blind blind_sd Document Index
carrier_notif /spe/carrier_notif Carrier Notification
cvp_xblck_v cvp_xblck Purpose Completed

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Customer Master Sales Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVV (
    MANDT,          -- Client [mandt]
    KUNNR,          -- Customer [kunnr]
    VKORG,          -- Sales Org. [vkorg]
    VTWEG,          -- Distr. Channel [vtweg]
    SPART,          -- Division [spart]
    ERNAM,          -- Created By [ernam]
    ERDAT,          -- Created On [erdat]
    BEGRU,          -- AuthorizGroup [begru]
    LOEVM,          -- Del.ID SlsArea [loevm_v]
    VERSG,          -- Cust.Stats.Grp [stgku]
    AUFSD,          -- Ord.blk:sls ar. [aufsd_v]
    KALKS,          -- Cust.Pric.Proc. [kalks]
    KDGRP,          -- Customer Group [kdgrp]
    BZIRK,          -- Sales District [bzirk]
    KONDA,          -- CustPrice Group [konda]
    PLTYP,          -- Price List Tp. [pltyp]
    AWAHR,          -- Order Probab. [awahr]
    INCO1,          -- Incoterms [inco1]
    INCO2,          -- Incoterms 2 [inco2]
    LIFSD,          -- DelBlckSalesAr. [lifsd_v]
    AUTLF,          -- Complete Dlv. [autlf]
    ANTLF,          -- Max.Part.Deliv. [antlf]
    KZTLF,          -- Part.dlv./item [kztlf]
    KZAZU,          -- Order Combinat. [kzazu_d]
    CHSPL,          -- Batch split [chspl]
    LPRIO,          -- Delivery Prior. [lprio]
    EIKTO,          -- Acct at Cust. [eikto]
    VSBED,          -- Shipping Conditions [vsbed]
    FAKSD,          -- BBlock for SlsA [faksd_v]
    MRNKZ,          -- Man.Inv.Maint. [mrnkz]
    PERFK,          -- Invoicing Dates [perfk]
    PERRL,          -- Inv.List Sched. [perrl]
    KVAKZ,          -- Cost estimate [kvakz]
    KVAWT,          -- Max.cost estim. [kvawt]
    WAERS,          -- Currency [waers_v02d]
    KLABC,          -- ABC class [klabc]
    KTGRD,          -- AccAssmtGrpCust [ktgrd]
    ZTERM,          -- Pyt Terms [dzterm]
    VWERK,          -- Deliver.Plant [dwerk_ext]
    VKGRP,          -- Sales Group [vkgrp]
    VKBUR,          -- Sales Office [vkbur]
    VSORT,          -- Item proposal [vsort]
    KVGR1,          -- Customer Grp 1 [kvgr1]
    KVGR2,          -- Customer Grp 2 [kvgr2]
    KVGR3,          -- Customer Grp 3 [kvgr3]
    KVGR4,          -- Customer Grp 4 [kvgr4]
    KVGR5,          -- Customer Grp 5 [kvgr5]
    BOKRE,          -- Rebate [bokre]
    BOIDT,          -- Rebate index [boidt]
    KURST,          -- Exch. Rate Type [kurst]
    PRFRE,          -- Price determin. [prfre]
    PRAT1,          -- Product attr.1 [kuat1]
    PRAT2,          -- Product attr.2 [kuat2]
    PRAT3,          -- Product attr.3 [kuat3]
    PRAT4,          -- Product attr.4 [kuat4]
    PRAT5,          -- Product attr.5 [kuat5]
    PRAT6,          -- Prod.attribute6 [kuat6]
    PRAT7,          -- Product attr.7 [kuat7]
    PRAT8,          -- Prod.attribute8 [kuat8]
    PRAT9,          -- Product attr.9 [kuat9]
    PRATA,          -- Prd.attribute10 [kuata]
    KABSS,          -- Paym.guar.proc. [kabssch_cm]
    KKBER,          -- Cred.Contr.Area [kkber]
    CASSD,          -- Sales Block [cassd_v]
    RDOFF,          -- Rounding off [rdoff]
    AGREL,          -- Settlem. Mgmt. [agrel]
    MEGRU,          -- UoM Group [megru]
    UEBTO,          -- Overdeliv. Tol. [uebto]
    UNTTO,          -- Underdel. Tol. [untto]
    UEBTK,          -- Unlimited Tol. [uebtk_v]
    PVKSM,          -- PP cust. proc. [pvksm]
    PODKZ,          -- POD-relevant [podkz]
    PODTG,          -- POD timeframe [podtg]
    BLIND,          -- Document Index [blind_sd]
    CARRIER_NOTIF,  -- Carrier Notification [/spe/carrier_notif]
    CVP_XBLCK_V,    -- Purpose Completed [cvp_xblck]
    PRIMARY KEY (MANDT, KUNNR, VKORG, VTWEG, SPART)
);

Learn More