I_UTILSCONTRTOBEBLLD

CDS View
41 Fields 3 CDS Views

Utilities Contract to Be Billed

I_UTILSCONTRTOBEBLLD is a CDS View in S/4HANA. Utilities Contract to Be Billed. It contains 41 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_BlkdUtilsContrToBeBlld view from CONSUMPTION Blocked Utilities Contract to be Billed
C_MisgUtilsBillingOrderWthDets view from CONSUMPTION Missing Utilities Billing Order with Details
C_UtilsContrToBeBlld view from CONSUMPTION Utilities Contract to Be Billed

Fields (41)

KeyField CDS FieldsUsed in Views
KEY ScheduledMeterReadingDate ScheduledMeterReadingDate 3
KEY ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate 3
KEY UtilitiesContract UtilitiesContract 3
KEY UtilitiesPortion UtilitiesPortion 3
_BusinessPartner _BusinessPartner 3
_CompanyCode _CompanyCode 3
_ContrAcc _ContrAcc 3
_Division _Division 3
_MeterReadingReason _MeterReadingReason 1
_MeterReadingUnit _MeterReadingUnit 3
_UtilitiesBillingReason _UtilitiesBillingReason 2
_UtilitiesInstallation _UtilitiesInstallation 3
_UtilitiesPortion _UtilitiesPortion 3
_UtilitiesRateCategory _UtilitiesRateCategory 3
_UtilsAccountDetnCode _UtilsAccountDetnCode 3
_UtilsBillgBlockReason _UtilsBillgBlockReason 3
_UtilsBillgUnblockReason _UtilsBillgUnblockReason 3
_UtilsBillingClass _UtilsBillingClass 3
_UtilsContrToBeBlldDetsType _UtilsContrToBeBlldDetsType 1
_UtilsContrToBeBlldType _UtilsContrToBeBlldType 1
AuthorizationGroup AuthorizationGroup 3
BusinessPartner BusinessPartner 3
CompanyCode CompanyCode 3
ContractAccount ContractAccount 3
Division Division 3
MeterReadingReason MeterReadingReason 1
MeterReadingUnit MeterReadingUnit 3
NmbrOfUtilsContractsToBeBilled NmbrOfUtilsContractsToBeBilled 1
NmbrOfUtilsContrBlkdForBillg NmbrOfUtilsContrBlkdForBillg 1
UtilitiesAccountDetnCode UtilitiesAccountDetnCode 3
UtilitiesBillingClass UtilitiesBillingClass 3
UtilitiesBillingReason UtilitiesBillingReason 2
UtilitiesInstallation UtilitiesInstallation 3
UtilitiesMoveInDate UtilitiesMoveInDate 1
UtilitiesMoveOutDate UtilitiesMoveOutDate 1
UtilitiesRateCategory UtilitiesRateCategory 3
UtilsBillgBlockReason UtilsBillgBlockReason 3
UtilsBillgUnblockReason UtilsBillgUnblockReason 3
UtilsContrToBeBlldDetsType UtilsContrToBeBlldDetsType 1
UtilsContrToBeBlldType UtilsContrToBeBlldType 1
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.

-- Utilities Contract to Be Billed
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSCONTRTOBEBLLD (
    SCHEDULEDMETERREADINGDATE,
    SCHEDULEDUTILITIESBILLINGDATE,
    UTILITIESCONTRACT,
    UTILITIESPORTION,
    _BUSINESSPARTNER,
    _COMPANYCODE,
    _CONTRACC,
    _DIVISION,
    _METERREADINGREASON,
    _METERREADINGUNIT,
    _UTILITIESBILLINGREASON,
    _UTILITIESINSTALLATION,
    _UTILITIESPORTION,
    _UTILITIESRATECATEGORY,
    _UTILSACCOUNTDETNCODE,
    _UTILSBILLGBLOCKREASON,
    _UTILSBILLGUNBLOCKREASON,
    _UTILSBILLINGCLASS,
    _UTILSCONTRTOBEBLLDDETSTYPE,
    _UTILSCONTRTOBEBLLDTYPE,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    COMPANYCODE,
    CONTRACTACCOUNT,
    DIVISION,
    METERREADINGREASON,
    METERREADINGUNIT,
    NMBROFUTILSCONTRACTSTOBEBILLED,
    NMBROFUTILSCONTRBLKDFORBILLG,
    UTILITIESACCOUNTDETNCODE,
    UTILITIESBILLINGCLASS,
    UTILITIESBILLINGREASON,
    UTILITIESINSTALLATION,
    UTILITIESMOVEINDATE,
    UTILITIESMOVEOUTDATE,
    UTILITIESRATECATEGORY,
    UTILSBILLGBLOCKREASON,
    UTILSBILLGUNBLOCKREASON,
    UTILSCONTRTOBEBLLDDETSTYPE,
    UTILSCONTRTOBEBLLDTYPE,
    UTILSPORTIONSCHEDULERECORDDATE,
    PRIMARY KEY (SCHEDULEDMETERREADINGDATE, SCHEDULEDUTILITIESBILLINGDATE, UTILITIESCONTRACT, UTILITIESPORTION)
);

Learn More