P_PAYMENTCARDREFUNDABLE

CDS View

Refundable payments with Credit Card

P_PAYMENTCARDREFUNDABLE is a CDS View in S/4HANA. Refundable payments with Credit Card. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PaymentCardRefundableTotal view_entity from COMPOSITE Refundable payments with Credit Card Aggregate by AuthNum
P_PaymentCardRefundableVH view_entity from CONSUMPTION Refundable payments with Credit Card Value Help
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
//@EndUserText.label: 'Refundable payments with Credit Card' 

@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity P_PaymentCardRefundable
  as select from bsegc as AcctgDoc
  association [0..1] to I_JournalEntry               as _JournalEntry    on  AcctgDoc.bukrs = _JournalEntry.CompanyCode
                                                                         and AcctgDoc.gjahr = _JournalEntry.FiscalYear
                                                                         and AcctgDoc.belnr = _JournalEntry.AccountingDocument
  association [0..1] to I_OperationalAcctgDocItem    as _AcctgDocItem    on  AcctgDoc.bukrs = _AcctgDocItem.CompanyCode
                                                                         and AcctgDoc.belnr = _AcctgDocItem.AccountingDocument
                                                                         and AcctgDoc.gjahr = _AcctgDocItem.FiscalYear
                                                                         and AcctgDoc.rfzei = _AcctgDocItem.PaymentCardItem

  association [0..1] to P_PaymentCardRefundableTotal as _RefundableTotal on  AcctgDoc.aunum = _RefundableTotal.Aunum //AuthorizationByPaytSrvcPrvdr

  association [0..1] to P_PaymentCardRefundableMM    as _RefundableMM    on  AcctgDoc.aunum = _RefundableMM.Aunum
  association [0..1] to I_Customer                   as _Customer        on  $projection.Kunnr = _Customer.Customer
{

  key bukrs                             as Bukrs,
  key gjahr                             as Gjahr,
  key audat                             as Audat,
  key belnr                             as Belnr,
      rfzei                             as Rfzei,
      aunum                             as Aunum,
      ccins                             as Ccins,
      ccnum                             as Ccnum,
      ccfol                             as Ccfol,
      datab                             as Datab,
      datbi                             as Datbi,
      ccname                            as Ccname,
      csour                             as Csour,
      @Semantics: { amount : {currencyCode: 'Ccwae'} }
      autwr                             as Autwr,
      ccwae                             as Ccwae,
      settl                             as Settl,
      autra                             as Autra,
      //      audat                             as Audat,

      autim                             as Autim,
      merch                             as Merch,
      locid                             as Locid,
      trmid                             as Trmid,
      ccbtc                             as Ccbtc,
      cctyp                             as Cctyp,
      ccard_guid                        as Ccard_Guid,
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }

      payment_amount                    as Payment_Amount,
      dp_token                          as Dp_Token,
      dp_psp                            as Dp_Psp,
      dp_payid                          as Dp_Payid,
      dp_psp_transid                    as Dp_Psp_Transid,
      dp_trans_id                       as Dp_Trans_Id,
      dp_merchant_alias                 as Dp_Merchant_Alias,
      dp_auth_rel_id                    as Dp_Auth_Rel_Id,
      dp_fraud_risk                     as Dp_Fraud_Risk,
      dp_charge_trans_id                as Dp_Charge_Trans_Id,
      setra                             as Setra,
      rcavr                             as Rcavr,
      rcava                             as Rcava,
      rcavz                             as Rcavz,
      rcrsp                             as Rcrsp,
      rtext                             as Rtext,
      react                             as React,
      kunnr                             as Kunnr,
      opbel                             as Opbel,
      dp_advref                         as Dp_Advref,
      _dataaging                        as _Dataaging,
      dp_rtext_long                     as Dp_Rtext_Long,
      dp_l2l3_sent                      as Dp_L2l3_Sent,
      _Customer.AuthorizationGroup      as AuthorizationGroup,
      _JournalEntry.TransactionCurrency as TransactionCurrency,
      _AcctgDocItem,
      _RefundableTotal,
      _JournalEntry,
      _RefundableMM,
      _Customer
}