KNVK

Customer Master Contact Partner | #masterdata | Component: Customer Master
Column Name Description
MANDT Client
PARNR Number of Contact Person
Column Name Description
Column Name Description
Column Name Description
GBDAT Date of Birth
MOAB1 Contact person's visiting hours: Monday morning from ...
MOBI1 Contact person's visiting hours: Monday morning until ...
MOAB2 Contact person's visiting hours: Monday afternoon from ...
MOBI2 Contact person's visiting hours: Monday afternoon until ...
DIAB1 Contact person's visiting hours: Tuesday morning from...
DIBI1 Contact person's visiting hours: Tuesday morning until ...
DIAB2 Contact person's visiting hours: Tuesday afternoon from..
DIBI2 Contact person's visiting hours: Tuesday afternoon until ...
MIAB1 Contact person's visiting hours: Wednesday morning from...
MIBI1 Contact person's visiting hours: Wednesday morning until ...
MIAB2 Contact person's visiting hours: Wednesday afternoon from ..
MIBI2 Contact person's visiting hours: Wednesday afternoon until..
DOAB1 Contact person's visiting hours: Thursday morning from ....
DOBI1 Contact person's visiting hours: Thursday morning until ....
DOAB2 Contact person's visiting hours: Thursday afternoon from...
DOBI2 Contact person's visiting hours: Thursday afternoon until ..
FRAB1 Contact person's visiting hours: Friday morning from ...
FRBI1 Contact person's visiting hours: Friday morning until ...
FRAB2 Contact person's visiting hours: Friday afternoon from ...
FRBI2 Contact person's visiting hours: Friday afternoon until ...
SAAB1 Contact person's visiting hours: Saturday morning from ...
SABI1 Contact person's visiting hours: Saturday morning until ...
SAAB2 Contact person's visiting hours: Saturday afternoon from ...
SABI2 Contact person's visiting hours: Saturday afternoon until ..
SOAB1 Contact person's visiting hours: Sunday morning from ...
SOBI1 Contact person's visiting hours: Sunday morning until ...
SOAB2 Contact person's visiting hours: Sunday afternoon from ...
SOBI2 Contact person's visiting hours: Sunday afternoon until ...
ERDAT Date on which the Record Was Created
Column Name Description
NMAIL Advertising material indicator Show values
DUEFL Status of Data Transfer into Subsequent Release Show values
LOEVM Central Deletion Flag for Master Record Show values
KZHERK Internal indicator for origin of the CP: Customer or Vendor Show values
CVP_XBLCK_K Business Purpose Completed Flag Show values
Column Name Description Domain name
NAMEV First name NAME
NAME1 Name 1 NAME
ORT01 City TEXT35
ADRND Business address ADRNR
ADRNP Home address ADRNR
ABTPA Contact person's department at customer ABTEI
UEPAR Higher-Level Partner PARNR
TELF1 First telephone number TEXT16
ANRED Form of address for contact person (Mr, Mrs...etc) TEXT30
PARGE Partner's gender AD_SEX
VRTNR Representative number VTRNR
PARAU Notes about contact person TEXT40
SORTL Sort field CHAR10
SPNAM Nickname TEXT10
TITEL_AP Title of contact person (description of function) TEXT35
ERNAM Name of Person who Created the Object USNAM
ADRNP_2 Address Number AD_ADDRNUM
PRSNR Person Number AD_PERSNUM
Master Data Relations Join Conditions
Contact person department
  • Contact person department
  • Client
  • KNVK.ABTNR == TSAB.ABTNR
  • KNVK.MANDT == TSAB.MANDT
Buying habits
  • Buying habits
  • Client
  • KNVK.AKVER == TVAV.AKVER
  • KNVK.MANDT == TVAV.MANDT
Call frequency
  • KNVK.MANDT == TVBR.MANDT
  • KNVK.BRYTH == TVBR.BRYTH
Customer Number
  • KNVK.MANDT == KNA1.MANDT
  • KNVK.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • KNVK.MANDT == LFA1.MANDT
  • KNVK.LIFNR == LFA1.LIFNR
Contact person function
  • KNVK.MANDT == TPFK.MANDT
  • KNVK.PAFKT == TPFK.PAFKT
Contact person: Attribute 6
  • KNVK.MANDT == TVP6.MANDT
  • KNVK.PAKN1 == TVP6.PAAT6
Contact person: Attribute 7
  • KNVK.MANDT == TVP7.MANDT
  • KNVK.PAKN2 == TVP7.PAAT7
Contact person: Attribute 8
  • KNVK.MANDT == TVP8.MANDT
  • KNVK.PAKN3 == TVP8.PAAT8
Contact person: Attribute 9
  • KNVK.MANDT == TVP9.MANDT
  • KNVK.PAKN4 == TVP9.PAAT9
Contact person: Attribute 10
  • Contact person: Attribute 10
  • Client
  • KNVK.PAKN5 == TVP0.PAAT0
  • KNVK.MANDT == TVP0.MANDT
Contact person: Attribute 1
  • Contact person: Attribute 1
  • Client
  • KNVK.PARH1 == TVPH.PARHO
  • KNVK.MANDT == TVPH.MANDT
Contact person: Attribute 2
  • KNVK.MANDT == TVP2.MANDT
  • KNVK.PARH2 == TVP2.PAAT2
Contact person: Attribute 3
  • KNVK.MANDT == TVP3.MANDT
  • KNVK.PARH3 == TVP3.PAAT3
Contact person: Attribute 4
  • Contact person: Attribute 4
  • Client
  • KNVK.PARH4 == TVP4.PAAT4
  • KNVK.MANDT == TVP4.MANDT
Contact person: Attribute 5
  • Contact person: Attribute 5
  • Client
  • KNVK.PARH5 == TVP5.PAAT5
  • KNVK.MANDT == TVP5.MANDT
Partner language KNVK.PARLA == T002.SPRAS
Partner's Authority
  • KNVK.MANDT == TVPV.MANDT
  • KNVK.PARVO == TVPV.PARVO
VIP Partner
  • VIP Partner
  • Client
  • KNVK.PAVIP == TVIP.PAVIP
  • KNVK.MANDT == TVIP.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Marital Status Key
  • Marital Status Key
  • ?
  • KNVK.MANDT == T502T.MANDT
  • KNVK.FAMST == T502T.FAMST
  • KNVK.[column in domain "SPRAS"] == T502T.SPRSL