SE11 ABAP Dictionary SE11 KNVV

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

KNVV

Customer Master Sales Data
SAP SD Transparent Table 77 Fields
Primary Key:
MANDT KUNNR VKORG VTWEG SPART

Dictionary Fields Fields

(77 dari 77 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
KUNNR
KEY Customer CHAR 10 - KNA1 Customer Number 1
3
VKORG
KEY Sales org. CHAR 4 - - Sales Organization
4
VTWEG
KEY Distr. Chl CHAR 2 - - Distribution Channel
5
SPART
KEY Division CHAR 2 - - Division
6
ERNAM
- Created CHAR 12 - - Name of Person who Created the Object
7
ERDAT
- On DATS 8 - - Date on Which Record Was Created
8
BEGRU
- AuthGrp CHAR 4 - - Authorization Group
9
LOEVM
- Delet.ID CHAR 1 - - Deletion flag for customer (sales level)
10
VERSG
- CustStatGr CHAR 1 - - Customer Statistics Group
11
AUFSD
- Sales CHAR 2 - - Customer order block (sales area)
12
KALKS
- Procedure CHAR 1 - - Pricing procedure assigned to this customer
13
KDGRP
- Cust.group CHAR 2 - - Customer group
14
BZIRK
- District CHAR 6 - - Sales district
15
KONDA
- Price grp CHAR 2 - - Price group (customer)
16
PLTYP
- Price list CHAR 2 - - Price list type
17
AWAHR
- Probab. NUMC 3 - - Order probability of the item
18
INCO1
- Incoterms CHAR 3 - - Incoterms (Part 1)
19
INCO2
- Inco. 2 CHAR 28 - - Incoterms (Part 2)
20
LIFSD
- Sales CHAR 2 - - Customer delivery block (sales area)
21
AUTLF
- Compl.dlv. CHAR 1 - - Complete delivery defined for each sales order?
22
ANTLF
- MaxPartDlv DEC 1 - - Maximum Number of Partial Deliveries Allowed Per Item
23
KZTLF
- Part.dlv. CHAR 1 - - Partial delivery at item level
24
KZAZU
- OrderComb. CHAR 1 - - Order Combination Indicator
25
CHSPL
- Btch split CHAR 1 - - Batch split allowed
26
LPRIO
- Dlv.Prior. NUMC 2 - - Delivery Priority
27
EIKTO
- Account No CHAR 12 - - Shipper's (Our) Account Number at the Customer or Vendor
28
VSBED
- Shpg Cond. CHAR 2 - - Shipping Conditions
29
FAKSD
- Sales CHAR 2 - - Billing block for customer (sales and distribution)
30
MRNKZ
- Inv.maint. CHAR 1 - - Manual invoice maintenance
31
PERFK
- Invoic.Dat CHAR 2 - - Invoice dates (calendar identification)
32
PERRL
- InvListSch CHAR 2 - - Invoice list schedule (calendar identification)
33
KVAKZ
- Cost est. CHAR 1 - - Cost estimate indicator (inactive)
34
KVAWT
- MaxCostEst CURR 13 2 - Value limit for cost estimate (inactive)
35
WAERS
- Currency CUKY 5 - TCURC Currency
36
KLABC
- ABC class. CHAR 2 - - Customer classification (ABC analysis)
37
KTGRD
- AcctAssgGr CHAR 2 - - Account assignment group for this customer
38
ZTERM
- Payt Terms CHAR 4 - - Terms of Payment Key
39
VWERK
- Dlv.Plant CHAR 4 - - Delivering Plant (Own or External)
40
VKGRP
- Sales Grp CHAR 3 - - Sales Group
41
VKBUR
- Sales Off. CHAR 4 - - Sales Office
42
VSORT
- Item prop. CHAR 10 - - Item proposal
43
KVGR1
- Cust.grp 1 CHAR 3 - - Customer group 1
44
KVGR2
- Cust.grp.2 CHAR 3 - - Customer group 2
45
KVGR3
- Cust.grp.3 CHAR 3 - - Customer group 3
46
KVGR4
- Cust.grp.4 CHAR 3 - - Customer group 4
47
KVGR5
- Cust.grp.5 CHAR 3 - - Customer group 5
48
BOKRE
- Rebate CHAR 1 - - Indicator: Customer Is Rebate-Relevant
49
BOIDT
- RebateInd. DATS 8 - - Start of validity per.for the rebate index for the customer
50
KURST
- ExRateType CHAR 4 - - Exchange Rate Type
51
PRFRE
- Price det. CHAR 1 - - Relevant for price determination ID
52
PRAT1
- ProdAttr.1 CHAR 1 - - ID for product attribute 1
53
PRAT2
- ProdAttr.2 CHAR 1 - - ID for product attribute 2
54
PRAT3
- PrdAttr.3 CHAR 1 - - ID for product attribute 3
55
PRAT4
- PrdAttr.4 CHAR 1 - - ID for product attribute 4
56
PRAT5
- PrdAttr.5 CHAR 1 - - ID for product attribute 5
57
PRAT6
- ProdAttr 6 CHAR 1 - - ID for product attribute 6
58
PRAT7
- ProdAttr.7 CHAR 1 - - ID for product attribute 7
59
PRAT8
- ProdAttr.8 CHAR 1 - - ID for product attribute 8
60
PRAT9
- ProdAttr.9 CHAR 1 - - ID for product attribute 9
61
PRATA
- ProdAttr10 CHAR 1 - - ID for product attribute 10
62
KABSS
- PayGuaProc CHAR 4 - - Customer payment guarantee procedure
63
KKBER
- CreditArea CHAR 4 - - Credit control area
64
CASSD
- Sales CHAR 2 - - Sales block for customer (sales area)
65
RDOFF
- Rdg off CHAR 1 - - Switch off rounding?
66
AGREL
- Agcy busn. CHAR 1 - - Indicator: Relevant for agency business
67
MEGRU
- UoM Group CHAR 4 - - Unit of Measure Group
68
UEBTO
- Over. Tol. DEC 3 1 - Overdelivery Tolerance Limit
69
UNTTO
- Under.Tol. DEC 3 1 - Underdelivery Tolerance Limit
70
UEBTK
- Unlimited CHAR 1 - - Unlimited overdelivery allowed
71
PVKSM
- PPCustProc CHAR 2 - - Customer procedure for product proposal
72
PODKZ
- POD-rel. CHAR 1 - - Relevant for POD processing
73
PODTG
- Conf. time DEC 11 - - Timeframe for Confirmation of POD
74
BLIND
- Doc. Index CHAR 1 - - Index Structure Active for Subsequent Settlement (in AB)
75
CARRIER_NOTIF
- Crr notify CHAR 1 - - Carrier is to be notified
76
/BEV1/EMLGPFAND
- Epty.Depos CHAR 1 - - Deposit on Empties
77
/BEV1/EMLGFORTS
- IDEmUpdOff CHAR 1 - - Indicator for Empties Update

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk KNVV.

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation → SAP SD - Links to FI Tables →
Standard T-Codes
VD03 XD03 VA01
Related Tables
KNA1 TCURC EQUI EQKT EQUZ EQST IFLOT IFLOTX
ANSI SQL Query 
SELECT a.KUNNR,
       a.VKORG,
       a.VTWEG,
       a.SPART,
       a.ERNAM,
       a.ERDAT,
       a.BEGRU
FROM KNVV AS a
WHERE a.KUNNR = '0000100025'
  AND a.VKORG = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~kunnr,
       a~vkorg,
       a~vtweg,
       a~spart,
       a~ernam,
       a~erdat,
       a~begru
  FROM knvv AS a
  WHERE a~kunnr = '0000100025'
  and a~vkorg = '0001'
  INTO TABLE @DATA(lt_knvv)
  UP TO 100 ROWS.