I_UtilsContrAcctInvcgOrderCntr

DDL: I_UTILSCONTRACCTINVCGORDERCNTR SQL: IECACCTINVCGORDC Type: view COMPOSITE

Number of Invoicing Orders for Contract Account

I_UtilsContrAcctInvcgOrderCntr is a Composite CDS View that provides data about "Number of Invoicing Orders for Contract Account" in SAP S/4HANA. It reads from 3 data sources (I_UtilitiesBillingDocument, I_UtilitiesContract, I_UtilitiesInvoicingOrder) and exposes 10 fields with key fields ContractAccount, ScheduledUtilitiesBillingDate, UtilitiesPortion, UtilitiesBillingReason. It has 1 association to related views.

3 data source(s) 10 fields

Data Sources (3)

SourceAliasJoin Type
I_UtilitiesBillingDocument UtilitiesBillingDocument inner
I_UtilitiesContract UtilitiesContract inner
I_UtilitiesInvoicingOrder UtilitiesInvoicingOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_UtilitiesContract _UtilitiesContract $projection.ContractAccount = _UtilitiesContract.ContractAccount

Annotations (8)

NameValueLevelField
EndUserText.label Number of Invoicing Orders for Contract Account view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IECACCTINVCGORDC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount I_UtilitiesInvoicingOrder ContractAccount
KEY ScheduledUtilitiesBillingDate I_UtilitiesBillingDocument ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_UtilitiesInvoicingOrder UtilitiesPortion
KEY UtilitiesBillingReason I_UtilitiesInvoicingOrder UtilitiesBillingReason
UtilsContrJointInvcType I_UtilitiesContract UtilsContrJointInvcType
NmbrOfUtilsInvcgOrdrs
_UtilitiesPortion I_UtilitiesInvoicingOrder _UtilitiesPortion
_UtilitiesBillingReason I_UtilitiesInvoicingOrder _UtilitiesBillingReason
_InvcUtilsContractsJointly I_UtilitiesContract _InvcUtilsContractsJointly
_UtilitiesContract _UtilitiesContract 
@EndUserText.label: 'Number of Invoicing Orders for Contract Account'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IECACCTINVCGORDC'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_UtilsContrAcctInvcgOrderCntr
  as select from I_UtilitiesInvoicingOrder  as UtilitiesInvoicingOrder
    inner join   I_UtilitiesBillingDocument as UtilitiesBillingDocument on UtilitiesBillingDocument.UtilitiesBillingDocument = UtilitiesInvoicingOrder.UtilitiesBillingDocument
    inner join   I_UtilitiesContract        as UtilitiesContract        on UtilitiesContract.UtilitiesContract = UtilitiesInvoicingOrder.UtilitiesContract
  association [1..*] to I_UtilitiesContract as _UtilitiesContract on $projection.ContractAccount = _UtilitiesContract.ContractAccount
{
  key UtilitiesInvoicingOrder.ContractAccount,

      @Semantics.businessDate.at: true
  key UtilitiesBillingDocument.ScheduledUtilitiesBillingDate,

      @ObjectModel.foreignKey.association: '_UtilitiesPortion'
  key UtilitiesInvoicingOrder.UtilitiesPortion,

      @ObjectModel.foreignKey.association: '_UtilitiesBillingReason'
  key UtilitiesInvoicingOrder.UtilitiesBillingReason,

      @ObjectModel.foreignKey.association: '_InvcUtilsContractsJointly'
      UtilitiesContract.UtilsContrJointInvcType,

      count(*) as NmbrOfUtilsInvcgOrdrs,

      /* Associations */
      UtilitiesInvoicingOrder._UtilitiesPortion,
      UtilitiesInvoicingOrder._UtilitiesBillingReason,
      UtilitiesContract._InvcUtilsContractsJointly,
      _UtilitiesContract
}
where
      UtilitiesInvoicingOrder.UtilsBillgSimulationReason =  ''
  and UtilitiesInvoicingOrder.UtilsBillgDocIsNotReleased =  ''
  and UtilsInvoicingOrdSrceType                          =  'A'
  and UtilitiesContract.UtilitiesMoveInDate              <= UtilitiesBillingDocument.ScheduledUtilitiesBillingDate
  and UtilitiesContract.UtilitiesMoveOutDate             >= UtilitiesBillingDocument.ScheduledUtilitiesBillingDate
group by
  UtilitiesInvoicingOrder.ContractAccount,
  UtilitiesBillingDocument.ScheduledUtilitiesBillingDate,
  UtilitiesInvoicingOrder.UtilitiesPortion,
  UtilitiesInvoicingOrder.UtilitiesBillingReason,
  UtilitiesContract.UtilsContrJointInvcType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESBILLINGDOCUMENT",
"I_UTILITIESCONTRACT",
"I_UTILITIESINVOICINGORDER"
],
"ASSOCIATED":
[
"I_INVCUTILSCONTRACTSJOINTLY",
"I_UTILITIESBILLINGREASON",
"I_UTILITIESCONTRACT",
"I_UTILITIESPORTION"
],
"BASE":
[
"I_UTILITIESCONTRACT",
"I_UTILITIESINVOICINGORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More