SAP table V_JITKNVP (Generated Table for View)

SAP table V_JITKNVP has 7 primary key fields being MANDT,KUNNR,KNREF,VKORG,VTWEG,SPART,PARVW.

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 T000 MANDT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
KNREF Customer description of partner (plant, storage location) CHAR 30 0 KNREF
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
PARVW Partner Function CHAR 2 0 TPAR PARVW

V_JITKNVP foreign key relationships

Table Field Check Table Check Field
0 V_JITKNVP KUNNR KNA1 General Data in Customer Master MANDT
0 V_JITKNVP KUNNR KNA1 General Data in Customer Master KUNNR
1 V_JITKNVP MANDT T000 Clients MANDT
0 V_JITKNVP PARVW TPAR Business Partner: Functions PARVW
1 V_JITKNVP SPART TSPA Organizational Unit: Sales Divisions MANDT
1 V_JITKNVP SPART TSPA Organizational Unit: Sales Divisions SPART
0 V_JITKNVP VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 V_JITKNVP VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 V_JITKNVP VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 V_JITKNVP VTWEG TVTW Organizational Unit: Distribution Channels VTWEG