SE11 ABAP Dictionary SE11 KNVD

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

KNVD

Customer master record sales request form
SAP SAP Transparent Table 10 Fields
Primary Key:
MANDT KUNNR VKORG VTWEG SPART DOCTP SPRAS

Dictionary Fields Fields

(10 dari 10 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
DOCTP
KEY OutputType CHAR 4 - - Output Type
7
SPRAS
KEY Language LANG 1 - T002 Message language
8
DOANZ
- Number DEC 3 - - Output quantity (original + copies)
9
DOVER
- Date/Time CHAR 1 - - Dispatch time
10
NACHA
- Medium CHAR 1 - - Message transmission medium

Related References & SQL

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

Interactive ERD Diagrams
SAP SD - Links to FI Tables →
Standard T-Codes
SE11 SE16
Related Tables
KNA1 T002 KNVP KNVV KNB1 KNB5
ANSI SQL Query 
SELECT a.KUNNR,
       a.VKORG,
       a.VTWEG,
       a.SPART,
       a.DOCTP,
       a.SPRAS,
       a.DOANZ
FROM KNVD AS a
WHERE a.KUNNR = '0000100025'
  AND a.VKORG = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~kunnr,
       a~vkorg,
       a~vtweg,
       a~spart,
       a~doctp,
       a~spras,
       a~doanz
  FROM knvd AS a
  WHERE a~kunnr = '0000100025'
  and a~vkorg = '0001'
  INTO TABLE @DATA(lt_knvd)
  UP TO 100 ROWS.