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.
Source: V_CONTACT (Generated Table for View)
V_CONTACT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| 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 |
