OIURV_DOC_RUNTKT

Transparent Table Application Table

Valuation Transaction - Run Ticket

OIURV_DOC_RUNTKT is an SAP database table in S/4HANA. Valuation Transaction - Run Ticket. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PRAValnDocTransRunTicket view_entity from BASIC Valuation Transaction Run Ticket

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY doc_no OIURV_DOCNR DocNr
KEY doc_year OIU_DOC_YEAR Document year
KEY line_no OIU_DOC_LINENR Doc Line No.
KEY pos_no OIU_DOC_POS_NO Position
KEY run_tkt_no OIU_RUN_TKT_NO Run Ticket No
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
std_vol OIU_STD_VOL Std Volume
entl_gr_vl OIU_ENTL_GR_VL_AM Entitled Vol
std_vol_u OIU_STD_VOL_U Unit
base_density OIU_STD_DENSITY Std. density
base_density_u OIU_STD_DENSITY_U Std dens. UoM
price_per_unit OIUVL_PRICE_PER_UNIT Trnsp unit val
price_punit_curr WAERS Currency
actl_gr_val_am OIU_ACTL_GR_VAL_AM Gross Value
entl_gr_val_am OIU_ENTL_GR_VAL_AM Entitled Val
actl_gr_val_curr WAERS Currency
dntyp OIU_OIB_DNTYP Dens. Type
trnsp_no OIU_TRNSP_NO Transporter
trnsp_ref_no OIU_TRNSP_REF_NO Trsprt.Ref.

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.

-- Valuation Transaction - Run Ticket
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIURV_DOC_RUNTKT (
    MANDT,             -- Client [MANDT]
    DOC_NO,            -- DocNr [OIURV_DOCNR]
    DOC_YEAR,          -- Document year [OIU_DOC_YEAR]
    LINE_NO,           -- Doc Line No. [OIU_DOC_LINENR]
    POS_NO,            -- Position [OIU_DOC_POS_NO]
    RUN_TKT_NO,        -- Run Ticket No [OIU_RUN_TKT_NO]
    EFF_FROM_DT,       -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,         -- Effective To [OIU_EFF_TO_DT]
    STD_VOL,           -- Std Volume [OIU_STD_VOL]
    ENTL_GR_VL,        -- Entitled Vol [OIU_ENTL_GR_VL_AM]
    STD_VOL_U,         -- Unit [OIU_STD_VOL_U]
    BASE_DENSITY,      -- Std. density [OIU_STD_DENSITY]
    BASE_DENSITY_U,    -- Std dens. UoM [OIU_STD_DENSITY_U]
    PRICE_PER_UNIT,    -- Trnsp unit val [OIUVL_PRICE_PER_UNIT]
    PRICE_PUNIT_CURR,  -- Currency [WAERS]
    ACTL_GR_VAL_AM,    -- Gross Value [OIU_ACTL_GR_VAL_AM]
    ENTL_GR_VAL_AM,    -- Entitled Val [OIU_ENTL_GR_VAL_AM]
    ACTL_GR_VAL_CURR,  -- Currency [WAERS]
    DNTYP,             -- Dens. Type [OIU_OIB_DNTYP]
    TRNSP_NO,          -- Transporter [OIU_TRNSP_NO]
    TRNSP_REF_NO,      -- Trsprt.Ref. [OIU_TRNSP_REF_NO]
    PRIMARY KEY (MANDT, DOC_NO, DOC_YEAR, LINE_NO, POS_NO, RUN_TKT_NO, EFF_FROM_DT)
);