OIURV_DOC_RUNTKT

Transparent Table Application Table
21 Fields 1 CDS Views

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)
);

Learn More