I_UTILSCONTRTOBEBLLDINVCDANLYS

CDS View
44 Fields 1 CDS Views

Analysis of Contract to Be Billed and Invoiced

I_UTILSCONTRTOBEBLLDINVCDANLYS is a CDS View in S/4HANA. Analysis of Contract to Be Billed and Invoiced. It contains 44 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_UtilsContrToBeBlldInvcdAnlys view from CONSUMPTION Analysis of Contract to Be Billed and Invoiced

Fields (44)

KeyField CDS FieldsUsed in Views
KEY ScheduledMeterReadingDate ScheduledMeterReadingDate 1
KEY ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate 1
KEY UtilitiesContract UtilitiesContract 1
KEY UtilitiesPortion UtilitiesPortion 1
_AltvContrAcc _AltvContrAcc 1
_BusinessPartner _BusinessPartner 1
_CAInvcgLockReason _CAInvcgLockReason 1
_CompanyCode _CompanyCode 1
_ContractAccountHeader _ContractAccountHeader 1
_Division _Division 1
_MeterReadingUnit _MeterReadingUnit 1
_UtilitiesInstallation _UtilitiesInstallation 1
_UtilitiesPortion _UtilitiesPortion 1
_UtilitiesRateCategory _UtilitiesRateCategory 1
_UtilsAccountDetnCode _UtilsAccountDetnCode 1
_UtilsBillgBlockReason _UtilsBillgBlockReason 1
_UtilsBillgUnblockReason _UtilsBillgUnblockReason 1
_UtilsBillingClass _UtilsBillingClass 1
_UtilsContrToBeBlldDetsType _UtilsContrToBeBlldDetsType 1
_UtilsContrToBeBlldType _UtilsContrToBeBlldType 1
_UtilsContrToBeInvcdPrgrs _UtilsContrToBeInvcdPrgrs 1
_UtilsContrToBeInvcdPrgrsSts _UtilsContrToBeInvcdPrgrsSts 1
_UtilsInstIntAndExtPtOfDeliv _UtilsInstIntAndExtPtOfDeliv 1
AltvContractAcctForCollvBills AltvContractAcctForCollvBills 1
AuthorizationGroup AuthorizationGroup 1
BusinessPartner BusinessPartner 1
CABusinessLockReason CABusinessLockReason 1
CompanyCode CompanyCode 1
ContractAccount ContractAccount 1
Division Division 1
MeterReadingUnit MeterReadingUnit 1
NmbrOfUtilsContrToBeInvoiced NmbrOfUtilsContrToBeInvoiced 1
UtilitiesAccountDetnCode UtilitiesAccountDetnCode 1
UtilitiesBillingClass UtilitiesBillingClass 1
UtilitiesInstallation UtilitiesInstallation 1
UtilitiesMoveInDate UtilitiesMoveInDate 1
UtilitiesMoveOutDate UtilitiesMoveOutDate 1
UtilitiesRateCategory UtilitiesRateCategory 1
UtilsBillgBlockReason UtilsBillgBlockReason 1
UtilsBillgUnblockReason UtilsBillgUnblockReason 1
UtilsContrToBeBlldDetsType UtilsContrToBeBlldDetsType 1
UtilsContrToBeBlldType UtilsContrToBeBlldType 1
UtilsContrToBeInvcdPrgrs UtilsContrToBeInvcdPrgrs 1
UtilsContrToBeInvcdPrgrsSts UtilsContrToBeInvcdPrgrsSts 1

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.

-- Analysis of Contract to Be Billed and Invoiced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILSCONTRTOBEBLLDINVCDANLYS (
    SCHEDULEDMETERREADINGDATE,
    SCHEDULEDUTILITIESBILLINGDATE,
    UTILITIESCONTRACT,
    UTILITIESPORTION,
    _ALTVCONTRACC,
    _BUSINESSPARTNER,
    _CAINVCGLOCKREASON,
    _COMPANYCODE,
    _CONTRACTACCOUNTHEADER,
    _DIVISION,
    _METERREADINGUNIT,
    _UTILITIESINSTALLATION,
    _UTILITIESPORTION,
    _UTILITIESRATECATEGORY,
    _UTILSACCOUNTDETNCODE,
    _UTILSBILLGBLOCKREASON,
    _UTILSBILLGUNBLOCKREASON,
    _UTILSBILLINGCLASS,
    _UTILSCONTRTOBEBLLDDETSTYPE,
    _UTILSCONTRTOBEBLLDTYPE,
    _UTILSCONTRTOBEINVCDPRGRS,
    _UTILSCONTRTOBEINVCDPRGRSSTS,
    _UTILSINSTINTANDEXTPTOFDELIV,
    ALTVCONTRACTACCTFORCOLLVBILLS,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    CABUSINESSLOCKREASON,
    COMPANYCODE,
    CONTRACTACCOUNT,
    DIVISION,
    METERREADINGUNIT,
    NMBROFUTILSCONTRTOBEINVOICED,
    UTILITIESACCOUNTDETNCODE,
    UTILITIESBILLINGCLASS,
    UTILITIESINSTALLATION,
    UTILITIESMOVEINDATE,
    UTILITIESMOVEOUTDATE,
    UTILITIESRATECATEGORY,
    UTILSBILLGBLOCKREASON,
    UTILSBILLGUNBLOCKREASON,
    UTILSCONTRTOBEBLLDDETSTYPE,
    UTILSCONTRTOBEBLLDTYPE,
    UTILSCONTRTOBEINVCDPRGRS,
    UTILSCONTRTOBEINVCDPRGRSSTS,
    PRIMARY KEY (SCHEDULEDMETERREADINGDATE, SCHEDULEDUTILITIESBILLINGDATE, UTILITIESCONTRACT, UTILITIESPORTION)
);

Learn More