I_UTILITIESPREMISE

CDS View
18 Fields 12 CDS Views

Premise

I_UTILITIESPREMISE is a CDS View in S/4HANA. Premise. It contains 18 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
/UCOM/C_MCM_Premise_VH view_entity from CONSUMPTION Premise Lookup
C_UtilitiesPremiseDP view_entity from CONSUMPTION Data Provider for premise
CRMS4_IU_C_PRMFTS view from Premise by free text
CRMS4_IU_I_PRM view from Premise
CRMS4_IU_P_PRMFTS_SHLP view from Premise free text search search help
I_ImplsblMtrRdngMaLrnApply view inner COMPOSITE Machine Learning Training for Implbl. Mtr. Rdng.
I_ImplsblMtrRdngMaLrnTrng view inner COMPOSITE Machine Learning Training Data for Implausible Meter Reading
I_UtilsPremiseAddress view from COMPOSITE Premise with Address Information
I_UtilsPremiseKeyDateAnalysis view from COMPOSITE Key Date-Based Premise Analysis
I_UtilsPremiseKeyDateAnalysis view union_all COMPOSITE Key Date-Based Premise Analysis
P_UtilsPremiseEntSrch view_entity from BASIC
R_UtilitiesPremiseTP view_entity from TRANSACTIONAL Utilities Premise - TP

Fields (18)

KeyField CDS FieldsUsed in Views
KEY UtilitiesConnectionObject HAUS,UtilitiesConnectionObject 4
KEY UtilitiesPremise UtilitiesPremise,VS_VSTELLE,VSTELLE 4
_UtilitiesPremiseType _UtilitiesPremiseType 1
_UtilsPremiseIsMainResidence _UtilsPremiseIsMainResidence 1
_UtilsTechObjLocationAddr _UtilsTechObjLocationAddr 1
AuthorizationGroup AuthorizationGroup,BEGRU 3
DeletionIndicator DeletionIndicator,VS_LOEVM 2
Floor Floor,VS_FLOOR 2
FunctionalLocation FunctionalLocation 2
HouseNumberSupplementText HouseNumberSupplementText,VS_HOUSE_NUM2 2
LocationSupplement LocationSupplement,VS_LGZUSATZ 2
NumberOfPersons NumberOfPersons,VS_ANZPERS 5
RoomNumber RoomNumber,VS_ROOMNUMBER 2
StreetSupplement1 StreetSupplement1,VS_STR_SUPPL1 2
StreetSupplement2 StreetSupplement2,VS_STR_SUPPL3 2
UtilitiesOwner UtilitiesOwner 2
UtilitiesPremiseType UtilitiesPremiseType 1
UtilsPremiseIsMainResidence UtilsPremiseIsMainResidence 2

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.

-- Premise
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESPREMISE (
    UTILITIESCONNECTIONOBJECT,
    UTILITIESPREMISE,
    _UTILITIESPREMISETYPE,
    _UTILSPREMISEISMAINRESIDENCE,
    _UTILSTECHOBJLOCATIONADDR,
    AUTHORIZATIONGROUP,
    DELETIONINDICATOR,
    FLOOR,
    FUNCTIONALLOCATION,
    HOUSENUMBERSUPPLEMENTTEXT,
    LOCATIONSUPPLEMENT,
    NUMBEROFPERSONS,
    ROOMNUMBER,
    STREETSUPPLEMENT1,
    STREETSUPPLEMENT2,
    UTILITIESOWNER,
    UTILITIESPREMISETYPE,
    UTILSPREMISEISMAINRESIDENCE,
    PRIMARY KEY (UTILITIESCONNECTIONOBJECT, UTILITIESPREMISE)
);

Learn More