I_UTILSINVCGDOCOUTSRTGDATACNTR

CDS View

Number of Automatically Outsorted Invoicing Documents

I_UTILSINVCGDOCOUTSRTGDATACNTR is a CDS View in S/4HANA. Number of Automatically Outsorted Invoicing Documents. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_OutsrtdUtilsInvcgDocument view_entity inner CONSUMPTION Outsorted Invoicing Document
I_UtilsInvcgDocBillingData view left_outer COMPOSITE Billing Data for Invoicing Document 
@EndUserText.label: 'Number of Automatically Outsorted Invoicing Documents'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IEINVDOCOUTDATAC'
@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_UtilsInvcgDocOutsrtgDataCntr
  as select from I_UtilsInvcgDocOutsrtgData   as UtilsInvcgDocOutsrtgData
    inner join   I_UtilitiesInvoicingDocument as UtilitiesInvoicingDocument on UtilitiesInvoicingDocument.UtilitiesInvoicingDocument = UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument
  association [1..1] to I_UtilsInvcgDocOutsrtgData as _UtilsInvcgDocOutsrtgData on  $projection.UtilitiesInvoicingDocument   = _UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument
                                                                                and $projection.UtilsInvcgDocSqncNmbrOutsrtg = _UtilsInvcgDocOutsrtgData.UtilsInvcgDocSqncNmbrOutsrtg
{
      @ObjectModel.foreignKey.association: '_UtilitiesInvoicingDocument'
  key UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument,

      min(UtilsInvcgDocOutsrtgData.UtilsInvcgDocSqncNmbrOutsrtg) as UtilsInvcgDocSqncNmbrOutsrtg,

      count(*)                                                   as UtilsInvcgDocOutsrtgDataCntr,


      /* Associations */
      UtilsInvcgDocOutsrtgData._UtilitiesInvoicingDocument,
      _UtilsInvcgDocOutsrtgData
}
where
      UtilsInvcgDocOutsrtgData.UtilsInvcgDocReleasedByUser   = '' //Not Released by User

  //  and UtilsInvcgDocOutsrtgData.UtilsInvcgOutsortingReason    = ''  //Not Manual Outsorting

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsNotReleased  = 'X' //Not Released

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsReversed     = ''  //Not Reversed

  and UtilitiesInvoicingDocument.UtilsInvcgDocIsSimulated    = ''  //Not Simulated

  and UtilsInvcgDocOutsrtgData.UtilsInvcgDocIsReldBackground = ''  // Not released

group by
  UtilsInvcgDocOutsrtgData.UtilitiesInvoicingDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESINVOICINGDOCUMENT",
"I_UTILSINVCGDOCOUTSRTGDATA"
],
"ASSOCIATED":
[
"I_UTILITIESINVOICINGDOCUMENT",
"I_UTILSINVCGDOCOUTSRTGDATA"
],
"BASE":
[
"I_UTILSINVCGDOCOUTSRTGDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More