I_UTILITIESCONTRACT

CDS View
49 Fields 35 CDS Views

Contract

I_UTILITIESCONTRACT is a CDS View in S/4HANA. Contract. It contains 49 fields. 35 CDS views read from this table.

CDS Views using this table (35)

ViewTypeJoinVDMDescription
C_OutsrtdUtilsBillgMaLeApply view inner CONSUMPTION Machine Learning Apply Data for Outsorted Billing
C_OutsrtdUtilsBillgMaLeTrng view inner CONSUMPTION Machine Learning Training Data for Outsorted Billing
C_UtilitiesContractDP view_entity from CONSUMPTION Data Provider for utilities contract
CRMS4_IU_I_UTCT view from Utilities Contract
CRMS4_IU_P_CNTBPC view left_outer Business partner ISU-Contracts count
CRMS4_IU_P_PODBP view inner Point of Delivery by Business Partner
CRMS4_IU_P_PRMBP view inner Premise by Business Partner
I_BR_McgnAllEngyAccountC view inner COMPOSITE Energy Account of Microgen - Cube
I_BR_McgnEngyExpryCube view inner COMPOSITE Expired Energy Information
I_NonBllbleUtilsBillgOrderCntr view inner COMPOSITE Non-Billable Billing Order Counter
I_OpenUtilsBillgDocAndOrdData view inner COMPOSITE Open Utilities Billing Document and Order Data
I_SpprsdUtilsBillgOrdWthDets view inner COMPOSITE Suppressed Utilities Billing Order with Details
I_SuppressedUtilsBillgOrd view inner COMPOSITE Suppressed Utilities Billing Order
I_UtilitiesContractTP view_entity from TRANSACTIONAL Utilities Contract
I_UtilitiesContractVH view from COMPOSITE Contract Value Help
I_UtilitiesLossContractVH view from BASIC ISU BR Engy Loss Contract
I_UtilsBillgDocIntAndExtPoD view inner COMPOSITE Internal and External Point of Delivery for Billing Document
I_UtilsBillgDocOutsrtgChkGrp view inner COMPOSITE Outsorting Data with Current Outsorting Check Group
I_UtilsBillgDocPrevYrInvcgDoc view inner COMPOSITE Previous Year Invoicing Document for Billing Document
I_UtilsBillgOrderForContract view inner COMPOSITE Billing Order For Contract
I_UtilsBillingOrder view inner COMPOSITE Utilities Billing Order
I_UtilsContrAcctInvcgOrderCntr view inner COMPOSITE Number of Invoicing Orders for Contract Account
I_UtilsContractBlkdForBillg view from COMPOSITE Contract Blocked For Billing
I_UtilsContractBlkdForBillg view union_all COMPOSITE Contract Blocked For Billing
I_UtilsContractKeyDateAnalysis view from COMPOSITE Key Date-Based Utilities Contract Analysis
I_UtilsContractKeyDateAnalysis view union_all COMPOSITE Key Date-Based Utilities Contract Analysis
I_UtilsContractProductChanges view from COMPOSITE Utilities Contract Product Changes
I_UtilsContractToBeBilled view inner COMPOSITE Contract To Be Billed
I_UtilsContrToBeBlldData view from COMPOSITE Utilities Contract to Be Billed Data
I_UtilsContrToBeBlldData view union_all COMPOSITE Utilities Contract to Be Billed Data
I_UtilsInvcgDocBillingData view inner COMPOSITE Billing Data for Invoicing Document
P_ISU_CSML_CONTRACTVH_BR view from BASIC
P_ISU_CSML_INSTALLATIONVH_BR view from COMPOSITE
P_SuppressedUtilsBillingOrder view inner COMPOSITE
P_UtilsContractSRCH view_entity from BASIC

Fields (49)

KeyField CDS FieldsUsed in Views
KEY ContractAccount ContractAccount 7
KEY UtilitiesContract UtilitiesContract 17
KEY UtilitiesInstallation MicrogenInstallation,UtilitiesInstallation 12
_CADunningProcedure _CADunningProcedure 3
_CompanyCode _CompanyCode 11
_CreatedByUser _CreatedByUser 1
_Division _Division 11
_InvcUtilsContractsJointly _InvcUtilsContractsJointly 6
_LastChangedByUser _LastChangedByUser 1
_UtilitiesContractHistory _UtilitiesContractHistory 2
_UtilitiesInstallation _UtilitiesInstallation 7
_UtilitiesPortion _UtilitiesPortion 1
_UtilitiesServiceProvider _UtilitiesServiceProvider 3
_UtilsAccountDetnCode _UtilsAccountDetnCode 9
_UtilsBillgBlockReason _UtilsBillgBlockReason 9
_UtilsBillgOutsortingGroup _UtilsBillgOutsortingGroup 4
_UtilsBillgUnblockReason _UtilsBillgUnblockReason 8
_UtilsContrProcessingStatus _UtilsContrProcessingStatus 3
_UtilsContrSpcfcBdgtBillgCyc _UtilsContrSpcfcBdgtBillgCyc 4
_UtilsOutsrtgChkGrpBillg _UtilsOutsrtgChkGrpBillg 2
_UtilsPlantOrCompanyCnsmpn _UtilsPlantOrCompanyCnsmpn 3
AlternativeUtilitiesPortion AlternativeUtilitiesPortion 4
AuthorizationGroup AuthorizationGroup 14
CADunningProcedure CADunningProcedure 5
CompanyCode CompanyCode 14
DeletionIndicator DeletionIndicator 5
LastUtilitiesPortion LastUtilitiesPortion 2
UtilitiesAccountDetnCode UtilitiesAccountDetnCode 11
UtilitiesContractCanclnDate UtilitiesContractCanclnDate 5
UtilitiesContractDescription UtilitiesContractDescription 3
UtilitiesContractRenewalDate UtilitiesContractRenewalDate 5
UtilitiesDivision Division,UtilitiesDivision 14
UtilitiesMoveInDate UtilitiesMoveInDate 14
UtilitiesMoveOutDate UtilitiesMoveOutDate 14
UtilitiesServiceProvider UtilitiesServiceProvider 5
UtilsBillgBlockReason UtilsBillgBlockReason 11
UtilsBillgOutsortingReason UtilsBillgOutsortingReason 6
UtilsBillgUnblockReason UtilsBillgUnblockReason 10
UtilsContractCreatedByUser UtilsContractCreatedByUser 5
UtilsContractCreationDate UtilsContractCreationDate 5
UtilsContractLastChangeDate UtilsContractLastChangeDate 5
UtilsContractLastChangedByUser UtilsContractLastChangedByUser 4
UtilsContractProcessingSts UtilsContractProcessingSts 5
UtilsContrIsBilledManually UtilsContrIsBilledManually 6
UtilsContrIsFinallyBilled UtilsContrIsFinallyBilled 3
UtilsContrJointInvcType UtilsContrJointInvcType 8
UtilsContrSpcfcBdgtBillgCycle UtilsContrSpcfcBdgtBillgCycle 6
UtilsOutsrtgCheckGrpForBillg UtilsOutsrtgCheckGrpForBillg 4
UtilsPlantOrCompanyConsumption UtilsPlantOrCompanyConsumption 5

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.

-- Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESCONTRACT (
    CONTRACTACCOUNT,
    UTILITIESCONTRACT,
    UTILITIESINSTALLATION,
    _CADUNNINGPROCEDURE,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DIVISION,
    _INVCUTILSCONTRACTSJOINTLY,
    _LASTCHANGEDBYUSER,
    _UTILITIESCONTRACTHISTORY,
    _UTILITIESINSTALLATION,
    _UTILITIESPORTION,
    _UTILITIESSERVICEPROVIDER,
    _UTILSACCOUNTDETNCODE,
    _UTILSBILLGBLOCKREASON,
    _UTILSBILLGOUTSORTINGGROUP,
    _UTILSBILLGUNBLOCKREASON,
    _UTILSCONTRPROCESSINGSTATUS,
    _UTILSCONTRSPCFCBDGTBILLGCYC,
    _UTILSOUTSRTGCHKGRPBILLG,
    _UTILSPLANTORCOMPANYCNSMPN,
    ALTERNATIVEUTILITIESPORTION,
    AUTHORIZATIONGROUP,
    CADUNNINGPROCEDURE,
    COMPANYCODE,
    DELETIONINDICATOR,
    LASTUTILITIESPORTION,
    UTILITIESACCOUNTDETNCODE,
    UTILITIESCONTRACTCANCLNDATE,
    UTILITIESCONTRACTDESCRIPTION,
    UTILITIESCONTRACTRENEWALDATE,
    UTILITIESDIVISION,
    UTILITIESMOVEINDATE,
    UTILITIESMOVEOUTDATE,
    UTILITIESSERVICEPROVIDER,
    UTILSBILLGBLOCKREASON,
    UTILSBILLGOUTSORTINGREASON,
    UTILSBILLGUNBLOCKREASON,
    UTILSCONTRACTCREATEDBYUSER,
    UTILSCONTRACTCREATIONDATE,
    UTILSCONTRACTLASTCHANGEDATE,
    UTILSCONTRACTLASTCHANGEDBYUSER,
    UTILSCONTRACTPROCESSINGSTS,
    UTILSCONTRISBILLEDMANUALLY,
    UTILSCONTRISFINALLYBILLED,
    UTILSCONTRJOINTINVCTYPE,
    UTILSCONTRSPCFCBDGTBILLGCYCLE,
    UTILSOUTSRTGCHECKGRPFORBILLG,
    UTILSPLANTORCOMPANYCONSUMPTION,
    PRIMARY KEY (CONTRACTACCOUNT, UTILITIESCONTRACT, UTILITIESINSTALLATION)
);

Learn More