OIRBMATMET

Transparent Table Application Table
16 Fields 1 CDS Views

Business Location material/meter assignment (IS-Oil, SSR)

OIRBMATMET is an SAP database table in S/4HANA. Business Location material/meter assignment (IS-Oil, SSR). It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_NominationMeterNoVH view from BASIC Meter Number Value Help

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pblnr oif_pblnr Location ID
KEY rnbt oira_rnbt Business type
KEY seqnr oii_gseqnr Seq no.
matnr matnr Material
servtyp oira_styp Service type
equnr equnr Equipment
d_valid_to oirb_dateto Date valid to
t_valid_to oirb_timeto Time valid to
d_valid_from oirb_datefrom Date valid from
t_valid_from oirb_timefrom Time valid from
mt_ind oirc_ind_mtc Meter ind.
gmmnr oii_gmmnr Gen. meter no.
stcoun oii_stcoun Start reading
qmet_ind oirc_qmet_ind Quantity Meter
matswitch oirc_matswitch Mat Switch

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.

-- Business Location material/meter assignment (IS-Oil, SSR)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIRBMATMET (
    MANDT,         -- Client [mandt]
    PBLNR,         -- Location ID [oif_pblnr]
    RNBT,          -- Business type [oira_rnbt]
    SEQNR,         -- Seq no. [oii_gseqnr]
    MATNR,         -- Material [matnr]
    SERVTYP,       -- Service type [oira_styp]
    EQUNR,         -- Equipment [equnr]
    D_VALID_TO,    -- Date valid to [oirb_dateto]
    T_VALID_TO,    -- Time valid to [oirb_timeto]
    D_VALID_FROM,  -- Date valid from [oirb_datefrom]
    T_VALID_FROM,  -- Time valid from [oirb_timefrom]
    MT_IND,        -- Meter ind. [oirc_ind_mtc]
    GMMNR,         -- Gen. meter no. [oii_gmmnr]
    STCOUN,        -- Start reading [oii_stcoun]
    QMET_IND,      -- Quantity Meter [oirc_qmet_ind]
    MATSWITCH,     -- Mat Switch [oirc_matswitch]
    PRIMARY KEY (MANDT, PBLNR, RNBT, SEQNR)
);

Learn More