P_PaymentCardRefundable

DDL: P_PAYMENTCARDREFUNDABLE Type: view_entity COMPOSITE
54 Fields 1 Data Sources 5 Associations

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 Value
KEY Gjahr gjahr Settlement Year
KEY Audat audat Trans. Period End
KEY Belnr belnr SD Document
Rfzei rfzei Payt Card Item
Aunum aunum AuthorizationNo
Ccins ccins Payt Card Type
Ccnum ccnum Condition Contract
Ccfol ccfol Suffix
Datab datab Validity period
Datbi datbi Validity period
Ccname ccname Cardholder Name
Csour csour Entry mode
Autwr autwr Authorized Amt
Ccwae ccwae Currency
Settl settl Settled
Autra autra Auth. Ref. No.
Autim autim Auth. Time
Merch merch Merchant ID
Locid locid Single-Character Flag
Trmid trmid Terminal
Ccbtc ccbtc Settlement
Cctyp cctyp Item Category
Ccard_Guid ccard_guid Reference to Encrypted Payment Card Data
Payment_Amount payment_amount Payout Amount
Dp_Token dp_token Token
Dp_Psp dp_psp Paymnt Serv. Provid.
Dp_Payid dp_payid Payment ID
Dp_Psp_Transid dp_psp_transid PSP Transaction ID
Dp_Trans_Id dp_trans_id Transaction/Payt ID
Dp_Merchant_Alias dp_merchant_alias Merchant Alias
Dp_Auth_Rel_Id dp_auth_rel_id Auth. Rel. ID
Dp_Fraud_Risk dp_fraud_risk Fraud Risk Code
Dp_Charge_Trans_Id dp_charge_trans_id Transaction/Payt ID
Setra setra Reference No.
Rcavr rcavr Address Result
Rcava rcava Address Check
Rcavz rcavz ZIP Code Check
Rcrsp rcrsp Card check
Rtext rtext Text
React react Response
Kunnr kunnr Stock customer
Opbel opbel Reopen
Dp_Advref dp_advref DP Adv.Ref.
_Dataaging _dataaging Data Aging
Dp_Rtext_Long dp_rtext_long Text
Dp_L2l3_Sent dp_l2l3_sent L2/L3 data sent
AuthorizationGroup _Customer AuthorizationGroup AuthorizGroup
TransactionCurrency _JournalEntry TransactionCurrency Transaction Currency
_AcctgDocItem _AcctgDocItem
_RefundableTotal _RefundableTotal
_JournalEntry _JournalEntry
_RefundableMM _RefundableMM
_Customer _Customer

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PaymentCardRefundable.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_PaymentCardRefundable AS
SELECT
  Bukrs,
  Gjahr,
  Audat,
  Belnr,
  Rfzei,
  Aunum,
  Ccins,
  Ccnum,
  Ccfol,
  Datab,
  Datbi,
  Ccname,
  Csour,
  Autwr,
  Ccwae,
  Settl,
  Autra,
  Autim,
  Merch,
  Locid,
  Trmid,
  Ccbtc,
  Cctyp,
  Ccard_Guid,
  Payment_Amount,
  Dp_Token,
  Dp_Psp,
  Dp_Payid,
  Dp_Psp_Transid,
  Dp_Trans_Id,
  Dp_Merchant_Alias,
  Dp_Auth_Rel_Id,
  Dp_Fraud_Risk,
  Dp_Charge_Trans_Id,
  Setra,
  Rcavr,
  Rcava,
  Rcavz,
  Rcrsp,
  Rtext,
  React,
  Kunnr,
  Opbel,
  Dp_Advref,
  Dp_Rtext_Long,
  Dp_L2l3_Sent,
  _Customer.AuthorizationGroup AS AuthorizationGroup,
  _JournalEntry.TransactionCurrency AS TransactionCurrency
FROM bsegc AS AcctgDoc
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON AcctgDoc.bukrs = _JournalEntry.CompanyCode AND AcctgDoc.gjahr = _JournalEntry.FiscalYear AND AcctgDoc.belnr = _JournalEntry.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN 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]
LEFT OUTER JOIN P_PaymentCardRefundableTotal AS _RefundableTotal ON AcctgDoc.aunum = _RefundableTotal.Aunum  -- association [0..1]
LEFT OUTER JOIN P_PaymentCardRefundableMM AS _RefundableMM ON AcctgDoc.aunum = _RefundableMM.Aunum  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Kunnr = _Customer.Customer  -- association [0..1]
;

Learn More