I_UTILITIESBILLINGDOCUMENTTP

CDS View
17 Fields 3 CDS Views

Billing Document for Transactional Processing

I_UTILITIESBILLINGDOCUMENTTP is a CDS View in S/4HANA. Billing Document for Transactional Processing. It contains 17 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_OutsrtdUtilsBillgDoc view_entity projection CONSUMPTION Outsorted Billing Document
C_OutsrtdUtilsBillingDoc view from CONSUMPTION Outsorted Utilities Billing Document
I_OpenUtilsBillgDocAndOrdData view union_all COMPOSITE Open Utilities Billing Document and Order Data

Fields (17)

KeyField CDS FieldsUsed in Views
KEY ScheduledUtilitiesBillingDate ScheduledUtilitiesBillingDate 2
KEY UtilitiesBillingDocument UtilitiesBillingDocument 1
KEY UtilitiesBillingReason UtilitiesBillingReason 2
KEY UtilitiesInstallation UtilitiesInstallation 2
_BusinessPartner _BusinessPartner 1
_MeterReadingUnit _MeterReadingUnit 1
_UtilitiesBillingReason _UtilitiesBillingReason 2
_UtilitiesContract _UtilitiesContract 1
_UtilitiesPortion _UtilitiesPortion 1
AuthorizationGroup AuthorizationGroup 1
BusinessPartner BusinessPartner 1
ContractAccount ContractAccount 1
MeterReadingUnit MeterReadingUnit 2
ScheduledMeterReadingDate ScheduledMeterReadingDate 2
UtilitiesContract UtilitiesContract 1
UtilitiesPortion UtilitiesPortion 2
UtilsBillgPeriodEndDate 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.

-- Billing Document for Transactional Processing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESBILLINGDOCUMENTTP (
    SCHEDULEDUTILITIESBILLINGDATE,
    UTILITIESBILLINGDOCUMENT,
    UTILITIESBILLINGREASON,
    UTILITIESINSTALLATION,
    _BUSINESSPARTNER,
    _METERREADINGUNIT,
    _UTILITIESBILLINGREASON,
    _UTILITIESCONTRACT,
    _UTILITIESPORTION,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    CONTRACTACCOUNT,
    METERREADINGUNIT,
    SCHEDULEDMETERREADINGDATE,
    UTILITIESCONTRACT,
    UTILITIESPORTION,
    UTILSBILLGPERIODENDDATE,
    PRIMARY KEY (SCHEDULEDUTILITIESBILLINGDATE, UTILITIESBILLINGDOCUMENT, UTILITIESBILLINGREASON, UTILITIESINSTALLATION)
);

Learn More