KNVV

Customer Master Sales Data | #masterdata | Component: Customer Master
Column Name Description
MANDT FK Client
KUNNR FK Customer Number
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
Column Name Description
💲 Currency Key (T001.WAERS):
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
ERNAM Name of Person Responsible for Creating the Object USNAM
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
INCO2_KEY Incoterm Location 1 - Place of Destination /SCMTMS/LOCUUID
INCO3_KEY Incoterm Location 2 - Place of Delivery /SCMTMS/LOCUUID
INCO4_KEY Incoterm - Deviating Place of Destination /SCMTMS/LOCUUID
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
KNVV_ADDR_EEW_CUST Customer sales addr. dep. extensibility KNVV_ADDR_EEW_CUST
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
  • ?
  • KNVV.AUFSD == TVAST.AUFSP
  • KNVV.MANDT == TVAST.MANDT
  • KNVV.[column in domain "SPRAS"] == TVAST.SPRAS
Sales District
  • KNVV.MANDT == T171.MANDT
  • KNVV.BZIRK == T171.BZIRK
Billing block for customer (sales and distribution)
  • KNVV.MANDT == TVFS.MANDT
  • KNVV.FAKSD == TVFS.FAKSP
Grouping Rule
ARUN Grouping Strategy
  • ARUN Grouping Strategy
  • Client
Customer Group 10
  • Sales Organization
  • Client
  • Customer Group 10
Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
Customer Group 7
  • Sales Organization
  • Customer Group 7
Customer Group 8
  • Customer Group 8
  • Client
  • Sales Organization
Customer Group 9
  • Sales Organization
  • Client
  • Customer Group 9
Distribution Center of Customer
  • KNVV.MANDT == KNA1.MANDT
  • KNVV.FSH_MSOCDC == KNA1.KUNNR
Release Strategy
  • Release Strategy
  • Client
Customer/Supplier Identifier
  • ?
  • Customer/Supplier Identifier
Order Scheduling Strategy
  • ?
  • Order Scheduling Strategy
  • KNVV.MANDT == FSH_OSS.MANDT
  • KNVV.[column in domain "FSH_APPLICATION"] == FSH_OSS.FSH_APPLICATION
  • KNVV.FSH_SS == FSH_OSS.FSH_SS
Value-Added Services Customer Group
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • KNVV.INCO1 == TINC.INCO1
  • KNVV.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • KNVV.INCOV == TINCV.INCOV
  • KNVV.MANDT == TINCV.MANDT
Exchange Key for NF Processing
Customer payment guarantee procedure
  • Customer payment guarantee procedure
  • Client
  • KNVV.KABSS == T691P.KABSS
  • KNVV.MANDT == T691P.MANDT
Customer Classification for Pricing Procedure Determination
  • Customer Classification for Pricing Procedure Determination
  • Client
  • KNVV.KALKS == TVKD.KALKS
  • KNVV.MANDT == TVKD.MANDT
Customer Group
  • Customer Group
  • Client
  • KNVV.KDGRP == T151.KDGRP
  • KNVV.MANDT == T151.MANDT
Credit control area
  • KNVV.MANDT == T014.MANDT
  • KNVV.KKBER == T014.KKBER
Customer Price Group
  • Customer Price Group
  • Client
  • KNVV.KONDA == T188.KONDA
  • KNVV.MANDT == T188.MANDT
Account Assignment Group for this Customer
  • KNVV.MANDT == TVKT.MANDT
  • KNVV.KTGRD == TVKT.KTGRD
Customer Number
  • KNVV.MANDT == KNA1.MANDT
  • KNVV.KUNNR == KNA1.KUNNR
Exchange Rate Type
  • KNVV.MANDT == TCURV.MANDT
  • KNVV.KURST == TCURV.KURST
Customer Group 1
  • KNVV.MANDT == TVV1.MANDT
  • KNVV.KVGR1 == TVV1.KVGR1
Customer Group 2
  • KNVV.MANDT == TVV2.MANDT
  • KNVV.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • KNVV.KVGR3 == TVV3.KVGR3
  • KNVV.MANDT == TVV3.MANDT
Customer Group 4
  • KNVV.MANDT == TVV4.MANDT
  • KNVV.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • KNVV.KVGR5 == TVV5.KVGR5
  • KNVV.MANDT == TVV5.MANDT
Customer delivery block (sales area)
  • KNVV.MANDT == TVLS.MANDT
  • KNVV.LIFSD == TVLS.LIFSP
Delivery Priority
  • KNVV.MANDT == TPRIO.MANDT
  • KNVV.LPRIO == TPRIO.LPRIO
Client KNVV.MANDT == T000.MANDT
Invoice Dates (Calendar Identification) KNVV.PERFK == TFACD.IDENT
Invoice List Schedule (calendar identification) KNVV.PERRL == TFACD.IDENT
Price List Type
  • KNVV.MANDT == T189.MANDT
  • KNVV.PLTYP == T189.PLTYP
Customer procedure for product proposal
  • Customer procedure for product proposal
  • Client
  • KNVV.PVKSM == TPVD.PVKSM
  • KNVV.MANDT == TPVD.MANDT
Division
  • KNVV.MANDT == TSPA.MANDT
  • KNVV.SPART == TSPA.SPART
Customer Statistics Group
  • Customer Statistics Group
  • Client
  • KNVV.VERSG == TVSD.STGKU
  • KNVV.MANDT == TVSD.MANDT
Sales office
  • Sales office
  • Client
  • KNVV.VKBUR == TVBUR.VKBUR
  • KNVV.MANDT == TVBUR.MANDT
Sales group
  • Sales group
  • Sales office
  • KNVV.MANDT == TVBVK.MANDT
  • KNVV.VKGRP == TVBVK.VKGRP
  • KNVV.VKBUR == TVBVK.VKBUR
Sales Organization
  • KNVV.MANDT == TVKO.MANDT
  • KNVV.VKORG == TVKO.VKORG
Shipping Conditions
  • KNVV.MANDT == TVSB.MANDT
  • KNVV.VSBED == TVSB.VSBED
Distribution Channel
  • Distribution Channel
  • Client
  • KNVV.VTWEG == TVTW.VTWEG
  • KNVV.MANDT == TVTW.MANDT
Delivering Plant (Own or External)
  • Sales Organization
  • Distribution Channel
  • Delivering Plant (Own or External)
  • KNVV.MANDT == TVKWZ.MANDT
  • KNVV.VKORG == TVKWZ.VKORG
  • KNVV.VTWEG == TVKWZ.VTWEG
  • KNVV.VWERK == TVKWZ.WERKS
Currency
  • KNVV.MANDT == TCURC.MANDT
  • KNVV.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Units of Measure Group Check
  • Unit of Measure Group
  • ?
  • KNVV.MANDT == TWMEG.MANDT
  • KNVV.MEGRU == TWMEG.MEGRU
  • KNVV.[column in domain "LRMEI"] == TWMEG.MEINS