P_PaymentCardRefundable

DDL: P_PAYMENTCARDREFUNDABLE Type: view_entity COMPOSITE

P_PaymentCardRefundable is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (bsegc) and exposes 54 fields with key fields Bukrs, Gjahr, Audat, Belnr. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
bsegc AcctgDoc from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_JournalEntry _JournalEntry AcctgDoc.bukrs = _JournalEntry.CompanyCode and AcctgDoc.gjahr = _JournalEntry.FiscalYear and AcctgDoc.belnr = _JournalEntry.AccountingDocument
[0..1] I_OperationalAcctgDocItem _AcctgDocItem AcctgDoc.bukrs = _AcctgDocItem.CompanyCode and AcctgDoc.belnr = _AcctgDocItem.AccountingDocument and AcctgDoc.gjahr = _AcctgDocItem.FiscalYear and AcctgDoc.rfzei = _AcctgDocItem.PaymentCardItem
[0..1] P_PaymentCardRefundableTotal _RefundableTotal AcctgDoc.aunum = _RefundableTotal.Aunum
[0..1] P_PaymentCardRefundableMM _RefundableMM AcctgDoc.aunum = _RefundableMM.Aunum
[0..1] I_Customer _Customer $projection.Kunnr = _Customer.Customer

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
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 (54)

KeyFieldSource TableSource FieldDescription
KEY Bukrs bukrs
KEY Gjahr gjahr
KEY Audat audat
KEY Belnr belnr
Rfzei rfzei
Aunum aunum
Ccins ccins
Ccnum ccnum
Ccfol ccfol
Datab datab
Datbi datbi
Ccname ccname
Csour csour
Autwr autwr
Ccwae ccwae
Settl settl
Autra autra
Autim autim
Merch merch
Locid locid
Trmid trmid
Ccbtc ccbtc
Cctyp cctyp
Ccard_Guid ccard_guid
Payment_Amount payment_amount
Dp_Token dp_token
Dp_Psp dp_psp
Dp_Payid dp_payid
Dp_Psp_Transid dp_psp_transid
Dp_Trans_Id dp_trans_id
Dp_Merchant_Alias dp_merchant_alias
Dp_Auth_Rel_Id dp_auth_rel_id
Dp_Fraud_Risk dp_fraud_risk
Dp_Charge_Trans_Id dp_charge_trans_id
Setra setra
Rcavr rcavr
Rcava rcava
Rcavz rcavz
Rcrsp rcrsp
Rtext rtext
React react
Kunnr kunnr
Opbel opbel
Dp_Advref dp_advref
_Dataaging _dataaging
Dp_Rtext_Long dp_rtext_long
Dp_L2l3_Sent dp_l2l3_sent
AuthorizationGroup _Customer AuthorizationGroup
TransactionCurrency _JournalEntry TransactionCurrency
_AcctgDocItem _AcctgDocItem
_RefundableTotal _RefundableTotal
_JournalEntry _JournalEntry
_RefundableMM _RefundableMM
_Customer _Customer
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_JOURNALENTRY",
"BSEGC"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"P_PAYMENTCARDREFUNDABLEMM",
"P_PAYMENTCARDREFUNDABLETOTAL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/