C_CADocumentSumClearedItem

DDL: C_CADOCUMENTSUMCLEAREDITEM Type: view_entity CONSUMPTION Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

Summarized Cleared Items

C_CADocumentSumClearedItem is a Consumption CDS View that provides data about "Summarized Cleared Items" in SAP S/4HANA. It reads from 1 data source (P_CADocumentSumClearedItem) and exposes 21 fields with key fields CAClearingDocumentNumber, CompanyCode, BusinessArea, Division, BusinessPartner. 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) 21 fields

Data Sources (1)

SourceAliasJoin Type
P_CADocumentSumClearedItem P_CADocumentSumClearedItem from

Annotations (7)

NameValueLevelField
EndUserText.label Summarized Cleared 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

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 (21)

KeyFieldSource TableSource FieldDescription
KEY CAClearingDocumentNumber CAClearingDocumentNumber
KEY CompanyCode CompanyCode
KEY BusinessArea BusinessArea
KEY Division Division
KEY BusinessPartner BusinessPartner
KEY ContractAccount ContractAccount
KEY TransactionCurrency TransactionCurrency
CADocumentNumber CADocumentNumber
CABPItemNumber CABPItemNumber
CASubItemNumber CASubItemNumber
CARepetitionItemNumber CARepetitionItemNumber
ContractAccountName _ContractAccountPartner ContractAccountName
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
NumberOfCADocumentItems NumberOfCADocumentItems Number
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CAClearingDocument _CAClearingDocument
_CompanyCode _CompanyCode
_ContractAccountPartner _ContractAccountPartner
_Division _Division
_TransactionCurrency _TransactionCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@EndUserText.label: 'Summarized Cleared 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]
@Consumption.dbHints:['USE_HEX_PLAN']
@Metadata.allowExtensions: true
define view entity C_CADocumentSumClearedItem
  as select from P_CADocumentSumClearedItem
{
      @ObjectModel.foreignKey.association: '_CAClearingDocument'
  key CAClearingDocumentNumber,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_BusinessArea'
  key BusinessArea,
      @ObjectModel.foreignKey.association: '_Division'
  key Division,
  key BusinessPartner,
      @ObjectModel.text.element: ['ContractAccountName']
  key ContractAccount,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
  key TransactionCurrency,

      CADocumentNumber,
      CABPItemNumber,
      CASubItemNumber,
      CARepetitionItemNumber,
      
      @Semantics.text: true
      _ContractAccountPartner.ContractAccountName,
      
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,

      @EndUserText.label: 'Number'
      NumberOfCADocumentItems,

      //Associations

      _BusinessArea,
      _BusinessPartner,
      _CAClearingDocument,
      _CompanyCode,
      _ContractAccountPartner,
      _Division,
      _TransactionCurrency
}

Learn More