UPOT_INT_UOMDNVD

Transparent Table Application Table
33 Fields 1 CDS Views

Delivery Network Variable Data (UOM)

UPOT_INT_UOMDNVD is an SAP database table in S/4HANA. Delivery Network Variable Data (UOM). It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
UPOV_PR_DNVD_UOM view left_outer Delivery Network Variable Data_UOM

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dn_no OIU_DN_NO Delivery network ID
KEY eff_from_dt OIU_EFF_FROM_DT Effective From
eff_to_dt OIU_EFF_TO_DT Effective To
al_basis_cd OIU_AL_BASIS_CD Alloc Basis
al_fl OIU_AL_FL Allocated
theo_basis_cd OIU_SAT_DRY_CD Saturated/Dry
theo_infl_am OIU_INFL_AM Theo.inflation
cha_compat_cd OIU_CHA_COMPAT_CD Chem Anal Comp
pi_meth_cd OIU_PI_METH_CD PI method
inactive_fl OIU_INACTIVE_FL Inactive
chem_meas_grp_id OIU_CHEM_MEAS_GRP_ID Chem Meas Grp
meas_grp_id OIU_MEAS_GRP_ID Meas. Group
ca_prcs_freq_cd OIU_CA_PRCS_FREQ_CD Process Freq
ca_auto_sel_fl OIU_CA_AUTO_SEL_FL Auto Select
ca_alloc_meth_cd OIU_CA_ALLOC_METH_CD Allocation Meth
ca_alloc_tol_pc OIU_CA_ALLOC_TOL_PC CA Tolerance %
ca_alloc_bas_cd OIU_CA_ALLOC_BAS_CD Gas Alloc Basis
ca_assume_mkr_fl OIU_CA_ASSUME_MKR_FL Ass.Mkt.Grp.
ca_assume_acr_fl OIU_CA_ASSUME_ACR_FL Assume ACR's
ca_assume_doi_fl OIU_CA_ASSUME_DOI_FL Assume DOIs
ca_spf_sbe_fl OIU_CA_SPF_SBE_FL Ent. On Sales
ca_spf_cpnt_fl OIU_CA_SPF_CPNT_FL Component Level
ca_fpf_wgb_cd OIU_CA_FPF_WGB_CD Wet Gas Bal
ca_fpf_sp_rlf_fl OIU_CA_FPF_SP_RLF_FL RLF Processing
vl_prcs_freq_cd OIU_VL_PRCS_FREQ_CD Run Valuation
vl_auto_sel_fl OIU_VL_AUTO_SEL_FL Auto Select
vl_val_on_val_fl OIU_VL_VAL_ON_VAL_FL Value on Value
oiu_cruser ERNAM Created By
oiu_timestamp TZNTSTMPS Time Stamp
ca_static_takes OIU_CA_STATIC_TAKES Static Takes
ca_spf_al_basis OIU_CA_ALLOC_BAS_CD Gas Alloc Basis
no_wg /PRA/CA_NO_WG No Wet Gas

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.

-- Delivery Network Variable Data (UOM)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOT_INT_UOMDNVD (
    MANDT,             -- Client [MANDT]
    DN_NO,             -- Delivery network ID [OIU_DN_NO]
    EFF_FROM_DT,       -- Effective From [OIU_EFF_FROM_DT]
    EFF_TO_DT,         -- Effective To [OIU_EFF_TO_DT]
    AL_BASIS_CD,       -- Alloc Basis [OIU_AL_BASIS_CD]
    AL_FL,             -- Allocated [OIU_AL_FL]
    THEO_BASIS_CD,     -- Saturated/Dry [OIU_SAT_DRY_CD]
    THEO_INFL_AM,      -- Theo.inflation [OIU_INFL_AM]
    CHA_COMPAT_CD,     -- Chem Anal Comp [OIU_CHA_COMPAT_CD]
    PI_METH_CD,        -- PI method [OIU_PI_METH_CD]
    INACTIVE_FL,       -- Inactive [OIU_INACTIVE_FL]
    CHEM_MEAS_GRP_ID,  -- Chem Meas Grp [OIU_CHEM_MEAS_GRP_ID]
    MEAS_GRP_ID,       -- Meas. Group [OIU_MEAS_GRP_ID]
    CA_PRCS_FREQ_CD,   -- Process Freq [OIU_CA_PRCS_FREQ_CD]
    CA_AUTO_SEL_FL,    -- Auto Select [OIU_CA_AUTO_SEL_FL]
    CA_ALLOC_METH_CD,  -- Allocation Meth [OIU_CA_ALLOC_METH_CD]
    CA_ALLOC_TOL_PC,   -- CA Tolerance % [OIU_CA_ALLOC_TOL_PC]
    CA_ALLOC_BAS_CD,   -- Gas Alloc Basis [OIU_CA_ALLOC_BAS_CD]
    CA_ASSUME_MKR_FL,  -- Ass.Mkt.Grp. [OIU_CA_ASSUME_MKR_FL]
    CA_ASSUME_ACR_FL,  -- Assume ACR's [OIU_CA_ASSUME_ACR_FL]
    CA_ASSUME_DOI_FL,  -- Assume DOIs [OIU_CA_ASSUME_DOI_FL]
    CA_SPF_SBE_FL,     -- Ent. On Sales [OIU_CA_SPF_SBE_FL]
    CA_SPF_CPNT_FL,    -- Component Level [OIU_CA_SPF_CPNT_FL]
    CA_FPF_WGB_CD,     -- Wet Gas Bal [OIU_CA_FPF_WGB_CD]
    CA_FPF_SP_RLF_FL,  -- RLF Processing [OIU_CA_FPF_SP_RLF_FL]
    VL_PRCS_FREQ_CD,   -- Run Valuation [OIU_VL_PRCS_FREQ_CD]
    VL_AUTO_SEL_FL,    -- Auto Select [OIU_VL_AUTO_SEL_FL]
    VL_VAL_ON_VAL_FL,  -- Value on Value [OIU_VL_VAL_ON_VAL_FL]
    OIU_CRUSER,        -- Created By [ERNAM]
    OIU_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    CA_STATIC_TAKES,   -- Static Takes [OIU_CA_STATIC_TAKES]
    CA_SPF_AL_BASIS,   -- Gas Alloc Basis [OIU_CA_ALLOC_BAS_CD]
    NO_WG,             -- No Wet Gas [/PRA/CA_NO_WG]
    PRIMARY KEY (MANDT, DN_NO, EFF_FROM_DT)
);

Learn More