P_CADOCUMENTSUMBPITEM

CDS View

Summarized Business Partner Items

P_CADOCUMENTSUMBPITEM is a CDS View in S/4HANA. Summarized Business Partner Items. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CADocumentSumBPItem view_entity from CONSUMPTION Summarized Business Partner Items 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Summarized Business Partner Items'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #P,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}


@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CADocumentSumBPItem
  as select from I_CADocumentBPItem


  association [0..1] to I_CAClearingReason as _CAClearingReason on $projection.CAClearingReason = _CAClearingReason.CAClearingReason

{
      @ObjectModel.foreignKey.association: '_CADocument'
  key CADocumentNumber,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
  key BusinessPartner,
      @ObjectModel.foreignKey.association: '_ContractAccountPartner'
  key ContractAccount,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
  key CAApplicationArea,
      @ObjectModel.foreignKey.association: '_CAMainTransaction'
  key CAMainTransaction,
      @ObjectModel.foreignKey.association: '_CASubTransaction'
  key CASubTransaction,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
  key TransactionCurrency,

      @ObjectModel.foreignKey.association: '_CAClearingReason'
      cast(max(CAClearingReason) as augrd_kk )             as CAClearingReason,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      cast(sum(CAAmountInTransactionCurrency) as betrw_kk) as CAAmountInTransactionCurrency,

      @EndUserText.label: 'Number'
      count(*)                                             as NumberOfCADocumentBPItems,


      cast(max(CANetDueDate) as faedn_kk)                  as CANetDueDate,

      cast(max(CACashDiscountDueDate) as faeds_kk )        as CACashDiscountDueDate,
      
      cast(max(CABPItemNumber) as opupk_kk ) as CABPItemNumber,
      cast(max(CASubItemNumber) as opupz_kk ) as CASubItemNumber,
      cast(max(CARepetitionItemNumber) as opupw_kk ) as CARepetitionItemNumber,


      //Associations

      _BusinessPartner,
      _CAClearingReason,
      _CADocument,
      _CAMainTransaction,
      _CASubTransaction,
      _CompanyCode,
      _ContractAccountPartner,
      _TransactionCurrency

}
group by
  CADocumentNumber,
  BusinessPartner,
  ContractAccount,
  CompanyCode,
  CAApplicationArea,
  CAMainTransaction,
  CASubTransaction,
  TransactionCurrency

Learn More