UPOT_INT_NO_VD

Transparent Table Application Table
22 Fields 1 CDS Views

Integration table for network object variable data

UPOT_INT_NO_VD is an SAP database table in S/4HANA. Integration table for network object variable data. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
UPO_INT_WCVD_UOM view inner Integration view for WCVD

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY gho_netobj_type GHO_NETOBJ_TYPE Nw Obj Type
KEY tplnr TPLNR Functional loc.
KEY effective_from GHO_VALID_FROM_TS Valid From Timestamp
KEY well_no OIU_WL_NO Well
KEY wc_no OIU_WC_NO Well Completion
effective_to GHO_VALID_TO_TS Valid To Timestamp
netobj_status GHO_NETOBJ_STATUS_CODE Network Status code
bukrs BUKRS Company Code
cost_centre OIUCM_KOSTL Cost Center
op_fl OIU_OPERATOR_FL Operated
pn_meas_grp OIU_MEAS_GRP_ID Meas. Group
optional CHAR01 Char01
prd_mth_cd OIU_PRD_MTH_CD Prod Method
operator OIU_OPERATOR Operator
pspnr PS_POSNR WBS Element
gho_wellclass_id GHO_WELLCLASS_ID Wellclass ID
rlf_usage_fl_mtr OIU_RLF_USAGE_FL RLF usage pt.
plnty PLNTY Task List Type
plnnr PLNNR Group
plnal PLNAL Group Counter
auart PM_AUFART Order type

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.

-- Integration table for network object variable data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UPOT_INT_NO_VD (
    MANDT,             -- Client [MANDT]
    GHO_NETOBJ_TYPE,   -- Nw Obj Type [GHO_NETOBJ_TYPE]
    TPLNR,             -- Functional loc. [TPLNR]
    EFFECTIVE_FROM,    -- Valid From Timestamp [GHO_VALID_FROM_TS]
    WELL_NO,           -- Well [OIU_WL_NO]
    WC_NO,             -- Well Completion [OIU_WC_NO]
    EFFECTIVE_TO,      -- Valid To Timestamp [GHO_VALID_TO_TS]
    NETOBJ_STATUS,     -- Network Status code [GHO_NETOBJ_STATUS_CODE]
    BUKRS,             -- Company Code [BUKRS]
    COST_CENTRE,       -- Cost Center [OIUCM_KOSTL]
    OP_FL,             -- Operated [OIU_OPERATOR_FL]
    PN_MEAS_GRP,       -- Meas. Group [OIU_MEAS_GRP_ID]
    OPTIONAL,          -- Char01 [CHAR01]
    PRD_MTH_CD,        -- Prod Method [OIU_PRD_MTH_CD]
    OPERATOR,          -- Operator [OIU_OPERATOR]
    PSPNR,             -- WBS Element [PS_POSNR]
    GHO_WELLCLASS_ID,  -- Wellclass ID [GHO_WELLCLASS_ID]
    RLF_USAGE_FL_MTR,  -- RLF usage pt. [OIU_RLF_USAGE_FL]
    PLNTY,             -- Task List Type [PLNTY]
    PLNNR,             -- Group [PLNNR]
    PLNAL,             -- Group Counter [PLNAL]
    AUART,             -- Order type [PM_AUFART]
    PRIMARY KEY (MANDT, GHO_NETOBJ_TYPE, TPLNR, EFFECTIVE_FROM, WELL_NO, WC_NO)
);

Learn More