SAP table V_CONTACT (Generated Table for View)

SAP table V_CONTACT has 12 primary key fields being MANDT,KUNNR,LIFNR,PAFKT,ABTNR,SORTL,MC_NAME_FIRST,MC_NAME_LAST,NAME_FIRST,NAME_LAST,PARNR,CVP_XBLCK_K.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
PAFKT Contact person function CHAR 2 0 TPFK PAFKT
ABTNR Contact person department CHAR 4 0 TSAB ABTNR_PA
SORTL Sort field CHAR 10 0 SORTL
MC_NAME_FIRST First Name in Uppercase for Search Help CHAR 25 0 AD_MC_NMFI
MC_NAME_LAST Last Name in Uppercase for Search Help CHAR 25 0 AD_MC_NMLA
NAME_FIRST First name CHAR 40 0 AD_NAMEFIR
NAME_LAST Last name CHAR 40 0 AD_NAMELAS
PARNR Number of Contact Person NUMC 10 0 PARNR
CVP_XBLCK_K Business Purpose Completed Flag CHAR 1 0 CVP_XBLCK
not blocked
X blocked

V_CONTACT foreign key relationships

Table Field Check Table Check Field
0 V_CONTACT ABTNR TSAB Contact persons: standard departments MANDT
0 V_CONTACT ABTNR TSAB Contact persons: standard departments ABTNR
1 V_CONTACT KUNNR KNA1 General Data in Customer Master MANDT
1 V_CONTACT KUNNR KNA1 General Data in Customer Master KUNNR
0 V_CONTACT LIFNR LFA1 Supplier Master (General Section) MANDT
0 V_CONTACT LIFNR LFA1 Supplier Master (General Section) LIFNR
1 V_CONTACT PAFKT TPFK Contact Persons: Functions MANDT
1 V_CONTACT PAFKT TPFK Contact Persons: Functions PAFKT