I_OPENUTILSBILLGDOCANDORD

CDS View
46 Fields 3 CDS Views

Open Utilities Billing Document and Order

I_OPENUTILSBILLGDOCANDORD is a CDS View in S/4HANA. Open Utilities Billing Document and Order. It contains 46 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_OpenUtilsBillgBlkdContr view from CONSUMPTION Blocked Utilities Contract with Open Billing
C_OpenUtilsBillgDocAndOrd view from CONSUMPTION Open Utilities Billing Document and Order
C_OutStdgUtilsBillgItemWthDets view_entity from CONSUMPTION Outstanding Billing Item with Details

Fields (46)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 3
KEY ContractAccount ContractAccount 3
KEY ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate 3
KEY UtilitiesBillingReason UtilitiesBillingReason 3
KEY UtilitiesContract UtilitiesContract 3
KEY UtilitiesInstallation UtilitiesInstallation 3
KEY UtilsInstHistValidityEndDate UtilsInstHistValidityEndDate 1
_BusinessPartner _BusinessPartner 3
_CompanyCode _CompanyCode 3
_ContrAcc _ContrAcc 3
_Division _Division 3
_ImplsblMtrRdngResultsCntr _ImplsblMtrRdngResultsCntr 1
_MeterReadingReason _MeterReadingReason 1
_MeterReadingStsGrp _MeterReadingStsGrp 1
_MeterReadingUnit _MeterReadingUnit 3
_MissingMtrRdngResultsCntr _MissingMtrRdngResultsCntr 1
_OpnUtilsBillgDocAndOrdType _OpnUtilsBillgDocAndOrdType 2
_UtilitiesBillingReason _UtilitiesBillingReason 3
_UtilitiesInstallation _UtilitiesInstallation 3
_UtilitiesPortion _UtilitiesPortion 3
_UtilitiesRateCategory _UtilitiesRateCategory 3
_UtilsAccountDetnCode _UtilsAccountDetnCode 3
_UtilsBillgBlockReason _UtilsBillgBlockReason 3
_UtilsBillgUnblockReason _UtilsBillgUnblockReason 3
_UtilsBillingClass _UtilsBillingClass 3
_UtilsInstIntAndExtPtOfDeliv _UtilsInstIntAndExtPtOfDeliv 1
AuthorizationGroup AuthorizationGroup 3
CompanyCode CompanyCode 3
Division Division 3
MeterReadingReason MeterReadingReason 1
MeterReadingStatusGroup MeterReadingStatusGroup 1
MeterReadingUnit MeterReadingUnit 3
NmbrOfImplausibleMtrRdngRslts NmbrOfImplausibleMtrRdngRslts 1
NmbrOfUtilsContrBlkdForBillg NmbrOfUtilsContrBlkdForBillg 1
NrOfOpenUtilsBillgDocsAndOrds NrOfOpenUtilsBillgDocsAndOrds 1
OpnUtilsBillgDocAndOrdType OpnUtilsBillgDocAndOrdType 2
ScheduledMeterReadingDate ScheduledMeterReadingDate 3
UtilitiesAccountDetnCode UtilitiesAccountDetnCode 3
UtilitiesBillingClass UtilitiesBillingClass 3
UtilitiesMoveInDate UtilitiesMoveInDate 1
UtilitiesMoveOutDate UtilitiesMoveOutDate 1
UtilitiesPortion UtilitiesPortion 3
UtilitiesRateCategory UtilitiesRateCategory 3
UtilsBillgBlockReason UtilsBillgBlockReason 3
UtilsBillgUnblockReason UtilsBillgUnblockReason 3
UtilsPortionScheduleRecordDate UtilsPortionScheduleRecordDate 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.

-- Open Utilities Billing Document and Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_OPENUTILSBILLGDOCANDORD (
    BUSINESSPARTNER,
    CONTRACTACCOUNT,
    SCHEDULEDUTILITIESBILLINGDATE,
    UTILITIESBILLINGREASON,
    UTILITIESCONTRACT,
    UTILITIESINSTALLATION,
    UTILSINSTHISTVALIDITYENDDATE,
    _BUSINESSPARTNER,
    _COMPANYCODE,
    _CONTRACC,
    _DIVISION,
    _IMPLSBLMTRRDNGRESULTSCNTR,
    _METERREADINGREASON,
    _METERREADINGSTSGRP,
    _METERREADINGUNIT,
    _MISSINGMTRRDNGRESULTSCNTR,
    _OPNUTILSBILLGDOCANDORDTYPE,
    _UTILITIESBILLINGREASON,
    _UTILITIESINSTALLATION,
    _UTILITIESPORTION,
    _UTILITIESRATECATEGORY,
    _UTILSACCOUNTDETNCODE,
    _UTILSBILLGBLOCKREASON,
    _UTILSBILLGUNBLOCKREASON,
    _UTILSBILLINGCLASS,
    _UTILSINSTINTANDEXTPTOFDELIV,
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    DIVISION,
    METERREADINGREASON,
    METERREADINGSTATUSGROUP,
    METERREADINGUNIT,
    NMBROFIMPLAUSIBLEMTRRDNGRSLTS,
    NMBROFUTILSCONTRBLKDFORBILLG,
    NROFOPENUTILSBILLGDOCSANDORDS,
    OPNUTILSBILLGDOCANDORDTYPE,
    SCHEDULEDMETERREADINGDATE,
    UTILITIESACCOUNTDETNCODE,
    UTILITIESBILLINGCLASS,
    UTILITIESMOVEINDATE,
    UTILITIESMOVEOUTDATE,
    UTILITIESPORTION,
    UTILITIESRATECATEGORY,
    UTILSBILLGBLOCKREASON,
    UTILSBILLGUNBLOCKREASON,
    UTILSPORTIONSCHEDULERECORDDATE,
    PRIMARY KEY (BUSINESSPARTNER, CONTRACTACCOUNT, SCHEDULEDUTILITIESBILLINGDATE, UTILITIESBILLINGREASON, UTILITIESCONTRACT, UTILITIESINSTALLATION, UTILSINSTHISTVALIDITYENDDATE)
);

Learn More