C_CADocumentSumBPItem

DDL: C_CADOCUMENTSUMBPITEM Type: view_entity CONSUMPTION Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

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. It is exposed through 2 OData services (UI_CAACCOUNTBALANCE_DISPLAY, UI_CADOCUMENT_MNG). Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

1 data source(s) Exposed by 2 service(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
P_CADocumentSumBPItem P_CADocumentSumBPItem from

Annotations (8)

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

OData Services (2)

ServiceBindingVersionContractRelease
UI_CAACCOUNTBALANCE_DISPLAY UI_CAACCOUNTBALANCE_DISPLAY V4 C1 NOT_RELEASED
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED

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 _ContractAccountPartner ContractAccountName
CAClearingReason CAClearingReason
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
NumberOfCADocumentBPItems NumberOfCADocumentBPItems
CANetDueDate CANetDueDate
CACashDiscountDueDate CACashDiscountDueDate
_BusinessPartner _BusinessPartner
_CAClearingReason _CAClearingReason
_CADocument _CADocument
_CAMainTransaction _CAMainTransaction
_CASubTransaction _CASubTransaction
_CompanyCode _CompanyCode
_ContractAccountPartner _ContractAccountPartner
_TransactionCurrency _TransactionCurrency 
@EndUserText.label: 'Summarized Business Partner Items'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.auditFilter: #ENABLED
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@Consumption.dbHints:['USE_HEX_PLAN']
@Metadata.allowExtensions: true
define view entity C_CADocumentSumBPItem
  as select from P_CADocumentSumBPItem
{
      @ObjectModel.foreignKey.association: '_CADocument'
  key CADocumentNumber,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
  key BusinessPartner,
      @ObjectModel.text.element: ['ContractAccountName']
  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,
  
      CABPItemNumber,
      CASubItemNumber,
      CARepetitionItemNumber,

      @Semantics.text: true
      _ContractAccountPartner.ContractAccountName,
      
      @ObjectModel.foreignKey.association: '_CAClearingReason'
      CAClearingReason,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @DefaultAggregation: #SUM
      CAAmountInTransactionCurrency,
      NumberOfCADocumentBPItems,
      CANetDueDate,
      CACashDiscountDueDate,
      /* Associations */
      _BusinessPartner,
      _CAClearingReason,
      _CADocument,
      _CAMainTransaction,
      _CASubTransaction,
      _CompanyCode,
      _ContractAccountPartner,
      _TransactionCurrency      
}

Learn More