SAP table CVLC23 (VELO : Assign Organization Data to VMS Roles)

SAP table CVLC23 has 2 primary key fields being MANDT,ROLE.

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
ROLE Roles in the Vehicle Management System CHAR 4 0 CVLC19 VLC_ROLE
WERKS Plant CHAR 4 0 T001W WERKS_D
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
AUART Sales Document Type CHAR 4 0 TVAK AUART
KUNNR Customer CHAR 10 0 KNA1 VLC_KUNNR
KUNWE Ship-to Party CHAR 10 0 KNA1 KUNWE
KUNRG Payer CHAR 10 0 KNA1 KUNRG
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
BSART Order Type (Purchasing) CHAR 4 0 * BSART
VHSAR Vehicle Search Area CHAR 10 0 CVLC18 VLC_VHSAR
VHORD Original Ordering Party of Vehicle CHAR 10 0 KNA1 VLC_VHORD
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 T683 KALSM_D
CURRENCY Currency Key CUKY 5 0 TCURC WAERS

CVLC23 foreign key relationships

Table Field Check Table Check Field
0 CVLC23 AUART TVAK Sales Document Types MANDT
0 CVLC23 AUART TVAK Sales Document Types AUART
1 CVLC23 CURRENCY TCURC Currency Codes WAERS
0 CVLC23 EKGRP T024 Purchasing Groups EKGRP
1 CVLC23 EKORG T024E Purchasing Organizations EKORG
0 CVLC23 KALSM T683 Pricing procedures KAPPL
0 CVLC23 KALSM T683 Pricing procedures KALSM
1 CVLC23 KUNNR KNA1 General Data in Customer Master MANDT
1 CVLC23 KUNNR KNA1 General Data in Customer Master KUNNR
0 CVLC23 KUNRG KNA1 General Data in Customer Master MANDT
0 CVLC23 KUNRG KNA1 General Data in Customer Master KUNNR
1 CVLC23 KUNWE KNA1 General Data in Customer Master MANDT
1 CVLC23 KUNWE KNA1 General Data in Customer Master KUNNR
0 CVLC23 ROLE CVLC19 VELO : Define VMS Roles MANDT
0 CVLC23 ROLE CVLC19 VELO : Define VMS Roles ROLE
1 CVLC23 SPART TSPA Organizational Unit: Sales Divisions MANDT
1 CVLC23 SPART TSPA Organizational Unit: Sales Divisions SPART
0 CVLC23 VHORD KNA1 General Data in Customer Master MANDT
0 CVLC23 VHORD KNA1 General Data in Customer Master KUNNR
1 CVLC23 VHSAR CVLC18 VELO : Vehicle Search Area MANDT
1 CVLC23 VHSAR CVLC18 VELO : Vehicle Search Area VHSAR
0 CVLC23 VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 CVLC23 VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 CVLC23 VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 CVLC23 VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 CVLC23 WERKS T001W Plants/Branches WERKS