I_CADocumentTotalAmountOpen

DDL: I_CADOCUMENTTOTALAMOUNTOPEN SQL: ICADOCAMTOPEN Type: view COMPOSITE

Offener Betrag eines Beleges

I_CADocumentTotalAmountOpen is a Composite CDS View that provides data about "Offener Betrag eines Beleges" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemLogical) and exposes 4 fields. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemLogical I_CADocumentBPItemLogical from

Associations (1)

CardinalityTargetAliasCondition
[1] I_CADocumentHeader _DocHeader $projection.CADocumentNumber = _DocHeader.CADocumentNumber

Annotations (8)

NameValueLevelField
EndUserText.label Offener Betrag eines Beleges view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ICADOCAMTOPEN view

Fields (4)

KeyFieldSource TableSource FieldDescription
CADocumentNumber CADocumentNumber
TransactionCurrency TransactionCurrency
OpenAmountInTransCrcy
_DocHeader _DocHeader 
@EndUserText.label: 'Offener Betrag eines Beleges'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ICADOCAMTOPEN'
define view I_CADocumentTotalAmountOpen as select from I_CADocumentBPItemLogical
association [1] to I_CADocumentHeader as _DocHeader on $projection.CADocumentNumber = _DocHeader.CADocumentNumber
{
  CADocumentNumber,
  TransactionCurrency,
  @Semantics.amount.currencyCode: 'TransactionCurrency'  
  sum(CAAmountInTransactionCurrency) as OpenAmountInTransCrcy,
  
  _DocHeader
}
  where CAClearingStatus = ' '
  group by CADocumentNumber,
           TransactionCurrency  // TransactionCurrency is unique for each CADocumentNumber

Learn More