SAP Table V_CONTACT
Generated Table for View
V_CONTACT (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link V_CONTACT to other SAP tables.
V_CONTACT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |
|
PAFKT
Contact person function
|
PAFKT | TPFK |
CHAR
|
2 | 0 | |
|
ABTNR
Contact person department
|
ABTNR_PA | TSAB |
CHAR
|
4 | 0 | |
|
SORTL
Sort field
|
SORTL |
CHAR
|
10 | 0 | ||
|
MC_NAME_FIRST
First name in upper case for search help
|
AD_MC_NMFI |
CHAR
|
25 | 0 | ||
|
MC_NAME_LAST
Last name in upper-case for search help
|
AD_MC_NMLA |
CHAR
|
25 | 0 | ||
|
NAME_FIRST
First name
|
AD_NAMEFIR |
CHAR
|
40 | 0 | ||
|
NAME_LAST
Last name
|
AD_NAMELAS |
CHAR
|
40 | 0 | ||
|
PARNR
Number of contact person
|
PARNR |
NUMC
|
10 | 0 |
V_CONTACT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| V_CONTACT | ABTNR | V_CONTACT | MANDT |
TSAB
Contact persons: standard departments
|
MANDT |
| V_CONTACT | ABTNR | V_CONTACT | ABTNR |
TSAB
Contact persons: standard departments
|
ABTNR |
| V_CONTACT | KUNNR | V_CONTACT | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| V_CONTACT | KUNNR | V_CONTACT | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| V_CONTACT | LIFNR | V_CONTACT | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| V_CONTACT | LIFNR | V_CONTACT | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| V_CONTACT | PAFKT | V_CONTACT | MANDT |
TPFK
Contact Persons: Functions
|
MANDT |
| V_CONTACT | PAFKT | V_CONTACT | PAFKT |
TPFK
Contact Persons: Functions
|
PAFKT |