VC_INTEGRATION_KNVV

Extraction for KNVV | view: VCIKNVV | Extraction: Full or Incremental | Component: Configuration and Pricing Services
Tables used: KNVV
Column Name Description
KUNNR FK Customer Number
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
Column Name Description
KVAWT Value limit for cost estimate (inactive)
Column Name Description
Column Name Description
ERDAT Date on which the record was created
BOIDT Start of validity per.for the rebate index for the customer
Column Name Description
LOEVM Deletion flag for customer (sales level) Show values
AWAHR Order Probability of the Item Show values
AUTLF Complete Delivery Defined for Each Sales Order? Show values
KZTLF Partial delivery at item level Show values
KZAZU Order Combination Indicator Show values
CHSPL Batch split allowed Show values
MRNKZ Manual Invoice Maintenance Show values
KVAKZ Cost estimate indicator (inactive) Show values
BOKRE Indicator: Customer Is Rebate-Relevant Show values
PRFRE Relevant for price determination ID Show values
PRAT1 ID for product attribute 1 Show values
PRAT2 ID for product attribute 2 Show values
PRAT3 ID for product attribute 3 Show values
PRAT4 ID for product attribute 4 Show values
PRAT5 ID for product attribute 5 Show values
PRAT6 ID for product attribute 6 Show values
PRAT7 ID for product attribute 7 Show values
PRAT8 ID for product attribute 8 Show values
PRAT9 ID for product attribute 9 Show values
PRATA ID for product attribute 10 Show values
RDOFF Switch off rounding? Show values
AGREL Indicator: Relevant for Settlement Management Show values
UEBTK Unlimited Overdelivery Allowed Show values
PODKZ Relevant for POD processing Show values
BLIND Index Structure Active for Subsequent Settlement Show values
CARRIER_NOTIF Carrier is to be notified Show values
CVP_XBLCK_V Business Purpose Completed Flag Show values
/BEV1/EMLGPFAND Deposit on Empties Show values
/BEV1/EMLGFORTS Indicator for Empties Update Show values
FSH_VAS_DETC VAS Determination Mode Show values
FSH_FRATE Fill Rate % Show values
FSH_FRATE_AGG_LEVEL Fill Rate Aggregation Level Show values
RFM_PSST_EXCLUDE Exclude from PSST Grouping Rule Determination Show values
Column Name Description Domain name
BEGRU Authorization Group BEGRU
INCO2 Incoterms (Part 2) INCO2
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF
EIKTO Shipper's (Our) Account Number at the Customer or Vendor CHAR12
KLABC Customer classification (ABC analysis) KLABC
ZTERM Terms of payment key ZTERM
VSORT Item proposal VBELN
CASSD Sales Block for Customer (Sales Area) CASSP
UEBTO Overdelivery Tolerance PRZ21
UNTTO Underdelivery Tolerance PRZ21
PODTG Timeframe for Confirmation of POD TSTRDURAG
INCO2_L Incoterms Location 1 INCO_L
INCO3_L Incoterms Location 2 INCO_L
KNVV_EEW_CONTACT Data element Extension for Contact KNVV_EEW_CONTACT
STATUS_OBJ_GUID Globally Unique Identifier
BILLPLAN_PROC Billing Plan Procedure CRM_BILLPLAN_PROC
FSH_MSOPID Customer Identification in the Partner System CHAR20
RFM_PSST_RULE PSST Grouping Rule RFM_PSST_RULE
Master Data Relations Join Conditions
Customer order block (sales area)
  • ?
  • Customer order block (sales area)
  • Client
  • VC_INTEGRATION_KNVV.[column in domain "SPRAS"] == TVAST.SPRAS
  • VC_INTEGRATION_KNVV.AUFSD == TVAST.AUFSP
  • VC_INTEGRATION_KNVV.MANDT == TVAST.MANDT
Sales District
  • Sales District
  • Client
  • VC_INTEGRATION_KNVV.BZIRK == T171.BZIRK
  • VC_INTEGRATION_KNVV.MANDT == T171.MANDT
Billing block for customer (sales and distribution)
  • Billing block for customer (sales and distribution)
  • Client
  • VC_INTEGRATION_KNVV.FAKSD == TVFS.FAKSP
  • VC_INTEGRATION_KNVV.MANDT == TVFS.MANDT
Grouping Rule
  • Grouping Rule
  • Client
ARUN Grouping Strategy
  • ARUN Grouping Strategy
  • Client
  • VC_INTEGRATION_KNVV.FSH_GRSGY == FSH_GRSG_W.FSH_GRSGY
  • VC_INTEGRATION_KNVV.MANDT == FSH_GRSG_W.MANDT
Customer Group 10
  • Sales Organization
  • Customer Group 10
  • Client
  • VC_INTEGRATION_KNVV.VKORG == FSH_TVV10.VKORG
  • VC_INTEGRATION_KNVV.FSH_KVGR10 == FSH_TVV10.KVGR10
  • VC_INTEGRATION_KNVV.MANDT == FSH_TVV10.MANDT
Customer Group 6
  • Sales Organization
  • Customer Group 6
  • Client
  • VC_INTEGRATION_KNVV.VKORG == FSH_TVV6.VKORG
  • VC_INTEGRATION_KNVV.FSH_KVGR6 == FSH_TVV6.KVGR6
  • VC_INTEGRATION_KNVV.MANDT == FSH_TVV6.MANDT
Customer Group 7
  • Customer Group 7
  • Sales Organization
  • Client
  • VC_INTEGRATION_KNVV.FSH_KVGR7 == FSH_TVV7.KVGR7
  • VC_INTEGRATION_KNVV.VKORG == FSH_TVV7.VKORG
  • VC_INTEGRATION_KNVV.MANDT == FSH_TVV7.MANDT
Customer Group 8
  • Sales Organization
  • Customer Group 8
  • Client
  • VC_INTEGRATION_KNVV.VKORG == FSH_TVV8.VKORG
  • VC_INTEGRATION_KNVV.FSH_KVGR8 == FSH_TVV8.KVGR8
  • VC_INTEGRATION_KNVV.MANDT == FSH_TVV8.MANDT
Customer Group 9
  • Customer Group 9
  • Sales Organization
  • Client
  • VC_INTEGRATION_KNVV.FSH_KVGR9 == FSH_TVV9.KVGR9
  • VC_INTEGRATION_KNVV.VKORG == FSH_TVV9.VKORG
  • VC_INTEGRATION_KNVV.MANDT == FSH_TVV9.MANDT
Release Strategy
  • Release Strategy
  • Client
  • VC_INTEGRATION_KNVV.FSH_RESGY == FSH_RESG_W.FSH_RESGY
  • VC_INTEGRATION_KNVV.MANDT == FSH_RESG_W.MANDT
Customer/Supplier Identifier
  • Customer/Supplier Identifier
  • ?
  • Client
  • VC_INTEGRATION_KNVV.FSH_SC_CID == FSH_SC_VCIDS.FSH_SC_ID
  • VC_INTEGRATION_KNVV.[column in domain "FSH_SC_IDT"] == FSH_SC_VCIDS.FSH_SC_IDT
  • VC_INTEGRATION_KNVV.MANDT == FSH_SC_VCIDS.MANDT
Order Scheduling Strategy
  • Order Scheduling Strategy
  • ?
  • Client
  • VC_INTEGRATION_KNVV.FSH_SS == FSH_OSS.FSH_SS
  • VC_INTEGRATION_KNVV.[column in domain "FSH_APPLICATION"] == FSH_OSS.FSH_APPLICATION
  • VC_INTEGRATION_KNVV.MANDT == FSH_OSS.MANDT
Value-Added Services Customer Group
  • Value-Added Services Customer Group
  • Client
  • VC_INTEGRATION_KNVV.FSH_VAS_CG == FSH_VAS_CG.FSH_VAS_CG
  • VC_INTEGRATION_KNVV.MANDT == FSH_VAS_CG.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • VC_INTEGRATION_KNVV.INCO1 == TINC.INCO1
  • VC_INTEGRATION_KNVV.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • VC_INTEGRATION_KNVV.INCOV == TINCV.INCOV
  • VC_INTEGRATION_KNVV.MANDT == TINCV.MANDT
Exchange Key for NF Processing
  • Exchange Key for NF Processing
  • Client
Customer payment guarantee procedure
  • Customer payment guarantee procedure
  • Client
  • VC_INTEGRATION_KNVV.KABSS == T691P.KABSS
  • VC_INTEGRATION_KNVV.MANDT == T691P.MANDT
Customer Classification for Pricing Procedure Determination
  • Customer Classification for Pricing Procedure Determination
  • Client
  • VC_INTEGRATION_KNVV.KALKS == TVKD.KALKS
  • VC_INTEGRATION_KNVV.MANDT == TVKD.MANDT
Customer Group
  • Customer Group
  • Client
  • VC_INTEGRATION_KNVV.KDGRP == T151.KDGRP
  • VC_INTEGRATION_KNVV.MANDT == T151.MANDT
Credit control area
  • Credit control area
  • Client
  • VC_INTEGRATION_KNVV.KKBER == T014.KKBER
  • VC_INTEGRATION_KNVV.MANDT == T014.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • VC_INTEGRATION_KNVV.KONDA == T188.KONDA
  • VC_INTEGRATION_KNVV.MANDT == T188.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • VC_INTEGRATION_KNVV.KTGRD == TVKT.KTGRD
  • VC_INTEGRATION_KNVV.MANDT == TVKT.MANDT
Customer Number
  • Customer Number
  • Client
  • VC_INTEGRATION_KNVV.KUNNR == KNA1.KUNNR
  • VC_INTEGRATION_KNVV.MANDT == KNA1.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • VC_INTEGRATION_KNVV.KURST == TCURV.KURST
  • VC_INTEGRATION_KNVV.MANDT == TCURV.MANDT
Customer Group 1
  • Customer Group 1
  • Client
  • VC_INTEGRATION_KNVV.KVGR1 == TVV1.KVGR1
  • VC_INTEGRATION_KNVV.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • VC_INTEGRATION_KNVV.KVGR2 == TVV2.KVGR2
  • VC_INTEGRATION_KNVV.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • VC_INTEGRATION_KNVV.KVGR3 == TVV3.KVGR3
  • VC_INTEGRATION_KNVV.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • VC_INTEGRATION_KNVV.KVGR4 == TVV4.KVGR4
  • VC_INTEGRATION_KNVV.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • VC_INTEGRATION_KNVV.KVGR5 == TVV5.KVGR5
  • VC_INTEGRATION_KNVV.MANDT == TVV5.MANDT
Customer delivery block (sales area)
  • Customer delivery block (sales area)
  • Client
  • VC_INTEGRATION_KNVV.LIFSD == TVLS.LIFSP
  • VC_INTEGRATION_KNVV.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • VC_INTEGRATION_KNVV.LPRIO == TPRIO.LPRIO
  • VC_INTEGRATION_KNVV.MANDT == TPRIO.MANDT
Invoice Dates (Calendar Identification) VC_INTEGRATION_KNVV.PERFK == TFACD.IDENT
Invoice List Schedule (calendar identification) VC_INTEGRATION_KNVV.PERRL == TFACD.IDENT
Price List Type
  • Price List Type
  • Client
  • VC_INTEGRATION_KNVV.PLTYP == T189.PLTYP
  • VC_INTEGRATION_KNVV.MANDT == T189.MANDT
Customer procedure for product proposal
  • Customer procedure for product proposal
  • Client
  • VC_INTEGRATION_KNVV.PVKSM == TPVD.PVKSM
  • VC_INTEGRATION_KNVV.MANDT == TPVD.MANDT
Division
  • Division
  • Client
  • VC_INTEGRATION_KNVV.SPART == TSPA.SPART
  • VC_INTEGRATION_KNVV.MANDT == TSPA.MANDT
Customer Statistics Group
  • Customer Statistics Group
  • Client
  • VC_INTEGRATION_KNVV.VERSG == TVSD.STGKU
  • VC_INTEGRATION_KNVV.MANDT == TVSD.MANDT
Sales office
  • Sales office
  • Client
  • VC_INTEGRATION_KNVV.VKBUR == TVBUR.VKBUR
  • VC_INTEGRATION_KNVV.MANDT == TVBUR.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • VC_INTEGRATION_KNVV.VKBUR == TVBVK.VKBUR
  • VC_INTEGRATION_KNVV.VKGRP == TVBVK.VKGRP
  • VC_INTEGRATION_KNVV.MANDT == TVBVK.MANDT
Sales Organization
  • Sales Organization
  • Client
  • VC_INTEGRATION_KNVV.VKORG == TVKO.VKORG
  • VC_INTEGRATION_KNVV.MANDT == TVKO.MANDT
Shipping Conditions
  • Shipping Conditions
  • Client
  • VC_INTEGRATION_KNVV.VSBED == TVSB.VSBED
  • VC_INTEGRATION_KNVV.MANDT == TVSB.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • VC_INTEGRATION_KNVV.VTWEG == TVTW.VTWEG
  • VC_INTEGRATION_KNVV.MANDT == TVTW.MANDT
Delivering Plant (Own or External)
  • Sales Organization
  • Distribution Channel
  • Delivering Plant (Own or External)
  • Client
  • VC_INTEGRATION_KNVV.VKORG == TVKWZ.VKORG
  • VC_INTEGRATION_KNVV.VTWEG == TVKWZ.VTWEG
  • VC_INTEGRATION_KNVV.VWERK == TVKWZ.WERKS
  • VC_INTEGRATION_KNVV.MANDT == TVKWZ.MANDT
Currency
  • Currency
  • Client
  • VC_INTEGRATION_KNVV.WAERS == TCURC.WAERS
  • VC_INTEGRATION_KNVV.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Units of Measure Group Check
  • ?
  • Client
  • Unit of Measure Group
  • VC_INTEGRATION_KNVV.[column in domain "LRMEI"] == TWMEG.MEINS
  • VC_INTEGRATION_KNVV.MANDT == TWMEG.MANDT
  • VC_INTEGRATION_KNVV.MEGRU == TWMEG.MEGRU