SE11 ABAP Dictionary SE11 KNVP

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

KNVP

Customer Master Partner Functions
SAP SAP Transparent Table 13 Fields
Primary Key:
MANDT KUNNR VKORG VTWEG SPART PARVW PARZA

Dictionary Fields Fields

(13 dari 13 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
PARVW
KEY Function CHAR 2 - - Partner Function
7
PARZA
KEY PartCount. NUMC 3 - - Partner counter
8
KUNN2
- Customer CHAR 10 - - Customer number of business partner
9
LIFNR
- Vendor CHAR 10 - LFA1 Account Number of Vendor or Creditor
10
PERNR
- Pers.No. NUMC 8 - - Personnel Number
11
PARNR
- Partner NUMC 10 - - Number of contact person
12
KNREF
- PartnDescr CHAR 30 - - Customer description of partner (plant, storage location)
13
DEFPA
- Def.Partnr CHAR 1 - - Default Partner

Related References & SQL

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

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation → SAP SD - Links to FI Tables →
Standard T-Codes
XD03 VD03 VOPAN
Related Tables
KNA1 LFA1 EQUI EQKT EQUZ EQST IFLOT IFLOTX
ANSI SQL Query 
SELECT a.KUNNR,
       a.VKORG,
       a.VTWEG,
       a.SPART,
       a.PARVW,
       a.PARZA,
       a.KUNN2
FROM KNVP AS a
WHERE a.KUNNR = '0000100025'
  AND a.VKORG = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~kunnr,
       a~vkorg,
       a~vtweg,
       a~spart,
       a~parvw,
       a~parza,
       a~kunn2
  FROM knvp AS a
  WHERE a~kunnr = '0000100025'
  and a~vkorg = '0001'
  INTO TABLE @DATA(lt_knvp)
  UP TO 100 ROWS.