OIGV

Transparent Table Application Table
55 Fields 8 CDS Views

TD Vehicle Header

OIGV is an SAP database table in S/4HANA. TD Vehicle Header. It contains 55 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
/dmbe/i_MotPipeline view from TSW Pipelines
/dmbe/i_MotVessel view from TSW Vessels
E_OIL_BulkTransportVehicle view_entity from EXTENSION Extention for Vehicle - Extn
I_BulkShipmentVehicleHeader view from BASIC Bulk Shipment Vehicle Header
I_NominationAnalysisPath view left_outer BASIC View for APF Nominations
I_NominationItemDetails view left_outer BASIC Nomination and its Items view
I_NominationVehicle view from BASIC TD Vehicle Selection
I_OIL_BulkTransportVehicle view_entity from BASIC Bulk Shipment Transport Vehicle

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY vehicle OIG_VHLNMR Vehicle Number
comp_group OIG_VEHCUSTGRP Cust.Comp.Group
veh_type OIG_VHLTYP Vehicle type
veh_id OIG_VEHID Ext. identifier
carrier OIG_LIFNR Carrier
veh_nrtus OIG_NMRTU Number of TUs
vol_uom OIG_VOLUOM Vol.UoM
wgt_uom OIG_WGTUOM Weight UoM
dim_uom OIG_DIMUOM Dimension UoM
veh_maxwgt OIG_VEHMWT Maximum weight
veh_unlwgt OIG_VEHUWT Unladen weight
veh_maxvol OIG_VEHMVL Maximum volume
equip_nr EQUNR Equipment
veh_height OIG_VEHHEI Height
veh_width OIG_VEHWID Width
veh_length OIG_VEHLEN Length
route OIG_ROUTEV Vehicle route
tzone TZNZONE Time Zone
calendar CR_WFCID Factory Calendar
depot WERKS_D Plant
veh_screl OIG_VHSCREL SC rel. vehicle
name_eff_date OIG_NMEFFDT Name Eff Date
clf_efdt OIG_CLFEFFDT VehTypeEffDt
reg_cntry OIG_REG_CNTR Registered Cntry/Reg
reg_date OIG_REGDT Registered Date
owner OIG_VEH_OWNER Vehicle Owner
reg_owner OIG_VEH_REG_OWN Registered Owner
grp_id OIG_BR_CP_GRP_ID BerthCmpGrp
own_flag OIG_VOWNFL Own Vehicle
ballcap OIG_BALLCAP Ballast Capacity
fl_bnk_capa OIG_FL_BNK_CAPA FuelBnkCapacity
dsl_bnk_capa OIG_DSL_BNK_CAPA Diesel Bunker Cap
cap_uom OIG_CAP_UOM BnkCapacityUoM
wt_uom OIG_WT_UOM Draft Wt. UoM
class_grp OIG_CL_GRP ClassfGroup
vhclsign OIG_VHCLSIGN VehicleCallSign
stcmnr OIG_STCMNR Telex Number
srfxnr OIG_STFXNR Fax Number
draft OIG_VEH_DRAFT Max Vehicle Draft
average_speed OIO_AVR_SPEED_02 Average Speed
avr_speed_uom OIO_SPEED_UOM_02 Speed UoM
deck_capacity OIO_DECK_CAP_02 Deck Capacity
deck_cap_uom OIO_DECK_UOM_02 DeckCap UoM
arrival_buffer OIO_ARR_BUFF_02 Arrival Buffer
departure_buffer OIO_DEP_BUFF_02 Depart. Buffer
veh_mail AD_SMTPADR E-Mail Address
veh_phone OIO_VEH_PHONE_02 Phone
tppoint TPLST TransportPlanPt
veh_status OIG_VEHSTA Vehicle status
cre_date ERSDA Created On
cre_name ERNAM Created By
cha_date LAEDA Last Change
cha_name AENAM Changed By
veh_xblck VEH_XBLCK PurposeComplete Flag

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.

-- TD Vehicle Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIGV (
    CLIENT,            -- Client [MANDT]
    VEHICLE,           -- Vehicle Number [OIG_VHLNMR]
    COMP_GROUP,        -- Cust.Comp.Group [OIG_VEHCUSTGRP]
    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_MAXWGT,        -- Maximum weight [OIG_VEHMWT]
    VEH_UNLWGT,        -- Unladen weight [OIG_VEHUWT]
    VEH_MAXVOL,        -- Maximum volume [OIG_VEHMVL]
    EQUIP_NR,          -- Equipment [EQUNR]
    VEH_HEIGHT,        -- Height [OIG_VEHHEI]
    VEH_WIDTH,         -- Width [OIG_VEHWID]
    VEH_LENGTH,        -- Length [OIG_VEHLEN]
    ROUTE,             -- Vehicle route [OIG_ROUTEV]
    TZONE,             -- Time Zone [TZNZONE]
    CALENDAR,          -- Factory Calendar [CR_WFCID]
    DEPOT,             -- Plant [WERKS_D]
    VEH_SCREL,         -- SC rel. vehicle [OIG_VHSCREL]
    NAME_EFF_DATE,     -- Name Eff Date [OIG_NMEFFDT]
    CLF_EFDT,          -- VehTypeEffDt [OIG_CLFEFFDT]
    REG_CNTRY,         -- Registered Cntry/Reg [OIG_REG_CNTR]
    REG_DATE,          -- Registered Date [OIG_REGDT]
    OWNER,             -- Vehicle Owner [OIG_VEH_OWNER]
    REG_OWNER,         -- Registered Owner [OIG_VEH_REG_OWN]
    GRP_ID,            -- BerthCmpGrp [OIG_BR_CP_GRP_ID]
    OWN_FLAG,          -- Own Vehicle [OIG_VOWNFL]
    BALLCAP,           -- Ballast Capacity [OIG_BALLCAP]
    FL_BNK_CAPA,       -- FuelBnkCapacity [OIG_FL_BNK_CAPA]
    DSL_BNK_CAPA,      -- Diesel Bunker Cap [OIG_DSL_BNK_CAPA]
    CAP_UOM,           -- BnkCapacityUoM [OIG_CAP_UOM]
    WT_UOM,            -- Draft Wt. UoM [OIG_WT_UOM]
    CLASS_GRP,         -- ClassfGroup [OIG_CL_GRP]
    VHCLSIGN,          -- VehicleCallSign [OIG_VHCLSIGN]
    STCMNR,            -- Telex Number [OIG_STCMNR]
    SRFXNR,            -- Fax Number [OIG_STFXNR]
    DRAFT,             -- Max Vehicle Draft [OIG_VEH_DRAFT]
    AVERAGE_SPEED,     -- Average Speed [OIO_AVR_SPEED_02]
    AVR_SPEED_UOM,     -- Speed UoM [OIO_SPEED_UOM_02]
    DECK_CAPACITY,     -- Deck Capacity [OIO_DECK_CAP_02]
    DECK_CAP_UOM,      -- DeckCap UoM [OIO_DECK_UOM_02]
    ARRIVAL_BUFFER,    -- Arrival Buffer [OIO_ARR_BUFF_02]
    DEPARTURE_BUFFER,  -- Depart. Buffer [OIO_DEP_BUFF_02]
    VEH_MAIL,          -- E-Mail Address [AD_SMTPADR]
    VEH_PHONE,         -- Phone [OIO_VEH_PHONE_02]
    TPPOINT,           -- TransportPlanPt [TPLST]
    VEH_STATUS,        -- Vehicle status [OIG_VEHSTA]
    CRE_DATE,          -- Created On [ERSDA]
    CRE_NAME,          -- Created By [ERNAM]
    CHA_DATE,          -- Last Change [LAEDA]
    CHA_NAME,          -- Changed By [AENAM]
    VEH_XBLCK,         -- PurposeComplete Flag [VEH_XBLCK]
    PRIMARY KEY (CLIENT, VEHICLE)
);

Learn More