V_OIJNOMI_LDS_BS

42 Fields 1 CDS Views

Generated Table for View

V_OIJNOMI_LDS_BS is an SAP database table in S/4HANA. Generated Table for View. It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BerthScheduling view left_outer COMPOSITE Berth Scheduling Information

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pegtype OIJ_PEGTYPE Peg type
KEY pegid OIJ_PEGID Peg ID
KEY brthseq OIJ_LDSEQ Berthing seq.
nomtk OIJ_NOMTK Nomination key
shipldseq OIJ_SHIPLDSEQ Ship LDSequence
schedmat OIJ_SMATNR Sched.Material
ldmat OIJ_MATNR LD MaterialNo
ldquan OIJ_SCHQUAN LD quantity
lduom OIJ_LDUOM LD Matrl. UOM
actualqty OIJ_ACTQTY Actual Qty
actualuom OIJ_ACTUOM ActualUoM
berid OIJ_BERID Berth Identifier
tankid OII_SOCNR SOCSEG number
lightloc OIJ_LIGHTLOCID Lightering Loc.
lightvessel OIJ_LIGHTVESS Lightering Ves.
lightnom OIJ_LIGHTNOM Lightering Nom.
ldfrdate OIJ_BERTHSTR Brth. StDate
ldfrtime OIJ_BERTHSTRT Brth. StTime
ldtodate OIJ_BERTHEND Brth.EndDate
ldtotime OIJ_BERTHENDT Brth.EndTime
ldsystid OIJ_LSYST Loading system
targetqty OIJ_TARQTY Target Qty.
targetqtyuom OIJ_TARQTYUOM Targt.Qty.UoM
meterno OII_GMMNR Gen. meter no.
stmeter OIJ_STMETER St.Meter Rd.
endmeter OIJ_ENDMETER End Meter Rd.
dipdate OII_DIPDAT Dip date
diptime OII_DIPZEIT Dip time
endgaugeval OIJ_ENDDIP End.Dip Reading
endgaugeuom OIJ_STDIPUOM1 End Dip UoM
vsl_arrdraft OIJ_ARRDRAFT Ship Arr.Draft
vsl_depdraft OIJ_DEPDRAFT Ship Dep.Draft
draftuom OIJ_DRF_UOM Draft UoM
vsl_txdeadwgt OIJ_SHIPDWEIGHT Deadweight
deadwgtuom OIJ_DWEIGHTUOM Dwgt. UoM
ticketno OIJ_TKTNR Ticket ext. no.
flushflag OIJ_FLUSHFL Flush Flag
ldind OIJ_LDIND LD Indicator
lightnomit OIJ_LIGHTNOMIT Lightering item
sched_tst_from OIJ_SCHED_F TST From
sched_tst_to OIJ_SCHED_T TST To

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_OIJNOMI_LDS_BS (
    MANDT,           -- Client [MANDT]
    PEGTYPE,         -- Peg type [OIJ_PEGTYPE]
    PEGID,           -- Peg ID [OIJ_PEGID]
    BRTHSEQ,         -- Berthing seq. [OIJ_LDSEQ]
    NOMTK,           -- Nomination key [OIJ_NOMTK]
    SHIPLDSEQ,       -- Ship LDSequence [OIJ_SHIPLDSEQ]
    SCHEDMAT,        -- Sched.Material [OIJ_SMATNR]
    LDMAT,           -- LD MaterialNo [OIJ_MATNR]
    LDQUAN,          -- LD quantity [OIJ_SCHQUAN]
    LDUOM,           -- LD Matrl. UOM [OIJ_LDUOM]
    ACTUALQTY,       -- Actual Qty [OIJ_ACTQTY]
    ACTUALUOM,       -- ActualUoM [OIJ_ACTUOM]
    BERID,           -- Berth Identifier [OIJ_BERID]
    TANKID,          -- SOCSEG number [OII_SOCNR]
    LIGHTLOC,        -- Lightering Loc. [OIJ_LIGHTLOCID]
    LIGHTVESSEL,     -- Lightering Ves. [OIJ_LIGHTVESS]
    LIGHTNOM,        -- Lightering Nom. [OIJ_LIGHTNOM]
    LDFRDATE,        -- Brth. StDate [OIJ_BERTHSTR]
    LDFRTIME,        -- Brth. StTime [OIJ_BERTHSTRT]
    LDTODATE,        -- Brth.EndDate [OIJ_BERTHEND]
    LDTOTIME,        -- Brth.EndTime [OIJ_BERTHENDT]
    LDSYSTID,        -- Loading system [OIJ_LSYST]
    TARGETQTY,       -- Target Qty. [OIJ_TARQTY]
    TARGETQTYUOM,    -- Targt.Qty.UoM [OIJ_TARQTYUOM]
    METERNO,         -- Gen. meter no. [OII_GMMNR]
    STMETER,         -- St.Meter Rd. [OIJ_STMETER]
    ENDMETER,        -- End Meter Rd. [OIJ_ENDMETER]
    DIPDATE,         -- Dip date [OII_DIPDAT]
    DIPTIME,         -- Dip time [OII_DIPZEIT]
    ENDGAUGEVAL,     -- End.Dip Reading [OIJ_ENDDIP]
    ENDGAUGEUOM,     -- End Dip UoM [OIJ_STDIPUOM1]
    VSL_ARRDRAFT,    -- Ship Arr.Draft [OIJ_ARRDRAFT]
    VSL_DEPDRAFT,    -- Ship Dep.Draft [OIJ_DEPDRAFT]
    DRAFTUOM,        -- Draft UoM [OIJ_DRF_UOM]
    VSL_TXDEADWGT,   -- Deadweight [OIJ_SHIPDWEIGHT]
    DEADWGTUOM,      -- Dwgt. UoM [OIJ_DWEIGHTUOM]
    TICKETNO,        -- Ticket ext. no. [OIJ_TKTNR]
    FLUSHFLAG,       -- Flush Flag [OIJ_FLUSHFL]
    LDIND,           -- LD Indicator [OIJ_LDIND]
    LIGHTNOMIT,      -- Lightering item [OIJ_LIGHTNOMIT]
    SCHED_TST_FROM,  -- TST From [OIJ_SCHED_F]
    SCHED_TST_TO,    -- TST To [OIJ_SCHED_T]
    PRIMARY KEY (MANDT, PEGTYPE, PEGID, BRTHSEQ)
);

Learn More