KNVV

Transparent Table Application Table
105 Fields 20 CDS Views

Customer Master Sales Data

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

CDS Views using this table (20)

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_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 (105)

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
incov INCOV Inco. Version
inco2_l INCO2_L Inco. Location1
inco3_l INCO3_L Inco. Location2
inco2_key /SCMTMS/INC_LOC_1_KEY Incoterm Location 1
inco3_key /SCMTMS/INC_LOC_2_KEY Incoterm Location 2
inco4_key /SCMTMS/INC_DEV_PLACE_DEST_KEY Dev. Destination
knvv_eew_contact KNVV_EEW_CONTACT Data element Extension for Contact
status_obj_guid GUID GUID
billplan_proc CRMT_BILLPLAN_PROC Bill.PlanProc
knvv_addr_eew_cust KNVV_ADDR_EEW_CUST Customer sales addr. dep. extensibility
j_1nboesl /NFM/BOESL Exchange Key
fsh_kvgr6 FSH_KVGR6 Customer Grp 6
fsh_kvgr7 FSH_KVGR7 Customer Grp 7
fsh_kvgr8 FSH_KVGR8 Customer Grp 8
fsh_kvgr9 FSH_KVGR9 Customer Grp 9
fsh_kvgr10 FSH_KVGR10 Customer Grp 10
fsh_grreg FSH_GRREG Grouping Rule
fsh_resgy FSH_RESGY Rel. Strategy
fsh_sc_cid FSH_SC_CID Cust. Sup. ID
fsh_vas_detc FSH_VAS_DETC VAS Determin. Mode
fsh_vas_cg FSH_VAS_CG_D VAS Cust. Group
fsh_grsgy FSH_GRSGY Group Strategy
fsh_ss FSH_SCH_STY Sched. Strat.
fsh_frate FSH_FRATE Fill Rate %
fsh_frate_agg_level FSH_FRATE_AGG_LEVEL Aggregation Level
fsh_msocdc FSH_MSOCDC Customer DC
fsh_msopid FSH_MSOPID CustID Partner
rfm_psst_rule RFM_PSST_RULE PSST Grouping Rule
rfm_psst_exclude RFM_PSST_EXCLUDE Exclude from PSST

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]
    INCOV,                -- Inco. Version [INCOV]
    INCO2_L,              -- Inco. Location1 [INCO2_L]
    INCO3_L,              -- Inco. Location2 [INCO3_L]
    INCO2_KEY,            -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
    INCO3_KEY,            -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
    INCO4_KEY,            -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
    KNVV_EEW_CONTACT,     -- Data element Extension for Contact [KNVV_EEW_CONTACT]
    STATUS_OBJ_GUID,      -- GUID [GUID]
    BILLPLAN_PROC,        -- Bill.PlanProc [CRMT_BILLPLAN_PROC]
    KNVV_ADDR_EEW_CUST,   -- Customer sales addr. dep. extensibility [KNVV_ADDR_EEW_CUST]
    J_1NBOESL,            -- Exchange Key [/NFM/BOESL]
    FSH_KVGR6,            -- Customer Grp 6 [FSH_KVGR6]
    FSH_KVGR7,            -- Customer Grp 7 [FSH_KVGR7]
    FSH_KVGR8,            -- Customer Grp 8 [FSH_KVGR8]
    FSH_KVGR9,            -- Customer Grp 9 [FSH_KVGR9]
    FSH_KVGR10,           -- Customer Grp 10 [FSH_KVGR10]
    FSH_GRREG,            -- Grouping Rule [FSH_GRREG]
    FSH_RESGY,            -- Rel. Strategy [FSH_RESGY]
    FSH_SC_CID,           -- Cust. Sup. ID [FSH_SC_CID]
    FSH_VAS_DETC,         -- VAS Determin. Mode [FSH_VAS_DETC]
    FSH_VAS_CG,           -- VAS Cust. Group [FSH_VAS_CG_D]
    FSH_GRSGY,            -- Group Strategy [FSH_GRSGY]
    FSH_SS,               -- Sched. Strat. [FSH_SCH_STY]
    FSH_FRATE,            -- Fill Rate % [FSH_FRATE]
    FSH_FRATE_AGG_LEVEL,  -- Aggregation Level [FSH_FRATE_AGG_LEVEL]
    FSH_MSOCDC,           -- Customer DC [FSH_MSOCDC]
    FSH_MSOPID,           -- CustID Partner [FSH_MSOPID]
    RFM_PSST_RULE,        -- PSST Grouping Rule [RFM_PSST_RULE]
    RFM_PSST_EXCLUDE,     -- Exclude from PSST [RFM_PSST_EXCLUDE]
    PRIMARY KEY (MANDT, KUNNR, VKORG, VTWEG, SPART)
);

Learn More