I_UTILSBILLINGRELATEDINSTDDVCE

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.

-- Billing-Related Installed Device
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSBILLINGRELATEDINSTDDVCE (
    ADVANCEDMETERCAPABILITYGROUP,
    ADVANCEDMETERINGSYSTEM,
    CITYNAME,
    CONSTRUCTIONYEAR,
    COUNTRY,
    DISTRICT,
    DIVISION,
    FUNCTIONALLOCATION,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    INSTDUTILSDEVICEISCERTIFIABLE,
    MAINTENANCEOBJECTLOCATION,
    MAINTENANCEPLANT,
    MAINTOBJECTLOCACCTASSGMTNMBR,
    METERREADINGBLOCKINGREASON,
    METERREADINGUNIT,
    POSTALCODE,
    REGION,
    SERIALNUMBER,
    STREETNAME,
    UTILITIESBILLINGCLASS,
    UTILITIESDEVICE,
    UTILITIESDEVICECATEGORY,
    UTILITIESINSTALLATION,
    UTILITIESINSTALLATIONTYPE,
    UTILITIESINSTGASPRSSRLVL,
    UTILITIESINSTVOLTAGELEVEL,
    UTILITIESPREMISE,
    UTILITIESPREPAYMENTMETERTYPE,
    UTILITIESRATECATEGORY,
    UTILITIESREGISTERGROUP,
    UTILITIESSRVCPROVIDERROLE,
    UTILITIESTEMPERATUREAREA,
    UTILSDEVICEACTIVITYREASON,
    UTILSDEVICEADVNCDMETERCAT,
    UTILSDEVICEARCRCOMMANDGROUP,
    UTILSDEVICECATEGORYDESCRIPTION,
    UTILSDEVICECERTIFICATIONYEAR,
    UTILSDEVICECONSTRUCTIONCLASS,
    UTILSDEVICEFUNCTIONCLASS,
    UTILSDEVICEINSTALLATIONDATE,
    UTILSDEVICELOCATION,
    UTILSDEVICEMEASUREMENTTYPE,
    UTILSDEVICEPRICECLASS,
    UTILSDEVICERATEFACTGROUP,
    UTILSDEVICERATETYPE,
    UTILSDEVICEVALIDITYENDDATE,
    UTILSDEVICEVALIDITYSTARTDATE,
    UTILSDVCEISNOTBILLINGRELEVANT,
    UTILSDVCEISRELEVANTFORRNTLPRC,
    UTILSDVCERATEDATAVALDTYENDDTE,
    UTILSDVCERATEDATAVALDTYSTRTDTE,
    UTILSINSTGUAROFSUPREASON,
    UTILSINSTHISTVALIDITYENDDATE,
    UTILSINSTHISTVALIDITYSTARTDATE,
    UTILSINSTISEXMPTFRMFRNCHSFEE,
    UTILSINSTISFORENERGYFEEDIN
);