I_UTILITIESBILLINGDOCUMENTTP
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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 |
@EndUserText.label: 'Billing Document for Transactional Processing'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
//Begin of BOPF
@ObjectModel.modelCategory: #BUSINESS_OBJECT
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.sapObjectNodeType.name: 'UtilitiesBillingDocument'
//End of BOPF
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
define root view entity I_UtilitiesBillingDocumentTP
as select from I_UtilitiesBillingDocument as UtilitiesBillingDocument
left outer to one join I_UtilsBillingLtstBPEMCase as I_UtilsBillingLtstBPEMCase on I_UtilsBillingLtstBPEMCase.UtilitiesBillingDocument = UtilitiesBillingDocument.UtilitiesBillingDocument
association [1..1] to I_UtilsBillgDocTotalNetAmt as _UtilsBillgDocTotalNetAmt on $projection.UtilitiesBillingDocument = _UtilsBillgDocTotalNetAmt.UtilitiesBillingDocument
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
association [0..1] to I_UtilitiesPortionScheduleRecd as _UtilitiesPortionScheduleRecd on $projection.UtilitiesPortion = _UtilitiesPortionScheduleRecd.UtilitiesPortion
and $projection.ScheduledUtilitiesBillingDate = _UtilitiesPortionScheduleRecd.ScheduledUtilitiesBillingDate
// association [0..1] to I_UtilsAllocOfInstToPoD as _UtilsAllocOfInstToPoD
// on $projection.utilitiesinstallation = _UtilsAllocOfInstToPoD.UtilitiesInstallation
// and $projection.UtilsBillgPeriodEndDate >= _UtilsAllocOfInstToPoD.UtilsInstToPoDAllocStartDate
// and _UtilsAllocOfInstToPoD.UtilsInstToPoDAllocStartTime >= '000000'
// and $projection.UtilsBillgPeriodEndDate <= _UtilsAllocOfInstToPoD.UtilsInstToPoDAllocEndDate
// and _UtilsAllocOfInstToPoD.UtilsInstToPoDAllocEndTime <= '235959'
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
association [1..1] to I_UtilitiesInstallationHist as _UtilitiesInstallationHist on $projection.utilitiesinstallation = _UtilitiesInstallationHist.UtilitiesInstallation
and $projection.UtilsBillgPeriodEndDate >= _UtilitiesInstallationHist.UtilsInstHistValidityStartDate
and $projection.UtilsBillgPeriodEndDate <= _UtilitiesInstallationHist.UtilsInstHistValidityEndDate
association [1..1] to I_UtilitiesPremise as _UtilitiesPremise on $projection.utilitiespremise = _UtilitiesPremise.UtilitiesPremise
association [0..1] to I_UtilsAllocOfExtToIntPoD as _UtilsAllocOfExtToIntPoD on $projection.utilsinternalpointofdelivery = _UtilsAllocOfExtToIntPoD.UtilsInternalPointOfDelivery
and _UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndDate = '99991231'
and _UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndTime = '235959'
association [0..1] to I_OutsrtdUtilsBillgDocMaLeRslt as _OutsrtdUtilsBillgDocMaLeRslt on $projection.UtilitiesBillingDocument = _OutsrtdUtilsBillgDocMaLeRslt.UtilitiesBillingDocument
//Interim Solution because of performance problems: access with timestamp (31.12.9999, 23:59) instead of end of billing period
// and (
// (
// $projection.UtilsBillgPeriodEndDate < _UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndDate and
// $projection.UtilsBillgPeriodEndDate >= _UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityStartDate
// ) or
// (
// $projection.UtilsBillgPeriodEndDate = _UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndDate and
// _UtilsAllocOfExtToIntPoD.UtilsPoDAllocValidityEndTime ='235959'
// )
//)
association [0..1] to I_UtilsBillgDocIntAndExtPoD as _UtilsBillgDocIntAndExtPoD on $projection.UtilitiesBillingDocument = _UtilsBillgDocIntAndExtPoD.UtilitiesBillingDocument
association [1..1] to I_UtilsBillgDocOutsrtgDataCntr as _UtilsBillgDocOutsrtgDataCntr on $projection.UtilitiesBillingDocument = _UtilsBillgDocOutsrtgDataCntr.UtilitiesBillingDocument
association [1..1] to I_UtilsBillgDocOutsrtgDataRsn as _UtilsBillgDocOutsrtgDataRsn on $projection.UtilitiesBillingDocument = _UtilsBillgDocOutsrtgDataRsn.UtilitiesBillingDocument
association [1..1] to I_CalendarDate as _CalendarDate on $projection.ScheduledUtilitiesBillingDate = _CalendarDate.CalendarDate
association [1..1] to I_OutsrtdUtilsBillgDocTotAmt as _OutsrtdUtilsBillgDocTotAmt on $projection.UtilitiesBillingDocument = _OutsrtdUtilsBillgDocTotAmt.UtilitiesBillingDocument
association [0..1] to E_UtilitiesBillingDocument as _UtilsBillingDocumentExtension on $projection.UtilitiesBillingDocument = _UtilsBillingDocumentExtension.UtilitiesBillingDocument
{
key UtilitiesBillingDocument.UtilitiesBillingDocument,
@ObjectModel.foreignKey.association: '_CompanyCode'
UtilitiesBillingDocument.CompanyCode,
@ObjectModel.foreignKey.association: '_BusinessPartner'
UtilitiesBillingDocument.BusinessPartner,
UtilitiesBillingDocument.ContractAccount,
@ObjectModel.foreignKey.association: '_UtilitiesContract'
UtilitiesBillingDocument.UtilitiesContract,
UtilitiesBillingDocument.UtilsBusTransactionType,
@ObjectModel.foreignKey.association: '_UtilitiesBillingReason'
UtilitiesBillingDocument.UtilitiesBillingReason,
@Semantics.businessDate.from: true
UtilitiesBillingDocument.UtilsBillgPeriodStartDate,
@Semantics.businessDate.to: true
UtilitiesBillingDocument.UtilsBillgPeriodEndDate,
@ObjectModel.foreignKey.association: '_Division'
UtilitiesBillingDocument.Division,
@ObjectModel.foreignKey.association: '_UtilsBillgDocSimulationRsn'
UtilitiesBillingDocument.UtilsBillgSimulationReason,
UtilitiesBillingDocument.UtilsBillgDocIsNotReleased,
UtilitiesBillingDocument.UtilsBillgDocReversalDate,
@ObjectModel.foreignKey.association: '_UtilsBillingDocReversalRsn'
UtilitiesBillingDocument.UtilsBillgDocReversalRsn,
UtilitiesBillingDocument.UtilsBillgPeriodAllocationDate,
@ObjectModel.foreignKey.association: '_UtilitiesPortion'
UtilitiesBillingDocument.UtilitiesPortion,
@Semantics.businessDate.at: true
UtilitiesBillingDocument.ScheduledUtilitiesBillingDate,
@ObjectModel.foreignKey.association: '_MeterReadingUnit'
UtilitiesBillingDocument.MeterReadingUnit,
UtilitiesBillingDocument.ScheduledMeterReadingDate,
@ObjectModel.foreignKey.association: '_ManualUtilsBillgDocCrtnRsn'
UtilitiesBillingDocument.ManualUtilsBillgDocCrtnRsn,
UtilitiesBillingDocument.MnlUtilsBillgDocIsReldForInvcg,
UtilitiesBillingDocument.UtilitiesBillingRun,
@Semantics.systemDate.createdAt: true
UtilitiesBillingDocument.UtilsBillgDocCreationDate,
@Semantics.user.createdBy
UtilitiesBillingDocument.UtilsBillgDocCreatedByUser,
@Semantics.systemDate.lastChangedAt: true
UtilitiesBillingDocument.UtilsBillgDocLastChangeDate,
@Semantics.user.lastChangedBy
UtilitiesBillingDocument.UtilsBillgDocLastChangedByUser,
UtilitiesBillingDocument.AuthorizationGroup,
@ObjectModel.foreignKey.association: '_UtilsAccountClass'
UtilitiesBillingDocument.UtilitiesAccountClass,
UtilitiesBillingDocument.UtilsPreviousBillingDocument,
UtilitiesBillingDocument.AltvContractAcctForCollvBills,
@ObjectModel.foreignKey.association: '_UtilsAccountDetnCode'
UtilitiesBillingDocument.UtilitiesAccountDetnCode,
@ObjectModel.foreignKey.association: '_UtilitiesInstallation'
UtilitiesBillingDocument._UtilitiesContract.UtilitiesInstallation,
UtilitiesBillingDocument._UtilitiesContract._UtilitiesInstallation.UtilitiesPremise,
_UtilsBillgDocIntAndExtPoD.UtilsInternalPointOfDelivery,
(_UtilsBillgDocOutsrtgDataCntr.NmbrOfBillgDocOutsrtgDataRecd - 1) as NmbrOfBillgDocOutsrtgDataRecd,
fltp_to_dec(_OutsrtdUtilsBillgDocMaLeRslt.UtilsMchnLrngRelConfidenceVal as e_rel_confidence_vdm) as UtilsMchnLrngRelConfidenceVal,
_UtilsBillgDocOutsrtgDataCntr._UtilsBillgDocOutsrtgChkGrp.UtilsOutsrtgCheckGrpForBillg,
_UtilsBillgDocOutsrtgDataCntr._UtilsBillgDocOutsrtgChkGrp.UtilitiesBillingCheck,
_UtilsBillgDocOutsrtgDataCntr._UtilsBillgDocOutsrtgChkGrp.UtilsOutsrtdBillgDocDvtgValue,
_UtilsBillgDocOutsrtgDataCntr._UtilsBillgDocOutsrtgChkGrp.UtilsSequenceNumberOutsrtg,
// BPEM
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCase as e_clarificationcase_vdm preserving type) as BPEMCase,
I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseCurrentProcessor,
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._User.UserDescription,
@ObjectModel.foreignKey.association: '_BPEMCaseCategory'
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseCategory as e_clarcasecategory_vdm preserving type) as BPEMCaseCategory,
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCasePreviousProcessor as e_clarcaseprevproc_vdm preserving type) as BPEMCasePreviousProcessor,
@UI.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._PreviousUser.UserDescription as LastChangedByUserDescription,
@ObjectModel.foreignKey.association: '_BPEMBusinessProcessCode'
I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMBusinessProcessCode,
@ObjectModel.foreignKey.association: '_BPEMCaseForwardReason'
I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseForwardingReason,
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseCreationDate as e_clarcasecreationdate_vdm preserving type) as BPEMCaseCreationDate,
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseDueDate as e_clarcaseduedate_vdm preserving type) as BPEMCaseDueDate,
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseOriginalDate as e_clarcaseorigdate_vdm preserving type) as BPEMCaseOriginalDate,
@ObjectModel.foreignKey.association: '_BPEMCasePriority'
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCasePriority as e_clarcasepriority_vdm preserving type) as BPEMCasePriority,
// @ObjectModel.foreignKey.association: '_OpenBPEMCaseStatus' e_clarcasestatus_vdm
cast(I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCaseStatus as e_clarificationcasestatus_vdm) as BPEMCaseStatus,
// in order to dynamically enable/disable BPEM actions in frontend
@UI.hidden: true
case when I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCase is null then cast('' as boolean )
when I_UtilsBillingLtstBPEMCase._OpenBPEMCase.BPEMCase is not null then cast('X' as boolean)
end as BPEMCaseIsExisting,
//needed for OVP
UtilitiesBillingDocument._UtilitiesContract.UtilsBillgBlockReason,
UtilitiesBillingDocument._UtilitiesContract.UtilsBillgUnblockReason,
UtilitiesBillingDocument._UtilitiesContract.UtilsContrSpcfcBdgtBillgCycle,
UtilitiesBillingDocument._UtilitiesPortion.UtilsDefaultBdgtBillgCycle,
_UtilsBillgDocOutsrtgDataRsn._UtilsBillgDocOutsrtgData.UtilsBillgOutsortingReason,
@ObjectModel.foreignKey.association: '_CalendarMonth'
cast(_CalendarDate.CalendarMonth as e_schdldmnth_vdm preserving type) as CalendarMonth,
@ObjectModel.foreignKey.association: '_CalendarYear'
cast(_CalendarDate.CalendarYear as e_schdldyr_vdm preserving type) as CalendarYear,
cast('' as abap.sstring( 256 )) as UtilsPostalAddressFormatted,
_OutsrtdUtilsBillgDocTotAmt.UtilsBillgDocTotalNetAmt,
_OutsrtdUtilsBillgDocTotAmt.UtilsBillgDocTransactionCrcy,
/* Associations */
UtilitiesBillingDocument._BusinessPartner,
UtilitiesBillingDocument._CompanyCode,
UtilitiesBillingDocument._CreatedByUser,
UtilitiesBillingDocument._Division,
UtilitiesBillingDocument._LastChangedByUser,
UtilitiesBillingDocument._ManualUtilsBillgDocCrtnRsn,
UtilitiesBillingDocument._MeterReadingUnit,
UtilitiesBillingDocument._UtilitiesBillingReason,
UtilitiesBillingDocument._UtilitiesContract,
UtilitiesBillingDocument._UtilitiesPortion,
UtilitiesBillingDocument._UtilsAccountClass,
UtilitiesBillingDocument._UtilsBillgDocDvceLineItem,
UtilitiesBillingDocument._UtilsBillgDocOutsrtgData,
UtilitiesBillingDocument._UtilsBillgDocSimulationRsn,
UtilitiesBillingDocument._UtilsBillingDocReversalRsn,
UtilitiesBillingDocument._ContractAccountPartner,
UtilitiesBillingDocument._UtilsAccountDetnCode as _UtilsAccountDetnCode,
_UtilsBillgDocTotalNetAmt,
_UtilitiesPortionScheduleRecd,
_UtilitiesInstallationHist,
_UtilitiesPremise,
// _UtilsAllocOfInstToPoD,
_UtilsAllocOfExtToIntPoD,
_UtilsBillgDocIntAndExtPoD,
UtilitiesBillingDocument._UtilitiesContract._UtilitiesInstallation,
_UtilsBillgDocOutsrtgDataCntr,
_UtilsBillgDocOutsrtgDataCntr._UtilsBillgDocOutsrtgChkGrp._UtilsOutsrtgChkGrpBillg as _UtilsOutsrtgChkGrpBillg,
_OutsrtdUtilsBillgDocMaLeRslt,
UtilitiesBillingDocument._UtilitiesContract._UtilsBillgBlockReason,
UtilitiesBillingDocument._UtilitiesContract._UtilsBillgUnblockReason,
UtilitiesBillingDocument._UtilitiesContract._UtilsContrSpcfcBdgtBillgCyc,
UtilitiesBillingDocument._UtilitiesPortion._UtilitiesBdgtBillgCyc,
_UtilsBillgDocOutsrtgDataRsn,
_UtilsBillgDocOutsrtgDataRsn._UtilsBillgDocOutsrtgData._UtilsBillgOutsortingGroup as _UtilsBillgOutsortingGroup,
_CalendarDate,
_CalendarDate._CalendarMonth,
_CalendarDate._CalendarYear,
_OutsrtdUtilsBillgDocTotAmt,
//BPEM Integration
// @Consumption.filter.hidden: true
// _BPEMCaseTP,
@Consumption.filter.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._BPEMBusinessProcessCode,
@Consumption.filter.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._BPEMCaseCategory,
@Consumption.filter.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._BPEMCasePriority,
// @Consumption.filter.hidden: true
// _OpenBPEMCaseStatus,
@Consumption.filter.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._User,
@Consumption.filter.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._PreviousUser,
@Consumption.filter.hidden: true
I_UtilsBillingLtstBPEMCase._OpenBPEMCase._BPEMCaseForwardReason
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_OPENBPEMCASE",
"I_OUTSRTDUTILSBILLGDOCMALERSLT",
"I_OUTSRTDUTILSBILLGDOCTOTAMT",
"I_USER",
"I_UTILITIESBILLINGDOCUMENT",
"I_UTILITIESCONTRACT",
"I_UTILITIESINSTALLATION",
"I_UTILITIESPORTION",
"I_UTILSBILLGDOCINTANDEXTPOD",
"I_UTILSBILLGDOCOUTSRTGCHKGRP",
"I_UTILSBILLGDOCOUTSRTGDATA",
"I_UTILSBILLGDOCOUTSRTGDATACNTR",
"I_UTILSBILLGDOCOUTSRTGDATARSN",
"I_UTILSBILLINGLTSTBPEMCASE"
],
"ASSOCIATED":
[
"I_BPEMBUSINESSPROCESSCODE",
"I_BPEMCASECATEGORY",
"I_BPEMCASEFORWARDREASON",
"I_BPEMCASEPRIORITY",
"I_BUSINESSPARTNER",
"I_CALENDARDATE",
"I_CALENDARMONTH",
"I_CALENDARYEAR",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTPARTNER",
"I_DIVISION",
"I_MANUALUTILSBILLGDOCCRTNRSN",
"I_METERREADINGUNIT",
"I_OUTSRTDUTILSBILLGDOCMALERSLT",
"I_OUTSRTDUTILSBILLGDOCTOTAMT",
"I_USER",
"I_UTILITIESBILLINGREASON",
"I_UTILITIESCONTRACT",
"I_UTILITIESINSTALLATION",
"I_UTILITIESINSTALLATIONHIST",
"I_UTILITIESPORTION",
"I_UTILITIESPORTIONSCHEDULERECD",
"I_UTILITIESPREMISE",
"I_UTILSACCOUNTCLASS",
"I_UTILSACCOUNTDETNCODE",
"I_UTILSALLOCOFEXTTOINTPOD",
"I_UTILSBILLGBLOCKREASON",
"I_UTILSBILLGDOCDVCELINEITEM",
"I_UTILSBILLGDOCINTANDEXTPOD",
"I_UTILSBILLGDOCOUTSRTGDATA",
"I_UTILSBILLGDOCOUTSRTGDATACNTR",
"I_UTILSBILLGDOCOUTSRTGDATARSN",
"I_UTILSBILLGDOCSIMULATIONRSN",
"I_UTILSBILLGDOCTOTALNETAMT",
"I_UTILSBILLGOUTSORTINGGROUP",
"I_UTILSBILLGUNBLOCKREASON",
"I_UTILSBILLINGDOCREVERSALRSN",
"I_UTILSCONTRSPCFCBDGTBILLGCYC",
"I_UTILSOUTSRTGCHKGRPBILLG",
"I_UTILSPORTNDFLTBDGTBILLGCYC"
],
"BASE":
[
"I_CALENDARDATE",
"I_OPENBPEMCASE",
"I_UTILITIESBILLINGDOCUMENT",
"I_UTILITIESCONTRACT",
"I_UTILITIESPORTION",
"I_UTILSBILLGDOCOUTSRTGCHKGRP",
"I_UTILSBILLGDOCOUTSRTGDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/