P_PaymentCardRefundableVH

DDL: P_PAYMENTCARDREFUNDABLEVH Type: view_entity CONSUMPTION Package: FBCC

Refundable payments with Credit Card Value Help

P_PaymentCardRefundableVH is a Consumption CDS View that provides data about "Refundable payments with Credit Card Value Help" in SAP S/4HANA. It reads from 1 data source (P_PaymentCardRefundable) and exposes 20 fields with key fields Bukrs, Belnr, Gjahr, Rfzei. Part of development package FBCC.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
P_PaymentCardRefundable P_PaymentCardRefundable from

Annotations (6)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Bukrs Bukrs
KEY Belnr Belnr
KEY Gjahr Gjahr
KEY Rfzei Rfzei
buzei _AcctgDocItem AccountingDocumentItem
Aunum Aunum
Ccnum Ccnum
Settl Settl
Ccbtc Ccbtc
Dp_Psp Dp_Psp
Dp_Payid Dp_Payid
Dp_Psp_Transid Dp_Psp_Transid
Dp_Trans_Id Dp_Trans_Id
Kunnr Kunnr
MaxRefundableAmount _RefundableTotal MaxRefundableAmount
TransactionCurrency _RefundableTotal TransactionCurrency
PendingAmount _RefundableTotal PendingAmount
CcbtcCcbtcthenXelseendasIsMinSettl
GLAccount _AcctgDocItem GLAccount
Audat Audat 
@AbapCatalog.viewEnhancementCategory: [#NONE]
//@EndUserText.label: 'Refundable payments with Credit Card VH'

@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity P_PaymentCardRefundableVH
  as select from P_PaymentCardRefundable
{

  key  Bukrs,
  key  Belnr,
  key  Gjahr,
  key  Rfzei,
       _AcctgDocItem.AccountingDocumentItem as buzei,
       Aunum,
       Ccnum,
       Settl,
       Ccbtc,
       Dp_Psp,
       Dp_Payid,
       Dp_Psp_Transid,
       Dp_Trans_Id,
       Kunnr,
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       _RefundableTotal.MaxRefundableAmount,
       _RefundableTotal.TransactionCurrency,
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       _RefundableTotal.PendingAmount,
       case
       when _RefundableMM.Ccbtc = Ccbtc   then 'X'
       else '' end                          as IsMinSettl,
       _AcctgDocItem.GLAccount,
       Audat
}

where
      Aunum                                <>   ''
  and _JournalEntry.ReferenceDocumentType  like 'BKPF%'
  and _AcctgDocItem.FinancialAccountType   =    'S'
  and _RefundableTotal.MaxRefundableAmount >    0

Learn More