VC_INTEGRATION_KNVV

DDL: VC_INTEGRATION_KNVV SQL: VCIKNVV Type: view Package: IPS_DATA_REPLICATION
100 Fields 1 Data Sources

Extraction for KNVV

VC_INTEGRATION_KNVV is a CDS View that provides data about "Extraction for KNVV" in SAP S/4HANA. It reads from 1 data source (knvv) and exposes 100 fields with key fields KUNNR, VKORG, VTWEG, SPART. Part of development package IPS_DATA_REPLICATION.

Data Sources (1)

SourceAliasJoin Type
knvv knvv from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName VCIKNVV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Extraction for KNVV view

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY KUNNR kunnr Stock customer
KEY VKORG vkorg SD Sales Org.
KEY VTWEG vtweg RefDistCh-Cust/Mat.
KEY SPART spart Source supplier
ERDAT erdat Entered On
BEGRU begru AuthorizGroup
LOEVM loevm End Contract
VERSG versg Matl stats grp
AUFSD aufsd Order block
KALKS kalks Cust.Pric.Proc.
KDGRP kdgrp Customer group
BZIRK bzirk Sales District
KONDA konda CustPrice Group
PLTYP pltyp Price List Tp.
AWAHR awahr Probability
INCO1 inco1 Incoterms
INCO2 inco2 Incoterms 2
LIFSD lifsd Delivery block
AUTLF autlf Complete Dlv.
ANTLF antlf Max.Part.Deliv.
KZTLF kztlf Part.dlv./item
KZAZU kzazu Order Combinat.
CHSPL chspl Batch split
LPRIO lprio Delivery Prior.
EIKTO eikto Acct w/ vendor
VSBED vsbed Shipping Conditions
FAKSD faksd Billing block
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 Transaction Currency
KLABC klabc ABC class
KTGRD ktgrd AccAssmtGrpCust
ZTERM zterm Terms of Payment
VWERK vwerk 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 Fix.rate type (EMU)
PRFRE prfre Price determin.
PRAT1 prat1 Product attr.1
PRAT2 prat2 Product attr.2
PRAT3 prat3 Product attr.3
PRAT4 prat4 Product attr.4
PRAT5 prat5 Product attr.5
PRAT6 prat6 Prod.attribute6
PRAT7 prat7 Product attr.7
PRAT8 prat8 Prod.attribute8
PRAT9 prat9 Product attr.9
PRATA prata Prd.attribute10
KABSS kabss Paym.guar.proc.
KKBER kkber Cred.Contr.Area
CASSD cassd Sales block
RDOFF rdoff Rounding off
AGREL agrel Settlem. Mgmt.
MEGRU megru UoM Group
UEBTO uebto Overrun Tol.
UNTTO untto Underdel. Tol.
UEBTK uebtk Unlimited Tol.
PVKSM pvksm PP cust. proc.
PODKZ podkz POD-relevant
PODTG podtg POD timeframe
BLIND blind Lock indicator
CARRIER_NOTIF carrier_notif Carrier Notification
CVP_XBLCK_V cvp_xblck_v 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 status_obj_guid GUID
BILLPLAN_PROC billplan_proc Bill.PlanProc
/BEV1/EMLGPFAND /bev1/emlgpfand
/BEV1/EMLGFORTS /bev1/emlgforts
J_1NBOESL j_1nboesl 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 VAS Cust. Group
FSH_GRSGY fsh_grsgy Group Strategy
FSH_SS fsh_ss Sched. Strat.
FSH_FRATE fsh_frate Fill Rate %
FSH_FRATE_AGG_LEVEL fsh_frate_agg_level Aggregation Level
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 interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view VC_INTEGRATION_KNVV.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: VCIKNVV

CREATE VIEW VC_INTEGRATION_KNVV AS
SELECT
  KUNNR,
  VKORG,
  VTWEG,
  SPART,
  ERDAT,
  BEGRU,
  LOEVM,
  VERSG,
  AUFSD,
  KALKS,
  KDGRP,
  BZIRK,
  KONDA,
  PLTYP,
  AWAHR,
  INCO1,
  INCO2,
  LIFSD,
  AUTLF,
  ANTLF,
  KZTLF,
  KZAZU,
  CHSPL,
  LPRIO,
  EIKTO,
  VSBED,
  FAKSD,
  MRNKZ,
  PERFK,
  PERRL,
  KVAKZ,
  KVAWT,
  WAERS,
  KLABC,
  KTGRD,
  ZTERM,
  VWERK,
  VKGRP,
  VKBUR,
  VSORT,
  KVGR1,
  KVGR2,
  KVGR3,
  KVGR4,
  KVGR5,
  BOKRE,
  BOIDT,
  KURST,
  PRFRE,
  PRAT1,
  PRAT2,
  PRAT3,
  PRAT4,
  PRAT5,
  PRAT6,
  PRAT7,
  PRAT8,
  PRAT9,
  PRATA,
  KABSS,
  KKBER,
  CASSD,
  RDOFF,
  AGREL,
  MEGRU,
  UEBTO,
  UNTTO,
  UEBTK,
  PVKSM,
  PODKZ,
  PODTG,
  BLIND,
  CARRIER_NOTIF,
  CVP_XBLCK_V,
  INCOV,
  INCO2_L,
  INCO3_L,
  KNVV_EEW_CONTACT,
  STATUS_OBJ_GUID,
  BILLPLAN_PROC,
  /BEV1/EMLGPFAND,
  /BEV1/EMLGFORTS,
  J_1NBOESL,
  FSH_KVGR6,
  FSH_KVGR7,
  FSH_KVGR8,
  FSH_KVGR9,
  FSH_KVGR10,
  FSH_GRREG,
  FSH_RESGY,
  FSH_SC_CID,
  FSH_VAS_DETC,
  FSH_VAS_CG,
  FSH_GRSGY,
  FSH_SS,
  FSH_FRATE,
  FSH_FRATE_AGG_LEVEL,
  FSH_MSOPID,
  RFM_PSST_RULE,
  RFM_PSST_EXCLUDE
FROM knvv
;

Learn More