I_UtilsBillgDocTotalNetAmt

DDL: I_UTILSBILLGDOCTOTALNETAMT SQL: IEBILLGDOCNETAMT Type: view COMPOSITE

Billing Document Total Net Amount

I_UtilsBillgDocTotalNetAmt is a Composite CDS View that provides data about "Billing Document Total Net Amount" in SAP S/4HANA. It reads from 3 data sources (I_UtilsBillgDocAddlLineItem, I_UtilsBillgDocLineItmAmtPrc, I_UtilsBillingDocumentLineItem) and exposes 5 fields with key field UtilitiesBillingDocument. It has 1 association to related views.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_UtilsBillgDocAddlLineItem UtilsBillgDocAddlLineItem left_outer
I_UtilsBillgDocLineItmAmtPrc UtilsBillgDocLineItmAmtPrc from
I_UtilsBillingDocumentLineItem UtilsBillingDocumentLineItem inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.UtilsBillgDocTransactionCrcy = _Currency.Currency

Annotations (8)

NameValueLevelField
EndUserText.label Billing Document Total Net Amount view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IEBILLGDOCNETAMT view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument I_UtilsBillgDocLineItmAmtPrc UtilitiesBillingDocument
UtilsBillgDocTotalNetAmt
UtilsBillgDocTransactionCrcy I_UtilsBillgDocLineItmAmtPrc UtilsBillgDocTransactionCrcy
_UtilitiesBillingDocument I_UtilsBillgDocLineItmAmtPrc _UtilitiesBillingDocument
_Currency _Currency 
@EndUserText.label: 'Billing Document Total Net Amount'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IEBILLGDOCNETAMT'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view          I_UtilsBillgDocTotalNetAmt 
     as select from  I_UtilsBillgDocLineItmAmtPrc   as UtilsBillgDocLineItmAmtPrc
     inner join      I_UtilsBillingDocumentLineItem as UtilsBillingDocumentLineItem on UtilsBillgDocLineItmAmtPrc.UtilitiesBillingDocument         = UtilsBillingDocumentLineItem.UtilitiesBillingDocument
                                                                                   and UtilsBillgDocLineItmAmtPrc.UtilitiesBillingDocLineItem      = UtilsBillingDocumentLineItem.UtilitiesBillingDocLineItem
     left outer join I_UtilsBillgDocAddlLineItem    as UtilsBillgDocAddlLineItem    on UtilsBillgDocLineItmAmtPrc.UtilitiesBillingDocument         = UtilsBillgDocAddlLineItem.UtilitiesBillingDocument
                                                                                   and UtilsBillgDocLineItmAmtPrc.UtilitiesBillingDocLineItem      = UtilsBillgDocAddlLineItem.UtilitiesBillingDocLineItem                                               
     association [0..1] to I_Currency               as _Currency                    on $projection.UtilsBillgDocTransactionCrcy                    = _Currency.Currency
{
  @ObjectModel.foreignKey.association: '_UtilitiesBillingDocument'
  key UtilsBillgDocLineItmAmtPrc.UtilitiesBillingDocument,
  
      @Semantics.amount.currencyCode: 'UtilsBillgDocTransactionCrcy'
      @DefaultAggregation: #NONE
      cast(sum(UtilsBillgDocLineItmAmtPrc.UtilsBillgDocLineItmNetAmt) as e_billgdoctotalnetamt_vdm preserving type) as UtilsBillgDocTotalNetAmt,  
          
      @Semantics.currencyCode: true
      UtilsBillgDocLineItmAmtPrc.UtilsBillgDocTransactionCrcy,
      
//      UtilsBillgDocAddlLineItem.UtilsBillgDocInAdjmtReversal,

      UtilsBillgDocLineItmAmtPrc._UtilitiesBillingDocument,     
      _Currency
      
} where 
   ( UtilsBillgDocAddlLineItem.UtilsBillgDocInAdjmtReversal      = ''  or UtilsBillgDocAddlLineItem.UtilsBillgDocInAdjmtReversal      is null ) and
   ( UtilsBillingDocumentLineItem.UtilsLineItmIsBdgtBillgAmtRlvt = ''  or UtilsBillingDocumentLineItem.UtilsLineItmIsBdgtBillgAmtRlvt is null ) and
     UtilsBillingDocumentLineItem.UtilsLineItmIsPostgRelevant    = 'X' 
group by
    UtilsBillgDocLineItmAmtPrc.UtilitiesBillingDocument,
    UtilsBillgDocLineItmAmtPrc.UtilsBillgDocTransactionCrcy
        
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILSBILLGDOCADDLLINEITEM",
"I_UTILSBILLGDOCLINEITMAMTPRC",
"I_UTILSBILLINGDOCUMENTLINEITEM"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_UTILITIESBILLINGDOCUMENT"
],
"BASE":
[
"I_UTILSBILLGDOCLINEITMAMTPRC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More