SAP Table KNVV
Customer Master Sales Data
Unsere Literaturempfehlung
SAP – Der technische Einstieg: SAP-Technologien und Konzepte
Sind Sie neu in der SAP-Welt und möchten schnell mitreden? Mit diesem Buch finden Sie sich erfolgreich im SAP-Umfeld zurecht! Sie steigen direkt in die Konzepte und Technologien der SAP-Software ein und lernen die unterschiedlichen Systeme und Prozesse kennen. Schritt für Schritt zeigen die Autoren Ihnen die wichtigsten technischen Aufgaben und die Zusammenhänge zwischen den Objekten. Dank der vielen Beispiele und Abbildungen finden Sie sich schnell im SAP-Umfeld zurecht und können direkt in SAP ERP oder SAP S/4HANA anfangen.
Bei amazon.de ansehen →
The table KNVV (Customer Master Sales Data) is a standard table in SAP ERP. It belongs to the package VS.
Technical Information
| Table | KNVV |
| Short Text | Customer Master Sales Data |
| Package | VS |
| Table Type | Transparent Table |
Fields for Table KNVV
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| VKORG | ✔ | Sales Organization | VKORG | CHAR | 4 | TVKO |
| VTWEG | ✔ | Distribution Channel | VTWEG | CHAR | 2 | TVTW |
| SPART | ✔ | Division | SPART | CHAR | 2 | TSPA |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | ||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | ||
| BEGRU | Authorization Group | BEGRU | CHAR | 4 | ||
| LOEVM | Deletion flag for customer (sales level) | LOEVM_V | CHAR | 1 | ||
| VERSG | Customer Statistics Group | STGKU | CHAR | 1 | TVSD | |
| AUFSD | Customer order block (sales area) | AUFSD_V | CHAR | 2 | TVAST | |
| KALKS | Pricing procedure assigned to this customer | KALKS | CHAR | 1 | TVKD | |
| KDGRP | Customer group | KDGRP | CHAR | 2 | T151 | |
| BZIRK | Sales district | BZIRK | CHAR | 6 | T171 | |
| KONDA | Price group (customer) | KONDA | CHAR | 2 | T188 | |
| PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | |
| AWAHR | Order probability of the item | AWAHR | NUMC | 3 | ||
| INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | |
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | ||
| LIFSD | Customer delivery block (sales area) | LIFSD_V | CHAR | 2 | TVLS | |
| AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | ||
| ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | ||
| KZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | ||
| KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | ||
| CHSPL | Batch split allowed | CHSPL | CHAR | 1 | ||
| LPRIO | Delivery Priority | LPRIO | NUMC | 2 | TPRIO | |
| EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | ||
| VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | |
| FAKSD | Billing block for customer (sales and distribution) | FAKSD_V | CHAR | 2 | TVFS | |
| MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | ||
| PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | |
| PERRL | Invoice list schedule (calendar identification) | PERRL | CHAR | 2 | TFACD | |
| KVAKZ | Cost estimate indicator (inactive) | KVAKZ | CHAR | 1 | ||
| KVAWT | Value limit for cost estimate (inactive) | KVAWT | CURR | 13 | ||
| WAERS | Currency | WAERS_V02D | CUKY | 5 | TCURC | |
| KLABC | Customer classification (ABC analysis) | KLABC | CHAR | 2 | ||
| KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | |
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ||
| VWERK | Delivering Plant (Own or External) | DWERK_EXT | CHAR | 4 | TVKWZ | |
| VKGRP | Sales Group | VKGRP | CHAR | 3 | TVBVK | |
| VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | |
| VSORT | Item proposal | VSORT | CHAR | 10 | VBUK | |
| KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | TVV1 | |
| KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | TVV2 | |
| KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | TVV3 | |
| KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | TVV4 | |
| KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | TVV5 | |
| BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | ||
| BOIDT | Start of validity per.for the rebate index for the customer | BOIDT | DATS | 8 | ||
| KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | |
| PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | ||
| PRAT1 | ID for product attribute 1 | KUAT1 | CHAR | 1 | ||
| PRAT2 | ID for product attribute 2 | KUAT2 | CHAR | 1 | ||
| PRAT3 | ID for product attribute 3 | KUAT3 | CHAR | 1 | ||
| PRAT4 | ID for product attribute 4 | KUAT4 | CHAR | 1 | ||
| PRAT5 | ID for product attribute 5 | KUAT5 | CHAR | 1 | ||
| PRAT6 | ID for product attribute 6 | KUAT6 | CHAR | 1 | ||
| PRAT7 | ID for product attribute 7 | KUAT7 | CHAR | 1 | ||
| PRAT8 | ID for product attribute 8 | KUAT8 | CHAR | 1 | ||
| PRAT9 | ID for product attribute 9 | KUAT9 | CHAR | 1 | ||
| PRATA | ID for product attribute 10 | KUATA | CHAR | 1 | ||
| KABSS | Customer payment guarantee procedure | KABSSCH_CM | CHAR | 4 | T691P | |
| KKBER | Credit control area | KKBER | CHAR | 4 | T014 | |
| CASSD | Sales block for customer (sales area) | CASSD_V | CHAR | 2 | ||
| RDOFF | Switch off rounding? | RDOFF | CHAR | 1 | ||
| AGREL | Indicator: Relevant for agency business | AGREL | CHAR | 1 | ||
| MEGRU | Unit of Measure Group | MEGRU | CHAR | 4 | TWMEG | |
| UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3 | ||
| UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3 | ||
| UEBTK | Unlimited overdelivery allowed | UEBTK_V | CHAR | 1 | ||
| PVKSM | Customer procedure for product proposal | PVKSM | CHAR | 2 | TPVD | |
| PODKZ | Relevant for POD processing | PODKZ | CHAR | 1 | ||
| PODTG | Timeframe for Confirmation of POD | PODTG | DEC | 11 | ||
| BLIND | Index Structure Active for Subsequent Settlement (in AB) | BLIND_SD | CHAR | 1 | ||
| CARRIER_NOTIF | Carrier is to be notified | /SPE/CARRIER_NOTIF | CHAR | 1 | ||
| /BEV1/EMLGPFAND | Deposit on Empties | /BEV1/EMGPFAND | CHAR | 1 | ||
| /BEV1/EMLGFORTS | Indicator for Empties Update | /BEV1/EMGFORTS | CHAR | 1 | ||
| J_1NBOESL | Exchange Key for NF Processing | /NFM/BOESL | CHAR | 3 | /NFM/TBOESL | |
| PROFILE | DRM profile | /SAPHT/DRM_PROFILE | CHAR | 4 | /SAPHT/DRM_PRF | |
| FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2 | TFPLA | |
| /XLSO/CUST_DIS | Rate (condition amount or percentage) where no scale exists | KBETR_KOND | CURR | 11 | ||
| /XLSO/COMP_NAME | Name 1 | NAME1_GP | CHAR | 35 | ||
| /XLSO/INDUSTRY | Industry key | BRSCH | CHAR | 4 | * | |
| /XLSO/H_NUMBER | House Number | AD_HSNM1 | CHAR | 10 | ||
| /XLSO/STREET | Street | AD_STREET | CHAR | 60 | ||
| /XLSO/POST_CODE | Postal Code | PSTLZ | CHAR | 10 | ||
| /XLSO/CITY | City | ORT01_GP | CHAR | 35 | ||
| /XLSO/COUNTRY | Country Key | LAND1_GP | CHAR | 3 | * | |
| /XLSO/INACTIVE | Single-Character Indicator | CHAR1 | CHAR | 1 |