V_OIGVT

13 Fields 5 CDS Views

Generated Table for View

V_OIGVT is an SAP database table in S/4HANA. Generated Table for View. It contains 13 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BerthScheduling view left_outer COMPOSITE Berth Scheduling Information
I_PlanVsActualNomination view left_outer COMPOSITE Plan Vs Actual Shipments
I_VisualNominations view left_outer COMPOSITE Visual Nominations
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization
I_VisualVehicleNumberVH view from BASIC Visual Vehicle Number

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY vehicle OIG_VHLNMR Vehicle Number
KEY veh_type OIG_VHLTYP Vehicle type
KEY veh_id OIG_VEHID Ext. identifier
KEY carrier OIG_LIFNR Carrier
KEY veh_nrtus OIG_NMRTU Number of TUs
KEY vol_uom OIG_VOLUOM Vol.UoM
KEY wgt_uom OIG_WGTUOM Weight UoM
KEY dim_uom OIG_DIMUOM Dimension UoM
KEY veh_status OIG_VEHSTA Vehicle status
KEY lang SPRAS Language
veh_text OIG_VHLTXT Vehicle text
tppoint TPLST TransportPlanPt

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_OIGVT (
    CLIENT,      -- Client [MANDT]
    VEHICLE,     -- Vehicle Number [OIG_VHLNMR]
    VEH_TYPE,    -- Vehicle type [OIG_VHLTYP]
    VEH_ID,      -- Ext. identifier [OIG_VEHID]
    CARRIER,     -- Carrier [OIG_LIFNR]
    VEH_NRTUS,   -- Number of TUs [OIG_NMRTU]
    VOL_UOM,     -- Vol.UoM [OIG_VOLUOM]
    WGT_UOM,     -- Weight UoM [OIG_WGTUOM]
    DIM_UOM,     -- Dimension UoM [OIG_DIMUOM]
    VEH_STATUS,  -- Vehicle status [OIG_VEHSTA]
    LANG,        -- Language [SPRAS]
    VEH_TEXT,    -- Vehicle text [OIG_VHLTXT]
    TPPOINT,     -- TransportPlanPt [TPLST]
    PRIMARY KEY (CLIENT, VEHICLE, VEH_TYPE, VEH_ID, CARRIER, VEH_NRTUS, VOL_UOM, WGT_UOM, DIM_UOM, VEH_STATUS, LANG)
);

Learn More