I_UTILITIESBILLINGDOCUMENT

CDS View
51 Fields 32 CDS Views

Billing Document

I_UTILITIESBILLINGDOCUMENT is a CDS View in S/4HANA. Billing Document. It contains 51 fields. 32 CDS views read from this table.

CDS Views using this table (32)

ViewTypeJoinVDMDescription
C_OutsrtdUtilsBillgMaLeApply view inner CONSUMPTION Machine Learning Apply Data for Outsorted Billing
C_OutsrtdUtilsBillgMaLeApply view left_outer CONSUMPTION Machine Learning Apply Data for Outsorted Billing
C_OutsrtdUtilsBillgMaLeTrng view inner CONSUMPTION Machine Learning Training Data for Outsorted Billing
C_OutsrtdUtilsBillgMaLeTrng view left_outer CONSUMPTION Machine Learning Training Data for Outsorted Billing
C_UtilsBillingDocumentHistory view from CONSUMPTION Billing Document History
CRMS4_IU_I_UBD view_entity from Utilities Billing Document
I_ActualUtilsBillingDocument view from COMPOSITE Actual Billing Document
I_BR_McgnAllEngyAccountC view inner COMPOSITE Energy Account of Microgen - Cube
I_BR_McgnEngyCnsmr view inner BASIC Microgen Energy Consumer
I_BR_McgnEngyExpryCube view inner COMPOSITE Expired Energy Information
I_OutsrtdUtilsBillgApplyMaLrn view_entity from COMPOSITE Machine learning apply for outsorted billing document
I_OutsrtdUtilsBillgDocBscData view from COMPOSITE Outsorted Billing Document Basic Data
I_OutsrtdUtilsBillgTrngMaLrn view_entity from COMPOSITE Machine learning training for outsorted billing document
I_ReversedUtilsBillingDocument view from COMPOSITE Reversed Billing Document
I_SchedldUtilsContrNotInvcd view left_outer COMPOSITE Scheduled Contract Has not Been Invoiced
I_SchedldUtilsContrUrdyInvcg view left_outer COMPOSITE Scheduled Contract is not Ready for Invoicing
I_UtilitiesBillingDocumentTP view_entity from TRANSACTIONAL Billing Document for Transactional Processing
I_UtilsBillgDocDateInformation view from COMPOSITE Date Information for Utilities Billing Document
I_UtilsBillgDocForContract view from COMPOSITE Utilities Billing Document for Contract
I_UtilsBillgDocIntAndExtPoD view from COMPOSITE Internal and External Point of Delivery for Billing Document
I_UtilsBillgDocOutsrtgChkGrp view inner COMPOSITE Outsorting Data with Current Outsorting Check Group
I_UtilsBillgDocOutsrtgDataCntr view inner COMPOSITE Number of Outsorting Data Records and First Entry
I_UtilsBillgDocPrevYrInvcgDoc view from COMPOSITE Previous Year Invoicing Document for Billing Document
I_UtilsBillgDocPrevYrInvcgDoc view inner COMPOSITE Previous Year Invoicing Document for Billing Document
I_UtilsContrAcctInvcgOrderCntr view inner COMPOSITE Number of Invoicing Orders for Contract Account
I_UtilsContrToBeBlld view left_outer COMPOSITE Utilities Contract to Be Billed
I_UtilsContrToBeBlldInvcdAnlys view left_outer COMPOSITE Analysis of Contract to Be Billed and Invoiced
I_UtilsContrToBeInvcd view left_outer COMPOSITE Contract to Be Invoiced
I_UtilsInvcgDocBillingData view inner COMPOSITE Billing Data for Invoicing Document
P_OutsrtdUtilsBillingDocument view from COMPOSITE
SHSM_ISU_F4_EA16 view from Billing Document with Reversal Transaction Search Help
SHSM_ISU_F4_EA16_ALL view from Billing Document Search Help

Fields (51)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,MicrogenBusinessPartner 7
KEY ContractAccount ContractAccount,MicrogenContractAccount 5
KEY ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate 5
KEY UtilitiesBillingDocument UtilitiesBillingDocument 7
KEY UtilitiesContract MicrogenContract,UtilitiesContract 5
KEY UtilsBillingPeriodValue MicrogenBillPeriodValue 1
_BusinessPartner _BusinessPartner 8
_CompanyCode _CompanyCode 3
_ContractAccountHeader _ContractAccountHeader 3
_ContractAccountPartner _ContractAccountPartner 2
_CreatedByUser _CreatedByUser 2
_Division _Division 3
_LastChangedByUser _LastChangedByUser 2
_ManualUtilsBillgDocCrtnRsn _ManualUtilsBillgDocCrtnRsn 2
_MeterReadingUnit _MeterReadingUnit 3
_UtilitiesBillingReason _UtilitiesBillingReason 4
_UtilitiesContract _UtilitiesContract 5
_UtilitiesPortion _UtilitiesPortion 3
_UtilsAccountClass _UtilsAccountClass 3
_UtilsAccountDetnCode _UtilsAccountDetnCode 2
_UtilsBillgDocDvceLineItem _UtilsBillgDocDvceLineItem 2
_UtilsBillgDocOutsrtgData _UtilsBillgDocOutsrtgData 2
_UtilsBillgDocSimulationRsn _UtilsBillgDocSimulationRsn 2
_UtilsBillingDocReversalRsn _UtilsBillingDocReversalRsn 2
AltvContractAcctForCollvBills AltvContractAcctForCollvBills 2
AuthorizationGroup AuthorizationGroup 4
CompanyCode CompanyCode 4
Division Division 8
ManualUtilsBillgDocCrtnRsn ManualUtilsBillgDocCrtnRsn 2
MeterReadingUnit MeterReadingUnit 3
MnlUtilsBillgDocIsReldForInvcg MnlUtilsBillgDocIsReldForInvcg 2
ScheduledMeterReadingDate ScheduledMeterReadingDate 3
UtilitiesAccountClass UtilitiesAccountClass 7
UtilitiesAccountDetnCode UtilitiesAccountDetnCode 6
UtilitiesBillingReason UtilitiesBillingReason 9
UtilitiesBillingRun UtilitiesBillingRun 2
UtilitiesPortion UtilitiesPortion 7
UtilsBillgDocCreatedByUser UtilsBillgDocCreatedByUser 2
UtilsBillgDocCreationDate UtilsBillgDocCreationDate 2
UtilsBillgDocIsNotReleased UtilsBillgDocIsNotReleased 2
UtilsBillgDocLastChangeDate UtilsBillgDocLastChangeDate 2
UtilsBillgDocLastChangedByUser UtilsBillgDocLastChangedByUser 2
UtilsBillgDocReversalDate UtilsBillgDocReversalDate 2
UtilsBillgDocReversalRsn UtilsBillgDocReversalRsn 2
UtilsBillgPeriodAllocationDate UtilsBillgPeriodAllocationDate 2
UtilsBillgPeriodEndDate MicrogenAllocationDate,MicrogenBillPeriodEndDate,UtilsBillgPeriodEndDate 6
UtilsBillgPeriodStartDate MicrogenBillPeriodStartDate,UtilsBillgPeriodStartDate 6
UtilsBillgSimulationReason UtilsBillgSimulationReason 2
UtilsBusTransactionType UtilsBusTransactionType 2
UtilsPortionScheduleRecordDate UtilsPortionScheduleRecordDate 1
UtilsPreviousBillingDocument UtilsPreviousBillingDocument 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.

-- Billing Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESBILLINGDOCUMENT (
    BUSINESSPARTNER,
    CONTRACTACCOUNT,
    SCHEDULEDUTILITIESBILLINGDATE,
    UTILITIESBILLINGDOCUMENT,
    UTILITIESCONTRACT,
    UTILSBILLINGPERIODVALUE,
    _BUSINESSPARTNER,
    _COMPANYCODE,
    _CONTRACTACCOUNTHEADER,
    _CONTRACTACCOUNTPARTNER,
    _CREATEDBYUSER,
    _DIVISION,
    _LASTCHANGEDBYUSER,
    _MANUALUTILSBILLGDOCCRTNRSN,
    _METERREADINGUNIT,
    _UTILITIESBILLINGREASON,
    _UTILITIESCONTRACT,
    _UTILITIESPORTION,
    _UTILSACCOUNTCLASS,
    _UTILSACCOUNTDETNCODE,
    _UTILSBILLGDOCDVCELINEITEM,
    _UTILSBILLGDOCOUTSRTGDATA,
    _UTILSBILLGDOCSIMULATIONRSN,
    _UTILSBILLINGDOCREVERSALRSN,
    ALTVCONTRACTACCTFORCOLLVBILLS,
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    DIVISION,
    MANUALUTILSBILLGDOCCRTNRSN,
    METERREADINGUNIT,
    MNLUTILSBILLGDOCISRELDFORINVCG,
    SCHEDULEDMETERREADINGDATE,
    UTILITIESACCOUNTCLASS,
    UTILITIESACCOUNTDETNCODE,
    UTILITIESBILLINGREASON,
    UTILITIESBILLINGRUN,
    UTILITIESPORTION,
    UTILSBILLGDOCCREATEDBYUSER,
    UTILSBILLGDOCCREATIONDATE,
    UTILSBILLGDOCISNOTRELEASED,
    UTILSBILLGDOCLASTCHANGEDATE,
    UTILSBILLGDOCLASTCHANGEDBYUSER,
    UTILSBILLGDOCREVERSALDATE,
    UTILSBILLGDOCREVERSALRSN,
    UTILSBILLGPERIODALLOCATIONDATE,
    UTILSBILLGPERIODENDDATE,
    UTILSBILLGPERIODSTARTDATE,
    UTILSBILLGSIMULATIONREASON,
    UTILSBUSTRANSACTIONTYPE,
    UTILSPORTIONSCHEDULERECORDDATE,
    UTILSPREVIOUSBILLINGDOCUMENT,
    PRIMARY KEY (BUSINESSPARTNER, CONTRACTACCOUNT, SCHEDULEDUTILITIESBILLINGDATE, UTILITIESBILLINGDOCUMENT, UTILITIESCONTRACT, UTILSBILLINGPERIODVALUE)
);

Learn More