P_PaymentCardRefundableTotal

DDL: P_PAYMENTCARDREFUNDABLETOTAL Type: view_entity COMPOSITE Package: FBCC

Refundable payments with Credit Card Aggregate by AuthNum

P_PaymentCardRefundableTotal is a Composite CDS View that provides data about "Refundable payments with Credit Card Aggregate by AuthNum" in SAP S/4HANA. It reads from 1 data source (P_PaymentCardRefundable) and exposes 4 fields with key field Aunum. Part of development package FBCC.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_PaymentCardRefundable P_PaymentCardRefundable from

Annotations (6)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Aunum Aunum
MaxRefundableAmount
curr232endasPendingAmount
TransactionCurrency _AcctgDocItem TransactionCurrency 

@AbapCatalog.viewEnhancementCategory: [#NONE]
//@AccessControl.authorizationCheck: #MANDATORY

//@EndUserText.label: 'Refundable payments with CC Aggr.AuthNum'

@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity P_PaymentCardRefundableTotal
  as select from P_PaymentCardRefundable
{
  key Aunum,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      sum(_AcctgDocItem.AmountInTransactionCurrency) as MaxRefundableAmount,

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      sum(
      case Settl
        when '' then (  cast( ( _AcctgDocItem.AmountInTransactionCurrency * -1 ) as abap.curr(23,2)) )
        else cast (0 as abap.curr(23,2))
      end
      )                                              as PendingAmount,
      _AcctgDocItem.TransactionCurrency              as TransactionCurrency
      /* Associations */
      // _AcctgDocItem,

      //  _Invoice

}
where
      Aunum                              <> ''
  and _AcctgDocItem.FinancialAccountType =  'S'


group by
  Aunum,
  _AcctgDocItem.TransactionCurrency

Learn More