OIRBMATMET

Transparent Table Application Table
22 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 22 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 (22)

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
erdat ERDAT Created On
ertim OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aetim OI0_AETIM Changed
aenam AENAM Changed By

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]
    ERDAT,         -- Created On [ERDAT]
    ERTIM,         -- Created [OI0_ERTIM]
    ERNAM,         -- Created By [ERNAM]
    AEDAT,         -- Changed On [AEDAT]
    AETIM,         -- Changed [OI0_AETIM]
    AENAM,         -- Changed By [AENAM]
    PRIMARY KEY (MANDT, PBLNR, RNBT, SEQNR)
);

Learn More