UTI_BIT_PREVPQTY

Transparent Table Application Table
17 Fields 2 CDS Views

Utilities Previous Period Quantity for Billable Items

UTI_BIT_PREVPQTY is an SAP database table in S/4HANA. Utilities Previous Period Quantity for Billable Items. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_UtilsBllbleItmPrevPeriodQty view from EXTENSION Previous Period Quantity - Extension
I_UtilsBllbleItmPrevPeriodQty view from BASIC Utilities Previous Period Quantity for Billable Item

Fields (17)

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_perd_quantity UTI_PREV_PERD_QTY Previous Period Qty
prev_perd_qty_msmt_unit UTI_PREV_PERD_QTY_MSMT_UNIT PQuantity Msmt.Unit
vtref VTREF_KK Contract
dummy_utils_bit_pq_ps CFD_DUMMY Dummy

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 Previous Period Quantity 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_PREVPQTY (
    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_PERD_QUANTITY,       -- Previous Period Qty [UTI_PREV_PERD_QTY]
    PREV_PERD_QTY_MSMT_UNIT,  -- PQuantity Msmt.Unit [UTI_PREV_PERD_QTY_MSMT_UNIT]
    VTREF,                    -- Contract [VTREF_KK]
    DUMMY_UTILS_BIT_PQ_PS,    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, EXTN_TYPE, EXTN_ID, EXTN_SUBID, EXTN_UUID)
);

Learn More