KNVV_PRC

Transparent Table Application Table
111 Fields 2 CDS Views

Master Data Consolidation: Process Table for KNVV

KNVV_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for KNVV. It contains 111 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPCustomerSalesAreaProcess view_entity from EXTENSION Extensibility for KNVV PRC - Extension
I_BPCustomerSalesAreaProcess view_entity from BASIC BP Customer Sales Area Data

Fields (111)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY vkorg VKORG Sales Org.
KEY vtweg VTWEG Distr. Channel
KEY spart SPART Division
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
kunnr KUNNR Customer
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
knvv_eew_contact KNVV_EEW_CONTACT Data element Extension for Contact
status_obj_guid GUID GUID
billplan_proc CRMT_BILLPLAN_PROC Bill.PlanProc
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
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
j_1nboesl /NFM/BOESL Exchange Key

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.

-- Master Data Consolidation: Process Table for KNVV
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KNVV_PRC (
    MANDT,                     -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    VKORG,                     -- Sales Org. [VKORG]
    VTWEG,                     -- Distr. Channel [VTWEG]
    SPART,                     -- Division [SPART]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    KUNNR,                     -- Customer [KUNNR]
    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]
    KNVV_EEW_CONTACT,          -- Data element Extension for Contact [KNVV_EEW_CONTACT]
    STATUS_OBJ_GUID,           -- GUID [GUID]
    BILLPLAN_PROC,             -- Bill.PlanProc [CRMT_BILLPLAN_PROC]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    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]
    J_1NBOESL,                 -- Exchange Key [/NFM/BOESL]
    PRIMARY KEY (MANDT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, VKORG, VTWEG, SPART, ASSIGNMENT_ID)
);

Learn More