CVLC23

Transparent Table Application Table
17 Fields 1 CDS Views

VELO : Assign Organization Data to VMS Roles

CVLC23 is an SAP database table in S/4HANA. VELO : Assign Organization Data to VMS Roles. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_VMSVehicleOrgToRole view_entity from BASIC Assign Organization Data to VMS Roles

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY role vlc_role VMS Roles
werks werks_d Plant
vkorg vkorg Sales Org.
vtweg vtweg Distr. Channel
spart spart Division
auart auart Sales Doc. Type
kunnr vlc_kunnr Customer
kunwe kunwe Ship-to Party
kunrg kunrg Payer
ekorg ekorg Purchasing Org.
ekgrp ekgrp Purch. Group
bsart bsart Order Type
vhsar vlc_vhsar Veh.Search Area
vhord vlc_vhord Orig. Ord. Pty
kalsm kalsm_d Procedure
currency waers Currency

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- VELO : Assign Organization Data to VMS Roles
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CVLC23 (
    MANDT,     -- Client [mandt]
    ROLE,      -- VMS Roles [vlc_role]
    WERKS,     -- Plant [werks_d]
    VKORG,     -- Sales Org. [vkorg]
    VTWEG,     -- Distr. Channel [vtweg]
    SPART,     -- Division [spart]
    AUART,     -- Sales Doc. Type [auart]
    KUNNR,     -- Customer [vlc_kunnr]
    KUNWE,     -- Ship-to Party [kunwe]
    KUNRG,     -- Payer [kunrg]
    EKORG,     -- Purchasing Org. [ekorg]
    EKGRP,     -- Purch. Group [ekgrp]
    BSART,     -- Order Type [bsart]
    VHSAR,     -- Veh.Search Area [vlc_vhsar]
    VHORD,     -- Orig. Ord. Pty [vlc_vhord]
    KALSM,     -- Procedure [kalsm_d]
    CURRENCY,  -- Currency [waers]
    PRIMARY KEY (MANDT, ROLE)
);

Learn More