C_SuplrPaytBlkBlkdItmsAggrgn

DDL: C_SUPLRPAYTBLKBLKDITMSAGGRGN SQL: CSUPLRPAYTBLKBIA Type: view CONSUMPTION

Total Amount and Count of Blocked Items

C_SuplrPaytBlkBlkdItmsAggrgn is a Consumption CDS View that provides data about "Total Amount and Count of Blocked Items" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_SupplierCompany) and exposes 5 fields with key fields CompanyCode, Supplier.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem OpenItems from
I_SupplierCompany Supplier inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSUPLRPAYTBLKBIA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Total Amount and Count of Blocked Items view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY Supplier I_OperationalAcctgDocItem Supplier
Currency I_SupplierCompany Currency
TotalBlockedAmountInCoCodeCrcy
NumberOfBlockedItems 
@AbapCatalog.sqlViewName: 'CSUPLRPAYTBLKBIA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Total Amount and Count of Blocked Items'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #CONSUMPTION
define view C_SuplrPaytBlkBlkdItmsAggrgn
  as select from I_OperationalAcctgDocItem as OpenItems
    inner join   I_SupplierCompany         as Supplier on  Supplier.CompanyCode = OpenItems.CompanyCode
                                                       and Supplier.Supplier    = OpenItems.Supplier
{
  key OpenItems.CompanyCode,
  key OpenItems.Supplier,

      @Semantics.currencyCode: true
      Supplier.Currency,
      @Semantics.amount.currencyCode: 'Currency'
      cast(sum(AmountInCompanyCodeCurrency) as farp_blocked_amount_cocd_crcy)        as TotalBlockedAmountInCoCodeCrcy,

      cast(count(*) as farp_number_of_blocked_items) as NumberOfBlockedItems

}
where
      ClearingAccountingDocument = ''
  and FinancialAccountType       = 'K'
  and OpenItems.PaymentBlockingReason != ''
  // exclude blocked/EoP business partners as they should never be displayed in MPB

  // therefore @AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED is allowed

  and Supplier.IsBusinessPurposeCompleted = ''

group by
  OpenItems.CompanyCode,
  OpenItems.Supplier,
  Supplier.Currency

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More