UTI_BIT_MTRRDNG

Transparent Table Application Table
25 Fields 2 CDS Views

Utilities Meter Readings for Billable Items

UTI_BIT_MTRRDNG is an SAP database table in S/4HANA. Utilities Meter Readings for Billable Items. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_UtilsBllbleItmMtrRdng view from EXTENSION Utilities Billable Item Meter Reading Extension
I_UtilsBllbleItmMtrRdng view from BASIC Utilities Meter Reading for Billable Item

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY extn_type bit_extn_type_kk Extension Type
KEY extn_id bit_extn_id_kk Extension ID
KEY extn_subid bit_extn_subid_kk ExtItemID
KEY extn_uuid uti_bit_extn_uuid Extension UUID
srctatype srctatype_kk SrcTransType
srctaid srctaid_kk Source Trans.ID
bitpackuuid bitpackuuid_kk Pkg Bill.Items
spart spart_kk Division
device_number uti_device_number Device Number
obis_code uti_obis_code Register Code
date_from bitperiodfrom_kk From Date
date_to bitperiodto_kk To Date
prev_meter_reading uti_previous_meter_reading Previous Meter Rdg
prev_meter_reading_msmt_unit uti_meter_reading_msmt_unit MR Msmt.Unit
meter_reading uti_meter_reading Meter Reading
meter_reading_category uti_meter_reading_category Meter Reading Cat
meter_reading_diff uti_meter_reading_diff Difference Btw MR
meter_reading_msmt_unit uti_meter_reading_msmt_unit MR Msmt.Unit
mr_rslt_adjmt_fctr_value uti_mr_rslt_adjmt_fctr_value MR.Res.Adj.FactValue
quantity uti_quantity Quantity
quantity_msmt_unit uti_quantity_msmt_unit Quantity Meas. Unit
meter_id uti_meter_id Meter ID
metering_location uti_metering_location Metering Location
vtref vtref_kk Contract

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.

-- Utilities Meter Readings for Billable Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE UTI_BIT_MTRRDNG (
    MANDT,                         -- Client [mandt]
    EXTN_TYPE,                     -- Extension Type [bit_extn_type_kk]
    EXTN_ID,                       -- Extension ID [bit_extn_id_kk]
    EXTN_SUBID,                    -- ExtItemID [bit_extn_subid_kk]
    EXTN_UUID,                     -- Extension UUID [uti_bit_extn_uuid]
    SRCTATYPE,                     -- SrcTransType [srctatype_kk]
    SRCTAID,                       -- Source Trans.ID [srctaid_kk]
    BITPACKUUID,                   -- Pkg Bill.Items [bitpackuuid_kk]
    SPART,                         -- Division [spart_kk]
    DEVICE_NUMBER,                 -- Device Number [uti_device_number]
    OBIS_CODE,                     -- Register Code [uti_obis_code]
    DATE_FROM,                     -- From Date [bitperiodfrom_kk]
    DATE_TO,                       -- To Date [bitperiodto_kk]
    PREV_METER_READING,            -- Previous Meter Rdg [uti_previous_meter_reading]
    PREV_METER_READING_MSMT_UNIT,  -- MR Msmt.Unit [uti_meter_reading_msmt_unit]
    METER_READING,                 -- Meter Reading [uti_meter_reading]
    METER_READING_CATEGORY,        -- Meter Reading Cat [uti_meter_reading_category]
    METER_READING_DIFF,            -- Difference Btw MR [uti_meter_reading_diff]
    METER_READING_MSMT_UNIT,       -- MR Msmt.Unit [uti_meter_reading_msmt_unit]
    MR_RSLT_ADJMT_FCTR_VALUE,      -- MR.Res.Adj.FactValue [uti_mr_rslt_adjmt_fctr_value]
    QUANTITY,                      -- Quantity [uti_quantity]
    QUANTITY_MSMT_UNIT,            -- Quantity Meas. Unit [uti_quantity_msmt_unit]
    METER_ID,                      -- Meter ID [uti_meter_id]
    METERING_LOCATION,             -- Metering Location [uti_metering_location]
    VTREF,                         -- Contract [vtref_kk]
    PRIMARY KEY (MANDT, EXTN_TYPE, EXTN_ID, EXTN_SUBID, EXTN_UUID)
);

Learn More