C_CADocumentSumBPItem

DDL: C_CADOCUMENTSUMBPITEM Type: view_entity CONSUMPTION

Summarized Business Partner Items

C_CADocumentSumBPItem is a Consumption CDS View that provides data about "Summarized Business Partner Items" in SAP S/4HANA. It reads from 1 data source (P_CADocumentSumBPItem) and exposes 25 fields with key fields CADocumentNumber, BusinessPartner, ContractAccount, CompanyCode, CAApplicationArea.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
P_CADocumentSumBPItem P_CADocumentSumBPItem from

Annotations (7)

NameValueLevelField
EndUserText.label Summarized Business Partner Items view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY BusinessPartner BusinessPartner
KEY ContractAccount ContractAccount
KEY CompanyCode CompanyCode
KEY CAApplicationArea CAApplicationArea
KEY CAMainTransaction CAMainTransaction
KEY CASubTransaction CASubTransaction
KEY TransactionCurrency TransactionCurrency
CABPItemNumber CABPItemNumber
CASubItemNumber CASubItemNumber
CARepetitionItemNumber CARepetitionItemNumber
ContractAccountName _CAPartner ContractAccountName
CAClearingReason CAClearingReason
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
NumberOfCADocumentBPItems NumberOfCADocumentBPItems
CANetDueDate CANetDueDate
CACashDiscountDueDate CACashDiscountDueDate
_BusinessPartner _BusinessPartner
_CAPartner _CAPartner
_ClearingReason _ClearingReason
_Currency _Currency
_MainTransaction _MainTransaction
_SubTransaction _SubTransaction
_DocHeader _DocHeader
_CompCode _CompCode 
@EndUserText.label: 'Summarized Business Partner Items'

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@Metadata.allowExtensions: true
define view entity C_CADocumentSumBPItem
  as select from P_CADocumentSumBPItem
{
      @ObjectModel.foreignKey.association: '_DocHeader'
  key CADocumentNumber,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
  key BusinessPartner,
      @ObjectModel.text.element: ['ContractAccountName']
  key ContractAccount,
      @ObjectModel.foreignKey.association: '_CompCode'
  key CompanyCode,
  key CAApplicationArea,
      @ObjectModel.foreignKey.association: '_MainTransaction'
  key CAMainTransaction,
      @ObjectModel.foreignKey.association: '_SubTransaction'
  key CASubTransaction,
      @ObjectModel.foreignKey.association: '_Currency'
  key TransactionCurrency,
  
      CABPItemNumber,
      CASubItemNumber,
      CARepetitionItemNumber,

      @Semantics.text: true
      _CAPartner.ContractAccountName,
      
      @ObjectModel.foreignKey.association: '_ClearingReason'
      CAClearingReason,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @DefaultAggregation: #SUM
      CAAmountInTransactionCurrency,
      NumberOfCADocumentBPItems,
      CANetDueDate,
      CACashDiscountDueDate,
      /* Associations */
      _BusinessPartner,
      _CAPartner,
      _ClearingReason,
      _Currency,
      _MainTransaction,
      _SubTransaction,
      _DocHeader,
      _CompCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONTRACTACCOUNTPARTNER",
"P_CADOCUMENTSUMBPITEM"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CACLEARINGREASON",
"I_CADOCUMENTHEADER",
"I_CAMAINTRANSACTION",
"I_CASUBTRANSACTION",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTPARTNER",
"I_CURRENCY"
],
"BASE":
[
"P_CADOCUMENTSUMBPITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More