I_UTILSBILLINGORDER

CDS View
53 Fields 6 CDS Views

Utilities Billing Order

I_UTILSBILLINGORDER is a CDS View in S/4HANA. Utilities Billing Order. It contains 53 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_UtilitiesBillingOrderHistory view from CONSUMPTION Billing Order History
C_UtilsBillgOrdErrorsWithDets view_entity from CONSUMPTION Utilities Billing Order Errors With Details
C_UtilsBillgOrdRdyBillgWthDets view from CONSUMPTION Billing Order Ready for Billing with Details
C_UtilsBillingOrder view from CONSUMPTION Utilities Billing Order
I_NonBllbleUtilsBillgOrd view from COMPOSITE Non-Billable Utilities Billing Order
I_OpenUtilsBillgDocAndOrdData view from COMPOSITE Open Utilities Billing Document and Order Data

Fields (53)

KeyField CDS FieldsUsed in Views
KEY ContractAccount ContractAccount 5
KEY ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate 6
KEY UtilitiesBillingReason UtilitiesBillingReason 6
KEY UtilitiesContract UtilitiesContract 6
KEY UtilitiesInstallation UtilitiesInstallation 6
KEY UtilsInstHistValidityEndDate UtilsInstHistValidityEndDate 2
_BusinessPartner _BusinessPartner 4
_CompanyCode _CompanyCode 6
_ContrAcc _ContrAcc 4
_Division _Division 6
_MeterReadingUnit _MeterReadingUnit 5
_SuppressedUtilsBillgReason _SuppressedUtilsBillgReason 2
_UtilitiesBillingReason _UtilitiesBillingReason 5
_UtilitiesInstallation _UtilitiesInstallation 6
_UtilitiesPortion _UtilitiesPortion 5
_UtilitiesRateCategory _UtilitiesRateCategory 5
_UtilsAccountDetnCode _UtilsAccountDetnCode 5
_UtilsBillgBlockReason _UtilsBillgBlockReason 5
_UtilsBillgOrdChkBfrBilling _UtilsBillgOrdChkBfrBilling 2
_UtilsBillgOutsortingGroup _UtilsBillgOutsortingGroup 2
_UtilsBillgUnblockReason _UtilsBillgUnblockReason 5
_UtilsBillingClass _UtilsBillingClass 5
_UtilsBillingOrderIndicator _UtilsBillingOrderIndicator 2
_UtilsBillingOrderStatus _UtilsBillingOrderStatus 3
_UtilsContrSpcfcBdgtBillgCyc _UtilsContrSpcfcBdgtBillgCyc 2
AuthorizationGroup AuthorizationGroup 6
BusinessPartner BusinessPartner 4
CompanyCode CompanyCode 6
Division Division 6
MeterReadingUnit MeterReadingUnit 5
NrOfUtilitiesBillingOrders NrOfUtilitiesBillingOrders 1
ScheduledMeterReadingDate ScheduledMeterReadingDate 6
SuppressedSchedldMtrRdngDte SuppressedSchedldMtrRdngDte 2
SuppressedUtilsBillgReason SuppressedUtilsBillgReason 2
SuppressedUtilsSchedldBillgDte SuppressedUtilsSchedldBillgDte 2
UtilitiesAccountDetnCode UtilitiesAccountDetnCode 5
UtilitiesBillingClass UtilitiesBillingClass 5
UtilitiesContractIsActive UtilitiesContractIsActive 1
UtilitiesMoveInDate UtilitiesMoveInDate 3
UtilitiesMoveOutDate UtilitiesMoveOutDate 3
UtilitiesPortion UtilitiesPortion 5
UtilitiesRateCategory UtilitiesRateCategory 5
UtilsBillgBlockReason UtilsBillgBlockReason 5
UtilsBillgOrdChkBfrBilling UtilsBillgOrdChkBfrBilling 2
UtilsBillgOutsortingReason UtilsBillgOutsortingReason 2
UtilsBillgUnblockReason UtilsBillgUnblockReason 5
UtilsBillingOrderIndicator UtilsBillingOrderIndicator 2
UtilsBillingOrderStatus UtilsBillingOrderStatus 3
UtilsContrIsBilledManually UtilsContrIsBilledManually 1
UtilsContrSpcfcBdgtBillgCycle UtilsContrSpcfcBdgtBillgCycle 2
UtilsExternalPointOfDelivery UtilsExternalPointOfDelivery 2
UtilsInstTimeSliceIsValid UtilsInstTimeSliceIsValid 1
UtilsPortionScheduleRecordDate UtilsPortionScheduleRecordDate 3

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 Billing Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSBILLINGORDER (
    CONTRACTACCOUNT,
    SCHEDULEDUTILITIESBILLINGDATE,
    UTILITIESBILLINGREASON,
    UTILITIESCONTRACT,
    UTILITIESINSTALLATION,
    UTILSINSTHISTVALIDITYENDDATE,
    _BUSINESSPARTNER,
    _COMPANYCODE,
    _CONTRACC,
    _DIVISION,
    _METERREADINGUNIT,
    _SUPPRESSEDUTILSBILLGREASON,
    _UTILITIESBILLINGREASON,
    _UTILITIESINSTALLATION,
    _UTILITIESPORTION,
    _UTILITIESRATECATEGORY,
    _UTILSACCOUNTDETNCODE,
    _UTILSBILLGBLOCKREASON,
    _UTILSBILLGORDCHKBFRBILLING,
    _UTILSBILLGOUTSORTINGGROUP,
    _UTILSBILLGUNBLOCKREASON,
    _UTILSBILLINGCLASS,
    _UTILSBILLINGORDERINDICATOR,
    _UTILSBILLINGORDERSTATUS,
    _UTILSCONTRSPCFCBDGTBILLGCYC,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    COMPANYCODE,
    DIVISION,
    METERREADINGUNIT,
    NROFUTILITIESBILLINGORDERS,
    SCHEDULEDMETERREADINGDATE,
    SUPPRESSEDSCHEDLDMTRRDNGDTE,
    SUPPRESSEDUTILSBILLGREASON,
    SUPPRESSEDUTILSSCHEDLDBILLGDTE,
    UTILITIESACCOUNTDETNCODE,
    UTILITIESBILLINGCLASS,
    UTILITIESCONTRACTISACTIVE,
    UTILITIESMOVEINDATE,
    UTILITIESMOVEOUTDATE,
    UTILITIESPORTION,
    UTILITIESRATECATEGORY,
    UTILSBILLGBLOCKREASON,
    UTILSBILLGORDCHKBFRBILLING,
    UTILSBILLGOUTSORTINGREASON,
    UTILSBILLGUNBLOCKREASON,
    UTILSBILLINGORDERINDICATOR,
    UTILSBILLINGORDERSTATUS,
    UTILSCONTRISBILLEDMANUALLY,
    UTILSCONTRSPCFCBDGTBILLGCYCLE,
    UTILSEXTERNALPOINTOFDELIVERY,
    UTILSINSTTIMESLICEISVALID,
    UTILSPORTIONSCHEDULERECORDDATE,
    PRIMARY KEY (CONTRACTACCOUNT, SCHEDULEDUTILITIESBILLINGDATE, UTILITIESBILLINGREASON, UTILITIESCONTRACT, UTILITIESINSTALLATION, UTILSINSTHISTVALIDITYENDDATE)
);

Learn More